class DuckDB::PreparedStatement
def bind_args(*args, **kwargs)
# or
stmt.bind_args([1])
stmt = PreparedStatement.new(con, sql)
# sql ='SELECT name FROM users WHERE id = $id'
# or
sql ='SELECT name FROM users WHERE id = ?'
con = db.connect
db = DuckDB::Database.open('duckdb_database')
require 'duckdb'
binds all parameters with SQL prepared statement.
def bind_args(*args, **kwargs) args.each.with_index(1) do |arg, i| bind(i, arg) end kwargs.each do |key, value| bind(key, value) end end