← Back to branch summary

~abompard/mailman/bug-1312884

~abompard/mailman/bug-1312884

« back to all changes in this revision

Viewing changes to src/mailman/database/alembic/script.py.mako

Committer: Barry Warsaw
Date: 2014-11-01 16:49:15 UTC
mfrom: (7251.1.38 abhilash)
Revision ID: barry@list.org-20141101164915-06wqfmya6wf47n6n

Database
--------
* The ORM layer, previously implemented with Storm, has been replaced by
   SQLAlchemy, thanks to the fantastic work by Abhilash Raj and Aurélien
   Bompard.  Alembic is now used for all database schema migrations.
* The new logger `mailman.database` logs any errors at the database layer.

API
---
* Several changes to the internal API:
   - `IListManager.mailing_lists` is guaranteed to be sorted in List-ID order.
   - `IDomains.mailing_lists` is guaranteed to be sorted in List-ID order.
   - Iteration over domains via the `IDomainManager` is guaranteed to be sorted
     by `IDomain.mail_host` order.
   - `ITemporaryDatabase` interface and all implementations are removed.

files added:
src/mailman/config/alembic.cfg

src/mailman/database/alembic

src/mailman/database/alembic/__init__.py

src/mailman/database/alembic/env.py

src/mailman/database/alembic/script.py.mako

src/mailman/database/alembic/versions

src/mailman/database/alembic/versions/51b7f92bd06c_initial.py

src/mailman/database/tests

src/mailman/database/tests/__init__.py

src/mailman/database/tests/test_factory.py

files removed:
src/mailman/database/docs

src/mailman/database/docs/__init__.py

src/mailman/database/docs/migration.rst

src/mailman/database/schema

src/mailman/database/schema/__init__.py

src/mailman/database/schema/helpers.py

src/mailman/database/schema/mm_00000000000000_base.py

src/mailman/database/schema/mm_20120407000000.py

src/mailman/database/schema/mm_20121015000000.py

src/mailman/database/schema/mm_20130406000000.py

src/mailman/database/schema/postgres.sql

src/mailman/database/schema/sqlite.sql

src/mailman/database/schema/sqlite_20120407000000_01.sql

src/mailman/database/schema/sqlite_20121015000000_01.sql

src/mailman/database/schema/sqlite_20130406000000_01.sql

src/mailman/database/tests

src/mailman/database/tests/__init__.py

src/mailman/database/tests/data

src/mailman/database/tests/data/__init__.py

src/mailman/database/tests/data/mailman_01.db

src/mailman/database/tests/data/migration_postgres_1.sql

src/mailman/database/tests/data/migration_sqlite_1.sql

src/mailman/database/tests/test_migrations.py

src/mailman/model/version.py

files modified:
MANIFEST.in

setup.py

src/mailman/app/docs/moderator.rst

src/mailman/app/subscriptions.py

src/mailman/bin/tests/test_master.py

src/mailman/commands/docs/conf.rst

src/mailman/commands/docs/withlist.rst

src/mailman/config/config.py

src/mailman/config/configure.zcml

src/mailman/config/schema.cfg

src/mailman/core/docs/runner.rst

src/mailman/core/logging.py

src/mailman/database/base.py

src/mailman/database/factory.py

src/mailman/database/model.py

src/mailman/database/postgresql.py

src/mailman/database/sqlite.py

src/mailman/database/types.py

src/mailman/docs/ACKNOWLEDGMENTS.rst

src/mailman/docs/NEWS.rst

src/mailman/handlers/docs/owner-recips.rst

src/mailman/interfaces/database.py

src/mailman/interfaces/domain.py

src/mailman/interfaces/listmanager.py

src/mailman/interfaces/messages.py

src/mailman/model/address.py

src/mailman/model/autorespond.py

src/mailman/model/bans.py

src/mailman/model/bounce.py

src/mailman/model/digests.py

src/mailman/model/docs/autorespond.rst

src/mailman/model/docs/mailinglist.rst

src/mailman/model/docs/messagestore.rst

src/mailman/model/docs/requests.rst

src/mailman/model/domain.py

src/mailman/model/language.py

src/mailman/model/listmanager.py

src/mailman/model/mailinglist.py

src/mailman/model/member.py

src/mailman/model/message.py

src/mailman/model/messagestore.py

src/mailman/model/mime.py

src/mailman/model/pending.py

src/mailman/model/preferences.py

src/mailman/model/requests.py

src/mailman/model/roster.py

src/mailman/model/tests/test_listmanager.py

src/mailman/model/tests/test_requests.py

src/mailman/model/uid.py

src/mailman/model/user.py

src/mailman/model/usermanager.py

src/mailman/rest/docs/moderation.rst

src/mailman/rest/validator.py

src/mailman/styles/base.py

src/mailman/testing/layers.py

src/mailman/testing/testing.cfg

src/mailman/utilities/importer.py

src/mailman/utilities/modules.py

src/mailman/utilities/tests/test_import.py

Show diffs side-by-side

added added

removed removed

src/mailman/database/alembic/script.py.mako

1

"""${message}

2

3

Revision ID: ${up_revision}

4

Revises: ${down_revision}

5

Create Date: ${create_date}

6

7

"""

8

9

# revision identifiers, used by Alembic.

10

revision = ${repr(up_revision)}

11

down_revision = ${repr(down_revision)}

12

13

from alembic import op

14

import sqlalchemy as sa

15

${imports if imports else ""}

16

17

def upgrade():

18

${upgrades if upgrades else "pass"}

19

20

21

def downgrade():

22

${downgrades if downgrades else "pass"}

Older »