On Sep 22, 1:01 pm, GregD <[email protected]> wrote:
> Well, after doing a little research. Apparently, Sybase, Informix and
> Ingres support user defined data types (domains in sybase). So, I
> will then assume that no ruby ORM will support them and
> understandable. I guess I could still use migrations, but if I want
> to create or use user defined types (domains), I'll have to use the
> Sybase SQL syntax to do it defeating the purpose for an ORM. Maybe I
> could check the DB type in the migration code and for Sybase use SQL
> syntax and ruby for all others. Still, defeats the many reason for an
> ORM. I just love this app I'm working on and the use of Sybase. <-
> Sarcasm
PostgreSQL supports user defined types as well.
Anyway, in terms of migrations, you can just use the domain/type name
directly when creating columns:
create_table(:blah) do
money :dollars
height :h
locationId :l
id :i
zoneId :z
end
Creating your domains during migrations is probably going to require
custom SQL, but you can probably create a function that does that and
call it for each domain you want to create.
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
