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.1.tar.gz
(3.8 kB
view hashes)
Built Distribution
Close
Hashes for sql_manager-1.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e6a9b1515b1958b3ed6ee9d3cef79476ac74ee8a2e5493b4486b5577a91d39d0 |
|
MD5 | 31a1a084f7c65742a00d5eec4799adb8 |
|
BLAKE2b-256 | c6bddf189900d763890b88278d1dd94d89ec7ae233c3fdfd6c1e5a8363c4f58e |