def workspace_test():
print_data('workspaces objects', br=False)
for index in range(3):
w = Workspace()
w.name = 'New workspace name'
w.description = 'Some new description'
w.save()
workspaces = Workspace.all()
print_data('new objects -> model.all()', workspaces)
w.name = 'Updated name'
w.save()
workspaces = Workspace.all()
print_data('UPDATED -> model.all()', workspaces)
workspaces = Workspace.get(id=w.id, name=w.name)
print_data('GET -> model.get()', [workspaces])
workspaces = Workspace.filter(name='New workspace name')
print_data('FILTER -> model.filter()', workspaces)
for index in range(2):
o = Application()
o.workspace_id = w.guid
o.save()
a = View()
a.application_id = o.guid
a.save()
a = Resource()
a.application_id = o.guid
a.save()
for index in range(3):
o = Widget()
o.workspace_id = w.guid
o.save()
for index in range(3):
o = DataSource()
o.workspace_id = w.guid
o.save()
objects = Workspace.all() + Resource.all() + Application.all() + Widget.all() + DataSource.all() + View.all()
print_data('All objects in db', objects)
# [w.delete() for w in Workspace.all()]
workspaces = Workspace.all()
print_data('cleaned', workspaces)
workspaces = Workspace.filter(include_deleted=True)
print_data('cleaned with deleted if exists', workspaces)
objects = Workspace.all() + Resource.all() + Application.all() + Widget.all() + DataSource.all() + View.all()
print_data('no objects left', objects)
def post(self):
session = Session()
data = json.loads(self.request.body.decode('utf8'))
if data.get('id'):
workspace = session.query(Workspace).get(data['id'])
else:
workspace = Workspace()
workspace.name = data.get('name', '')
session.add(workspace)
session.commit()
workspace.update_labels(session, data['labels'])
workspace.update_urls(session, data['urls'])
session.commit()
self.write({'id': workspace.id})
def widget_test():
print_data('widgets objects', br=False)
workspaces = []
for index in range(3):
w = Workspace()
w.name = 'New workspace name'
w.description = 'Some new description'
w.save()
workspaces.append(w)
for index in range(3):
w = Widget()
w.source = '<source>some stuff</source>'
w.workspace_id = workspaces[0].guid if index in [0, 1] else workspaces[1].guid
w.save()
widgets = Widget.all()
print_data('new objects -> model.all()', widgets)
w.source = '<b>UDPATED</b>'
w.save()
w.reload()
print_data('UPDATED', [w.source])
widgets = Widget.get(id=w.id)
print_data('GET -> model.get()', [widgets])
widgets = Widget.filter(source='<source>some stuff</source>')
print_data('FILTER -> model.filter()', widgets)
for index, w in enumerate(workspaces):
widgets = w.widgets
print_data('workspace %s -> workspace.widgets' % str(index), widgets)
[w.delete() for w in Widget.all()]
objects = Widget.all() + Workspace.all()
print_data('cleaned', objects)
widgets = Widget.filter(include_deleted=True)
print_data('cleaned with deleted if exists', widgets)