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()