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)
