a Database Wrapper for Redis and MySQL
Project description
a Database Wrapper for Redis and MySQL
from DBService import MysqlService
mysql_server = MysqlService(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_PORT, MYSQL_DB)
# query
mysql_server.query("SELECT * FROM TABLE")
# execute
mysql_server.execute("UPDATE from TABLES SET a = 55 WHERE id = 1")
# transaction
mysql_server.query(["UPDATE from TABLES SET a = 55 WHERE id = 1","UPDATE from TABLES SET a = 545 WHERE id = 2"])
from DBService import RedisService
redis_server = RedisService("redis://:user@host:port/db")
from DBService import PgsqlService
pgsql_server = PgsqlService(PGSQL_HOST, PGSQL_USER, PGSQL_PASSWORD, PGSQL_PORT, PGSQL_DB)
# query
pgsql_server.query("SELECT * FROM TABLE")
# execute
pgsql_server.execute("UPDATE from TABLES SET a = 55 WHERE id = 1")
# transaction
pgsql_server.query(["UPDATE from TABLES SET a = 55 WHERE id = 1","UPDATE from TABLES SET a = 545 WHERE id = 2"])
also support async,use them just add 'await'
from DBService import AsyncRedisService,AsyncMysqlService,AsyncPgsqlService
redis_server = AsyncRedisService("redis://:user@host:port/db")
mysql_server = AsyncMysqlService(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_PORT, MYSQL_DB)
pgsql_server = AsyncPgsqlService(PGSQL_HOST, PGSQL_USER, PGSQL_PASSWORD, PGSQL_PORT, PGSQL_DB)
# or pgsql_server = AsyncPgsqlService(dsn="postgresql://username:password@localhost:5432/mydatabase")
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
dbservice-2.1.1.tar.gz
(13.4 kB
view hashes)
Built Distribution
dbservice-2.1.1-py3-none-any.whl
(14.4 kB
view hashes)
Close
Hashes for dbservice-2.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e8a2306a861c163ee87b2a64d372f65a568091fd2432e6c785a1a6cb6f934518 |
|
MD5 | 130e7af8dc96e5a01aea53f0bf4508c1 |
|
BLAKE2b-256 | 14d4c140c0462bad755e9d736523cc9eaae8edafcad7a2de124efd1d5afbb86a |