tarflow.iquizoo 3.3.0

Breaking Changes

• The RMariaDB::MariaDB() database driver is detected with higher priority, and odbc::odbc() is technically deprecated, although still supported (not sure for working) for now (#68).
• Renamed fetch_parameterized() as fetch_iquizoo(). The latter is shorter and echoes with the package name.
• Removed fetch_batch() as vector parameters are supported by DBI::dbGetQuery(). fetch_iquizoo() handles both vector and scalar parameters.

tarflow.iquizoo 3.2.0

New Features

• Added setup_source() to specify the data source. Arguments driver, dsn and groups of fetch_parameterized() now live in this function.
• Let params argument of fetch_parameterized() be optional (but not after ...) when no parameters in query. Note this is not checked beforehand, so you should take care of whether there are parameters.
• Supported custom SQL templates. When users want to use different parameter names other than the default one, they could support their own paired with SQL templates. See setup_templates() for details (#66).

Improvements

• Enhanced progress hash.
  • The name is changed from project_hash to progress_hash, which is more informative. So the argument always_check_hash of prepare_fetch_data() is changed to check_progress accordingly.
  • Now if there are multiple projects, the hash will be separated for each project.
  • The SQL now is independent of the user's parameters (#67).

tarflow.iquizoo 3.1.1

• Fixed a bug that fetch_preset() does not pass ... to fetch_parameterized() correctly.

tarflow.iquizoo 3.1.0

Breaking Changes

• Changed parameters to organization name and project name. Former course specification is removed.

New Features

• Support specify dsn and groups in options by tarflow.dsn and tarflow.groups respectively. This is useful when default values are not suitable for you.
• Added project users to pipeline.
• Added support for auto-check whether the projects data are up-to-date. This turned on by default, and you can turn it off by setting always_check_hash to FALSE in use_targets().

Bug Fixes

• Fix a bug that targets flow will fail with meaningless message when odbc does not configure correctly.

tarflow.iquizoo 3.0.0

Breaking Changes

• Supported the new database design of IQUIZOO. Now the Rmarkdown templates were removed, and users should call tarflow.iquizoo::use_targets() to generate the pipeline.
• Limited the parameters settings to only course_name and course_period for now. Other parameters will be added in future.
• Added game_stage and game_star to scores data (#29).

tarflow.iquizoo 2.5.3

• Added more tests. No user-level updates.

tarflow.iquizoo 2.5.1

Bug Fixes

• Fixed option "tarflow.driver" not working.
• Removed ... argument from connect_to_db() for it is just an internal function.

tarflow.iquizoo 2.5.0

Breaking Changes

• Now pickup() support drv argument to specify the database driver. This is useful when you want to specify which database driver to use. For example, you can use drv = RMariaDB::MariaDB().
  • The default is from the value of option "tarflow.driver", which will find the first available driver from odbc and RMariaDB. If neither of them is available, a message will be prompted to inform user to install one.

tarflow.iquizoo 2.4.1

Breaking Changes

• Added a new argument add_keyword to compose_where() to allow adding keyword WHERE to the where clause. This is useful when you want to compose a where clause for a subquery.

tarflow.iquizoo 2.4.0

Breaking Changes

• Removed search_games_mem() for it will not behave as expected. Especially, memoise::forget() will not work. A working version is added in rmarkdown template.

Misc

• Enhanced code quality.