A simple database manager with sqlalchemy
Project description
A simple database manager with sqlalchemy
Installation
python3 -m pip install sql_manager
Basic Usage
from sqlalchemy import Column, Integer
from sql_manager import DynamicModel, Manager
# create model
columns = {
'uid': Column(Interger, primary_key=True),
'name': Column(String(10), comment='the username')}
Base, Data = DynamicModel('TEST', columns, 'test')
# insert data
with Manager(Base, dbfile='test.db') as m:
data = Data(uid=1, name='zoro')
m.insert(Data, 'uid', data)
# query, delete
with Manager(Base, dbfile='test.db') as m:
res = m.query(Data, 'uid', 1)
print(res.all())
m.delete(Data, 'uid', 1)
# other origin methods
with Manager(Base, dbfile='test.db') as m:
query = m.session.query(Data)
query.filter(Data.name.like('%zo%')).limit(1)
Document
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sql_manager-1.0.2.tar.gz
(4.3 kB
view hashes)
Built Distribution
Close
Hashes for sql_manager-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0ed631125df5dcd4eee2d07cbf633a46696c595510bc166bfd2b3b49007f3b2e |
|
MD5 | 30981f9f1dfd4ee27f953db0e6c72e2c |
|
BLAKE2b-256 | d2dbebb834e8299728be9ff0c93d9a2a0e9eb2cd6d516bdddc4601da5a028091 |