Re: [sqlalchemy] SQLAlchemy enum in external file

2017-10-19 Thread Mike Bayer
It's not different "processes". It's the difference between running myfile.py from the python interpreter, making the module effectively __main__, vs running myfile.py via "import myfile". Same filesystem file but two totally different modules in the same process. On Oct 19, 2017 4:29 PM,

[sqlalchemy] Is ARRAY supported in MySQL?

2017-10-19 Thread sqlalchemy_mysql
Sorry I don't see any references in doc. I tried using array type but got this error can't render element of type Compiler can't render element of type Here is my column defintion sqla.Column(sqla_types.ARRAY(sqla_types.String), default=[], nullable=False) -- SQLAlchemy - The Python

Re: [sqlalchemy] SQLAlchemy enum in external file

2017-10-19 Thread Jonathan Vanasco
On Thursday, October 19, 2017 at 4:10:11 PM UTC-4, Taz Mainiac wrote: > > > If you ran two scripts or two modules, it would also almost always fail >> (IIRC, it is remotely possible but highly unlikely, to generate the same id >> in another process). >> > > I am not doing that. > > re-read

Re: [sqlalchemy] SQLAlchemy enum in external file

2017-10-19 Thread TazMainiac
On Thu, Oct 19, 2017 at 2:25 PM, Jonathan Vanasco wrote: > On Thursday, October 19, 2017 at 11:55:49 AM UTC-4, Taz Mainiac wrote: >> >> So - a morning spent googling does not turn up any information about >> Python classes having a different id depending on context (script

Re: [sqlalchemy] SQLAlchemy enum in external file

2017-10-19 Thread Jonathan Vanasco
On Thursday, October 19, 2017 at 11:55:49 AM UTC-4, Taz Mainiac wrote: > > So - a morning spent googling does not turn up any information about > Python classes having a different id depending on context (script vs > module). I'm probably not googling for the right thing? Can anyone point >

Re: [sqlalchemy] SQLAlchemy enum in external file

2017-10-19 Thread TazMainiac
On Wed, Oct 18, 2017 at 9:08 PM, Mike Bayer wrote: > the example calls the "myoper" python file in two different contexts, > resulting in two different MyStatus enumeration objects. Calling > "python myoper.py" invokes "myoper" as a plain Python script, sets up >

Re: [sqlalchemy] missing select() in CompoundSelectTest ?

2017-10-19 Thread Gijs Molenaar
Op donderdag 19 oktober 2017 03:22:31 UTC+2 schreef Mike Bayer: > > On Wed, Oct 18, 2017 at 10:18 AM, Gijs Molenaar > wrote: > > Hi again! > > > > This is the hopefully the last mail since this is the last failing test > for > > the MonetDB dialect! > > > > I

Re: [sqlalchemy] question about test_integrity_error test

2017-10-19 Thread Gijs Molenaar
Op donderdag 19 oktober 2017 03:18:46 UTC+2 schreef Mike Bayer: > > On Wed, Oct 18, 2017 at 9:23 AM, Gijs Molenaar > wrote: > > hi! > > > > I'm trying to understand the intentions of this test better: > > > > >

Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

2017-10-19 Thread Gijs Molenaar
Op donderdag 19 oktober 2017 03:10:21 UTC+2 schreef Mike Bayer: > > On Wed, Oct 18, 2017 at 7:38 AM, Gijs Molenaar > wrote: > > hi! > > > > > > Not sure if this a bug or something I should in my SQLAlchemy dialect, > but > > currently > > > > > > expr =