Metadata-Version: 1.2
Name: easySQL_fiachia
Version: 2.0.8
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
Description: :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
Platform: all
