semvec/pypi-packages huggingface dataset:
easySQL-fiachia 3.2.8
Easy SQL Used pymysql
License: BSD License

:Name: easySQL
:Author: fiachia
:Function: use easy function to execute pyMySQL module
:Defect: only easy SQL can be used

use:
####
* database connect:
* a) db=easySQL(databaseName, user, passwd, host) or easySQL(database)
* table creat:
* a) table = tableSQL(tableName, engine, charset)
* b) table.addAttribute(aName, aType, aLong, default, isNotNull, isPrimaryKey, isAuto, isUnique, isUnsigned)
* c) sql = table.creatLanguage()
* d) db.commit(sql)
* data find:
* a) data = db.find(tableName, key1=value1, key2=value2...)
* data add:
* a) db.add(tableName, key1=value1, key2=value2...) or db.add(tableName, data)
* data delete:
* a) db.delete(tableName, key1=value1, key2=value2...) or db.add(tableName, data)
* data update:
* a) db.update(data, key1=value3, key2=value4...)
* other:
* a) db.commit(sql) or db.getData(sql)
* data add dataList:
* n) 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.
* a) db.addList(tableName, key1=list1, key2=list2...)
* data add(data add data rather than data add to table)
* a) data.add(data1)
* creat table by DIC(json.loads()):
* a) db.creat(tableName, childDeep=0, \**kwargs)

2.0.4:
######
* a) fix the columns in mysql maybe in confusion

2.0.5:
######
* a) you can get data by a dict type

2.0.6:
######
* a) fix a bug that dict use the same addr

2.0.7:
######
* a) Modify a small amount of code and logic to improve efficiency
* b) db.commit(sql) change to db.execute(sql)
* c) 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

2.0.8:
######
* a) fix a wrong that NoneType in data