Module: SqlTools

Defined in:

lib/sql_tools.rb,
lib/sql_tools/index.rb,
lib/sql_tools/query.rb,
lib/sql_tools/schema.rb,
lib/sql_tools/version.rb,
lib/sql_tools/relation.rb,
lib/sql_tools/left_join.rb,
lib/sql_tools/predicate.rb,
lib/sql_tools/selection.rb,
lib/sql_tools/constraint.rb,
lib/sql_tools/inner_join.rb,
lib/sql_tools/query_visitor.rb,
lib/sql_tools/schema_visitor.rb,
lib/sql_tools/predicate_filter.rb,
lib/sql_tools/column_definition.rb,
lib/sql_tools/predicate_visitor.rb,
lib/sql_tools/common_table_expression.rb

Defined Under Namespace

Modules: Selection Classes: ColumnDefinition, CommonTableExpression, Constraint, Error, Index, Predicate, PredicateFilter, PredicateVisitor, Query, QueryVisitor, Relation, Schema, SchemaVisitor

Constant Summary

Table =

Data.define(:name, :alias)

Column =

Data.define(:table, :name) do
  def to_s = "#{table.name}.#{name}"
  def inspect = to_s
end

VERSION =

"0.2.2"

LeftJoin =

Data.define(:object, :predicate)

InnerJoin =

Data.define(:object, :predicate)

Class Method Summary

• .parser ⇒ Object
• .query_from_sql(sql) ⇒ Object
• .query_from_tree(tree) ⇒ Object
• .schema_from_sql(sql) ⇒ Object
• .schema_from_tree(tree) ⇒ Object
• .tree_from_sql(sql) ⇒ Object

Class Method Details

.parser ⇒ Object

# File 'lib/sql_tools.rb', line 18

def parser = @parser ||= TreeStand::Parser.new("sql")

.query_from_sql(sql) ⇒ Object

# File 'lib/sql_tools.rb', line 15

def query_from_sql(sql) = query_from_tree(tree_from_sql(sql))

.query_from_tree(tree) ⇒ Object

# File 'lib/sql_tools.rb', line 16

def query_from_tree(tree) = SqlTools::QueryVisitor.new(tree.root_node).visit.query

.schema_from_sql(sql) ⇒ Object

# File 'lib/sql_tools.rb', line 13

def schema_from_sql(sql) = schema_from_tree(tree_from_sql(sql))

.schema_from_tree(tree) ⇒ Object

# File 'lib/sql_tools.rb', line 14

def schema_from_tree(tree) = SqlTools::SchemaVisitor.new(tree.root_node).visit.schema

.tree_from_sql(sql) ⇒ Object

# File 'lib/sql_tools.rb', line 17

def tree_from_sql(sql) = parser.parse_string(sql)