zf

zenflows testing
git clone https://s.sonu.ch/~srfsh/zf.git
Log | Files | Refs | Submodules | README | LICENSE

20211111191749_fill_vf_scenario_definition.exs (1413B)

      1 # Zenflows is designed to implement the Valueflows vocabulary,
      2 # written and maintained by srfsh <info@dyne.org>.
      3 # Copyright (C) 2021-2023 Dyne.org foundation <foundation@dyne.org>.
      4 #
      5 # This program is free software: you can redistribute it and/or modify
      6 # it under the terms of the GNU Affero General Public License as published by
      7 # the Free Software Foundation, either version 3 of the License, or
      8 # (at your option) any later version.
      9 #
     10 # This program is distributed in the hope that it will be useful,
     11 # but WITHOUT ANY WARRANTY; without even the implied warranty of
     12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     13 # GNU Affero General Public License for more details.
     14 #
     15 # You should have received a copy of the GNU Affero General Public License
     16 # along with this program.  If not, see <https://www.gnu.org/licenses/>.
     17 
     18 defmodule Zenflows.DB.Repo.Migrations.Fill_vf_scenario_definition do
     19 use Ecto.Migration
     20 
     21 @check """
     22 (has_duration_unit_type IS NULL AND has_duration_numeric_duration IS NULL)
     23 OR
     24 (has_duration_unit_type IS NOT NULL AND has_duration_numeric_duration IS NOT NULL)
     25 """
     26 
     27 def change() do
     28 	alter table("vf_scenario_definition") do
     29 		add :name, :text, null: false
     30 		add :note, :text
     31 		add :has_duration_unit_type, :vf_time_unit
     32 		add :has_duration_numeric_duration, :decimal
     33 		timestamps()
     34 	end
     35 
     36 	create constraint("vf_scenario_definition", :has_duration, check: @check)
     37 end
     38 end