Simple util from which I inherit my sqlite classes
Project description
Simple class that wraps around the sqlite3.conn().cursor().execute()
method
from simplesqlitewrap import Database
class DbWrapper(Database):
def create_tables(self):
self._execute('CREATE TABLE IF NOT EXISTS Users (user_id INTEGER PRIMARY KEY, first_name NVARCHAR);')
def insert_users(self, users, **kwargs):
return self._execute('INSERT OR IGNORE INTO Users (user_id, first_name) VALUES (?, ?)', users, many=True, **kwargs)
def select_users(self, **kwargs):
# returns the list of all the records in 'Users'
return self._execute('SELECT * FROM Users', fetchall=True, **kwargs)
db = DbWrapper('database.sqlite')
print(db)
db.create_tables()
params = [(1, 'Bob'), (2, 'Charlie')]
rows_inserted = db.insert_users(params, rowcount=True)
print('Rows inserted:', rows_inserted)
users = db.select_users(as_namedtuple=True)
for user in users:
print('ID:', user.user_id, 'first name:', user.first_name)
Installation
pip install simplesqlitewrap
Disclaimer
If you stumbled upon this package, please remember that this is just a small utility I made for myself - breaking changes may be introduced without notice
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for simplesqlitewrap-0.1.12-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 010c6adb9900e66629eeca11b1c8e27e5d9280be8f4108363e4b80caf7cc9296 |
|
MD5 | 1cf8f23cdbdccadb6ff02074d0902f8f |
|
BLAKE2b-256 | 5fa8a8d458234dc77aff2cc7abdff8c995c6da52b2744b16e80acf053cc7c515 |