def pre_process(self):
'''
Pre-processing method
Inputs:
-
Output:
None
'''
# --- Definitions
nid = self.inputs.getvalue('note')
pos = self.inputs.getvalue('position')
# --- Database
note = DB('../Notes/{0}/{1}/Note.db'.format(self.session.user['id'], nid))
# Get page id
tmp = note.single('SELECT * FROM Pages WHERE position=?', pos)
pid = tmp['id']
# Delete page
note.delete('Pages', 'id=?', pid)
# Update following pages position
note.update('Pages', 'position', 'position-1', 'position>=?', pos, encode=False)
# Delete page elements
note.delete('Elements', 'page=?', pid)
def pre_process(self):
'''
Pre-processing method
Inputs:
-
Output:
None
'''
# --- Definitions
nid = self.inputs.getvalue('note')
eid = self.inputs.getvalue('elm')
# --- Update Note
# Access DB
db = DB('../Notes/{0}/{1}/Note.db'.format(self.session.user['id'], nid))
# Get element
elm = db.single('SELECT * FROM Elements WHERE id=?', eid)
# Remove equation (if any)
if elm['type'] in ('equation'):
path = '../Notes/{0}/{1}/Medias/{2}.svg'.format(self.session.user['id'], nid, eid)
if os.path.isfile(path):
os.remove(path)
# Remove media file (if any)
if elm['type'] in ('media'):
frow = db.single('SELECT ext FROM media WHERE id=?', eid);
path = '../Notes/{0}/{1}/Medias/{2}.{3}'.format(self.session.user['id'], nid, eid, frow['ext'])
if os.path.isfile(path):
os.remove(path)
# Delete element
db.delete('Elements', 'id=?', eid)
db.delete(elm['type'], 'id=?', eid)
# Update remaining elements
db.update('Elements', 'position', 'position-1', 'position>?', elm['position'], encode=False)
