Ruby: Sequel gem Insert to Mysql

Question

very new to ruby so any help is appreciated. I'm trying to use a different gem(Sequel) to insert data into a mysql database. The catch is, some of this data contains mysql special characters which is why i'm trying to use the other mysql driver Sequel as someone recommended to me.

Here's the error when i use the native mysql gem:

[user@server nessus-report-database]# ./testme.rb 949293931.nessus 
949293931.nessus
1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'backported' to the remote SSH server without changing its version number. 

Bann' at line 47

My main question is i'm not sure i understand the documentation for the Sequel gem which gives the following examples:

DB[:items].insert([1,2,3])
# INSERT INTO items VALUES (1, 2, 3)

The part that is throwing me off is DB[:items] . what is the [:items] portion? is this a variable that i would set the value of to my columns i want to update? And also does anyone know if this example above would escape special characters for mysql?

Documentation for this gem is here: http://sequel.jeremyevans.net/rdoc/classes/Sequel/Dataset.html#method-i-insert

mwp · Accepted Answer · 2015-11-23 17:55:31Z

1

:items is the table name. That's just Sequel's syntax for indicating which table you want to insert into.

answered Nov 23, 2015 at 17:55

mwp

8,57724 silver badges28 bronze badges

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

1 Comment

tadman Over a year ago

More specifically, :items is a symbol, like an internalized string constant, which is a common tool used with in Ruby. They are somewhat like singleton strings, as in all :x instances are exactly the same object but not all strings containing "x" are identical. Just equivalent.

Collectives™ on Stack Overflow

Ruby: Sequel gem Insert to Mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related