littlesql 0.1

连接

连接到sqlite3

ctx =  SqliteContext("test.db")
db = Database(ctx)

connect mysql

ctx = MySqlContext(username="name", password="pwd", hostname="localhost", db="test")
db = Database(ctx)

查询

查询行dict

db.foo("name=?", "tom").get()

# raw sql
db.get("select * from foo where name=?", "tom")

查询多行

db.foo("id>?", 100).orderby("id desc").limit(0,10).query()

# raw sql
db.query("select * from foo where id>? order by id desc limit 0,100;", 100)

查询选定的列

db.foo.query("id, name")

# raw sql
db.query("select id, name from foo")

更新

fdict = dict(name="new foo")
db.foo("id=?", 1).update(**fidct)

# raw sql
db.execute("update foo set name=? where id=?", "new foo", 1)

删除

db.foo("name like ?", "test%").delete()

# raw sql
db.execute("delete from foo where name like ?", "test%")

其他

请参阅测试代码。