Easy SQL Used pymysql
Project description
- Name:
easySQL
- Function:
use easy function to execute pyMySQL module
- Defect:
only easy SQL can be used
use:
database connect:
db=easySQL(databaseName, user, passwd, host) or easySQL(database)
table creat:
table = tableSQL(tableName, engine, charset)
table.addAttribute(aName, aType, aLong, default, isNotNull, isPrimaryKey, isAuto, isUnique, isUnsigned)
sql = table.creatLanguage()
db.commit(sql)
data find:
data = db.find(tableName, key1=value1, key2=value2…)
data add:
db.add(tableName, key1=value1, key2=value2…) or db.add(tableName, data)
data delete:
db.delete(tableName, key1=value1, key2=value2…) or db.add(tableName, data)
data update:
db.update(data, key1=value3, key2=value4…)
other:
db.commit(sql) or db.getData(sql)
data add dataList:
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.
db.addList(tableName, key1=list1, key2=list2…)
data add(data add data rather than data add to table)
data.add(data1)
creat table by DIC(json.loads()):
db.creat(tableName, childDeep=0, **kwargs)
2.0.4:
fix the columns in mysql maybe in confusion
2.0.5:
you can get data by a dict type
2.0.6:
fix a bug that dict use the same addr
2.0.7:
Modify a small amount of code and logic to improve efficiency
db.commit(sql) change to db.execute(sql)
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:
fix a wrong that NoneType in data
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
Built Distribution
Hashes for easySQL_fiachia-2.0.8-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 35c6edd2b312f4fd728d277cbbd66c8ee572121bee623c9472fa9e12484dec7a |
|
MD5 | a503034c63f83b39f8cfab3820a3859f |
|
BLAKE2b-256 | 1af94e6d891f4d10fd525a02def367325941f0bc5ff49abe37dae7e8394178c7 |