def __init__(self, configFilePath): self.configFilePath = configFilePath self.dbHelper = None # self.dbHelper = MysqlHelper.DB("localhost", 3306, "root", "", "metadata") self.dbHelper = MysqlHelper.DB( readInXml.getElement(self.configFilePath, 'DatabaseConfig', 'host'), int( readInXml.getElement(self.configFilePath, 'DatabaseConfig', 'port')), readInXml.getElement(self.configFilePath, 'DatabaseConfig', 'userName'), "", readInXml.getElement(self.configFilePath, 'DatabaseConfig', 'dbName'))
if self.cursor is not None: columnsArray = [] sql_cols = "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE table_name ='" + tableName + "'" self.cursor.execute(sql_cols) row_cols = self.cursor.fetchall() for row_col in row_cols: columnsArray.append(row_col[0]) return columnsArray def __printMergeData(self, tableName, num): if self.cursor is not None: columnsArray = self.__getTableColsArray(tableName) sql = "SELECT * FROM " + tableName + " limit 0," + num info = "{\nstorage:HBase\n" self.cursor.execute(sql) for row in self.cursor.fetchall(): i = 0 info += "\trecords:{\n" for eachUnit in row: # print eachUnit, columnsArray[i] info += "\t\t" + columnsArray[i] + " : " + str( eachUnit) + "\n" i += 1 info += "\t}\n}" print info if __name__ == '__main__': conn = MysqlHelper.DB("localhost", 3306, "root", "", "metadata") LoadMetadata(conn.getCursor(), './config/mapping.conf', 'CRJ_CCRJZJRYXX', conn)