def add_ticket_template_store(env, db):
"""Add table ticket_template_store."""
from tickettemplate.model import schema, schema_version, TT_Template
from trac.db import DatabaseManager
connector, _ = DatabaseManager(env)._get_connector()
cursor = db.cursor()
table = schema[0]
for stmt in connector.to_sql(table):
try:
cursor.execute(stmt)
except:
pass
from default_templates import DEFAULT_TEMPLATES
from ttadmin import SYSTEM_USER
now = int(time.time())
for tt_name, tt_value in DEFAULT_TEMPLATES:
record = (now, SYSTEM_USER, tt_name, "description", tt_value,)
TT_Template.insert(env, record)
for id, modi_time, tt_name, tt_text in cursor.fetchall():
record = (modi_time, SYSTEM_USER, tt_name, "description", tt_text,)
TT_Template.insert(env, record)
def add_tt_table(env, db):
"""Migrate from template files to db."""
# detect existing templates files
allTmpls = _findAllTmpls(env)
allTmpls.sort(_cmp)
# import into db
for tt_name in allTmpls:
tt_text = _loadTemplateText(env, tt_name)
modi_time = _getMTime(tt_name)
from tickettemplate.model import TT_Template
TT_Template.insert(env, tt_name, tt_text, modi_time)
# base64
# detect existing templates files
allTmpls = _findAllTmplsBase64(env)
allTmpls.sort(_cmpBase64)
# import into db
for tt_name in allTmpls:
tt_text = _loadTemplateTextBase64(env, tt_name)
modi_time = _getMTimeBase64(tt_name)
from tickettemplate.model import TT_Template
tt_name = base64.decodestring(tt_name).decode('utf-8')
TT_Template.insert(env, tt_name, tt_text, modi_time)
def add_tt_table(env, db):
"""Migrate from template files to db."""
cursor = db.cursor()
# detect existing templates files
allTmpls = _findAllTmpls(env)
allTmpls.sort(_cmp)
# import into db
for tt_name in allTmpls:
tt_text = _loadTemplateText(env, tt_name)
modi_time = _getMTime(tt_name)
from tickettemplate.model import TT_Template
TT_Template.insert(env, tt_name, tt_text, modi_time)
# base64
# detect existing templates files
allTmpls = _findAllTmplsBase64(env)
allTmpls.sort(_cmpBase64)
# import into db
for tt_name in allTmpls:
tt_text = _loadTemplateTextBase64(env, tt_name)
modi_time = _getMTimeBase64(tt_name)
from tickettemplate.model import TT_Template
tt_name = base64.decodestring(tt_name).decode("utf-8")
TT_Template.insert(env, tt_name, tt_text, modi_time)
def environment_created(self):
# Create the required tables
db = self.env.get_db_cnx()
connector, _ = DatabaseManager(self.env)._get_connector()
cursor = db.cursor()
for table in schema:
for stmt in connector.to_sql(table):
cursor.execute(stmt)
# Insert a global version flag
cursor.execute(
"INSERT INTO system (name,value) "
"VALUES ('tt_version',%s)", (schema_version, ))
# Create some default templates
now = int(time.time())
from default_templates import DEFAULT_TEMPLATES
for tt_name, tt_value in DEFAULT_TEMPLATES:
record = [
now,
SYSTEM_USER,
tt_name,
"description",
tt_value,
]
TT_Template.insert(self.env, record)
db.commit()
def environment_created(self):
# Create the required tables
db = self.env.get_db_cnx()
connector, _ = DatabaseManager(self.env)._get_connector()
cursor = db.cursor()
for table in schema:
for stmt in connector.to_sql(table):
cursor.execute(stmt)
# Insert a global version flag
cursor.execute("INSERT INTO system (name,value) "
"VALUES ('tt_version',%s)", (schema_version,))
# Create some default templates
now = int(time.time())
from default_templates import DEFAULT_TEMPLATES
for tt_name, tt_value in DEFAULT_TEMPLATES:
record = [
now,
SYSTEM_USER,
tt_name,
"description",
tt_value,
]
TT_Template.insert(self.env, record)
db.commit()
def _saveTemplateText(self, tt_name, tt_text):
""" save ticket template text to db.
"""
id = TT_Template.insert(
self.env,
(int(time.time()), "SYSTEM", tt_name, "description", tt_text))
return id
def _insert_templates(self, templates):
"""
accept list of tuples called templates and insert into database.
example: templates = [('tt_name','tt_value'),]
"""
now = int(time.time())
for tt_name, tt_value in templates:
record = [
now,
SYSTEM_USER,
tt_name,
'description',
tt_value,
]
TT_Template.insert(self.env, record)
# increment timestamp; other code expects it to be unique
now += 1
def _insert_templates(self, templates):
"""
accept list of tuples called templates and insert into database.
example: templates = [('tt_name','tt_value'),]
"""
now = int(time.time())
for tt_name, tt_value in templates:
record = [
now,
SYSTEM_USER,
tt_name,
'description',
tt_value,
]
TT_Template.insert(self.env, record)
# increment timestamp; other code expects it to be unique
now += 1
def environment_created(self):
# Create the required tables
db = self.env.get_db_cnx()
connector, _ = DatabaseManager(self.env)._get_connector()
cursor = db.cursor()
for table in schema:
for stmt in connector.to_sql(table):
cursor.execute(stmt)
# Insert a global version flag
cursor.execute("INSERT INTO system (name,value) "
"VALUES ('tt_version',%s)", (schema_version,))
# Create some default templates
for tt_name, tt_text in DEFAULT_TEMPLATES:
TT_Template.insert(self.env, tt_name, tt_text, 0)
db.commit()
def _handleCustomSave(self, req):
""" save custom template
"""
jsonstr = urllib.unquote(req.read())
custom_data = json.loads(jsonstr)
tt_name = custom_data.get('tt_name')
custom_template = custom_data.get('custom_template')
if not tt_name or not custom_template:
return tt_name, custom_template
now = int(time.time())
tt_user = req.authname
# delete same custom template if exist
delete_data = {
'tt_user': tt_user,
'tt_name': tt_name,
}
TT_Template.deleteCustom(self.env, delete_data)
# save custom template
field_list = self._getFieldList()
for tt_field in field_list:
tt_value = custom_template.get(tt_field)
if tt_value is not None:
record = [
now,
tt_user,
tt_name,
tt_field,
tt_value,
]
TT_Template.insert(self.env, record)
return tt_name, custom_template
def _handleCustomSave(self, req):
""" save custom template
"""
jsonstr = urllib.unquote(req.read())
custom_data = json.loads(jsonstr)
tt_name = custom_data.get("tt_name")
custom_template = custom_data.get("custom_template")
if not tt_name or not custom_template:
return tt_name, custom_template
now = int(time.time())
tt_user = req.authname
# delete same custom template if exist
delete_data = {
"tt_user": tt_user,
"tt_name": tt_name,
}
TT_Template.deleteCustom(self.env, delete_data)
# save custom template
field_list = self._getFieldList()
for tt_field in field_list:
tt_value = custom_template.get(tt_field)
if tt_value is not None:
record = [
now,
tt_user,
tt_name,
tt_field,
tt_value,
]
TT_Template.insert(self.env, record)
return tt_name, custom_template
def _saveTemplateText(self, tt_name, tt_text):
""" save ticket template text to db.
"""
id = TT_Template.insert(self.env, (int(time.time()), 'SYSTEM',
tt_name, 'description', tt_text))
return id
def _saveTemplateText(self, tt_name, tt_text):
""" save ticket template text to db.
"""
id = TT_Template.insert(self.env, tt_name, tt_text, time.time())
return id
