PySQL

by thinker

關鍵字:

之前 linkname:[Host SQL in $Python$] http://heaven.branda.to/~thinker/GinGin_CGI.py/show_id_doc/108 與 linkname:[Host SQL in $Python$ II] http://heaven.branda.to/~thinker/GinGin_CGI.py/show_id_doc/162
 兩篇討論以 $Python$ implement SQL command 的文章，被我丟到倉庫一陣子後，因為某 project 而被找回來。目前已經和 sqlite 進行整合，已可使用 $Python$ 定義 table 、 query 、 update  和 insert 。

下面是 PySQL 的一個$範例$:
{{{
    from pysqlite2 import dbapi2 as sqlite
    from pysql import *
    
    #
    # define data source
    # comprises tables and queries
    #
    class my_data_src(data_src):
        def ds_definition():
            class t1(pysql.table):
                #
                # define table 't1'
                #
                item = pysql.str_f()
                count = pysql.int_f()
                pass
            
            class t2(pysql.table):
                #
                # define table 't2'
                #
                item = pysql.str_f()
                money = pysql.float_f()
                pass
            
            #
            # define a query 'get_count_and_money_of_item'
            #
            get_count_and_money_of_item = \
            lambda: (t1 * t2) \
            .fields(t1.item, t1.count * t2.money - 30) \
            .where((t1.item == t2.item) & (t1.item != pysql._q))
            
            return ds_define()
        pass
    
    cx = sqlite.connect('$test$.db')

db = my_data_src(cx)  # create a instance of data source

db.init_db()  # create tables

db.insert(db.t1, item='foo', count=100)
    db.insert(db.t2, item='foo', money=3.2)
    db.insert(db.t1, item='boo', count=50)
    db.insert(db.t2, item='boo', money=3.0)

db.update(db.t1, count=140, where=~(db.t1.item == 'foo'))

cu = db.get_count_and_money_of_item('foo')
    rows = cu.fetchall()
    print rows

cu = db.get_count_and_money_of_item('cool')
    rows = cu.fetchall()
    print rows

db.commit()
    pass
}}}

== Downloads ==
需要 pysql 和 pythk 兩個 module
* http://master.branda.to/downloads/pysql/pysql-20070108.tar.gz
* http://master.branda.to/downloads/pythk/pythk-20070108.tar.gz

最後更新時間: 2007-01-08 12:18:06 CST | 引用

查詢:

COMMENTS: