Cldr.Unit.DDL (Cldr Units SQL v0.3.0) View Source

Functions to return SQL DDL commands that support the creation and deletion of the cldr_unit database type and associated aggregate functions.

Link to this section Summary

Functions

Returns the SQL string which when executed will define the money_with_currency data type.

Returns the SQL string which when executed will define aggregate functions for the money_with_currency data type.

Returns the SQL string which when executed will drop the aggregate functions for the money_with_currency data type.

Returns the SQL string which when executed will drop the money_with_currency data type.

Returns a string that will Ecto execute a single SQL command.

Returns a string that will Ecto execute each SQL command.

Link to this section Functions

Link to this function

create_cldr_unit(db_type \\ :postgres)

View Source

Returns the SQL string which when executed will define the money_with_currency data type.

Arguments

  • db_type: the type of the database for which the SQL string should be returned. Defaults to :postgres which is currently the only supported database type.
Link to this function

define_aggregate_functions(db_type \\ :postgres)

View Source

Returns the SQL string which when executed will define aggregate functions for the money_with_currency data type.

Arguments

  • db_type: the type of the database for which the SQL string should be returned. Defaults to :postgres which is currently the only supported database type.
Link to this function

drop_aggregate_functions(db_type \\ :postgres)

View Source

Returns the SQL string which when executed will drop the aggregate functions for the money_with_currency data type.

Arguments

  • db_type: the type of the database for which the SQL string should be returned. Defaults to :postgres which is currently the only supported database type.
Link to this function

drop_cldr_unit(db_type \\ :postgres)

View Source

Returns the SQL string which when executed will drop the money_with_currency data type.

Arguments

  • db_type: the type of the database for which the SQL string should be returned. Defaults to :postgres which is currently the only supported database type.

Returns a string that will Ecto execute a single SQL command.

Arguments

  • sql is a single SQL command

Example

iex> Money.DDL.execute "SELECT name FROM customers;"
"execute "SELECT name FROM customers;""

Returns a string that will Ecto execute each SQL command.

Arguments

  • sql is a string of SQL commands that are separated by three newlines ("\n"), that is to say two blank lines between commands in the file.

Example

iex> Money.DDL.execute "SELECT name FROM customers;

SELECT id FROM orders;"

"execute """

SELECT name FROM customers;

SELECT id FROM orders; """"