Ecto v2.2.12 Ecto.Adapters.SQL.Connection behaviour View Source
Specifies the behaviour to be implemented by all SQL connections.
Link to this section Summary
Callbacks
Receives a query and must return a SELECT query.
Receives options and returns DBConnection
supervisor child
specification.
Returns a DELETE for the filters
returning the given returning
.
Receives a query and must return a DELETE query.
Executes the given prepared query with DBConnection
.
Receives a DDL command and returns a query that executes it.
Returns an INSERT for the given rows
in table
returning
the given returning
.
Prepares and executes the given query with DBConnection
.
Returns a stream that prepares and executes the given query with
DBConnection
.
Receives the exception returned by query/4
.
Returns an UPDATE for the given fields
in table
filtered by
filters
returning the given returning
.
Receives a query and values to update and must return an UPDATE query.
Link to this section Types
cached()
View Source
cached() :: map()
cached() :: map()
The cache query which is a DBConnection Query
prepared()
View Source
prepared() :: String.t()
prepared() :: String.t()
The prepared query which is an SQL command
Link to this section Callbacks
all(query)
View Source
all(query :: Ecto.Query.t()) :: iodata()
all(query :: Ecto.Query.t()) :: iodata()
Receives a query and must return a SELECT query.
child_spec(options) View Source
Receives options and returns DBConnection
supervisor child
specification.
delete(prefix, table, filters, returning) View Source
Returns a DELETE for the filters
returning the given returning
.
delete_all(query)
View Source
delete_all(query :: Ecto.Query.t()) :: iodata()
delete_all(query :: Ecto.Query.t()) :: iodata()
Receives a query and must return a DELETE query.
execute(connection, prepared_query, params, options)
View Source
execute(
connection :: DBConnection.t(),
prepared_query :: prepared(),
params :: [term()],
options :: Keyword.t()
) :: {:ok, term()} | {:error, Exception.t()}
execute(
connection :: DBConnection.t(),
prepared_query :: cached(),
params :: [term()],
options :: Keyword.t()
) :: {:ok, term()} | {:error | :reset, Exception.t()}
execute( connection :: DBConnection.t(), prepared_query :: prepared(), params :: [term()], options :: Keyword.t() ) :: {:ok, term()} | {:error, Exception.t()}
execute( connection :: DBConnection.t(), prepared_query :: cached(), params :: [term()], options :: Keyword.t() ) :: {:ok, term()} | {:error | :reset, Exception.t()}
Executes the given prepared query with DBConnection
.
execute_ddl(command)
View Source
execute_ddl(command :: Ecto.Adapter.Migration.command()) ::
String.t() | [iodata()]
execute_ddl(command :: Ecto.Adapter.Migration.command()) :: String.t() | [iodata()]
Receives a DDL command and returns a query that executes it.
insert(prefix, table, header, rows, on_conflict, returning) View Source
Returns an INSERT for the given rows
in table
returning
the given returning
.
prepare_execute(connection, name, prepared, params, options)
View Source
prepare_execute(
connection :: DBConnection.t(),
name :: String.t(),
prepared(),
params :: [term()],
options :: Keyword.t()
) :: {:ok, query :: map(), term()} | {:error, Exception.t()}
prepare_execute( connection :: DBConnection.t(), name :: String.t(), prepared(), params :: [term()], options :: Keyword.t() ) :: {:ok, query :: map(), term()} | {:error, Exception.t()}
Prepares and executes the given query with DBConnection
.
stream(connection, prepared_query, params, options)
View Source
stream(
connection :: DBConnection.conn(),
prepared_query :: prepared(),
params :: [term()],
options :: Keyword.t()
) :: Enum.t()
stream( connection :: DBConnection.conn(), prepared_query :: prepared(), params :: [term()], options :: Keyword.t() ) :: Enum.t()
Returns a stream that prepares and executes the given query with
DBConnection
.
to_constraints(exception)
View Source
to_constraints(exception :: Exception.t()) :: Keyword.t()
to_constraints(exception :: Exception.t()) :: Keyword.t()
Receives the exception returned by query/4
.
The constraints are in the keyword list and must return the
constraint type, like :unique
, and the constraint name as
a string, for example:
[unique: "posts_title_index"]
Must return an empty list if the error does not come from any constraint.
update(prefix, table, fields, filters, returning) View Source
Returns an UPDATE for the given fields
in table
filtered by
filters
returning the given returning
.
update_all(query)
View Source
update_all(query :: Ecto.Query.t()) :: iodata()
update_all(query :: Ecto.Query.t()) :: iodata()
Receives a query and values to update and must return an UPDATE query.