class Clear::SQL::InsertQuery

• Clear::SQL::InsertQuery
• Reference
• Object

Overview

An insert query

cf. postgres documentation

[ WITH [ RECURSIVE ] with_query [, ...] ]
INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ]
   { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
   [ ON CONFLICT [ conflict_target ] conflict_action ]
   [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

Included Modules

• Clear::SQL::Query::Change
• Clear::SQL::Query::Connection
• Clear::SQL::Query::CTE
• Clear::SQL::Query::OnConflict

Defined in:

Constructors

• .new(table : Symbol | String, values)
• .new(table : Symbol | String)

Instance Method Summary

• #clear_values
• #columns(*args)

  Used with values

• #execute(connection_name : String = "default") : Hash(String, Clear::SQL::Any)
• #fetch(connection_name : String = "default", &block : Hash(String, Clear::SQL::Any) -> Nil)
• #into(table : Symbol | String)
• #keys : Array(Symbolic)
• #returning : String?
• #returning(str : String)
• #size : Int32

  Number of rows of this insertion request

• #table : Symbol | String
• #table? : Symbol | String?
• #to_sql
• #values(*args)
• #values : SelectBuilder | Array(Array(Inserable))
• #values(select_query : SelectBuilder)

  Insert into ...

• #values(rows : Array(NamedTuple))
• #values(row : NamedTuple)

  Fast insert system

• #values(rows : Array(Hash(Symbolic, Inserable)))
• #values(row : Hash(Symbolic, Inserable))

Constructor Detail

Instance Method Detail