Hi Everyone, How to save new objects to database without SELECT permission on the table?
I tried using implicit_returning and use_scope_identity in create_engine. engine = create_engine(connstr, implicit_returning=False, use_scope_identity =False, echo=True) db_session = sessionmaker(engine)() db_session.add_all(new_resources) No luck with that. There's always some sort of select on table that returned row identity. I found on StackOverflow that I could execute insert on table with insert(inline=True) and list of raw data to send. self.db_session.execute(query_class.__table__.insert(inline=True), new_resources_data) Though with that approach I need to extract data from ORM objects and manually map them into dict with column names. Any suggestions? -- 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.
