def getElementsDiagramFromSelectedTables(request):
""" Creates diagram objects from selected tables in LiveSearchGrid
"""
selectedTables = []
connectors = []
jsondict = {}
objects = json.loads(request.body)
UUIDAttributeList = []
for element in objects:
elementUUID = uuid.UUID(element['id']).hex
UUIDAttributeList.append(elementUUID)
try:
entities = Entity.objects.filter(smUUID__in=UUIDAttributeList)
assembler = JSONAssembler()
assembler.getJSONElements(entities, selectedTables, connectors)
jsondict = {
'success':True,
'message': '',
'tables': selectedTables,
'connectors': connectors,
}
except Exception as e:
print(e)
jsondict = {
'success':False,
'message': 'Error on creating JSON file',
}
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json", status=500)
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json")
def synchDBFromDiagram(request):
""" Create and synchronize elements in database
"""
projectID = request.GET['projectID']
try:
project = Project.objects.get(id=projectID)
user = request.user
model = Model.objects.filter(project=project)
if not model:
model = Model.objects.create(project=project,code='default',smOwningTeam=project.smOwningTeam,smCreatedBy=user,smOwningUser=user)
else:
model = model[0]
owningTeam = model.smOwningTeam
except Exception as e:
return JsonError(e)
objects = json.loads(request.body)
deletedConnectors = []
UUIDList = []
for element in objects:
elementUUID = uuid.UUID(element['id']).hex
if element['type'] == 'dbModel.shape.DBTable':
UUIDList.append(elementUUID)
addOrUpdateEntity(model, user, owningTeam, deletedConnectors, element, elementUUID)
else:
if elementUUID not in deletedConnectors:
sourceUUID = uuid.UUID(element['source']['node']).hex
targetUUID = uuid.UUID(element['target']['node']).hex
try:
refEntity = Entity.objects.get(smUUID=sourceUUID)
connEntity = Entity.objects.get(smUUID=targetUUID)
except Exception as e:
return JsonError(e)
addOrUpdateConnector(element, elementUUID, refEntity, connEntity)
# Return the updated JSON model
selectedTables = []
connectors = []
try:
entities = Entity.objects.filter(smUUID__in=UUIDList)
assembler = JSONAssembler()
assembler.getJSONElements(entities, selectedTables, connectors)
except Exception as e:
print(e)
return JsonError("Entity non trouvé")
jsondict = {
'success':True,
'message': '',
'tables': selectedTables,
'connectors': connectors,
}
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json")
def getElementsDiagramFromSelectedTables(request):
""" Creates diagram objects from selected tables in LiveSearchGrid
"""
selectedTables = []
connectors = []
jsondict = {}
objects = json.loads(request.body)
UUIDAttributeList = []
for element in objects:
elementUUID = uuid.UUID(element['id']).hex
UUIDAttributeList.append(elementUUID)
try:
entities = Entity.objects.filter(smUUID__in=UUIDAttributeList)
assembler = JSONAssembler()
assembler.getJSONElements(entities, selectedTables, connectors)
jsondict = {
'success': True,
'message': '',
'tables': selectedTables,
'connectors': connectors,
}
except Exception as e:
print(e)
jsondict = {
'success': False,
'message': 'Error on creating JSON file',
}
context = json.dumps(jsondict)
return HttpResponse(context,
content_type="application/json",
status=500)
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json")
def synchDiagramFromDB(request):
""" Updates diagram objects from database
"""
projectID = request.POST['projectID']
selectedTables = []
connectors = []
try:
entities = Entity.objects.filter(model__project_id=projectID)
assembler = JSONAssembler()
assembler.getJSONElements(entities, selectedTables, connectors)
except Exception as e:
print(e)
return JsonError("Entity non trouvé")
jsondict = {
'success':True,
'message': '',
'tables': selectedTables,
'connectors': connectors,
}
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json")
def synchDiagramFromDB(request):
""" Updates diagram objects from database
"""
projectID = request.POST['projectID']
selectedTables = []
connectors = []
try:
entities = Entity.objects.filter(model__project_id=projectID)
assembler = JSONAssembler()
assembler.getJSONElements(entities, selectedTables, connectors)
except Exception as e:
print(e)
return JsonError("Entity non trouvé")
jsondict = {
'success': True,
'message': '',
'tables': selectedTables,
'connectors': connectors,
}
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json")
def synchDBFromDiagram(request):
""" Create and synchronize elements in database
"""
projectID = request.GET['projectID']
try:
project = Project.objects.get(id=projectID)
user = request.user
model = Model.objects.filter(project=project)
if not model:
model = Model.objects.create(project=project,
code='default',
smOwningTeam=project.smOwningTeam,
smCreatedBy=user,
smOwningUser=user)
else:
model = model[0]
owningTeam = model.smOwningTeam
except Exception as e:
return JsonError(e)
objects = json.loads(request.body)
deletedConnectors = []
UUIDList = []
for element in objects:
elementUUID = uuid.UUID(element['id']).hex
if element['type'] == 'dbModel.shape.DBTable':
UUIDList.append(elementUUID)
addOrUpdateEntity(model, user, owningTeam, deletedConnectors,
element, elementUUID)
else:
if elementUUID not in deletedConnectors:
sourceUUID = uuid.UUID(element['source']['node']).hex
targetUUID = uuid.UUID(element['target']['node']).hex
try:
refEntity = Entity.objects.get(smUUID=sourceUUID)
connEntity = Entity.objects.get(smUUID=targetUUID)
except Exception as e:
return JsonError(e)
addOrUpdateConnector(element, elementUUID, refEntity,
connEntity)
# Return the updated JSON model
selectedTables = []
connectors = []
try:
entities = Entity.objects.filter(smUUID__in=UUIDList)
assembler = JSONAssembler()
assembler.getJSONElements(entities, selectedTables, connectors)
except Exception as e:
print(e)
return JsonError("Entity non trouvé")
jsondict = {
'success': True,
'message': '',
'tables': selectedTables,
'connectors': connectors,
}
context = json.dumps(jsondict)
return HttpResponse(context, content_type="application/json")