def _createDatabase():
dataabaseName = _getInput('Enter Database Name')
count = _processInteger('Enter Number of Fields')
schemaElements = []
i = 0
while i < count:
field_name = _getInput('Enter Field Name')
if _checkIfAlreadyExists(field_name, schemaElements):
print "Error: Field name already exits"
else:
while True:
print ("\nChoose Field Type\n" +
"1. INT\n" +
"2. DOUBLE\n" +
"3. STRING\n")
client_input = _getInput('Select')
if(client_input == '1'):
field_type = DBSlice.INT
break
elif(client_input == '2'):
field_type = DBSlice.DOUBLE
break
elif(client_input == '3'):
field_type = DBSlice.STRING
break
else:
print "Error: Invalid input"
schemaElements.append(SliceField(field_name, field_type))
i = i + 1
indexNotGood = True
while indexNotGood:
index = _getInput('Enter Index Name (Optional, INT Type)')
if index == '':
indexNotGood = False
for field in schemaElements:
if field.name == index and field.type == DBSlice.INT:
indexNotGood = False
if index == '':
index = None
sliceEnv = SliceEnv()
sliceEnv.createDB(dataabaseName, schemaElements, index)
'''
Created on Aug 12, 2014
@author: Mehrdad Dehdashti
'''
from SliceDBMS import DBSlice
from SliceDBMS.SliceEnv import SliceEnv
from SliceDBMS.SliceField import SliceField
if __name__ == '__main__':
schemaElements = [
SliceField("cust", DBSlice.INT),
SliceField("name", DBSlice.STRING),
SliceField("age", DBSlice.INT),
SliceField("phone", DBSlice.STRING),
SliceField("address", DBSlice.STRING)
]
sliceEnv = SliceEnv()
sliceEnv.createDB("CustDB", schemaElements, "cust")