unepwcmc/SAPI — pull request #87 by agnessa (2013-10-15 16:25:23+00:00)
Title: Appendix species year

in shell console:
rake db:migrate

in rails console:
Trade::SpeciesNameAppendixYearValidationRule.create(
:column_names => ['species_name', 'appendix', 'year'],
:valid_values_view => 'valid_species_name_appendix_year_mview',
:run_order => 4,
:is_primary => false
)

in db console:
SELECT * FROM valid_species_name_appendix_year_mview()

The "valid_species_name_appendix_year_mview" calculation is appended at the end of the Sapi.rebuild task (because it depends on listing_changes_mview)