littlesql A little database access interface
Download

littlesql Ranking & Summary

littlesql Tags

database Python library Python database access Access database interface

littlesql Description

littlesql is a vary simple database access interface for Python.Exampleexample table: foo (id int, name string)Connectconnect to sqlite3ctx = SqliteContext("test.db")db = Database(ctx)connect mysqlctx = MySqlContext(username="name", password="pwd", hostname="localhost", db="test")db = Database(ctx)Queryquery a row dictdb.foo("name=?", "tom").get()# raw sqldb.get("select * from foo where name=?", "tom")query many rowsdb.foo("id >?", 100).orderby("id desc").limit(0,10).query()# raw sqldb.query("select * from foo where id >? order by id desc limit 0,100;", 100)query selected colsdb.foo.query("id, name")# raw sqldb.query("select id, name from foo")Updatefdict = dict(name="new foo")db.foo("id=?", 1).update(**fidct)# raw sqldb.execute("update foo set name=? where id=?", "new foo", 1)Deletedb.foo("name like ?", "test%").delete()# raw sqldb.execute("delete from foo where name like ?", "test%")Product's homepage

littlesql Related Software