Packages

moebius

1.0.3
4.2.0 4.1.1 4.0.2 4.0.1 3.0.1 3.0.0 2.0.3 2.0.2 2.0.1 2.0.0 1.0.8 1.0.7 1.0.6 1.0.5 1.0.4 1.0.3 1.0.2 1.0.1 1.0.0 0.1.0 0.0.1

A functional approach to data access with Elixir

HexDocs

Current section

Files

Jump to
Readme
21 Versions
5 Dependencies
Dependants
Files
Activity
moebius lib mix tasks create_document_table.ex
Raw

lib/mix/tasks/create_document_table.ex 

defmodule Mix.Tasks.Moebius.CreateDocumentTable do



  use Mix.Task

  import Moebius.Query



  def run(args) do

    Application.ensure_all_started(:moebius)



    table_name = List.first(args)



    """

        create table #{table_name}(

          id serial primary key not null,

          body jsonb not null,

          search tsvector,

          created_at timestamptz not null default now(),

          updated_at timestamptz

        );

    """

      |> Moebius.Query.run



    "create index idx_#{table_name}_search on #{table_name} using GIN(search);" |> Moebius.Query.run

    "create index idx_#{table_name} on #{table_name} using GIN(body jsonb_path_ops);" |> Moebius.Query.run



    IO.puts "Created table #{table_name}"

  end



end