no such file /dev/dsp

# apt-get install oss-compat 
# apt-get install alsa-oss
# modprobe snd_pcm_oss

Execute Python code in Jinja Template

controller.py 

def clever_function():
    return u'HELLO'

app.jinja_env.globals.update(clever_function=clever_function)

view.py 

{{ clever_function() }}

References :

Call a python function from jinja2 - Stack Overflow

Deploy a project using Git push

Server :

$ git init
$ git config receive.denyCurrentBranch ignore
$ mv post-update .git/hooks

Client :

$ git remote add prod ssh://git@deploy-server:22/var/www/myproject

References :
php - Deploy a project using Git push - Stack Overflow

Automated git deployments from Bitbucket

Administration -> Hooks -> POST -> Add hook




References :
Pixel Acres » Blog Archive » Automated git deployments from Bitbucket

mod_wsgi automatic reload on source code change

Adding the WSGIScriptReloading directive meant that any time I made changes to my application files, I could simply $  touch flaskTest.wsgi and the app would restart with changes applied.

# vi /etc/apache2/sites-enabled/000-default.conf 

<VirtualHost *:80>
    ServerName flasktest.subdimension.co.uk

    WSGIDaemonProcess flaskTest user=flask group=www-data threads=5 home=/<redacted>/flaskTest
    WSGIScriptAlias / /<redacted>/flaskTest/flaskTest.wsgi

    <Directory /<redacted>/flaskTest>
        WSGIProcessGroup flaskTest
        WSGIApplicationGroup %{GLOBAL}
        WSGIScriptReloading On
        Order deny,allow
        Allow from all
    </Directory>
</VirtualHost>

$ touch /<redacted>/flaskTest/flaskTest.wsgi

References :
Deploying Flask to Apache » subdimension

linux 監視檔案更改

# apt-get install inotify-tools
# inotifywait -rme modify,attrib,move,close_write,create,delete,delete_self /

* 如果一次監視太多可能會出錯，將 / 改爲 /home 或更小範圍的其他位址

Linux run program using proxy

# apt-get install proxychains
# vi /etc/proxychains.conf
or
$ vi /home/user/.proxychains/proxychains.conf
socks5 127.0.0.1 1234
$ proxychains curl icanhazip.com


可搭配 ssh tunnel
$ ssh -D 8080 user@myhost.com




References :
How to run apt-get (wget, whois, etc.) via SOCKS Proxy using Proxychains | SwitchRoot.com

SQLAlchemy 沒有主鍵 錯誤

sqlalchemy.exc.ArgumentError: Mapper Mapper|FooTable|foo_table could not assemble any primary key columns for mapped table 'foo_table'


SQLAlchemy 不允許沒有定義主鍵，若是複合主鍵，則需要在多個欄位加上 primary_key=True。




References :
MooGoo's Blog: [SQLAlchemy] 不用primary key的table
SQLAlchemy0.6.5文檔-----用元數據定義數據庫_StackDoc

資料外洩防護 DLP 軟體

Windows 查詢資料是否被復制：

• USB 型號記錄 (Registry)

• 第三方軟體：

檔案操作記錄：
Windows Explorer Tracker

存取限制：
資料夾護衛 Folder Guard

Flask Application and Request context

Application context

• flask._app_ctx_stack

• flask.current_app

Request context

• flask._request_ctx_stack

• flask.g
• flask.request
• flask.session

References :
In Flask we Trust

Jinja Template include file

Include Files

Hello World

  {% include "parts/introtext" %}

Requiring Files
{% require %} works like {% include %} but doesn't return the output.

{% require "myblocks" %}
{% require "parts/introtext" as introtext %}

Hello World
{% call "divbox", "intro", introtext %}

References :
Reuse Parts | Jinja Documentation

CentOS pip install MySQL-python

Command /usr/bin/python -c "import setuptools, tokenize;__file__='/tmp/pip_build_root/MySQL-python/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /tmp/pip-HGn8ZB-record/install-record.txt --single-version-externally-managed --compile failed with error code 1 in /tmp/pip_build_root/MySQL-python

Storing debug log for failure in /root/.pip/pip.log

# yum install gcc python-devel mysql-devel

unable to execute gcc: No such file or directory

# yum install gcc

ImportError: No module named flask.ext.sqlalchemy

# pip install Flask-SQLAlchemy

Flask session expiration

from datetime import timedelta
app.config['SECRET_KEY'] = 'random'
app.permanent_session_lifetime = timedelta(seconds=60*60*10)  # session expire time

Windows 7 PPPOE 錯誤 651

References :
Error 651 in Windows 7: A killer for internet connection/VPN | Techie Talkz

Python Flask delete session

flask.session.clear()

References :
flask.session.clear - Nullege Python Samples

datetime format

RFC3339

2008-09-08T22:47:31-07:00

RFC2445 (iCalendar)

20121211155343

ISO8601

2008-12-19T16:39:57.67Z

ATOM = "Y-m-d\TH:i:sP";

COOKIE = "l, d-M-y H:i:s T";

ISO8601 = "Y-m-d\TH:i:sO";

RFC822 = "D, d M y H:i:s O";

RFC850 = "l, d-M-y H:i:s T";

RFC1036 = "D, d M y H:i:s O";

RFC1123 = "D, d M Y H:i:s O";

RFC2822 = "D, d M Y H:i:s O";

RFC3339 = "Y-m-d\TH:i:sP";

RSS = "D, d M Y H:i:s O";

W3C = "Y-m-d\TH:i:sP";




References :
PHP: DateTime - Manual

jQuery prop('checked') vs. is(':checked') 速度比較

$el.prop('checked');

$el.is(':checked');

$el.attr("checked");

$el[0].checked;

 

 

 

 

 

References :

jQuery prop('checked') vs. is(':checked') · jsPerf

DUC unable to find a version of the runtime to run this application

install .net framework 2.0

CJSCOPE 驅動程式下載

ftp://61.222.111.87/
帳號：user
密碼：user




References :
CJSCOPE 喜傑獅 - You design , We made !

pcmanfm set icon theme

$ ls /usr/share/icons/

$ vi ~/.gtkrc-2.0

gtk-icon-theme-name = "Humanity"

nvidia brightness control on ubuntu 調整螢幕亮度

# vi /etc/X11/xorg.conf 

Section "Device"
        Identifier  "Card2"
        Driver      "nvidia"
        BusID       "PCI:1:0:0"
        Option "RegistryDwords" "EnableBrightnessControl=1"
EndSection

if no /etc/X11/xorg.conf 

# X :1 -configure

# mv xorg.conf.new /etc/X11

boot with argument acpi_backlight=vendor

 

亮度調整

$ xbacklight -dec 20
$ xbacklight -inc 20

References :
NVIDIA - ArchWiki