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

Download files

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

Source Distribution

anduin-3.0.11b0.tar.gz (11.1 kB view details)

Uploaded Source

File details

Details for the file anduin-3.0.11b0.tar.gz.

File metadata

  • Download URL: anduin-3.0.11b0.tar.gz
  • Upload date:
  • Size: 11.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.6.1 requests/2.25.1 setuptools/51.1.0.post20201221 requests-toolbelt/0.9.1 tqdm/4.54.1 CPython/3.8.6

File hashes

Hashes for anduin-3.0.11b0.tar.gz
Algorithm Hash digest
SHA256 6d2180243f72721e15964b1924d616aae93db05fe4519c86c7a2f8b0d47f593f
MD5 4e0df4fccf681fb850b3ce3cf083a7ec
BLAKE2b-256 050110b2392d6e344c95d3a61e49135cf83ae0f7544ce0e7a2956f7c9d049d5e

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