Alembic autogenerate ignore non mapped tables.

Hi, When I auto generate a migration using alembic, it automatically drops some dynamically created tables which are in the DB schema. These tables are dynamically created by my application. These class don't inherit declarative base. They are added to declarative base by the application

[sqlalchemy] ROLLBACK with no reason.

Hi, SQLalchemy rollbacks an insert command with out the reason for failure. I am using Mysql 2017-10-06 15:23:22,170 INFO [sqlalchemy.engine.base.Engine:1140][b'uWSGIWorker2Core0'] INSERT INTO group_message_22f9b36c (group_id, group_topic_id, score, user_id, uname, msg, created_at,

Re: [sqlalchemy] Set/clear mapping for some tables only

Hi, Sorry for the delay. Marking the DBsession dirty after a non ORM operation works for now. Zope.sqlalchemy.mark_changed(DBSession()) Thanks for the info Simon Srikanth Bemineni On Tuesday, November 29, 2016 at 9:10:32 AM UTC-6, Mike Bayer wrote: > > Hi Srikanth, answers inline. >

Re: [sqlalchemy] Set/clear mapping for some tables only

/ with session_shardid(DBSession,table_hash): Base.metadata.create_all(DBSession.connection()) self.request.tm.commit() -> This also doesn't help all the statements just roll back. Srikanth Bemineni On Monday, November 28, 2016 at 8:28:22 AM UTC-6, Mike Bayer wrote: > > > > On 1

Re: [sqlalchemy] Set/clear mapping for some tables only

; be committed. > > Also you should be able to attach session events to the scoped_session > object directly, the session event structure will extract the underlying > sessionmaker class as the target. > > > > On 11/26/2016 01:56 PM, Srikanth Bemineni wrote: > &g

Re: [sqlalchemy] Set/clear mapping for some tables only

ngine:1143][b 'uWSGIWorker4Core0'] {} 2016-11-26 12:38:13,705 INFO [sqlalchemy.engine.base.Engine:699][b 'uWSGIWorker4Core0'] ROLLBACK On Saturday, November 26, 2016 at 9:10:23 AM UTC-6, Srikanth Bemineni wrote: > > Hi, > > Hope this helps others > > 1. DBSession is scoped_

Re: [sqlalchemy] Set/clear mapping for some tables only

parameters[param] = value.replace("_shardid_",session_info["shard"]) return statement, parameters On Friday, November 25, 2016 at 10:14:31 PM UTC-6, Srikanth Bemineni wrote: > > Hi, > > Sorry some of the debug trace was missing from the previou

Re: [sqlalchemy] Set/clear mapping for some tables only

session.transaction._iterate_parents()[-1] AttributeError: 'SessionTransaction' object has no attribute '_iterate_parents' On Friday, November 25, 2016 at 10:12:18 PM UTC-6, Srikanth Bemineni wrote: > > Hi, > > I was not using the DBSession.connection() while creating the tables when

Re: [sqlalchemy] Set/clear mapping for some tables only

3.4/site-packages/zope.sqlalchemy-0.7.6-py3.4.egg/zope/sqlalchemy/datamanager.py" , line 65, in __init__ self.tx = session.transaction._iterate_parents()[-1] AttributeError: 'SessionTransaction' object has no attribute '_iterate_parents' On Friday, November 25, 2016 at 7:50:25 PM UTC-6,

Re: [sqlalchemy] Set/clear mapping for some tables only

connection.info['session_info'] = session.info DBSession.configure(bind=engine) Srikanth Bemineni On Friday, November 25, 2016 at 3:15:27 PM UTC-6, Mike Bayer wrote: > > > > On 11/25/2016 03:55 PM, Srikanth Bemineni wrote: > > > > Hi Mike, > > > >

Re: [sqlalchemy] Set/clear mapping for some tables only

pretation of the data returned by database and its not able to map to the specified class. Are there future plans to get this recipe into the the library.? Srikanth Bemineni On Friday, November 25, 2016 at 2:04:29 PM UTC-6, Mike Bayer wrote: > > > > On 11/24/2016 11:04 PM, Srikanth Be

[sqlalchemy] Re: Set/clear mapping for some tables only

all classes. Cannot use clear_mappers(), which will clear other declarative mappings, Srikanth Bemineni On Thursday, November 24, 2016 at 10:04:02 PM UTC-6, Srikanth Bemineni wrote: > > Hi, > > I am using sqlalchemy in my pyramid application. I have situation here, > wher

[sqlalchemy] Set/clear mapping for some tables only

he request. This is a uwsgi application will the clear_mapper affect other worker threads. ? Srikanth Bemineni -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http:

[sqlalchemy] Re: Pyramid SQLAlchemy tutorial error

stance. Thanks Michael for pointing out that the problem was in zope.sqlalchemy part of the code/library. Srikanth On Sunday, November 29, 2015 at 8:13:45 PM UTC-6, Srikanth Bemineni wrote: > > Hi, > > I am going through the Pyramid quick tutorial. > > While initializing th

[sqlalchemy] Re: Pyramid SQLAlchemy tutorial error

Hi all, How do we debug these kind of issues in python ?. The problem was completely some where else, but error was thrown during database operation, with no info on the actual issue. Srikanth On Sunday, November 29, 2015 at 8:13:45 PM UTC-6, Srikanth Bemineni wrote: > > Hi, > >

[sqlalchemy] Re: Pyramid SQLAlchemy tutorial error

Finished processing dependencies for tutorial==0.0.0 Srikanth On Sunday, November 29, 2015 at 8:13:45 PM UTC-6, Srikanth Bemineni wrote: > > Hi, > > I am going through the Pyramid quick tutorial. > > While initializing the database, I am getting the below error. Can some > o

[sqlalchemy] Pyramid SQLAlchemy tutorial error

Hi, I am going through the Pyramid quick tutorial. While initializing the database, I am getting the below error. Can some one point me out, what would cause this error. I am completely new to python and pyramid moving here from Ruby world.