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