clj-liquibase.change — clj-liquibase 0.6.0

Clojure wrappers for liquibase.change.Change implementations. See also: http://www.liquibase.org/documentation/changes/home (Available Database Refactorings)

*schema* clj

Fallback schema-name - used only if not nil

add-auto-increment clj

(add-auto-increment table-name
                    column-name
                    column-data-type
                    &
                    {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that converts an existing column to be an auto-increment column (AddAutoIncrementChange). See also: http://www.liquibase.org/documentation/changes/add_auto_increment

add-columns clj

(add-columns table-name
             columns
             &
             {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that adds columns to an existing table (AddColumnChange). See also: http://www.liquibase.org/documentation/changes/add_column http://www.liquibase.org/documentation/column

add-default-value clj

(add-default-value table-name
                   column-name
                   default-value
                   &
                   {:keys [catalog-name catalog schema-name schema
                           column-data-type data-type]
                    :as opt})

Return a Change instance that adds a default value to the database definition for the specified column (AddDefaultValueChange). See also: http://www.liquibase.org/documentation/changes/add_default_value

add-foreign-key-constraint clj

(add-foreign-key-constraint constraint-name
                            base-table-name
                            base-column-names
                            referenced-table-name
                            referenced-column-names
                            &
                            {:keys [base-table-schema-name base-schema
                                    referenced-table-schema-name ref-schema
                                    deferrable defer initially-deferred idefer
                                    on-delete ondel on-update onupd]
                             :as opt})

Return a Change instance that adds a foreign key constraint to an existing column (AddForeignKeyConstraintChange). See also: http://www.liquibase.org/documentation/changes/add_foreign_key_constraint

add-lookup-table clj

(add-lookup-table existing-table-name
                  existing-column-name
                  new-table-name
                  new-column-name
                  constraint-name
                  &
                  {:keys [existing-table-schema-name existing-schema
                          new-table-schema-name new-schema new-column-data-type
                          new-data-type]
                   :as opt})

Return a Change instance that adds a lookup table (AddLookupTableChange). See also: http://www.liquibase.org/documentation/changes/add_lookup_table

add-not-null-constraint clj

(add-not-null-constraint table-name
                         column-name
                         column-data-type
                         &
                         {:keys [catalog-name catalog schema-name schema
                                 default-null-value default]
                          :as opt})

Return a Change instance that adds a NOT NULL constraint (AddNotNullConstraintChange). See also: http://www.liquibase.org/documentation/changes/add_not_null_constraint

add-primary-key clj

(add-primary-key
  table-name
  column-names
  constraint-name
  &
  {:keys [catalog-name catalog schema-name schema table-space tspace] :as opt})

Return a Change instance that adds creates a primary key out of an existing column or set of columns (AddPrimaryKeyChange). See also: http://www.liquibase.org/documentation/changes/add_primary_key_constraint

add-unique-constraint clj

(add-unique-constraint table-name
                       column-names
                       constraint-name
                       &
                       {:keys [catalog-name catalog schema-name schema
                               table-space tspace deferrable defer
                               initially-deferred idefer disabled]
                        :as opt})

Return a Change instance that adds a UNIQUE constraint (AddUniqueConstraintChange). See also: http://www.liquibase.org/documentation/changes/add_unique_constraint

alter-sequence clj

(alter-sequence seq-name
                increment-by
                &
                {:keys [catalog-name catalog schema-name schema max-value max
                        min-value min ordered ord]
                 :as opt})

Return a Change instance that alters a seuqence (AlterSequenceChange). See also: http://www.liquibase.org/documentation/changes/alter_sequence

create-index clj

(create-index table-name
              column-names
              &
              {:keys [catalog-name catalog schema-name schema index-name index
                      unique uniq table-space tspace]
               :as opt})

Return a Change instance that creates an index on an existing column or set of columns (CreateIndexChange). See also: http://www.liquibase.org/documentation/changes/create_index

create-sequence clj

(create-sequence sequence-name
                 &
                 {:keys [catalog-name catalog schema-name schema start-value
                         start increment-by incby max-value max min-value min
                         ordered ord cycle cyc]
                  :as opt})

Return a Change instance that creates a sequence (CreateSequenceChange). See also: http://www.liquibase.org/documentation/changes/create_sequence

create-stored-procedure clj

(create-stored-procedure procedure-body & {:keys [comments] :as opt})

Return a Change instance that creates a stored procedure (CreateProcedureChange). See also: http://www.liquibase.org/documentation/changes/create_stored_procedure

create-table clj

(create-table table-name
              columns
              &
              {:keys [catalog-name catalog schema-name schema table-space tspace
                      remarks]
               :as opt})

Return a Change instance that creates a table (CreateTableChange). See also: http://www.liquibase.org/documentation/changes/create_table http://www.liquibase.org/documentation/column

create-table-withid clj

(create-table-withid table-name columns & args)

Same as create-table, but includes an additional auto-generated primary key column. The primary key column is named <table-name>_id unless overriden with optional argument :idcol and ID column-name as the value. E.g. if the table name is :sample or "sample", then primary key will be "sample_id". See also: create-table

create-view clj

(create-view view-name
             select-query
             &
             {:keys [catalog-name catalog schema-name schema replace-if-exists
                     replace]
              :as opt})

Return a Change instance that creates a view (CreateViewChange). See also: http://www.liquibase.org/documentation/changes/create_view

dbfn clj

(dbfn value)

delete-data clj

(delete-data table-name
             &
             {:keys [catalog-name catalog schema-name schema where-clause where]
              :as opt})

Return a Change instance that deletes data from an existing table (DeleteDataChange). See also: http://www.liquibase.org/documentation/changes/delete_data

drop-column clj

(drop-column table-name
             column-name
             &
             {:keys [catalog-name catalog schema-name schema] :as opt})

Return Change instance that drops a column from an existing table (DropColumnChange). See also: http://www.liquibase.org/documentation/changes/drop_column

drop-default-value clj

(drop-default-value table-name
                    column-name
                    &
                    {:keys [catalog-name catalog schema-name schema
                            column-data-type data-type]
                     :as opt})

Return a Change instance that removes a database default value for a column (DropDefaultValueChange). See also: http://www.liquibase.org/documentation/changes/drop_default_value

drop-foreign-key-constraint clj

(drop-foreign-key-constraint constraint-name
                             base-table-name
                             &
                             {:keys [catalog-name catalog schema-name schema]
                              :as opt})

Return a Change instance that drops an existing foreign key (DropForeignKeyConstraintChange). See also: http://www.liquibase.org/documentation/changes/drop_foreign_key_constraint

drop-index clj

(drop-index index-name
            table-name
            &
            {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that drops an existing index (DropIndexChange). See also: http://www.liquibase.org/documentation/changes/drop_index

drop-not-null-constraint clj

(drop-not-null-constraint table-name
                          column-name
                          &
                          {:keys [catalog-name catalog schema-name schema
                                  column-data-type data-type]
                           :as opt})

Return a Change instance that drops a NOT NULL constraint (DropNotNullConstraintChange). See also: http://www.liquibase.org/documentation/changes/drop_not_null_constraint

drop-primary-key clj

(drop-primary-key table-name
                  &
                  {:keys [catalog-name catalog schema-name schema
                          constraint-name constr]
                   :as opt})

Return a Change instance that drops an existing primary key (DropPrimaryKeyChange). See also: http://www.liquibase.org/documentation/changes/drop_primary_key_constraint

drop-sequence clj

(drop-sequence sequence-name
               &
               {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that drops a sequence (DropSequenceChange). See also: http://www.liquibase.org/documentation/changes/drop_sequence

drop-table clj

(drop-table table-name
            &
            {:keys [catalog-name catalog schema-name schema cascade-constraints
                    cascade]
             :as opt})

Return a Change instance that drops a table (DropTableChange). See also: http://www.liquibase.org/documentation/changes/drop_table

drop-unique-constraint clj

(drop-unique-constraint table-name
                        constraint-name
                        &
                        {:keys [catalog-name catalog schema-name schema]
                         :as opt})

Return a Change instance that drops a UNIQUE constraint (DropUniqueConstraintChange). See also: http://www.liquibase.org/documentation/changes/drop_unique_constraint

drop-view clj

(drop-view view-name
           &
           {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that drops a view (DropViewChange). See also: http://www.liquibase.org/documentation/changes/drop_view

insert-data clj

(insert-data table-name
             column-value-map
             &
             {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that inserts data into an existing table (InsertDataChange). See also: http://www.liquibase.org/documentation/changes/insert_data

iso-date clj

(iso-date date-str)

Parse date from ISO-date-format string.

load-data clj

(load-data table-name
           csv-filename
           columns-spec
           &
           {:keys [catalog-name catalog schema-name schema encoding enc]
            :as opt})

Return a Change instance that Loads data from a CSV file into an existing table (LoadDataChange). A value of NULL in a cell will be converted to a database NULL rather than the string NULL. Arguments: table-name (keyword/String) table name csv-filename (String) CSV file name columns-spec (map) key => name, value => type (:string :numeric :date :boolean) (coll) list of lists, each list is a col spec Optional arguments: :schema (keyword/String) schema name - defaults to the default schema :encoding (String) encoding of the CSV file - defaults to UTF-8 See also: http://www.liquibase.org/documentation/changes/load_data

load-update-data clj

(load-update-data table-name
                  csv-filename
                  primary-key-cols
                  columns-spec
                  &
                  {:keys [catalog-name catalog schema-name schema encoding enc]
                   :as opt})

Return a Change instance that loads or updates data from a CSV file into an existing table (LoadUpdateDataChange). Differs from loadData by issuing a SQL batch that checks for the existence of a record. If found, the record is UPDATEd, else the record is INSERTed. Also, generates DELETE statements for a rollback. A value of NULL in a cell will be converted to a database NULL rather than the string NULL. Arguments: table-name (keyword/String) table name csv-filename (String) CSV file name primary-key-cols (String) Comma delimited list of the columns for the primary key columns-spec (map) key => name, value => type (:string :numeric :date :boolean) (coll) list of lists, each list is a col spec Optional arguments: :schema (keyword/String) schema name - defaults to the default schema :encoding (String) encoding of the CSV file - defaults to UTF-8 See also: http://www.liquibase.org/documentation/changes/load_update_data

merge-columns clj

(merge-columns table-name
               column1-name
               join-string
               column2-name
               final-column-name
               final-column-type
               &
               {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that merges columns (MergeColumnChange). See also: http://www.liquibase.org/documentation/changes/merge_columns

modify-column clj

(modify-column table-name
               column-name
               new-data-type
               &
               {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that modifies data type of a column in an existing table (ModifyDataTypeChange). See also: http://www.liquibase.org/documentation/changes/modify_column

rename-column clj

(rename-column table-name
               old-column-name
               new-column-name
               &
               {:keys [catalog-name catalog schema-name schema column-data-type
                       data-type]
                :as opt})

Return a Change instance that renames a column in an existing table (RenameColumnChange). See also: http://www.liquibase.org/documentation/changes/rename_column

rename-table clj

(rename-table old-table-name
              new-table-name
              &
              {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that renames a table (RenameTableChange). See also: http://www.liquibase.org/documentation/changes/rename_table

rename-view clj

(rename-view old-view-name
             new-view-name
             &
             {:keys [catalog-name catalog schema-name schema] :as opt})

Return a Change instance that renames a view (RenameViewChange). See also: http://www.liquibase.org/documentation/changes/rename_view

sql clj

(sql sql
     &
     {:keys [comment dbms end-delimiter split-statements strip-comments]
      :as opt})

Return a Change instance that executes arbitrary SQL (RawSQLChange). May be useful when desired change types don't exist, or are buggy/inflexible. See also: http://www.liquibase.org/documentation/changes/sql

sql-file clj

(sql-file sql-filepath
          &
          {:keys [dbms encoding end-delimiter split-statements strip-comments]
           :as opt})

Return a Change instance that executes SQL after reading it from a file (SQLFileChange). Useful to integrate with legacy projects having SQL files for DDL, or to decouple DDL from the project in general. See also: http://www.liquibase.org/documentation/changes/sql_file

stop clj

(stop)

(stop message)

Return a Change instance that stops LiquiBase execution with a message (StopChange). Mainly useful for debugging and stepping through a changelog. See also: http://www.liquibase.org/documentation/changes/stop

tag-database clj

(tag-database tag)

Return a Change instance that applies a tag to the database for future rollback (TagDatabaseChange). See also: http://www.liquibase.org/documentation/changes/tag_database

update-data clj

(update-data table-name
             column-name-value-map
             &
             {:keys [catalog-name catalog schema-name schema where-clause where]
              :as opt})

Return a Change instance that updates data in an existing table (UpdateDataChange). See also: http://www.liquibase.org/documentation/changes/update_data