FieldConf(id="excludeSystem",
datatype="checkbox",
default=[],
listItems=[{
"id": "pool_sys",
"name": "pool_sys"
}, {
"id": "pool_fulltext",
"name": "pool_fulltext"
}],
name=_(u"Exclude system columns"))
]
configuration.views = [
ViewConf(name="",
view=ToolView,
attr="form",
permission="system",
context="nive.tools.dbSqlDump.dbSqlDump")
]
class dbSqlDump(Tool):
"""
"""
def _Run(self, **values):
result = 1
codepage = "utf-8"
app = self.app
datapool = app.db
return self.SendResponse(data, mime=self.context.mimetype, raiseException=False)
configuration = ToolConf()
configuration.id = "dbStructureUpdater"
configuration.context = "nive.components.tools.dbStructureUpdater.dbStructureUpdater"
configuration.name = _(u"Database Structure")
configuration.description = _(u"Generate or update the database structure based on configuration settings.")
configuration.apply = (IApplication,)
configuration.data = [
FieldConf(id="modify", datatype="bool", default=0, name=_(u"Modify existing columns"), description=_(u"Change existing database columns to new configuration. Depending on the changes, data may be lost!")),
FieldConf(id="showSystem", datatype="bool", default=0, name=_(u"Show system columns"), description=u"")
]
configuration.mimetype = "text/html"
configuration.views = [
ViewConf(name="", view=dbView, attr="view", permission="system", context="nive.components.tools.dbStructureUpdater.dbStructureUpdater")
]
class dbStructureUpdater(Tool):
def _Run(self, **values):
result = 1
importWf = 1
importSecurity = 0
showSystem = values.get("showSystem")
modify = values.get("modify")
request = values["original"]
try:
localizer = get_localizer(get_current_request())
id = "dbSqlDump",
context = "nive.tools.dbSqlDump.dbSqlDump",
name = _(u"Database sql dump"),
description = _("This function dumps table contents as SQL INSERT statements. 'CREATE table' statements are not included."),
apply = (IApplication,),
mimetype = "text/sql"
)
configuration.data = [
FieldConf(id="excludeSystem",
datatype="checkbox",
default=[],
listItems=[{"id":"pool_sys", "name":"pool_sys"},{"id":"pool_fulltext","name":"pool_fulltext"}],
name=_(u"Exclude system columns"))
]
configuration.views = [
ViewConf(name="", view=ToolView, attr="form", permission="system", context="nive.tools.dbSqlDump.dbSqlDump")
]
class dbSqlDump(Tool):
"""
"""
def _Run(self, **values):
result = 1
codepage="utf-8"
app = self.app
datapool = app.db
conf = app.dbConfiguration
# Released under GPL3. See license.txt
#
from nive.tool import Tool, ToolView
from nive.definitions import ToolConf, FieldConf, ViewConf
configuration = ToolConf(
id = "exampletool",
context = "nive.tools.example.tool",
name = u"Empty tool for tests",
description = "",
apply = None, #(IObject,)
mimetype = "text/html",
)
configuration.data = [
FieldConf(id="parameter1", datatype="bool", default=0, name=u"Show 1", description=u"Display 1"),
FieldConf(id="parameter2", datatype="string", required=1, default="", name=u"Show 2", description=u"Display 2")
]
configuration.views = [
ViewConf(name="", view=ToolView, attr="run", permission="system", context="nive.tools.example.tool")
]
class tool(Tool):
def _Run(self, **values):
result = u"<h1>OK</h1>"
return result
