easySQL-fiachia 2.0.3

Easy SQL Used pymysql

Name:

easySQL

Author:

fiachia

Function:

use easy function to execute pyMySQL module

Defect:

only easy SQL can be used

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