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 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