Skip to main content

a lite mysql & sqlite3 connect engine, mapping table into k-v structure

Project description

a lite mysql & sqlite3 connect engine… Name from the Lord of Ring

<=========how to use=========>

from anduin.river import Ring

configuration setting:
db_config = {‘host’: mysql host,

‘user’: username,

‘password’: password,

‘database’: database name,

‘port’: port,

‘engine’:’mysql’}

then use Ring.init(db_config) to init the connection

now enjoy it!!

or you can put a config file in config/db_config.py , write the dict in it

cond = [

(col1,’=’,val1), (col2,’=’,val2), ….]

fields = [

col1, col2 …]

params = {

key1:val1, key2:val2, …}

find one line of data:

Ring.find(__TableName__,conditions=cond,fields=fields)

return a python dict like { col1:value1,col2:value2…}

find datas

Ring.select(__TableName__,conditions=cond,fields=fields)

return a python list like [{ col1:value1,col2:value2…}]

update data:

Ring.update(__TableName__,conditions=cond,params=params)

return None

insert data:

Ring.insert(__TableName__,params=params)

return None

delete data:

Ring.delete(__TableName__,conditions=cond)

return None

using Ring.query() to execute sql directly like Ring.query(‘select * from table’)

all of these executions will have auto commit

or you can do like

from anduin.river import Ring

db_manager = Ring.Base_pool[‘default’] sql = db_manager.find_free_sql()

sql.update(‘user’,cond,or_cond=None,params=params ) sql.insert(‘user’,params=params ) sql.delete(‘user’,cond,or_cond=None)

sql.commit()

to choose a certain sql connection to execute

Project details


Release history Release notifications | RSS feed

This version

5.0.9

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

anduin-5.0.9.tar.gz (11.9 kB view details)

Uploaded Source

File details

Details for the file anduin-5.0.9.tar.gz.

File metadata

  • Download URL: anduin-5.0.9.tar.gz
  • Upload date:
  • Size: 11.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/3.10.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.60.0 CPython/3.8.2

File hashes

Hashes for anduin-5.0.9.tar.gz
Algorithm Hash digest
SHA256 285bd109a41fb5a13568eb7a5ed25024284940e1c877e2dc65d9c7ba645a8e45
MD5 8315e890a978b081010313767eba6d9e
BLAKE2b-256 9d75f8da3b5a835d29d5533762fa7071852c6c190f0851e7257a8d42ebf3d228

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page