return val ################################################# # MAIN ################################################# if __name__ == '__main__': from connect import Connect # automatically sets default schema handler = Connect() # drop table handler.run_query("DROP TABLE PROFILE.BIGTABLE_EMPLOYEE") # create table handler.run_query( """ CREATE TABLE BIGTABLE_EMPLOYEE ( firstname VARCHAR(30), lastname VARCHAR(30), email VARCHAR(50), id BIGINT, agency_code CHAR(5), traveler_profile BIGINT, loyalty_type SMALLINT, provider_code CHAR(5), loyalty_no VARCHAR(50) );
if __name__ == '__main__': from connect import Connect # automatically sets default schema handler = Connect() ###### #### employee ###### new_table = "EMPLOYEE" # drop if handler.table_exists(new_table): query = "DROP TABLE %s" % new_table handler.run_query(query) # create query = """ CREATE TABLE PROFILE.%s ( firstname VARCHAR(30), lastname VARCHAR(30), middlename VARCHAR(30), birthdate VARCHAR(12), phone VARCHAR(30), gender CHAR(1), email VARCHAR(50) UNIQUE NOT NULL, traveler_profile VARCHAR(30) NOT NULL, CONSTRAINT pk_traveler_profile PRIMARY KEY(traveler_profile) )""" % new_table handler.run_query(query)
query.append( col_names[i] + " BIGINT" ) all_col_types.append("BIGINT") elif col_len[i] >= 5: query.append( col_names[i] + " INTEGER" ) all_col_types.append("INTEGER") elif col_len[i] >= 0: query.append( col_names[i] + " SMALLINT") all_col_types.append("SMALLINT") else: query.append( col_names[i] + " VARCHAR(" + str(col_len[i]) + ")" ) all_col_types.append("VARCHAR") tmp = ','.join(query[:-1]) if handler.table_exists("BIGTABLE_EMPLOYEE_DETAIL"): handler.run_query("DROP TABLE PROFILE.BIGTABLE_EMPLOYEE_DETAIL") query = "CREATE TABLE PROFILE.BIGTABLE_EMPLOYEE_DETAIL (" + tmp + "," + query[-1] + ");" handler.run_query(query) # dump from excel into table rows_dumped = 0 rows_with_bug = [] for i in range(1, sheet.nrows): row = sheet.row_values(i) try: row = [format(x) for x in row] except UnicodeEncodeError: print "Unicode bug: ", row