anduin 1.3.5

a mysql connector

a lite mysql connector… Name from the Lord of Ring

<=========how to use=========>

from anduin.server import Data

cond = [

(col1,’=’,val1), (col2,’=’,val2), ….]

fields = [

col1, col2 …]

params = {

key1:val1, key2:val2, …}

find one line of data:

Data.find(__TableName__,conditions=cond,fields=fields)

return a python dict like { col1:value1,col2:value2…}

find datas

Data.select(__TableName__,conditions=cond,fields=fields)

return a python list like [{ col1:value1,col2:value2…}]

update data:

Data.update(__TableName__,conditions=cond,params=params)

return None

insert data:

Data.insert(__TableName__,params=params)

return None

delete data:

Data.delete(__TableName__,conditions=cond)

return None

using Data.query() to execute sql directly like Data.query(‘select * from table’)