def test_wiki_data_migrated(self): """Wiki data is migrated on table upgrade.""" now = to_utimestamp(datetime_now(utc)) wiki_column_names = \ [col.name for col in old_wiki_schema.columns] wiki_data = ( ('TracGuide', 2, now, 'user2', '::4', 'The guide', 'Edit', 0), ('WikiStart', 1, now, 'user1', '::3', 'The page', 'Init', 1)) self.dbm.insert_into_tables((('wiki', wiki_column_names, wiki_data),)) db42.do_upgrade(self.env, VERSION, None) ipnr_col = wiki_column_names.index('ipnr') i = 0 for i, data in enumerate(self.env.db_query(""" SELECT * FROM wiki ORDER BY name """)): self.assertEqual(wiki_data[i][:ipnr_col] + wiki_data[i][ipnr_col+1:], data) self.assertEqual(len(wiki_data), i+1)
def test_attachments_data_migrated(self): """Attachment data is migrated on table upgrade.""" now = to_utimestamp(datetime_now(utc)) attachment_column_names = \ [col.name for col in old_attachment_schema.columns] attachment_data = ( ('ticket', '1', 'file1', 10, now, 'desc1', 'user1', '::1'), ('wiki', 'WikiStart', 'file2', 20, now, 'desc2', 'user2', '::2')) self.dbm.insert_into_tables((('attachment', attachment_column_names, attachment_data),)) db42.do_upgrade(self.env, VERSION, None) ipnr_col = attachment_column_names.index('ipnr') i = 0 for i, data in enumerate(self.env.db_query(""" SELECT * FROM attachment ORDER BY type """)): self.assertEqual(attachment_data[i][:ipnr_col] + attachment_data[i][ipnr_col+1:], data) self.assertEqual(len(attachment_data), i+1)
def test_wiki_table_upgraded(self): """The ipnr column is removed from the wiki table.""" db42.do_upgrade(self.env, VERSION, None) column_names = [col.name for col in new_wiki_schema.columns] self.assertEqual(column_names, self.dbm.get_column_names('wiki'))