Python DBnormalizer.addRelationWithKey Examples

Example #1

def validateAddKeyRelation(originrelation, fds, relations, keyrelationstring):
	keys = DBnormalizer.getKeys(originrelation, fds)
	keyrelation = frozenset(keyrelationstring) | frozenset(EMPTY_SET)	
	newrelations = relations[:]
	if len(DBnormalizer.addRelationWithKey(relations[:], keys)) > len(relations):
		#key must be added
		if keyrelation in keys:
			newrelations.append(keyrelation)
			return newrelations
		else:
			return []
	else:
		#no key must be added
		if keyrelationstring == "":
			return newrelations
		else:
			return []

Example #2

File: inputValidation.py Project: becherd/DBnormalizer

def validateAddKeyRelation(originrelation, fds, relations, keyrelationstring):
	keys = DBnormalizer.getKeys(originrelation, fds)
	keyrelation = frozenset(keyrelationstring) | frozenset(EMPTY_SET)	
	newrelations = relations[:]
	if len(DBnormalizer.addRelationWithKey(relations[:], keys)) > len(relations):
		#key must be added
		if keyrelation in keys:
			newrelations.append(keyrelation)
			return newrelations
		else:
			return []
	else:
		#no key must be added
		if keyrelationstring == "":
			return newrelations
		else:
			return []