def test_is_table_exist():
database_name = 'a'
table_name = 'a'
print is_table_exist(database_name,table_name)
table_name = 'b'
print is_table_exist(database_name,table_name)
raw_input('>')
def create_table(database_name,table_name,rows):
if is_database_exist(database_name) == False:
print 'The database named %s was not exists!' % (database_name)
return False
if is_table_exist(dbname = database_name,table_name = table_name) == True:
print 'The table named %s has already exists!' % (table_name)
return False
if whether_can_new_table_object(table_name,rows) == False:
#print r' Your input was wrong.'
return False
database_path = get_data_base_path(database_name)
table_name_append_suffix = table_name + TABLE_INFO_FILE_SUFFIX
table_info = ''
for row in rows:
table_info += '\t'.join(row)
table_info += '\n'
write_to_file(string = table_info,file_path = r'%s\%s' % (database_path ,table_name_append_suffix))
write_to_file(string = '',file_path = r'%s\%s%s' % (database_path ,table_name,TABLE_DATA_FILE_SUFFIX))
append_string_to_file(string = table_name + '\n', file_path = r'%s\%s' % (database_path,TABLES_NAME_FILE))
#print 'Table created successful!'
return True
def desc_table(database_name,table_name):
if table_name is None:
print 'Please input the table you want to check out!'
return None
if is_database_exist(database_name) == False:
print 'The database named %s was not exists!' % (database_name)
return None
if is_table_exist(dbname = database_name,table_name = table_name) == False:
print 'The table named %s was not exists!' % (table_name)
return None
info_path = get_table_info_txt_path(database_name,table_name)
table_infomation = get_object_from_file_append_to_list(info_path)
for info in table_infomation:
print ' '.join(info)
return table_infomation
