Database Plugin - Macros

• Execute SQL and SQL script
  • # EXECUTE_SQL {file} ON {database} AS {result}
  • # EXECUTE_SQL_SCRIPT {file} ON {database} AS {result} WITH ENCODING {encoding} AND DELIMITER {delimiter}
  • #EXECUTE_SQL_SCRIPT_BY_REMOVING_SEPARATOR {file} ON {database} AS {result}
• Insert DbUnit
  • # INSERT_DBUNIT {dataset} INTO {database}
  • # INSERT_DBUNIT {dataset} INTO {database} WITH CONFIG {config}
  • # INSERT_DBUNIT {dataset} INTO {database} USING {ppkfilter}
  • # INSERT_DBUNIT {dataset} INTO {database} WITH CONFIG {config} USING {ppkfilter}
• Delete DbUnit
  • # DELETE_DBUNIT {dataset} FROM {database}
  • # DELETE_DBUNIT {dataset} FROM {database} WITH CONFIG {config}
  • # DELETE_DBUNIT {dataset} FROM {database} USING {ppkfilter}
  • # DELETE_ALL_DBUNIT {dataset} FROM {database}
  • # DELETE_ALL_DBUNIT {dataset} FROM {database} WITH CONFIG {config}
• Refresh DbUnit
  • # REFRESH_DBUNIT {dataset} INTO {database}
  • # REFRESH_DBUNIT {dataset} INTO {database} WITH CONFIG {config}
  • # REFRESH_DBUNIT {dataset} INTO {database} USING {ppkfilter}
  • # REFRESH_DBUNIT {dataset} INTO {database} WITH CONFIG {config} USING {ppkfilter}
• Update DbUnit
  • # UPDATE_DBUNIT {dataset} INTO {database}
  • # UPDATE_DBUNIT {dataset} INTO {database} WITH CONFIG {config}
  • # UPDATE_DBUNIT {dataset} INTO {database} USING {ppkfilter}
  • # UPDATE_DBUNIT {dataset} INTO {database} WITH CONFIG {config} USING {ppkfilter}
• Assert DbUnit
  • # ASSERT_DBUNIT TARGET {database} CONTAINS {dataset}
  • # ASSERT_DBUNIT TARGET {database} CONTAINS {dataset} WITH CONFIG {config}
  • # ASSERT_DBUNIT TARGET {database} CONTAINS {dataset} WITH FILTER {filter}
  • # ASSERT_DBUNIT TARGET {database} CONTAINS {dataset} WITH CONFIG {config} AND FILTER {filter}
  • # ASSERT_DBUNIT TARGET {database} EQUALS {dataset}
  • # ASSERT_DBUNIT TARGET {database} EQUALS {dataset} WITH CONFIG {config}
  • # ASSERT_DBUNIT TARGET {database} EQUALS {dataset} WITH FILTER {filter}
  • # ASSERT_DBUNIT TARGET {database} EQUALS {dataset} WITH CONFIG {config} AND FILTER {filter}
• Verify DbUnit
  • # VERIFY_DBUNIT TARGET {database} CONTAINS {dataset}
  • # VERIFY_DBUNIT TARGET {database} CONTAINS {dataset} WITH CONFIG {config}
  • # VERIFY_DBUNIT TARGET {database} CONTAINS {dataset} WITH FILTER {filter}
  • # VERIFY_DBUNIT TARGET {database} CONTAINS {dataset} WITH CONFIG {config} AND FILTER {filter}
  • # VERIFY_DBUNIT TARGET {database} EQUALS {dataset}
  • # VERIFY_DBUNIT TARGET {database} EQUALS {dataset} WITH CONFIG {config}
  • # VERIFY_DBUNIT TARGET {database} EQUALS {dataset} WITH FILTER {filter}
  • # VERIFY_DBUNIT TARGET {database} EQUALS {dataset} WITH CONFIG {config} AND FILTER {filter}