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. Also, my first pypi package - will probably use it for tests and sheningans.
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.15-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5933f004b454c6006b8bd2149b7a50feaa18204b2d460260f16f1ebb2754411a |
|
MD5 | 2fa781570338bbf73842e6b4d1ee9b09 |
|
BLAKE2-256 | 2845fd8a334cddf5b999c2d276a1ae550744b17435d7bbe809c453d4e09f9f4b |