Just posting this to the group for SEO equity
The docs for inserting many are all built around a table class:
conn.execute(addresses.insert(), [... {'user_id': 1, 'email_address' :
'[email protected]'},... {'user_id': 1, 'email_address' : '[email protected]'}
I needed to quickly create some temp tables and didn't want to create
classes to insert data. using a `sqlalchemy.text()` instance instead of
`addresses.insert()` works:
tmp_create = sqlalchemy.text("CREATE TEMPORARY TABLE
_daily_metrics_dates ( metric_date DATE PRIMARY KEY);")
results = dbSession.execute(tmp_create)
tmp_insert_stmt = sqlalchemy.text("INSERT INTO _daily_metrics_dates
VALUES (:metric_date)")
tmp_insert_data = [{'metric_date': i} for i in dates_process_strings]
results = dbSession.execute(tmp_insert_stmt, tmp_insert_data)
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
