from cosql.manager import DBManager
from cosql.connector import DBConnector
from cosql.command import DBCommand
from cosql.command import db_checker
from cosql.sqlobject import SQLiteObject
class SQLiteCmd(DBCommand):
@db_checker
def select(self):
# self.execcmd("select * from TestTable where id = 9930 or id=5678 order by id")
return self.execcmd("SELECT * FROM TestTable WHERE id IN (9930, 5678) ORDER BY id")
dbc_sqlite = DBConnector(host="test.db", maxline=1, sqltype=SQLiteObject, cmdtype=SQLiteCmd)
dbm = DBManager()
dbm.regConnector("sqlite", dbc_sqlite)
dbm.start()
def cosql_sqlite_select():
cmd = dbm.getCommand("sqlite")
return cmd.select().getOne(0)
if __name__ == "__main__":
rst = cosql_sqlite_select()
print rst.id
cmd = dbm.getCommand("sqlite")
sql = "insert into TestTable (id,name,phone) values (%d, '%s', %d)" % (i, "cello_" + str(i), 100 + i)
# print sql
self.execcmd(sql)
@db_checker
def select(self):
# self.execcmd("select * from TestTable where id = 9930 or id=5678 order by id")
self.execcmd("SELECT * FROM TestTable WHERE id IN (9930, 5678) ORDER BY id")
dbc_sqlite = DBConnector(host="test.db", maxline=1, sqltype=SQLiteObject, cmdtype=SQLiteCmd)
dbc_mysql = DBConnector(
host="192.168.44.142", db="cello", user="******", passwd="cello", maxline=1, sqltype=MySQLObject, cmdtype=MySQLCmd
)
dbm = DBManager()
dbm.regConnector("sqlite", dbc_sqlite)
dbm.regConnector("mysql", dbc_mysql)
dbm.start()
# cmd = dbm.getCommand("sqlite")
# cmd.GetMemData()
conn = sqlite3.connect("test.db")
cur = conn.cursor()
def create_table():
cur.execute(
"""create table [TestTable]
(serial integer primary key autoincrement,
