mailman.git/src/mailman/database/schema/sqlite_20120407000000_01.sql, branch pluggable-components The GNU Mailing List manager. https://git.neuromancer.sk/mailman.git/atom/src/mailman/database/schema/sqlite_20120407000000_01.sql?h=pluggable-components 2014-09-22T23:32:58Z Migrations will be replaced with Alchemy. 2014-09-22T23:32:58Z Barry Warsaw 2014-09-22T23:32:58Z urn:sha1:31aebefadf7853a4e7767ea1552720f52e06bb7a We don't need the raw SQL schema stuff any more. We don't need the Version table any more. Migrate bounceevent.list_name -> bounceevent.list_id 2013-09-01T15:15:08Z Barry Warsaw 2013-09-01T15:15:08Z urn:sha1:d146f14b3eef9f608c0e03347c135062bade8ced * Rename StormBaseDatabase._create() -> .initialize() * Refactor database initialization. * make_listid() helper. * Add a pivot() helper for schema migrations. * The column `mailinglist.new_member_options` was unused, and has been 2012-12-30T16:59:05Z Barry Warsaw 2012-12-30T16:59:05Z urn:sha1:fc662999d425e9347f59f676861ee44ad81c2623 removed. Database 2012-10-16T22:40:12Z Barry Warsaw 2012-10-16T22:40:12Z urn:sha1:a1666479d87e26e5c79dd1cf507b8ef0472c59aa -------- * The `ban` table now uses list-ids to cross-reference the mailing list, since these cannot change even if the mailing list is moved or renamed. Interfaces ---------- * The `IBanManager` is no longer a global utility. Instead, you adapt an `IMailingList` to an `IBanManager` to manage the bans for a specific mailing list. To manage the global bans, adapt ``None``. * Schema migrations (LP: #1024509) 2012-09-05T02:25:49Z Barry Warsaw 2012-09-05T02:25:49Z urn:sha1:952cd3770fe4db4786efcc7c90d72dfa9aa74e68 - member.mailing_list -> list_id * The link between members and the mailing lists they are subscribed to, is 2012-09-05T01:31:50Z Barry Warsaw 2012-09-05T01:31:50Z urn:sha1:3c77c83ec4070e7183482445ff0b9a30398b72f4 now via the RFC 2369 `list_id` instead of the fqdn listname (i.e. posting address). This is because while the posting address can change if the mailing list is moved to a new server, the list id is fixed. (LP: #1024509) + IListManager.get_by_list_id() added. + IListManager.list_ids added. + IMailingList.list_id added. + Several internal APIs that accepted fqdn list names now require list ids, e.g. ISubscriptionService.join() and .find_members(). + IMember.list_id attribute added; .mailing_list is now an alias that retrieves and returns the IMailingList. - list_id added (LP: #1024509) * Removed obsolete `IMailingList` attribute `generic_nonmember_action. 2012-08-19T22:58:55Z Barry Warsaw 2012-08-19T22:58:55Z urn:sha1:9eb9875569a716dd82ee7764ecee2f37ab446e13 (LP: #975696) Working for SQLite: 2012-07-26T03:40:46Z Barry Warsaw 2012-07-26T03:40:46Z urn:sha1:30ecd410ba83dc32ad021a2d2c841761befe3079 include_list_post_header -> allow_list_posts Also add a bunch more migration tests. - Rename the model attributes. 2012-04-08T23:40:38Z Barry Warsaw 2012-04-08T23:40:38Z urn:sha1:fdfc98239de2cfdfff6c62a5bb9d49abc8d3722e - news_moderation -> newsgroup_moderation - Refactor the way databases are schema-migrated so that load_migrations() 2012-04-08T16:15:29Z Barry Warsaw 2012-04-08T16:15:29Z urn:sha1:2410fe8c2578fbd11275cfc7fc1897173eecd41a can be tested separately. - Add an `until` argument to load_migrations() so that we can load only up to a given timestamp. - In load_migrations(), ignore files in which the `version` part of the file name is empty. - In migrations.rst, use the new, better way of ensuring post-test cleanup. - Add tests for partial upgrades. - LP: #971013 - schema migrations for beta 2. - LP: #967238 - IMailingList.archive + IMailingList.archive_private -> IMailingList.archive_policy, and add ArchivePolicy enum. - Move the `chdir` context manager to helpers.py and add `temporary_db` context manager.