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