def insert(itemList): init() # create a new session session = Session() session.add_all(itemList) session.commit() session.close()
from sqlalchemy import and_ start = datetime.datetime.now() print(f"start time: {start}") session = Session() pages = list(session.query(Page)) traits = list(session.query(Trait)) for page in pages: # Empty list to hold TraitPage objects trait_pages = [] # Check if the trait term is found for trait in traits: trait_page = page.trait_search(trait) if trait_page is not None: trait_pages.append(trait_page) # Write to db.trait_page if len(trait_pages) > 0: print(trait_pages) result = session.add_all(trait_pages) session.flush() session.close() end = datetime.datetime.now() print(f"start time: {end}") print(f"duration: {end - start}")
def append_string(insert, compiler, **kw): s = compiler.visit_insert(insert, **kw) if 'append_string' in insert.kwargs: return s + " " + insert.kwargs['append_string'] return s my_connection.execute(my_table.insert(append_string = 'ON DUPLICATE KEY UPDATE foo=foo'), my_values) try: # 3 - create a new session session = Session() # cards = qr.from_csv('data.csv') session.add_all(users_all) for card in cards_all: session.add(card) session.commit() finally: session.close() # class User(Base): # __tablename__ = 'users' # user_id = Column(Integer, primary_key=True)
birth_date='2008-11-11', gender='F', hire_date='2020-04-04') emp5 = Employee(first_name="kuty", last_name="john", birth_date='2008-11-11', gender='M', hire_date='2020-04-04') emp6 = Employee(first_name="jose", last_name="jones", birth_date='2008-11-11', gender='M', hire_date='2020-04-04') session.add_all([emp2, emp3, emp4, emp5, emp6]) dep2 = Department(dep_name="CSE") dep3 = Department(dep_name="MECH") dep4 = Department(dep_name="EEE") dep5 = Department(dep_name="ECE") dep6 = Department(dep_name="CIVIL") session.add_all([dep2, dep3, dep4, dep5, dep6]) dep_emp2 = Dep_Emp(employee=emp2, department=dep2,
cards_all = [] users_all = [] for one_row in chunk: # user0 = User(user_id=int(one_row[0])) user0 = User(user_id=int(one_row[0])) users_all.append(user0) card = Card(card_id=int(one_row[1]), user_id=int(one_row[0])) cards_all.append(card) # In case I need a mapper kw_map = {a.key: a.class_attribute.name for a in User.__mapper__.attrs} kwargs = {a.key: user0[a.class_attribute.name] for a in User.__mapper__.attrs} try: # 3 - create a new session session = Session() # users_all = session.merge(users_all) merged_users = map(session.merge, users_all) # cards = qr.from_csv('data.csv') session.add_all(merged_users) for card in cards_all: session.add(card) session.commit() finally: session.close()
session.add(velozes_e_furiosos_7) session.add(sem_dor_sem_ganho) session.add(gente_grande) session.add(click) session.add(street_fighter) session.add(kickboxer) session.add(bloodsport) session.add(cyborg) session.add(rocky_4) session.add(os_mercenarios_2) session.add(soldado_universal) session.add(matt_damon) session.add(dwayne_johnson) session.add(mark_wahlberg) session.add(van_damme) session.add(adam_sandler) session.add(stallone) session.add(dolph_lundgren) session.add_all([matt_contato, dwayne_contato, dwayne_contato_2, mark_contato]) session.add_all([matt_duble, dwayne_duble, mark_duble]) session.commit() except Exception as e: print('Error: ', e) finally: session.close()