Insert Into DB using Sequel

Question

I want to insert some data into a Postgres DB using Sequel. I have pursued two approaches, none has yielded the results I want.

My first approach was "Querying in Sequel":

connection = Sequel.connect('postgres://admin:admin@localhost:5432/test_tcp')    
insert_values = connection["INSERT INTO cards (:card_number, :phone_number, :uuid, :created_at, :updated_at) VALUES (?)", '766877868', '256700000000', '9043', '2016-09-07 11:11:31 +0300', '2016-09-07 11:11:31 +0300']
insert_values.insert
connection.close

My second approach was "Inserting Records":

connection = Sequel.connect('postgres://admin:admin@localhost:5432/test_tcp')
cards = connection.from(:cards)
cards.insert(:id => 1, :card_number => "13668389", :phone_number => "256700000000", :uuid => "9014", :created_at => '2016-09-07 11:11:31 +0300', :updated_at => '2016-09-07 11:11:31 +0300')
connection.close

I expected to insert the data into the DB. I check for evidence of the insert by querying the DB separately. The insert didn't happen — Esseme
– Esseme, Commented Sep 8, 2016 at 7:58

the Tin Man · Accepted Answer · 2016-10-06 00:55:58Z

1

Simply following the code below worked for me:

connection = Sequel.connect('postgres://admin:admin@localhost:5432/test_tcp')
cards = connection.from(:cards)
cards.insert(id: 1, card_number: "13668389", phone_number: "256700000000", uuid: "9014", created_at: '2016-09-07 11:11:31', updated_at: '2016-09-07 11:11:31')
connection.close

Changing the values for :created_at and :updated_at to store time stamps without time zones did the trick.

It is weird how Sequel wouldn't output an error to warn about this.

edited Oct 6, 2016 at 0:55

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered Sep 13, 2016 at 11:32

Esseme

1791 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert Into DB using Sequel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related