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
