Me again. Just wanted to say that
engine = create_engine(connstr, implicit_returning=False, use_scope_identity =True, echo=True) actually works as expected. I was able to add new objects without select permission on table :) On Wednesday, August 10, 2016 at 5:33:30 PM UTC+2, mdob wrote: > > 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.