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()
def insert_ev_site():
from ev_site import EVParentSite, EVSite
site_list = []
query_site = session.query(EVSite)
query_parent_site = session.query(EVParentSite)
""" for x1x.com """
try:
ev_site = query_site.filter_by(name='X1X.com').one()
except NoResultFound:
ev_site = EVSite(name='X1X.com')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='X1X.com').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for caribbeancom.com """
try:
ev_site = query_site.filter_by(name='カリビアンコム').one()
except NoResultFound:
ev_site = EVSite(name='カリビアンコム')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='カリビアンコム').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for xxx-av.com """
try:
ev_site = query_site.filter_by(name='トリプルエックス').one()
except NoResultFound:
ev_site = EVSite(name='トリプルエックス')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='トリプルエックス').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for 1pondo.tv """
try:
ev_site = query_site.filter_by(name='一本道').one()
except NoResultFound:
ev_site = EVSite(name='一本道')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='一本道').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for heyzo.com """
try:
ev_site = query_site.filter_by(name='HEYZO').one()
except NoResultFound:
ev_site = EVSite(name='HEYZO')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='HEYZO').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for enkou55.com """
try:
ev_site = query_site.filter_by(name='援助交際めちゃハメムービー').one()
except NoResultFound:
ev_site = EVSite(name='援助交際めちゃハメムービー')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='援助交際めちゃハメムービー').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for my.tokyo-hot.com """
try:
ev_site = query_site.filter_by(name='東京熱').one()
except NoResultFound:
ev_site = EVSite(name='東京熱')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='東京熱').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
""" for onacle.tv """
try:
ev_site = query_site.filter_by(name='オナクル').one()
except NoResultFound:
ev_site = EVSite(name='オナクル')
if not ev_site.parent_site:
parent_site = query_parent_site.filter_by(name_jp='オナクル').one()
ev_site.parent_site = parent_site
site_list.append(ev_site)
session.add_all(site_list)
session.commit()
