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