Python AddColumn Examples

Example #1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.AddColumn('podcast', 'episode', 'author', 'integer NULL',
                        'auth_user')

Example #2

File: 032_add_column_category_to_articles_article.py Project: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.AddColumn('articles', 'article', 'category', 'integer NOT NULL',
                        'articles_articlecategory')

Example #3

File: 038_add_columns_pages_title_and_mainNavigation_and_footerNavigation_to_articles_ArticleCategory.py Project: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.Compound([
    m.AddColumn('articles', 'articlecategory', 'pages_title',
                'varchar(200) NOT NULL'),
    m.AddColumn('articles', 'articlecategory', 'mainNavigation',
                'integer NULL', 'navigation_navigation'),
    m.AddColumn('articles', 'articlecategory', 'footerNavigation',
                'integer NULL', 'navigation_navigation'),
])

Example #4

File: 057_add_columns_duration_to_podcast_episode.py Project: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime

migration = m.AddColumn('podcast', 'episode', 'duration', 'varchar(8) NULL')

Example #5

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.AddColumn('podcast', 'episode', 'image_description',
                        'varchar(50) NULL')

Example #6

File: 036_add_column_pod_promos_to_articles_article.py Project: gareth53/gareth53_v1

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.AddColumn('articles', 'article', 'pod_promos', 'integer NULL',
                        'articles_promo')

Example #7

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.AddColumn('podcast', 'episode', 'enhanced_media_URL',
                        'varchar(200) NULL')

Example #8

from gareth53.apps.dmigrations.mysql import migrations as m
import datetime
migration = m.AddColumn('blog', 'blogcategory', 'use_count',
                        'integer NOT NULL')