def InsertRowToTable(_tblName, _header, _rowsTuple):
tmp = ["%s" for x in range(len(_header))]
strValue = ", ".join(tmp)
sql = "INSERT INTO " + _tblName + " (" + ",".join(_header) \
+ ") VALUES" + "(" + strValue + ")"
connection = mySQLSettings.OpenConnection()
cursor = connection.cursor()
cursor.executemany(sql, _rowsTuple)
connection.commit()
mySQLSettings.CloseConnection(connection)
def GetCellValue(_columnValue, _tblName, _columnCondition, _valueCondition):
# condList = []
# for x, y in zip(_columnCondition, _valueCondition):
# condList.append(x + "='" + y + "'")
# mylist1 = ",".join(condList)
condList = " and ".join([
x + "='" + y + "'" for x, y in zip(_columnCondition, _valueCondition)
])
sql = "SELECT " + _columnValue + " FROM " + _tblName + " WHERE " + condList
connection = mySQLSettings.OpenConnection()
df = pd.read_sql(sql, connection)
return df[_columnValue]
def tblToDataFrame(_tblName):
sql = "SELECT * FROM " + _tblName
connection = mySQLSettings.OpenConnection()
return pd.read_sql(sql, connection)
def GetFunctionStatus(_status):
sql = "SELECT * FROM " + tblFunctionList + " WHERE " + columnRunHeader + " ='" + _status + "'"
connection = mySQLSettings.OpenConnection()
df = pd.read_sql(sql, connection)
result = zip(df['id'], df['run'])
return result
def RunSQL(_sql):
connection = mySQLSettings.OpenConnection()
cursor = connection.cursor()
cursor.execute(_sql)
connection.commit()
mySQLSettings.CloseConnection(connection)