← Back to branch summary

~abompard/mailman/bug-1312884

~abompard/mailman/bug-1312884

« back to all changes in this revision

Viewing changes to src/mailman/model/message.py

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/model/message.py

24

24

'Message',

25

25

]

26

26

27

from storm.locals import AutoReload, Int, RawStr, Unicode

27

from sqlalchemy import Column, Integer, LargeBinary, Unicode

28

28

from zope.interface import implementer

29

29

30

30

from mailman.database.model import Model

37

37

class Message(Model):

38

38

"""A message in the message store."""

39

39

40

id = Int(primary=True, default=AutoReload)

41

message_id = Unicode()

42

message_id_hash = RawStr()

43

path = RawStr()

40

__tablename__ = 'message'

41

42

id = Column(Integer, primary_key=True)

44

43

# This is a Messge-ID field representation, not a database row id.

44

message_id = Column(Unicode)

45

message_id_hash = Column(LargeBinary)

46

path = Column(LargeBinary)

45

47

46

48

@dbconnection

47

49

def __init__(self, store, message_id, message_id_hash, path):

Older »