On Sunday, April 8, 2018 at 5:05:39 PM UTC-7, Greg Gilbert wrote:
> Hey,
> Following up on my last message (which I closed myself), I'm looking to 
> create a class that extends Sequel::Model and uses the schema in a 
> connection.
> Here's an example:
> MyDB = Sequel.connect(
>               adapter:  'postgres', 
>               host:     ENV['MYDB_HOST'], 
>               port:     ENV['MYDB_PORT'], 
>               database: ENV['MYDB_DATABASE'],
>               user:     ENV['MYDB_USERNAME'],
>               password: ENV['MYDB_PASSWORD']
>             )
> Then, when trying to define the class using that connection:
>   class Account < Sequel::Model(MyDB[:foo][:account])
> This doesn't work. This does, however:
>   class Account < Sequel::Model(Sequel[:foo][:account])
> It seems dangerous to not specify the connection to use. Is there a way to 
> do this to ensure that the data is correct?

You first example doesn't work because ,MyDB[:foo] returns a dataset 
(SELECT * FROM foo), so your code Dataset#[], which issues a query to the 
database (SELECT * FROM foo WHERE account LIMIT 1) and returns the first 
row.  Your second example is correct but doesn't specify a database to use, 
so Sequel::Model.db will be used by default, and the default for that is 
the first Database instance created (first entry in Sequel::DATABASES).  
You probably want:

  class Account < Sequel::Model(MyDB[Sequel[:foo][:account]]); end
  # or:
  class Account < Sequel::Model(MyDB.from{foo[:account]}); end


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 sequel-talk+unsubscr...@googlegroups.com.
To post to this group, send email to sequel-talk@googlegroups.com.
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.

Reply via email to