Re: [sqlalchemy] Numeric type without scale? Oracle

2019-10-01 Thread jr
That worked perfectly, thank you so much for your help! On Tuesday, October 1, 2019 at 3:35:25 PM UTC+2, Mike Bayer wrote: > > Hi there - > > you can use sqlalchemy.dialects.oracle.NUMBER directly: > > from sqlalchemy import Column > from sqlalchemy import MetaData > from sqlalchemy import Table

Re: [sqlalchemy] Numeric type without scale? Oracle

2019-10-01 Thread Mike Bayer
Hi there - you can use sqlalchemy.dialects.oracle.NUMBER directly: from sqlalchemy import Column from sqlalchemy import MetaData from sqlalchemy import Table from sqlalchemy.dialects import oracle from sqlalchemy.dialects.oracle import NUMBER from sqlalchemy.schema import CreateTable t =

Re: [sqlalchemy] Association table through two columns?

2019-10-01 Thread Mike Bayer
On Mon, Sep 30, 2019, at 12:25 AM, Mateja Putic wrote: > I would like to create an association between a Dataset object and all > Category objects through an intermediate Annotation table. > A Dataset contains a collection of Annotations. Each Annotation has a single > Category. I want

[sqlalchemy] Numeric type without scale? Oracle

2019-10-01 Thread jr
When the sqlalchemy Numeric type is used with default parameters, in an Oracle DB this generates the NUMBER type with empty precision but scale set to zero, which has the effect that only integer values can be saved. My goal is to use the Oracle NUMBER type with empty scale in order to