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