← 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/preferences.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/preferences.py

25

25

]

26

26

27

27

28

from storm.locals import Bool, Int, Unicode

28

from sqlalchemy import Boolean, Column, Integer, Unicode

29

29

from zope.component import getUtility

30

30

from zope.interface import implementer

31

31

41

41

class Preferences(Model):

42

42

"""See `IPreferences`."""

43

43

44

id = Int(primary=True)

45

acknowledge_posts = Bool()

46

hide_address = Bool()

47

_preferred_language = Unicode(name='preferred_language')

48

receive_list_copy = Bool()

49

receive_own_postings = Bool()

50

delivery_mode = Enum(DeliveryMode)

51

delivery_status = Enum(DeliveryStatus)

44

__tablename__ = 'preferences'

45

46

id = Column(Integer, primary_key=True)

47

acknowledge_posts = Column(Boolean)

48

hide_address = Column(Boolean)

49

_preferred_language = Column('preferred_language', Unicode)

50

receive_list_copy = Column(Boolean)

51

receive_own_postings = Column(Boolean)

52

delivery_mode = Column(Enum(DeliveryMode))

53

delivery_status = Column(Enum(DeliveryStatus))

52

54

53

55

def __repr__(self):

54

56

return '<Preferences object at {0:#x}>'.format(id(self))

Older »