Cldr Units SQL
Cldr Units SQL
v1.0.1

View Source Cldr.Unit.DDL (Cldr Units SQL v1.0.1)

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

Summary

Functions

create_cldr_unit(db_type \\ :postgres)

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

define_aggregate_functions(db_type \\ :postgres)

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

drop_aggregate_functions(db_type \\ :postgres)

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

drop_cldr_unit(db_type \\ :postgres)

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

execute(sql)

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

execute_each(sql)

Returns a string that will Ecto execute each SQL command.

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.
Link to this function

execute(sql)

View Source

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;""
Link to this function

execute_each(sql)

View Source

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; """"