Mercurial > hg > sqlex
diff sqlex/model.py @ 2:63a75d318b06
stub a model
author | Jeff Hammel <k0scist@gmail.com> |
---|---|
date | Sat, 01 Apr 2017 08:44:42 -0700 |
parents | |
children | 5f1e1ac96aa7 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sqlex/model.py Sat Apr 01 08:44:42 2017 -0700 @@ -0,0 +1,30 @@ +import sqlite3 + +class SQLEx(object): + """ + sqlite model + https://docs.python.org/2/library/sqlite3.html + """ + + def __init__(self, db): + self.db = db + self.conn = sqlite3.connect(self.db) + + def __call__(self, sql, *args): + c = conn.cursor() + c.execute(sql, args) + c.commit() + + def __del__(self): + self.conn.close() + + def tables(self): + """ + returns table names in database + """ + # http://stackoverflow.com/questions/82875/how-to-list-the-tables-in-an-sqlite-database-file-that-was-opened-with-attach + + sql = "SELECT name FROM dbname.sqlite_master WHERE type='table';" + tables = self(sql) + return tables +