aboutsummaryrefslogtreecommitdiffstats
path: root/mediagoblin/db/sql/migrations.py
diff options
context:
space:
mode:
Diffstat (limited to 'mediagoblin/db/sql/migrations.py')
-rw-r--r--mediagoblin/db/sql/migrations.py23
1 files changed, 18 insertions, 5 deletions
diff --git a/mediagoblin/db/sql/migrations.py b/mediagoblin/db/sql/migrations.py
index fb178285..1d822cd9 100644
--- a/mediagoblin/db/sql/migrations.py
+++ b/mediagoblin/db/sql/migrations.py
@@ -16,14 +16,12 @@
import datetime
-from sqlalchemy import (MetaData, Table, Column, Boolean, SmallInteger,
+from sqlalchemy import (MetaData, Table, Column, Boolean, SmallInteger,
Integer, Unicode, UnicodeText, DateTime, ForeignKey)
-
-
from mediagoblin.db.sql.util import RegisterMigration
-from mediagoblin.db.sql.models import MediaEntry, Collection, User
-
+from mediagoblin.db.sql.models import MediaEntry, Collection, User, \
+ ProcessingMetaData
MIGRATIONS = {}
@@ -66,6 +64,7 @@ def add_transcoding_progress(db_conn):
col.create(media_entry)
db_conn.commit()
+
@RegisterMigration(4, MIGRATIONS)
def add_collection_tables(db_conn):
metadata = MetaData(bind=db_conn.bind)
@@ -92,6 +91,7 @@ def add_collection_tables(db_conn):
db_conn.commit()
+
@RegisterMigration(5, MIGRATIONS)
def add_mediaentry_collected(db_conn):
metadata = MetaData(bind=db_conn.bind)
@@ -103,3 +103,16 @@ def add_mediaentry_collected(db_conn):
col.create(media_entry)
db_conn.commit()
+
+@RegisterMigration(6, MIGRATIONS)
+def create_processing_metadata_table(db):
+ metadata = MetaData(bind=db.bind)
+
+ metadata_table = Table('core__processing_metadata', metadata,
+ Column('id', Integer, primary_key=True),
+ Column('media_entry_id', Integer, ForeignKey(MediaEntry.id),
+ nullable=False, index=True),
+ Column('callback_url', Unicode))
+
+ metadata_table.create()
+ db.commit()