On Jan 5, 5:00 am, Paweł Kondzior <[email protected]> wrote: > Hello, > > Today on polish rails community channel somone asked about extended > insert functionality in sequel, is it available. Well i must see i > don't see anything giving such functionality inside documentation but > i thnik it is pretty simple in implementation, we just need to > override for example << method od Datase? (or dataset for each > adapter) > > This is example of uch functionality. > > require 'rubygems' > require 'sequel' > > DB = Sequel.sqlite # memory database > > DB.create_table :items do # Create a new table > primary_key :id > column :name, :text > column :price, :float > end > > items = DB[:items] # Create a dataset > > items << [{:name => 'abc', :price => rand * 100}, {:name => > 'def', :price => rand * 100}, {:name => 'ghi', :price => rand * 100}] > > This will produce sql: > "INSERT items (name, price) VALUES (('abc', 123), ('def', 123), ('ghi', > 123))" > > And i think is obvious for everybody that such sql query will be much > faster than regullary 3 single queries for every row. > > I seems that << only refers to insert_sql so we don't need to care > about any callbacks or typecast of defined schema ? > > I'm wondering what do you thnik about that Jeremy ?
Dataset#multi_insert already exists and does what you want. :) 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 -~----------~----~----~----~------~----~------~--~---
