pbp_com/apps/catalog/extra/generate_subscriptions.py

# intended to run in shell plus
from django.contrib.auth.models import User
from django.db import transaction

from catalog.constants import INCOUNTY, INSTATE, OUTSTATE, REGULAR, FIRST_CLASS, FOREIGN
from catalog.models import Subscription

TITLES = ('The Weekly Packet', 'Island Advantages', 'Castine Patriot')
PREFIXES = (('IC', INCOUNTY),
            ('IS', INSTATE),
            ('OOS', OUTSTATE))  # 'F'
DURATIONS = ['9', '12', '24']
SHIPPING = (('R', REGULAR),)  # 'FC'

pricing = {
    'IC9R': 23.95,
    'IS9R': 24.95,
    'OOS9R': 34.95,
    'IC12R': 29.95,
    'IS12R': 31.95,
    'OOS12R': 44.95,
    'IC24R': 54.95,
    'IS24R': 57.95,
    'OOS24R': 79.95,
}

with transaction.commit_on_success():
    admin, rc = User.objects.get_or_create(username='admin')
    for title in TITLES:
        for prefix, value in PREFIXES:
            for duration in DURATIONS:
                for shipping_prefix, shipping_value in SHIPPING:
                    sku = prefix + duration + shipping_prefix
                    price = pricing[sku]
                    # first letter in title
                    title_abbrev = ''.join([i[0] for i in title.upper().split()])
                    sku = title_abbrev + sku
                    # regular flavor
                    # subscription, rc = Subscription.objects.get_or_create(
                    #     sku=sku,
                    #     created_by=admin,
                    #     last_updated_by=admin,
                    #     price=price,
                    #     shipping_cost=0.00,
                    #     shipping_cost_multiple=1,
                    #     duration=duration,
                    #     title=title,
                    #     shipping_type=value,
                    #     shipping_method=shipping_value)
                    # subscription.save()
                    # renewal flavor
                    sku += 'REN'
                    subscription, rc = Subscription.objects.get_or_create(
                        sku=sku,
                        created_by=admin,
                        last_updated_by=admin,
                        price=price,
                        shipping_cost=0.00,
                        shipping_cost_multiple=1,
                        duration=duration,
                        title=title,
                        shipping_type=value,
                        shipping_method=shipping_value,
                        renewal=True)
                    subscription.save()

# intended to run in shell plus
from django.contrib.auth.models import User
from django.db import transaction

from catalog.constants import INCOUNTY, INSTATE, OUTSTATE, REGULAR, FIRST_CLASS, FOREIGN
from catalog.models import Subscription

TITLES = ('The Weekly Packet', 'Island Advantages', 'Castine Patriot')
PREFIXES = (('IC', INCOUNTY),
            ('IS', INSTATE),
            ('OOS', OUTSTATE),
            ('F', FOREIGN),)  # 'F'
DURATIONS = ['12']
SHIPPING = (('FC', FIRST_CLASS),)  # 'FC'

pricing = {
    'IC12FC': 169.95,
    'IS12FC': 169.95,
    'OOS12FC': 169.95,
    'F12FC': 279.95
    }

with transaction.commit_on_success():
    admin = User.objects.get(username='admin')
    for title in TITLES:
        for prefix, value in PREFIXES:
            for duration in DURATIONS:
                for shipping_prefix, shipping_value in SHIPPING:
                    sku = prefix + duration + shipping_prefix
                    price = pricing[sku]
                    # first letter in title
                    title_abbrev = ''.join([i[0] for i in title.upper().split()])
                    sku = title_abbrev + sku
                    # regular flavor
                    subscription, rc = Subscription.objects.get_or_create(
                        sku=sku,
                        created_by=admin,
                        last_updated_by=admin,
                        price=price,
                        shipping_cost=0.00,
                        shipping_cost_multiple=1,
                        duration=duration,
                        title=title,
                        shipping_type=value,
                        shipping_method=shipping_value)
                    subscription.save()
                    # renewal flavor
                    sku += 'REN'
                    subscription, rc = Subscription.objects.get_or_create(
                        sku=sku,
                        created_by=admin,
                        last_updated_by=admin,
                        price=price,
                        shipping_cost=0.00,
                        shipping_cost_multiple=1,
                        duration=duration,
                        title=title,
                        shipping_type=value,
                        shipping_method=shipping_value,
                        renewal=True)
                    subscription.save()