def insert_ev_site():
#import ev_site
from ev_site import EVSite, AffiliateProvider
site_list = []
query_site = session.query(EVSite)
query_affiliate_provider = session.query(AffiliateProvider)
#if not query.filter_by(name_jp = 'X1X.com').first():
# site_list.append(EVSite('X1X.com', 'X1X.com', 'x1x.com'))
try:
ev_site = query_site.filter_by(name_jp='X1X.com').one()
except NoResultFound:
ev_site = EVSite(name_jp='X1X.com', name_en='X1X.com', url='x1x.com')
if not ev_site.affiliate_provider:
affiliate_provider = query_affiliate_provider.filter_by(name='TMP').one()
ev_site.affiliate_provider = affiliate_provider
site_list.append(ev_site)
#if not query.filter_by(name_jp = 'カリビアンコム').first():
# site_list.append(EVSite('カリビアンコム', 'CARIBBEANCOM', 'caribbeancom.com'))
try:
ev_site = query_site.filter_by(name_jp='カリビアンコム').one()
except NoResultFound:
ev_site = EVSite(name_jp='カリビアンコム', name_en='CARIBBEANCOM', url='caribbeancom.com')
if not ev_site.affiliate_provider:
affiliate_provider = query_affiliate_provider.filter_by(name='DTI').one()
ev_site.affiliate_provider = affiliate_provider
site_list.append(ev_site)
#if not query.filter_by(name_jp = 'トリプルエックス').first():
# site_list.append(EVSite('トリプルエックス', 'XXX', 'xxx-av.com'))
try:
ev_site = query_site.filter_by(name_jp='トリプルエックス').one()
except NoResultFound:
ev_site = EVSite(name_jp='トリプルエックス', name_en='XXX', url='xxx-av.com')
if not ev_site.affiliate_provider:
affiliate_provider = query_affiliate_provider.filter_by(name='SBS').one()
ev_site.affiliate_provider = affiliate_provider
site_list.append(ev_site)
session.add_all(site_list)
session.commit()
