On Monday, July 16, 2012 2:24:49 PM UTC-7, Jason Hines wrote: > > I think I may have answered my own question. See below. > > class Rule < Sequel::Model(:nm_requests) > > self.dataset = self.dataset.sequence(:seq_nm_req_id) > > > With the above, I should be able to use automatic sequences in Sequel even > when the sequences/triggers are created externally and with custom naming. > Am I on track? >
Correct. If you can't use autosequence, then you have to set the sequence manually for each model/dataset that uses surrogate keys. I'll definitely accept patches that would allow the shared oracle adapter to introspect the database to determine the appropriate sequence, similar to what the shared postgres adapter does. However, this isn't something I plan to work on myself, at least unless someone points me to the relevant documentation/examples showing the appropriate SQL. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/j4JW-vKQLfgJ. 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.
