def createTable(database, table, numbercolumns):
if searchInMode(database) != None:
currentMode = searchInMode(database)
if currentMode == 'avl':
avlList.append(table)
return avl.createTable(database, table, numbercolumns)
elif currentMode == 'b':
bList.append(table)
return b.createTable(database, table, numbercolumns)
elif currentMode == 'bplus':
bplusList.append(table)
return bplus.createTable(database, table, numbercolumns)
elif currentMode == 'dict':
dictList.append(table)
return DM.createTable(database, table, numbercolumns)
elif currentMode == 'isam':
isamList.append(table)
return isam.createTable(database, table, numbercolumns)
elif currentMode == 'json':
jsonList.append(table)
return j.createTable(database, table, numbercolumns)
elif currentMode == 'hash':
hashList.append(table)
return Hash.createTable(database, table, numbercolumns)
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
