Class: Boxcars::SQLSequel

Inherits:

SQLBase

• Object
• Boxcar
• EngineBoxcar
• SQLBase
• Boxcars::SQLSequel

Defined in:

lib/boxcars/boxcar/sql_sequel.rb

Overview

A Boxcar that interprets a prompt and executes Sequel SQL code to get answers

Constant Summary

Constants inherited from SQLBase

Boxcars::SQLBase::CTEMPLATE, Boxcars::SQLBase::LOCKED_OUT_TABLES, Boxcars::SQLBase::SQLDESC, Boxcars::SQLBase::WRITE_SQL_KEYWORDS

Constants inherited from Boxcar

Boxcar::SCHEMA_KEY_ALIASES, Boxcar::TYPE_ALIASES

Instance Attribute Summary

Attributes inherited from SQLBase

#approval_callback, #connection, #context, #read_only, #the_tables

Attributes inherited from EngineBoxcar

#engine, #prompt, #stop, #top_k

Attributes inherited from Boxcar

#description, #name, #parameters, #return_direct

Instance Method Summary

• #initialize(connection: nil, tables: nil, except_tables: nil, **kwargs) ⇒ SQLSequel constructor

  A new instance of SQLSequel.

Methods inherited from SQLBase

#prediction_additional, #read_only?

Methods inherited from EngineBoxcar

#apply, #call, #extract_code, #generate, #input_keys, #output_key, #output_keys, #predict, #prediction_additional, #prediction_variables

Methods inherited from Boxcar

#apply, assi, #call, #conduct, #conduct_result, hist, #input_keys, #output_keys, #parameters_json_schema, #run, #run_result, #schema, syst, #tool_call_name, #tool_definition, #tool_spec, user, #validate_inputs, #validate_outputs

Constructor Details

#initialize(connection: nil, tables: nil, except_tables: nil, **kwargs) ⇒ SQLSequel

Returns a new instance of SQLSequel.

Parameters:

• connection (SEQUEL Database object) (defaults to: nil) —

  The Sequel connection to use for this boxcar.

• tables (Array<String>) (defaults to: nil) —

  The tables to use for this boxcar. Will use all if nil.

• except_tables (Array<String>) (defaults to: nil) —

  The tables to exclude from this boxcar. Will exclude none if nil.

• kwargs (Hash) —

  Any other keyword arguments to pass to the parent class. This can include :name, :description, :prompt, :top_k, :stop, and :engine

# File 'lib/boxcars/boxcar/sql_sequel.rb', line 12

def initialize(connection: nil, tables: nil, except_tables: nil, **kwargs)
  Boxcars::OptionalDependency.require!("sequel", feature: "Boxcars::SQLSequel")
  super
end