Teemu Yli-Elsilä wrote: > > Hello, > > I read http://www.sqlalchemy.org/trac/wiki/06Migration and did not see a > mention of any changes to type mapping or casting. > > I am currently using 0.5.5. While developing an application I found that > generating tables from a declarative model resulted in undesirable / > incorrect column types, so I had to create the tables using a SQL script > directly.
the exact column types desired should always be available by using UPPERCASE types, and if that doesn't work then just creating custom types that do what you need as described in the documentation. > Also, percious had to add explicit casting into Sprox to make sure that > integer column values from the db were cast as ints, which is not needed > for PostgreSQL, MySQL or SQLite. While I don't know that chris ever posted trac tickets for these issues, my testing has shown that in almost all cases, cx_oracle returns an int. There were a few edge cases regarding RETURNING where it did not so there are adjustments in 0.6 for this. > > We have worked around these issues, but it just seems that the Oracle > adapter is not behaving like those of other databases. Is this intended > behaviour or a known issue? I really don't know since you havent provided any sample code to illustrate the behavior you are seeing. We do have unit tests which ensure the correct behavior. As I said I did identify some edge cases where cx_oracle doesn't convert to int but it is only when using OUT parameters. > > On a related note, I am afraid I am likely unable to contribute code to > SA myself. these are all small issues and all we need are succinct and definitive tests that illustrate the behaviors in question. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
