easySQL-fiachia

use:

database connect:
1. db=easySQL(databaseName, user, passwd, host) or easySQL(database)
table creat:
1. table = tableSQL(tableName, engine, charset)
1. table.addAttribute(aName, aType, aLong, default, isNotNull, isPrimaryKey, isAuto, isUnique, isUnsigned)
1. sql = table.creatLanguage()
1. db.commit(sql)
data find:
1. data = db.find(tableName, key1=value1, key2=value2…)
data add:
1. db.add(tableName, key1=value1, key2=value2…) or db.add(tableName, data)
data delete:
1. db.delete(tableName, key1=value1, key2=value2…) or db.add(tableName, data)
data update:
1. db.update(data, key1=value3, key2=value4…)
other:
1. db.commit(sql) or db.getData(sql)
data add dataList:
1. add all data in dataList. if input data is not list, it will be list in this function. this function need all input list type have the same length.
1. db.addList(tableName, key1=list1, key2=list2…)
data add(data add data rather than data add to table)
1. data.add(data1)
creat table by DIC(json.loads()):
1. db.creat(tableName, childDeep=0, **kwargs)

1. Modify a small amount of code and logic to improve efficiency
1. db.commit(sql) change to db.execute(sql)
1. you can use db.addSQL(sql(s)) db.showSQL(index=None) db.deleteSQL(index=None) to change sqlList and then db.commit() to run sqlList

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution for easySQL-fiachia 3.2.8
File	Size	Uploaded
easySQL_fiachia-3.2.8.tar.gz	29.4 kB	Dec 28, 2022	Details

Table of built distributions (wheels) for easySQL-fiachia 3.2.8
File	Interpreter	ABI	Platform	Reset
easySQL_fiachia-3.2.8-py2.py3-none-any.whl 29.5 kB Dec 28, 2022	Python 2, Python 3	none	any	Details

Total release size: 58.9 kB

Download URL	easySQL_fiachia-3.2.8.tar.gz
Size	29.4 kB
Tags	Source
SHA-256 checksum How to use checksums	`383a2bdaa46ae90fa4d5af9186110efbebc47e2d49ecad58d04eb949ebb7b85d`
BLAKE2b-256 checksum How to use checksums	`bea78f96d6f9edf7171bdc6772ff3771086ae9e908e3778b9f2c95bffa0e05d9`
Upload date	Dec 28, 2022
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.2 CPython/3.10.8`

Download URL	easySQL_fiachia-3.2.8-py2.py3-none-any.whl
Size	29.5 kB
Tags	Python 2 Python 3
SHA-256 checksum How to use checksums	`aca33a4cb70521f699786d8a4886d8703ffb893f8734507929aff2ae37b309fb`
BLAKE2b-256 checksum How to use checksums	`daca21e565a623efd16ee209da00da49dfeee4fc3e49eacbba5e86a86cc5ca76`
Upload date	Dec 28, 2022
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.2 CPython/3.10.8`