Simple DataBase tools for MySQL
Project description
mageia
This is a simple database tools for MySQL
- Based on SQLAlchemy
- Transaction-Safe
- Friendly interface for developer
- Use
:param
syntax bind param
Documentation
pip install mageia
Usage
from mageia.db import DB, create_engine, Dict
url = "mysql+pymysql://root:password@localhost/info?charset=utf8"
# create a engine instance, and DB instance
engine = create_engine(url)
db = DB(engine)
Query
# return [dict-like,dict-like,dict-like,] or None
user_list = db.query("select * from user where id=:id", id = 1)
user_list = db.query("select * from user where id in :id", id = [1,2,3])
user = user_list[0]
print(user.id)
print(user.name)
Query One
# return dict-like or None
db.query_one("select * from user where id=:id", id = 1)
Query Page
# return [dict-like,dict-like,dict-like,] or None
user = db.query_page("select * from user", page=1, limit=10)
Insert
Jack = {
"name":"Jack",
"age":18,
"sex":1
}
table = "user"
# Insert done, don't need commit
db.add(table, Jack)
Insert Many
Jack = {
"name":"Jack",
"age":18,
"sex":1
}
Tom = {
"name":"Tom",
"age":18,
"sex":1
}
table = "user"
db.add_many(table, [Tom,Jack])
Delete
data = db.query_one("select * from user where id = :id", id=1)
# Delete done, don't need commit, data must contain a primary key ,etc id .
db.delete("user", data)
Merge
data = db.query_one("select * from user where id = :id", id=1)
# merge done, don't need commit, data must contain a primary key ,etc id .
data.name = "stefanlei"
db.merge("user",data)
Merge many
user_list = db.query("select * from user where id in :ids", ids=[1, 2, 3, 4, 5, 6, 7, 8])
for user in user_list:
user.name = "stefanlei"
db.merge_many("user", user_list)
Execute
# return affected rows total
db.execute("delete from user where id = 1")
db.execute("update user set age = 18 where age = :age", age=16)
Transaction-Safe
You can also use session
to keep Transaction-Safe
# Use session to keep transaction-safe
with db.session() as s:
db_user = s.query_one("select * from user")
s.delete("user", db_user)
user = Dict()
user.name = "stefan"
user.age = 18
s.add("user", user)
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
mageia-0.1.3.tar.gz
(3.8 kB
view hashes)