def saveCallback(self, widget=None, data=None):
try:
view = self.getMyObject()
except GenericObjectStoreException:
return
mapping = {}
used_widgetIds = []
for spacewidget in self.compose_spacewidgets.values():
wgt = spacewidget.getWidget()
if wgt is not None:
widgetId = wgt.getId()
if widgetId in used_widgetIds:
raise ViewException(ViewException.get_msg(
8, wgt.getName()))
mapping[spacewidget.getSpaceId()] = widgetId
used_widgetIds.append(widgetId)
view.setSpaceWidgetMapping(mapping)
boxmapping = {}
for boxwidget in self.compose_boxwidgets.values():
widgets = boxwidget.getWidgets()
for wgt in widgets:
widgetId = wgt.getId()
if widgetId in used_widgetIds:
raise ViewException(ViewException.get_msg(
8, wgt.getName()))
if not boxmapping.has_key(boxwidget.getBoxId()):
boxmapping[boxwidget.getBoxId()] = []
boxmapping[boxwidget.getBoxId()].append(widgetId)
used_widgetIds.append(widgetId)
view.setBoxMapping(boxmapping)
def saveCallback(self, widget=None, data=None):
try:
view = self.getMyObject()
except GenericObjectStoreException:
return
mapping = {}
used_widgetIds = []
for spacewidget in self.compose_spacewidgets.values():
wgt = spacewidget.getWidget()
if wgt is not None:
widgetId = wgt.getId()
if widgetId in used_widgetIds:
raise ViewException(ViewException.get_msg(8,wgt.getName()))
mapping[spacewidget.getSpaceId()]= widgetId
used_widgetIds.append(widgetId)
view.setSpaceWidgetMapping(mapping)
boxmapping = {}
for boxwidget in self.compose_boxwidgets.values():
widgets = boxwidget.getWidgets()
for wgt in widgets:
widgetId = wgt.getId()
if widgetId in used_widgetIds:
raise ViewException(ViewException.get_msg(8,wgt.getName()))
if not boxmapping.has_key(boxwidget.getBoxId()):
boxmapping[boxwidget.getBoxId()] = []
boxmapping[boxwidget.getBoxId()].append(widgetId)
used_widgetIds.append(widgetId)
view.setBoxMapping(boxmapping)
def get_from_json(cls, json):
"""
creates a view from a json that looks like this:
{'s':<page_id>,
'v':{'<space_id>':<widget_id>,'<space_id>':<widget_id>,[...]},
'b':{'<box_id>':[<widget_id>, <widget_id>, [...]]},
'c':{'<wgt_id>': {<widget_args>},'wgt_id':{<widget_args>},[...]},
'p':<wgt_id>
}
's' is the page that this view is going to be rendered on
'v' is a dictionary that maps space_ids to widget_ids
'b' represents box-packed widgets
'c' maps parameters to widgets
'p' is an OPTIONAL parameter. if a html-form is submitted, this
contains a widget_id to
"""
json = unquote(json)
jd = JSONDecoder()
try:
json = jd.decode(json)
except ValueError:
raise ViewException(ViewException.get_msg(7))
view = View(cls._core)
if json.has_key('s'):
view.set_page(json['s'])
else:
raise ViewException(ViewException.get_msg(6))
if json.has_key('v'):
for key, value in json['v'].items(): #transform indices back to int
json['v'][int(key)] = value
del(json['v'][key])
view.set_space_widget_mapping(json['v'])
else:
view.set_space_widget_mapping({})
if json.has_key('b'):
for key, value in json['b'].items(): #transform indices back to int
json['b'][int(key)] = value
del(json['b'][key])
view.set_box_mapping(json['b'])
else:
view.set_box_mapping({})
if json.has_key('c'):
for key, value in json['c'].items(): #transform indices back to int
json['c'][int(key)] = value
del(json['c'][key])
view.set_widget_param_mapping(json['c'])
else:
view.set_widget_param_mapping({})
if json.has_key('p'):
view.set_post_widget_id(json['p'])
return view
def get_box_info(self, box_id):
stmnt = "SELECT BOX_ORIENTATION, BOX_NAME FROM BOXES WHERE BOX_ID = ? ;"
db = self._core.get_db()
cur = db.query(self._core, stmnt, (int(box_id), ))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(9))
else:
return row["BOX_ORIENTATION"], row["BOX_NAME"]
def get_default_view(cls):
db = cls._core.get_db()
stmnt = "SELECT VIE_NAME FROM VIEWS WHERE VIE_DEFAULT = 1 ;"
cur = db.query(cls._core, stmnt)
row = cur.fetchonemap()
if row is not None:
return cls.get_from_name(row["VIE_NAME"])
else:
raise ViewException(ViewException.get_msg(3))
def remove_widget_from_space(self, space):
if type(space) == int:
pass
elif type(space) == str:
space = self._page.get_space_id_by_name(space)
else:
raise ViewException(ViewException.get_msg(1))
if self._space_widget_mapping.has_key(space):
del (self._space_widget_mapping[space])
def set_params_for_widget(self, widget, params):
if type(widget) != int:
widget = widget.get_id()
if type(params) != dict:
raise ViewException(ViewException.get_msg(2))
if widget not in self._space_widget_mapping.values():
raise ViewException(ViewException.get_msg(4))
self._widget_param_mapping[widget] = params
def set_params_for_widget(self, widget, params):
if type(widget) != int:
widget = widget.get_id()
if type(params) != dict:
raise ViewException(ViewException.get_msg(2))
if widget not in self._space_widget_mapping.values():
raise ViewException(ViewException.get_msg(4))
self._widget_param_mapping[widget] = params
def place_widget_in_space(self, space, widget):
if type(space) == int:
pass
elif type(space) == str:
space = self._page.get_space_id_by_name(space)
else:
raise ViewException(ViewException.get_msg(1))
if type(widget) != int:
widget = widget.get_id()
self._space_widget_mapping[space] = widget
def get_from_id(cls, nr):
"""
returns the view that is given by this id
"""
db = cls._core.get_db()
stmnt = "SELECT VIE_NAME, VIE_SIT_ID, VIE_DEFAULT FROM VIEWS WHERE VIE_ID = ? ;"
cur = db.query(cls._core, stmnt, (int(nr), ))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(0))
else:
view = View(cls._core)
view.set_name(row["VIE_NAME"])
view.set_default(row["VIE_DEFAULT"])
view.set_page(row["VIE_SIT_ID"])
view.set_id(nr)
stmnt = "SELECT VIW_SPA_ID, VIW_WGT_ID FROM VIEWWIDGETS WHERE VIW_VIE_ID = ? ;"
cur = db.query(cls._core, stmnt, (view.get_id(), ))
rows = cur.fetchallmap()
space_widget_mapping = {}
for row in rows:
space_widget_mapping[row["VIW_SPA_ID"]] = row["VIW_WGT_ID"]
view.set_space_widget_mapping(space_widget_mapping)
stmnt = "SELECT BOX_ID, BWT_WGT_ID \
FROM BOXES LEFT JOIN BOXWIDGETS ON (BOX_ID = BWT_BOX_ID) \
WHERE BWT_VIE_ID = ? OR (BWT_VIE_ID IS NULL AND BOX_SIT_ID = ?) \
ORDER BY BWT_BOX_ID, BWT_ORDER ;"
cur = db.query(cls._core, stmnt, (view.get_id(), view.get_page()))
rows = cur.fetchallmap()
box_mapping = {}
for row in rows:
box_id = int(row["BOX_ID"])
if not box_mapping.has_key(box_id):
box_mapping[box_id] = []
if row["BWT_WGT_ID"] is not None:
box_mapping[box_id].append(row["BWT_WGT_ID"])
view.set_box_mapping(box_mapping)
stmnt = "SELECT VWP_KEY, VWP_VALUE, VWP_WGT_ID FROM VIEWWIDGETPARAMS WHERE VWP_VIE_ID = ? ORDER BY VWP_WGT_ID;"
cur = db.query(cls._core, stmnt, (view.get_id(), ))
rows = cur.fetchallmap()
widget_param_mapping = {}
for row in rows:
if not widget_param_mapping.has_key(row["VWP_WGT_ID"]):
widget_param_mapping[row["VWP_WGT_ID"]] = {}
widget_param_mapping[row["VWP_WGT_ID"]][
row["VWP_KEY"]] = row["VWP_VALUE"]
view.set_widget_param_mapping(widget_param_mapping)
return view
def get_from_name(cls, name):
"""
Searches in the database if there is a View
with the given name. If there is, creates it
with the data that can be retrieved from the database
"""
if len(name) > 128:
return None # Prevents DB-Error. Change VIE_NAME in scvdb.sql too if changing here
db = cls._core.get_db()
stmnt = "SELECT VIE_ID FROM VIEWS WHERE VIE_NAME = ? ;"
cur = db.query(cls._core, stmnt, (str(name), ))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(0))
else:
return cls.get_from_id(row["VIE_ID"])
def get_default_view(cls):
db = cls._core.get_db()
stmnt = "SELECT VIE_NAME FROM VIEWS WHERE VIE_DEFAULT = 1 ;"
cur = db.query(cls._core, stmnt)
row = cur.fetchonemap()
if row is not None:
return cls.get_from_name(row["VIE_NAME"])
else:
raise ViewException(ViewException.get_msg(3))
def get_box_info(self, box_id):
stmnt = "SELECT BOX_ORIENTATION, BOX_NAME FROM BOXES WHERE BOX_ID = ? ;"
db = self._core.get_db()
cur = db.query(self._core, stmnt, (int(box_id),))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(9))
else:
return row["BOX_ORIENTATION"], row["BOX_NAME"]
def get_default_view(cls):
db = Database()
stmnt = "SELECT VIE_ID FROM VIEWS WHERE VIE_DEFAULT = 1 ;"
cur = db.query(stmnt)
row = cur.fetchonemap()
if row is not None:
return cls.get_from_id(row["VIE_ID"])
else:
raise ViewException(ViewException.get_msg(3))
def remove_widget_from_space(self, space):
if type(space) == int:
pass
elif type(space) == str:
space = self._page.get_space_id_by_name(space)
else:
raise ViewException(ViewException.get_msg(1))
if self._space_widget_mapping.has_key(space):
del(self._space_widget_mapping[space])
def place_widget_in_space(self, space, widget):
if type(space) == int:
pass
elif type(space) == str:
space = self._page.get_space_id_by_name(space)
else:
raise ViewException(ViewException.get_msg(1))
if type(widget) != int:
widget = widget.get_id()
self._space_widget_mapping[space] = widget
def get_from_id(cls, nr):
"""
returns the view that is given by this id
"""
db = cls._core.get_db()
stmnt = "SELECT VIE_NAME, VIE_SIT_ID, VIE_DEFAULT FROM VIEWS WHERE VIE_ID = ? ;"
cur = db.query(cls._core, stmnt, (int(nr),))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(0))
else:
view = View(cls._core)
view.set_name(row["VIE_NAME"])
view.set_default(row["VIE_DEFAULT"])
view.set_page(row["VIE_SIT_ID"])
view.set_id(nr)
stmnt = "SELECT VIW_SPA_ID, VIW_WGT_ID FROM VIEWWIDGETS WHERE VIW_VIE_ID = ? ;"
cur = db.query(cls._core, stmnt, (view.get_id(),))
rows = cur.fetchallmap()
space_widget_mapping = {}
for row in rows:
space_widget_mapping[row["VIW_SPA_ID"]] = row["VIW_WGT_ID"]
view.set_space_widget_mapping(space_widget_mapping)
stmnt = "SELECT BOX_ID, BWT_WGT_ID \
FROM BOXES LEFT JOIN BOXWIDGETS ON (BOX_ID = BWT_BOX_ID) \
WHERE BWT_VIE_ID = ? OR (BWT_VIE_ID IS NULL AND BOX_SIT_ID = ?) \
ORDER BY BWT_BOX_ID, BWT_ORDER ;"
cur = db.query(cls._core, stmnt, (view.get_id(), view.get_page()))
rows = cur.fetchallmap()
box_mapping = {}
for row in rows:
box_id = int(row["BOX_ID"])
if not box_mapping.has_key(box_id):
box_mapping[box_id] = []
if row["BWT_WGT_ID"] is not None:
box_mapping[box_id].append(row["BWT_WGT_ID"])
view.set_box_mapping(box_mapping)
stmnt = "SELECT VWP_KEY, VWP_VALUE, VWP_WGT_ID FROM VIEWWIDGETPARAMS WHERE VWP_VIE_ID = ? ORDER BY VWP_WGT_ID;"
cur = db.query(cls._core, stmnt, (view.get_id(),))
rows = cur.fetchallmap()
widget_param_mapping = {}
for row in rows:
if not widget_param_mapping.has_key(row["VWP_WGT_ID"]):
widget_param_mapping[row["VWP_WGT_ID"]] = {}
widget_param_mapping[row["VWP_WGT_ID"]][row["VWP_KEY"]]= row["VWP_VALUE"]
view.set_widget_param_mapping(widget_param_mapping)
return view
def get_from_name(cls, name):
"""
Searches in the database if there is a View
with the given name. If there is, creates it
with the data that can be retrieved from the database
"""
if len(name) > 128:
return None # Prevents DB-Error. Change VIE_NAME in scvdb.sql too if changing here
db = cls._core.get_db()
stmnt = "SELECT VIE_ID FROM VIEWS WHERE VIE_NAME = ? ;"
cur = db.query(cls._core, stmnt, (str(name),))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(0))
else:
return cls.get_from_id(row["VIE_ID"])
def get_from_json(cls, json):
"""
creates a view from a json that looks like this:
{'s':<page_id>,
'v':{'<space_id>':<widget_id>,'<space_id>':<widget_id>,[...]},
'b':{'<box_id>':[<widget_id>, <widget_id>, [...]]},
'c':{'<wgt_id>': {<widget_args>},'wgt_id':{<widget_args>},[...]},
'p':<wgt_id>
}
's' is the page that this view is going to be rendered on
'v' is a dictionary that maps space_ids to widget_ids
'b' represents box-packed widgets
'c' maps parameters to widgets
'p' is an OPTIONAL parameter. if a html-form is submitted, this
contains a widget_id to
"""
json = unquote(json)
jd = JSONDecoder()
try:
json = jd.decode(json)
except ValueError:
raise ViewException(ViewException.get_msg(7))
view = View(cls._core)
if json.has_key('s'):
view.set_page(json['s'])
else:
raise ViewException(ViewException.get_msg(6))
if json.has_key('v'):
for key, value in json['v'].items(
): #transform indices back to int
json['v'][int(key)] = value
del (json['v'][key])
view.set_space_widget_mapping(json['v'])
else:
view.set_space_widget_mapping({})
if json.has_key('b'):
for key, value in json['b'].items(
): #transform indices back to int
json['b'][int(key)] = value
del (json['b'][key])
view.set_box_mapping(json['b'])
else:
view.set_box_mapping({})
if json.has_key('c'):
for key, value in json['c'].items(
): #transform indices back to int
json['c'][int(key)] = value
del (json['c'][key])
view.set_widget_param_mapping(json['c'])
else:
view.set_widget_param_mapping({})
if json.has_key('p'):
view.set_post_widget_id(json['p'])
return view
def get_from_id(cls, nr):
"""
returns the view that is given by this id
"""
db = Database()
stmnt = "SELECT VIE_NAME, VIE_SIT_ID, VIE_VIE_BASEVIEW, VIE_DEFAULT\
FROM VIEWS WHERE VIE_ID = ? ;"
cur = db.query(stmnt, (int(nr),))
row = cur.fetchonemap()
if row is None:
raise ViewException(ViewException.get_msg(0))
else:
configuration = Configuration()
rendermode = configuration.get_entry("core.rendermode")
if rendermode == "pure":
view = PureView()
elif rendermode == "ajax":
view = AJAXView()
view.set_name(row["VIE_NAME"])
view.set_default(row["VIE_DEFAULT"])
view.set_page(row["VIE_SIT_ID"])
view.set_baseview_id(row["VIE_VIE_BASEVIEW"])
view.set_id(nr)
# get the widget space mapping. if the view has a baseview, also get those of
# the baseview. store into a dictionary. overwrite the space widget mapping
# of the baseview with those of the view. the derived view only stores the
# differences of itself and the baseview (same goes for widget_param_mapping
# and box_mapping
stmnt = "SELECT VIW_SPA_ID, VIW_WGT_ID FROM VIEWWIDGETS \
WHERE VIW_VIE_ID = (SELECT VIE_VIE_BASEVIEW FROM VIEWS WHERE VIE_ID = ?) \
UNION SELECT VIW_SPA_ID, VIW_WGT_ID FROM VIEWWIDGETS WHERE VIW_VIE_ID = ? ;"
cur = db.query(stmnt, (view.get_id(), view.get_id()))
rows = cur.fetchallmap()
space_widget_mapping = {}
for row in rows:
space_widget_mapping[row["VIW_SPA_ID"]] = row["VIW_WGT_ID"]
view.set_space_widget_mapping(space_widget_mapping)
# get the box mapping. this mapping maps box_ids to a list of widget_ids.
stmnt = "SELECT BOX_ID, BWT_WGT_ID FROM (\
SELECT BOX_ID, BWT_WGT_ID, BWT_BOX_ID, BWT_ORDER, 0 AS UNIONSORT \
FROM BOXES LEFT JOIN BOXWIDGETS ON (BOX_ID = BWT_BOX_ID) \
WHERE BWT_VIE_ID = (SELECT VIE_VIE_BASEVIEW FROM VIEWS WHERE VIE_ID = ?) \
OR (BWT_VIE_ID IS NULL AND BOX_SIT_ID = ?) \
UNION SELECT BOX_ID, BWT_WGT_ID, BWT_BOX_ID, BWT_ORDER, 1 AS UNIONSORT \
FROM BOXES LEFT JOIN BOXWIDGETS ON (BOX_ID = BWT_BOX_ID) \
WHERE BWT_VIE_ID = ? OR (BWT_VIE_ID IS NULL AND BOX_SIT_ID = ?)) \
ORDER BY UNIONSORT, BWT_BOX_ID, BWT_ORDER ;"
cur = db.query(stmnt, (view.get_id(), view.get_page(),
view.get_id(), view.get_page()))
rows = cur.fetchallmap()
box_mapping = {}
for row in rows:
box_id = int(row["BOX_ID"])
if not box_mapping.has_key(box_id):
box_mapping[box_id] = []
if row["BWT_WGT_ID"] is not None:
box_mapping[box_id].append(row["BWT_WGT_ID"])
view.set_box_mapping(box_mapping)
# get the widget_param mapping. this maps a dictionary of parameters to
# a widget_id
stmnt = "SELECT VWP_KEY, VWP_VALUE, VWP_WGT_ID FROM ( \
SELECT VWP_KEY, VWP_VALUE, VWP_WGT_ID, 0 AS UNIONSORT FROM VIEWWIDGETPARAMS \
WHERE VWP_VIE_ID = (SELECT VIE_VIE_BASEVIEW FROM VIEWS WHERE VIE_ID = ?) \
UNION \
SELECT VWP_KEY, VWP_VALUE, VWP_WGT_ID, 1 AS UNIONSORT FROM VIEWWIDGETPARAMS \
WHERE VWP_VIE_ID = ?)\
ORDER BY UNIONSORT, VWP_WGT_ID;"
cur = db.query(stmnt, (view.get_id(),view.get_id()))
rows = cur.fetchallmap()
widget_param_mapping = {}
for row in rows:
if not widget_param_mapping.has_key(row["VWP_WGT_ID"]):
widget_param_mapping[row["VWP_WGT_ID"]] = {}
widget_param_mapping[row["VWP_WGT_ID"]][row["VWP_KEY"]]= row["VWP_VALUE"]
view.set_widget_param_mapping(widget_param_mapping)
return view
