def upgrade_environment(self, db):
"""Actually perform an environment upgrade.
Implementations of this method should not commit any database
transactions. This is done implicitly after all participants have
performed the upgrades they need without an error being raised.
"""
# create a table for ticket location
ticket_location_table = Table("ticket_location", key="ticket")[
Column("ticket", type="int"),
Column("latitude", type="float"),
Column("longitude", type="float"),
Index(["ticket"]),
]
create_table(self.env, ticket_location_table)
# update ticket locations
tickets = get_column(self.env, "ticket", "id")
tickets = [Ticket(self.env, ticket) for ticket in tickets]
for ticket in tickets:
try:
location, (lat, lon) = self.locate_ticket(ticket)
self.set_location(ticket.id, lat, lon)
except GeolocationException:
pass
# note the DB version
execute_non_query(self.env, "insert into system (name, value) values ('geoticket.db_version', '1');")
# add a default dashboard panel
self.default_dashboard()
def upgrade_environment(self, db):
"""Actually perform an environment upgrade.
Implementations of this method should not commit any database
transactions. This is done implicitly after all participants have
performed the upgrades they need without an error being raised.
"""
# create a table for ticket location
ticket_location_table = Table(
'ticket_location', key='ticket')[Column('ticket', type='int'),
Column('latitude', type='float'),
Column('longitude', type='float'),
Index(['ticket'])]
create_table(self.env, ticket_location_table)
# update ticket locations
tickets = get_column(self.env, 'ticket', 'id')
tickets = [Ticket(self.env, ticket) for ticket in tickets]
for ticket in tickets:
try:
location, (lat, lon) = self.locate_ticket(ticket)
self.set_location(ticket.id, lat, lon)
except GeolocationException:
pass
# note the DB version
execute_non_query(
self.env,
"insert into system (name, value) values ('geoticket.db_version', '1');"
)
# add a default dashboard panel
self.default_dashboard()
def create_db(self):
autocomplete_table = Table('autocomplete', key='name')[
Column('name', 'text'),
Column('description', 'text')]
autocomplete_values_table = Table('autocomplete_values')[
Column('autocomplete_name', 'text'),
Column('value', 'text')]
create_table(self.env, autocomplete_table)
create_table(self.env, autocomplete_values_table)
execute_non_query(self.env, """INSERT INTO system (name, value) VALUES
('autocompleteplugin.db_version', '1');""")
def upgrade_environment(self, db):
"""Actually perform an environment upgrade.
Implementations of this method should not commit any database
transactions. This is done implicitly after all participants have
performed the upgrades they need without an error being raised.
"""
# table of CAPTCHAs
captcha_table = Table('captcha', key='key')[Column('id'),
Column('word')]
create_table(self.env, captcha_table)
def upgrade_environment(self, db):
"""Actually perform an environment upgrade.
Implementations of this method should not commit any database
transactions. This is done implicitly after all participants have
performed the upgrades they need without an error being raised.
"""
# table of CAPTCHAs
captcha_table = Table('captcha', key='key')[
Column('id'),
Column('word')]
create_table(self.env, captcha_table)
def create_db(self):
repo_cache_table = Table("repository_node", key=("id"))[
Column("id", auto_increment=True), Column("repo"), Column("filename"), Column("contents")
]
create_table(self.env, repo_cache_table)
repo_version_table = Table("repository_version", key=("id"))[
Column("id", auto_increment=True), Column("repo"), Column("version")
]
create_table(self.env, repo_version_table)
execute_non_query(
self.env, "insert into system (name, value) values ('multireposearch.sqlindexer.db_version', '1');"
)
def create_db(self):
repo_cache_table = Table('repository_node', key=('id'))[
Column('id', auto_increment=True),
Column('repo'),
Column('filename'),
Column('contents'),
]
create_table(self.env, repo_cache_table)
repo_version_table = Table('repository_version', key=('id'))[
Column('id', auto_increment=True),
Column('repo'),
Column('version'),
]
create_table(self.env, repo_version_table)
execute_non_query(self.env, "insert into system (name, value) values ('multireposearch.sqlindexer.db_version', '1');")
def create_db(self):
default_image = Table('default_image',
key=('ticket', ))[Column('ticket', type='int'),
Column('image'), ]
create_table(self.env, default_image)
def create_db(self):
default_image = Table("default_image", key=("ticket",))[Column("ticket", type="int"), Column("image")]
create_table(self.env, default_image)