[sqlalchemy] Re: Portable Enum Columns

[Michael Bayer]

Yannick Gingras wrote:
 On October 6, 2009, Adrian von Bidder wrote:
   On Tuesday 06 October 2009 14.45:33 Yannick Gingras wrote:
 [...]
  Is there another way to do it?  Something that would be portable and
  to both MySQL and Postgres would be great.

 Since both pg and mysql hava a native enum type, it's only a matter of
 writing the appropriate code in the SQL dialects.

 I still use sqlite for tests but it would not be to hard to do
 without.  Still, having a solution that has a workaround for sqlite is
 always a plus.

 This came up just recently, search the list archive.  I can't remember
 if
 the answer last time was it would be quite easy to do or somebody is
 working on it, though.

 I simply can't find it.  Would you have a link or a few keywords that
 I could search for by any chance?

the ticket is here:

http://www.sqlalchemy.org/trac/ticket/1109

you'll see from the discussion the issue is not nearly so straightforward.




 --
 Yannick Gingras
 http://ygingras.net



--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---

[sqlalchemy] Re: Portable Enum Columns

[Yannick Gingras]

On October 7, 2009, Michael Bayer wrote:
 the ticket is here:
 
 http://www.sqlalchemy.org/trac/ticket/1109
 
 you'll see from the discussion the issue is not nearly so straightforward.

Right, looks like I should either go with PGEnum or stick to varchar
FKs if I need something that is portable.  Thanks for the info.

-- 
Yannick Gingras
http://ygingras.net


signature.asc
Description: This is a digitally signed message part.

[sqlalchemy] Re: Portable Enum Columns

[Adrian von Bidder]

On Tuesday 06 October 2009 14.45:33 Yannick Gingras wrote:
[...]
 Is there another way to do it?  Something that would be portable and
 to both MySQL and Postgres would be great.

Since both pg and mysql hava a native enum type, it's only a matter of 
writing the appropriate code in the SQL dialects.

This came up just recently, search the list archive.  I can't remember if 
the answer last time was it would be quite easy to do or somebody is 
working on it, though.

cheers
-- vbi

-- 
featured product: PostgreSQL - http://postgresql.org


signature.asc
Description: This is a digitally signed message part.