thatsanicehatyouh...@mac.com wrote: > > Hello, > > > On 12 Oct 2009, at 21:04, Michael Bayer wrote: > >> On Oct 12, 2009, at 4:26 PM, thatsanicehatyouh...@mac.com wrote: >> >>> Hello, >>> >>> I have a custom type defined in my postgresql database, and this is >>> giving me the warning: >>> >>> /Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site- >>> packages/sqlalchemy/engine/base.py:1265: SAWarning: Did not recognize >>> type 'fibertype' of column 'fiber_type' >>> self.dialect.reflecttable(conn, table, include_columns) >>> >>> From an earlier email from Michael (13 September 2009), I saw that I >>> can do something like this: >>> >>> sa_major_version = sqlalchemy.__version__[0:3] >>> >>> if sa_major_version == "0.5": >>> from sqlalchemy.databases import postgres >>> postgres.ischema_names['fiber_type'] = fibertype >>> elif sa_major_version == "0.6": >>> from sqlalchemy.dialects.postgresql import base as pg >>> pg.ischema_names['fiber_type'] = fibertype >>> >>> >>> But of course "fibertype" needs to be defined. How can I define this? >>> The definition in the database is simply: >>> >>> CREATE TYPE fibertype AS ENUM ( >>> 'A', >>> 'B', >>> 'C' >>> ); >> >> >> what happens if you put "fibertype": FiberType in the dictionary as >> well ? all its doing is looking in there for something to use. > > > I'm not sure what you mean here. I take this to mean: > > postgres.ischema_names['fibertype'] = FiberType > > but in either case, the value of the dictionary here is undefined. > That's the thing I'm unsure of how it's to be defined. Do you mean > that it should simply be any value, e.g. > > postgres.ischema_names['fibertype'] = "FiberType"
ah no it should be either a default type like String or a custom type like a TypeEngine or TypeDecorator subclass of your design. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---