daru

https://github.com/sciruby/daru

Ruby

Data Analysis in RUby

Daru::DataFrame#write_sql

Insert each case of the Dataset on the selected table

== Arguments

* dbh - DBI database connection object.
* query - Query string.

== Usage

 ds = Daru::DataFrame.new({:id=>Daru::Vector.new([1,2,3]), :name=>Daru::Vector.new(["a","b","c"])})
 dbh = DBI.connect("DBI:Mysql:database:localhost", "user", "password")
 ds.write_sql(dbh,"test")

Source | Google | Stack overflow

Edit

git clone [email protected]:sciruby/daru.git
cd daru
open lib/daru/dataframe.rb

Contribute

# Make a new branch

git checkout -b -your-name--update-docs-Daru--DataFrame-write_sql-for-pr

# Commit to git

git add lib/daru/dataframe.rbgit commit -m "better docs for Daru::DataFrame#write_sql"

# Open pull request

gem install hub # on a mac you can `brew install hub`

hub fork

git push <your name> -your-name--update-docs-Daru--DataFrame-write_sql-for-pr

hub pull-request

# Celebrate!