inputpanel = views.inputToString(relation, currentfds, mvds,
additionalFds, additionalMvds,
"default", candidatekeys)
if (step == '4'):
currentfds, currentmvds = DBnormalizer.parseInputFDsMVDs(
str(form['currentfds'].value))
#validate final fds
try:
finalfdinput = str(form['finalfds'].value)
except KeyError:
finalfdinput = ""
canonicalcover = inputValidation.validateFinalCanonicalCoverFds(
currentfds, finalfdinput)
if canonicalcover:
alert = views.getSuccessMessageBox("Richtig!")
relations = DBnormalizer.generateNewRelations(canonicalcover)
numberOfTries = numberOfTries - 1
quizform = quizForms.formRelationSchemas(numberOfTries,
numberOfSteps,
relationString, fdsString,
canonicalcover, relations)
inputpanel = views.inputToString(relation, canonicalcover, mvds,
additionalFds, additionalMvds,
"default", candidatekeys)
else:
alert = views.getErrorMessageBox("Leider falsch!")
quizform = quizForms.canonicalCoverCollapse(
numberOfTries, numberOfSteps, relationString, fdsString,
currentfds)
inputpanel = views.inputToString(relation, currentfds, mvds,
additionalFds, additionalMvds,
inputpanel = views.inputToString(relation, newfds,mvds, additionalFds, "default", candidatekeys)
else:
alert = views.getErrorMessageBox("Leider falsch!")
quizform = quizForms.canonicalCoverRemoveEmptyRight(numberOfTries, numberOfSteps, relationString, fdsString, currentfds)
inputpanel = views.inputToString(relation, currentfds,mvds, additionalFds, "default", candidatekeys)
if (step=='4'):
currentfds, currentmvds = DBnormalizer.parseInputFDsMVDs(str(form['currentfds'].value))
#validate final fds
try:
finalfdinput = str(form['finalfds'].value)
except KeyError:
finalfdinput = ""
canonicalcover = inputValidation.validateFinalCanonicalCoverFds(currentfds, finalfdinput)
if canonicalcover:
alert = views.getSuccessMessageBox("Richtig!")
relations = DBnormalizer.generateNewRelations(canonicalcover)
numberOfTries = numberOfTries - 1
quizform = quizForms.formRelationSchemas(numberOfTries, numberOfSteps, relationString, fdsString, canonicalcover, relations)
inputpanel = views.inputToString(relation, canonicalcover,mvds, additionalFds, "default", candidatekeys)
else:
alert = views.getErrorMessageBox("Leider falsch!")
quizform = quizForms.canonicalCoverCollapse(numberOfTries, numberOfSteps, relationString, fdsString, currentfds)
inputpanel = views.inputToString(relation, currentfds,mvds, additionalFds, "default", candidatekeys)
if (step=='5'):
currentfds, currentmvds = DBnormalizer.parseInputFDsMVDs(str(form['currentfds'].value))
relations = DBnormalizer.generateNewRelations(currentfds)
numberOfSteps = numberOfSteps + 1
quizform = quizForms.addKeyRelation(numberOfTries, numberOfSteps, relationString, fdsString, currentfds, relations)
inputpanel = views.inputToString(relation, currentfds,mvds, additionalFds, "default", candidatekeys)
if DBnormalizer.getNormalForms(relation, fds, mvds)[2]:
info = views.getInfoMessageBox("Die Relation ist zwar schon in 3NF, führe den Algorithmus zur Übung trotzdem aus...")
