easySQL-fiachia 3.2.8

Easy SQL Used pymysql

Name:

easySQL

Author:

fiachia

Function:

use easy function to execute pyMySQL module

Defect:

only easy SQL can be used

use:

• database connect:

• 1. db=easySQL(databaseName, user, passwd, host) or easySQL(database)

• table creat:

• 1. table = tableSQL(tableName, engine, charset)

• 2. table.addAttribute(aName, aType, aLong, default, isNotNull, isPrimaryKey, isAuto, isUnique, isUnsigned)

• 3. sql = table.creatLanguage()

• 4. 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:

• 14. 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)

2.0.4:

• 1. fix the columns in mysql maybe in confusion

2.0.5:

• 1. you can get data by a dict type

2.0.6:

• 1. fix a bug that dict use the same addr

2.0.7:

• 1. Modify a small amount of code and logic to improve efficiency

• 2. db.commit(sql) change to db.execute(sql)

• 3. 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:

• 1. fix a wrong that NoneType in data