On Monday, November 18, 2013 1:50:38 PM UTC-8, [email protected] wrote: > > New to Sequel so a pointer to "where to read" in the documentation is > actually better than an answer, I just can't figure out the answer. > > If I were speaking directly to, say MySQL, and my connection was to some > "database" ( to use the MySQL name ) called "readonly", and I wanted to > create a table in a different database on the same server instance, say > "dev", I could write the SQL > > CREATE TABLE dev.new_table .... > > My first guess at the Sequel equivalent: > > DB.create_table "dev.new_table" ... > > ended up trying to create a table called "dev.new_table" in > the readonly database > > Other than making a second Sequel connection object for the dev database, > is there a way to get what I want? >
You want to create a qualified identifier, and the easiest way to do that in Sequel is: DB.create_table :dev__new_table ... The double underscore notation for qualification is discussed in the README, as well as alternative ways to create them. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/groups/opt_out.
