Re: [sqlalchemy] Commands out of sync; you can't run this command now

2019-04-16 Thread Jonathan Vanasco
On Tuesday, April 16, 2019 at 9:41:39 AM UTC-4, Mike Bayer wrote: > > On Tue, Apr 16, 2019 at 4:49 AM tonthon wrote: > > > > Celery tasks are using the same scoped_session factory, could it cause > the errors we're facing here ? > Is Celery running as threads or multiprocessing? IIRC, it u

[sqlalchemy] Hiring for Senior Full Stack Python Developer,Atlanta, GA, NO h1b

2019-04-16 Thread ranjeet kumar
*Hi please go through the job description for * *Senior Full Stack Python Developer* *send me your updated resume * *Position : Senior Full Stack Python Developer Location : Atlanta, GA Duration 6+ Months Interview Process: Phone and Skype* *No h1b* *Senior Full Stack Python Developer (9+

[sqlalchemy] Re: 100 records are inserted while inserting 10 records raw_connection

2019-04-16 Thread Jonathan Vanasco
You have two for loops On Tuesday, April 16, 2019 at 6:47:34 AM UTC-4, Suresh Chinta wrote: > > > for rows in range(0,df.shape[0]): > ... > for row in range(0,df.shape[0]): > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/

[sqlalchemy] Hiring for Full Stack C#.Net Developer,Dallas, TX, locals receive first preference.

2019-04-16 Thread ranjeet kumar
*Hi please go through the job description for Full Stack C#.Net Developer send me your updated resume * *Position : Full Stack C#.Net Developer Location : Dallas, TX Duration 24+ months Interview Process: Phone and f2f/Skype* LOCAL CANDIDATES TO THE RICHARDSON/DALLAS AREA RECEIVE FIRST PREFE

Re: [sqlalchemy] Commands out of sync; you can't run this command now

2019-04-16 Thread Mike Bayer
Note also the objects can be copied using copy.deepcopy(), or pickle loads()/dumps(), before sending them to the other Session. This might not have worked in older Python / SQLAlchemy versions but deepcopy() seems to rely upon the pickle internals e.g. __setstate__, which in SQLAlchemy will cor

Re: [sqlalchemy] Commands out of sync; you can't run this command now

2019-04-16 Thread Mike Bayer
On Tue, Apr 16, 2019 at 4:49 AM tonthon wrote: > > Celery tasks are using the same scoped_session factory, could it cause the > errors we're facing here ? what's important is if these tasks run in the same process or not ? ( i thought celery runs as a separate service?) If you are passing O

[sqlalchemy] 100 records are inserted while inserting 10 records raw_connection

2019-04-16 Thread Suresh Chinta
Hi, When I try to insert 10 records into oracle database, 100 records are inserted. i.e number of records is multiplied by itself. Please let me know if I am doing something incorrect. #df has 10 records. engine = create_engine(connection_str, echo=False) connection = engine.raw_con

Re: [sqlalchemy] Commands out of sync; you can't run this command now

2019-04-16 Thread tonthon
Celery tasks are using the same scoped_session factory, could it cause the errors we're facing here ? Le 15/04/2019 à 15:39, Mike Bayer a écrit : On Mon, Apr 15, 2019 at 5:41 AM tonthon wrote: I tried to set a lower value for the pool_recycle value and it seems to work. There is a celery se

Re: [sqlalchemy] Creating database tables from queries based on ORM API?

2019-04-16 Thread Markus Elfring
> Answering line by line is not really a good use of either of our time I increased my feedback according to the provided information. > and I apologize that I cannot really work with the lack of specifics > presented here, You might prefer an other communication style. > if I can restate the