Packages

lotus

0.5.0
0.16.6 0.16.5 0.16.4 0.16.3 0.16.2 0.16.1 0.16.0 0.15.0 0.14.0 0.13.1 0.13.0 0.12.0 0.11.0 0.10.0 0.9.2 0.9.1 0.9.0 0.8.0 0.7.0 0.6.0 0.5.4 0.5.3 0.5.2 0.5.1 0.5.0 0.4.0 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.0

Embeddable business intelligence engine for Elixir — run SQL queries, build dashboards, and manage analytics directly in your Phoenix app with Ecto.

HexDocs

Current section

Files

Jump to
Readme
32 Versions
7 Dependencies
Dependants
Files
Activity
lotus lib lotus migrations sqlite.ex
Raw

lib/lotus/migrations/sqlite.ex 

defmodule Lotus.Migrations.SQLite do

  @moduledoc false



  @behaviour Lotus.Migration



  use Ecto.Migration



  @impl Lotus.Migration

  def up(_opts \\ []) do

    create_if_not_exists table(:lotus_queries, primary_key: false) do

      add(:id, :serial, primary_key: true)

      add(:name, :string, null: false)

      add(:description, :text)

      add(:statement, :text, null: false)

      add(:variables, :map, null: false, default: "[]")

      add(:data_repo, :string)

      add(:search_path, :string)

      timestamps(type: :utc_datetime_usec)

    end



    create_if_not_exists(unique_index(:lotus_queries, [:name], name: "lotus_queries_name_index"))



    :ok

  end



  @impl Lotus.Migration

  def down(_opts \\ []) do

    drop_if_exists(index(:lotus_queries, [:name], name: "lotus_queries_name_index"))

    drop_if_exists(table(:lotus_queries))



    :ok

  end



  @impl Lotus.Migration

  def migrated_version(_opts), do: 0

end