Ejemplo n.º 1
0
def add_row_to_table(database_name, table_name, row):
    #row like ['a','int']
    if is_db_and_tb_both_exist(database_name, table_name) == False:
        return False
        
    table_info_path = get_table_info_txt_path(database_name, table_name)
    
    #print 'row',row
    row_obj = create_new_row_object(row)
    #print 'row_obj',row_obj
    if row_obj is None:
        #print 'Your input was wrong'
        return False
    else:
        row_name = row[0]
        if is_row_exist(database_name, table_name, row_name ) == True:
            print 'The row named %s has already exists!' % (row_name)
            return False
        
        row_info = ''
        for r in row:
            row_info += r + '\t'
            
        row_info += '\n'
        append_string_to_file(row_info,table_info_path)
        return True
    
    return False
Ejemplo n.º 2
0
def drop_row(database_name, table_name, row_name):
    if is_db_and_tb_both_exist(database_name, table_name) == False:
        return False
    if is_row_exist(database_name, table_name, row_name ) == False:
        print 'The row named %s has not exists!' % (row_name)
        return False
    
    table_info_txt_path = get_table_info_txt_path(database_name, table_name)
    table_info_list = get_object_from_file_append_to_list(table_info_txt_path)
    
    after_drop_info = get_drop_row_string_from_infolist(table_info_list,row_name)
        
    write_to_file(after_drop_info, table_info_txt_path)
    
    return True
Ejemplo n.º 3
0
def modify_row_from_table(database_name, table_name, row_name,new_type):
    
    if new_type not in ROW_TUPLE:
        return False
    if is_db_and_tb_both_exist(database_name, table_name) == False:
        return False
    if is_row_exist(database_name, table_name, row_name ) == False:
        print 'The row named %s has not exists!' % (row_name)
        return False

    table_info_txt_path = get_table_info_txt_path(database_name, table_name)
    table_info_list = get_object_from_file_append_to_list(table_info_txt_path)
    
    after_modified_info = get_modified_row_string_from_infolist(table_info_list, row_name , new_type)
    
    write_to_file(after_modified_info, table_info_txt_path)
    
    return True