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") rst = cmd.select()
# 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, id int not null,