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)