diff options
author | Joar Wandborg <git@wandborg.com> | 2012-06-10 18:26:21 +0200 |
---|---|---|
committer | Joar Wandborg <git@wandborg.com> | 2012-06-10 18:26:21 +0200 |
commit | 38c6d44123aa1ee21e55730cc13f9e3da30a94f4 (patch) | |
tree | 3fec11b57a2a31a3fc8f962946725f4ee7f59507 | |
parent | 00722c99084da94e48d84ea9e740bc1e2a49d9b1 (diff) | |
download | mediagoblin-38c6d44123aa1ee21e55730cc13f9e3da30a94f4.tar.lz mediagoblin-38c6d44123aa1ee21e55730cc13f9e3da30a94f4.tar.xz mediagoblin-38c6d44123aa1ee21e55730cc13f9e3da30a94f4.zip |
Added SQL migrations for email notifications
-rw-r--r-- | mediagoblin/db/sql/migrations.py | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/mediagoblin/db/sql/migrations.py b/mediagoblin/db/sql/migrations.py index 3b7ee8b4..c7f45e16 100644 --- a/mediagoblin/db/sql/migrations.py +++ b/mediagoblin/db/sql/migrations.py @@ -14,7 +14,7 @@ # You should have received a copy of the GNU Affero General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. -from sqlalchemy import MetaData, Table +from sqlalchemy import MetaData, Table, Column, Boolean from mediagoblin.db.sql.util import RegisterMigration @@ -30,6 +30,18 @@ def ogg_to_webm_audio(db_conn): autoload_with=db_conn.bind) db_conn.execute( - file_keynames.update().where(file_keynames.c.name=='ogg'). + file_keynames.update().where(file_keynames.c.name == 'ogg'). values(name='webm_audio') ) + + +@RegisterMigration(2, MIGRATIONS) +def add_wants_notification_column(db_conn): + metadata = MetaData(bind=db_conn.bind) + + users = Table('core__users', metadata, autoload=True, + autoload_with=db_conn.bind) + + col = Column('wants_comment_notification', Boolean, + default=True, nullable=False) + col.create(users, populate_defaults=True) |