Alas, the production database is SQL Server (though from Linux). I use
SQLite for testing. One of the attractions of SQLAlchemy is to stop
worrying about database differences.
I'll get it all figured out eventually. Thanks for the help.
Skip
On Tue, Nov 21, 2017 at 7:16 AM, Simon King
I'm pretty sure that bulk_insert_mappings ends up just calling the
same code that I suggested.
What database are you using? If it's Postgres, you might be interested
in
http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#psycopg2-batch-mode
(linked from
(TLDR: I think bulk_insert_mappings is the wrong function for you to use)
SQLAlchemy consists of 2 main layers. The Core layer deals with SQL
construction, database dialects, connection pooling and so on. The ORM
is built on top of Core, and is intended for people who want to work
with "mapped
I've narrowed down my problem space a bit. Consider this simple code:
from sqlalchemy import (Integer, String, Column, MetaData, create_engine)
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
METADATA = MetaData()
BASE =