Metadata-Version: 2.1
Name: easySQL-fiachia
Version: 2.0.5
Summary: Easy SQL Used pymysql
Home-page: UNKNOWN
Author: fiachia
Author-email: 208473302@qq.com
Maintainer: fiachia
Maintainer-email: 208473302@qq.com
License: BSD License
Platform: all
Requires-Dist: pymysql

: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


