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
GregD On Sep 22, 1:05 pm, GregD <[email protected]> wrote: > Hey, > > I have an Sybase DB for an existing application and using sequel with > a JDBC hack adapter to test stored procedures and some java > interfaces. I have just started to scratch the surface of the app, > but wanted to look at using migrations to create the schema. And > since I have already started to make Sequel::Models, I'd like to look > at going to ruby for the app itself. The DB schema uses a lot of > Sybase domains to define table column types. For example, they have > made domains like say money as a numeric(19,2) or height as > numeric(10,3) or like locatonId as varchar(30), id as varchar(40), or > zoneId as vachar(10). They use a lot of these data type domain > definitions. Is there a way to use these domains in migrations or > even to create these domains during migrations? Or is this strictly > a Sybase thing and there are no Sequel/ruby hooks/mappings to these > Sybase domains? I've never defined these in MySql or Sqlite before > and not even sure if such "domains" exist outside of Sybase. > > Thanks, > > GregD -- 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.
