@spec create_all() :: :ok

Adds raw SQL queries to a migration for creating the database types, associated functions, casts, operators, and operator families.

Safe to run multiple times when new functionality is added in updates to this library. Existing values will be skipped.

types-created

Types Created

Calling this macro creates the following type definitions:

CREATE TYPE framerate_tags AS ENUM (
  'drop',
  'non_drop'
);

CREATE TYPE framerate AS (
  playback rational,
  tags framerate_tags[]
);

schemas-created

Schemas Created

Up to two schemas are created as detailed by the Configuring Database Objects section below.

configuring-database-objects

Configuring Database Objects

To change where supporting functions are created, add the following to your Repo confiugration:

config :vtc, Vtc.Test.Support.Repo,
  adapter: Ecto.Adapters.Postgres,
  ...
  vtc: [
    pg_framerate: [
      functions_schema: :framerate,
      functions_private_schema: :framerate_private,
      functions_prefix: "framerate"
    ]
  ]

Option definitions are as follows:

• functions_schema: The schema for "public" functions that will have backwards compatibility guarantees and application code support. Default: :public.

• functions_private_schema: The schema for for developer-only "private" functions that support the functions in the "framerate" schema. Will NOT have backwards compatibility guarantees NOR application code support. Default: :public.

• functions_prefix: A prefix to add before all functions. Defaults to "framerate" for any function created in the "public" schema, and "" otherwise.

examples

Examples

defmodule MyMigration do
  use Ecto.Migration

  alias Vtc.Ecto.Postgres.PgFramerate
  require PgFramerate.Migrations

  def change do
    PgFramerate.Migrations.create_all()
  end
end