def alterAddPK(database, table, columns): if searchInMode(database) != None: currentMode = searchInMode(database) if currentMode == 'avl': # avlList.append(tableNew) return avl.alterAddPK(database, table, columns) elif currentMode == 'b': # bList.append(tableNew) return b.alterAddPK(database, table, columns) elif currentMode == 'bplus': # bplusList.append(tableNew) return bplus.alterAddPK(database, table, columns) elif currentMode == 'dict': # dictList.append(tableNew) return DM.alterAddPK(database, table, columns) elif currentMode == 'isam': # isamList.append(tableNew) return isam.alterAddPK(database, table, columns) elif currentMode == 'json': # jsonList.append(tableNew) return j.alterAddPK(database, table, columns) elif currentMode == 'hash': # hashList.append(tableNew) return Hash.alterAddPK(database, table, columns) else: return 2
def alterTableaddUnique(database , table, indexName, colums): tabla = {} for item in structs: tuplas = item.extractTable(database,table) if tuplas !=2: if item.tipoEDD() == 'avl': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if avl.createTable(database, table+indexName , len(colums)) != 2 and avl.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 elif item.tipoEDD() == 'bplus': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if bplus.createTable(database, table+indexName , len(colums)) != 2 and bplus.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 elif item.tipoEDD() == 'b': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if b.createTable(database, table+indexName , len(colums)) != 2 and b.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 elif item.tipoEDD() == 'hash': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if _hash.createTable(database, table+indexName , len(colums)) != 2 and _hash.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 elif item.tipoEDD() == 'isam': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if isam.createTable(database, table+indexName , len(colums)) != 2 and isam.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 elif item.tipoEDD() == 'dict': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if _dict.createTable(database, table+indexName , len(colums)) != 2 and _dict.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 elif item.tipoEDD() == 'json': indice = (indexName , colums) tabla[table] = indice uIndex[database] = tabla if _hash.createTable(database, table+indexName , len(colums)) != 2 and _hash.alterAddPK(database, table+indexName, colums) !=2: for i in tuplas: unicos = [i[x] for x in colums] if None in unicos: return 2 else: value = item.insert(database, table+indexName, unicos) if value == 2: return 2 else: return 2 else: return 3