Contents

require File.expand_path("../example_setup", __FILE__)
require "github/sql"

GitHub::SQL.run <<-SQL
  INSERT INTO example_key_values (`key`, `value`)
  VALUES ("foo", "bar"), ("baz", "wick")
SQL

sql = GitHub::SQL.new "SELECT `VALUE` FROM example_key_values"

key = ENV["KEY"]
unless key.nil?
  sql.add "WHERE `key` = :key", key: key
end

limit = ENV["LIMIT"]
unless limit.nil?
  sql.add "ORDER BY `key` ASC"
  sql.add "LIMIT :limit", limit: limit.to_i
end

p sql.results

# Only select value for key = foo
# $ env KEY=foo bundle exec ruby examples/sql_add.rb
# [["bar"]]
#
# Only select value for key = bar
# $ env KEY=bar bundle exec ruby examples/sql_add.rb
# []
#
# Only select value for key = baz
# $ env KEY=baz bundle exec ruby examples/sql_add.rb
# [["wick"]]
#
# Select all values
# $ bundle exec ruby examples/sql_add.rb
# [["bar"], ["wick"]]
#
# Select only 1 key.
# $ env LIMIT=1 bundle exec ruby examples/sql_add.rb
# [["wick"]]

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
github-ds-0.1.0	examples/sql_add.rb