# -*- coding: utf-8 -*-
from plugin_jstree import JsTree
from plugin_mptt import MPTT
import datetime
### setup core objects #########################################################
mptt = MPTT(db)
mptt.settings.table_node_name = 'plugin_mptt_node'
mptt.settings.extra_fields = {
'plugin_mptt_node': [
Field('name'),
Field('node_type'),
Field('created_on', 'datetime', default=request.now)
],
}
### inject the mptt tree model to the jstree plugin ###
jstree = JsTree(tree_model=mptt, renderstyle=True)
### define tables ##############################################################'
mptt.define_tables()
table_node = mptt.settings.table_node
### populate records ###########################################################
deleted = db(table_node.created_on < request.now -
datetime.timedelta(minutes=30)).delete()
if deleted:
table_node.truncate()
session.flash = 'the database has been refreshed'
redirect(URL('index'))
# -*- coding: utf-8 -*-
from plugin_mptt import MPTT
import unittest
import re
import datetime
db = DAL('sqlite:memory:')
### setup core objects #########################################################
mptt = MPTT(db)
mptt.settings.table_node_name = 'plugin_mptt_node'
mptt.settings.extra_fields = {
'plugin_mptt_node':
[Field('name')],
}
### define tables ##############################################################'
mptt.define_tables()
table_node = mptt.settings.table_node
### demo functions #############################################################
def index():
return dict(unit_tests=[A('test all', _href=URL('test')),
A('test reading', _href=URL('test', args='reading')),
A('test reparenting', _href=URL('test', args='reparenting')),
A('test deletion', _href=URL('test', args='deletion')),
A('test moving', _href=URL('test', args='moving'))])
### unit tests #################################################################
# -*- coding: utf-8 -*-
from plugin_jstree import JsTree
from plugin_mptt import MPTT
import datetime
### setup core objects #########################################################
mptt = MPTT(db)
mptt.settings.table_node_name = 'plugin_mptt_node'
mptt.settings.extra_fields = {
'plugin_mptt_node':
[Field('name'),
Field('node_type'),
Field('created_on', 'datetime', default=request.now)],
}
### inject the mptt tree model to the jstree plugin ###
jstree = JsTree(tree_model=mptt, renderstyle=True)
### define tables ##############################################################'
mptt.define_tables()
table_node = mptt.settings.table_node
### populate records ###########################################################
deleted = db(table_node.created_on < request.now - datetime.timedelta(minutes=30)).delete()
if deleted:
table_node.truncate()
session.flash = 'the database has been refreshed'
redirect(URL('index'))
if not mptt.roots().count():
# -*- coding: utf-8 -*-
from plugin_jstree import JsTree
from plugin_mptt import MPTT
import re
import datetime
### setup core objects #########################################################
mptt = MPTT(db)
mptt.settings.table_node_name = "plugin_mptt_node"
mptt.settings.extra_fields = {
"plugin_mptt_node": [Field("name"), Field("node_type"), Field("created_on", "datetime", default=request.now)]
}
### inject the mptt tree model to the jstree plugin ###
jstree = JsTree(tree_model=mptt, renderstyle=True)
### define tables ##############################################################'
mptt.define_tables()
table_node = mptt.settings.table_node
### populate records ###########################################################
deleted = db(table_node.created_on < request.now - datetime.timedelta(minutes=30)).delete()
if deleted:
table_node.truncate()
session.flash = "the database has been refreshed"
redirect(URL("index"))
if not mptt.roots().count():
_root1 = mptt.insert_node(None, name="root1", node_type="root")
_child1 = mptt.insert_node(_root1, name="child1")
