Files in vimc/dettl

Data Extract, Transform, Test and Load

.Rbuildignore

.github/.gitignore

.github/workflows/R-CMD-check.yaml

.github/workflows/pkgdown.yaml

.github/workflows/test-coverage.yaml

.gitignore

.lintr

DESCRIPTION

LICENSE

Makefile

NAMESPACE

NEWS.md R/automatic_load.R R/automatic_load_order.R R/data_write_error.R R/db.R R/dettl_auto_load_create.R R/dettl_config.R R/dettl_runner.R R/envir.R R/extract_runner.R R/foreign_key_constraints.R R/foreign_keys.R R/format.R R/generic_import.R R/git.R R/helper_git.R R/helper_testing.R R/import_config.R R/initialise.R R/insert_into_returning.R R/log_import.R R/main.R R/mode.R R/new.R R/not_null_constraints.R R/r_import.R R/save_data.R R/sql_import.R R/sql_load.R R/test_runner.R R/transform_runner.R R/utils.R R/utils_assert.R README.md

buildkite/pipeline.yml

dettl.Rproj

docker/Dockerfile

docker/Rprofile.site

docker/bin/dettl

docker/bin/install_packages

docker/bin/install_remote

docker/build

docker/common

docker/push

images/README.md

images/dettlFlowchard.png

inst/WORDLIST

inst/examples/dettl_config.yml

inst/examples/person_information/R/extract.R inst/examples/person_information/R/load.R inst/examples/person_information/R/test_extract.R inst/examples/person_information/R/test_load.R inst/examples/person_information/R/test_transform.R inst/examples/person_information/R/transform.R

inst/examples/person_information/data/people.csv

inst/examples/person_information/dettl.yml

inst/examples/sql_example/R/test_load.R inst/examples/sql_example/R/verification_queries.R

inst/examples/sql_example/dettl.yml

inst/examples/sql_example/import.sql

inst/sql/README.md

inst/sql/postgresql/create_log_table.sql

inst/sql/postgresql/get_fk.sql

inst/sql/postgresql/get_not_null.sql

inst/sql/sqlite/create_log_table.sql

inst/template/R/extract.R inst/template/R/transform.R inst/template/R/verification_queries.R

inst/template/dettl.yml

inst/template/tests/test_extract.R inst/template/tests/test_load.R inst/template/tests/test_transform.R man/Import.Rd man/ImportLog.Rd man/RImport.Rd man/SqlImport.Rd man/add_fk_data.Rd man/add_missing_function_fields.Rd man/convert_bit64_columns.Rd man/db_connect.Rd man/db_get_log_table.Rd man/dettl.Rd man/dettl_auto_load.Rd man/dettl_auto_load_create.Rd man/dettl_config.Rd man/dettl_config_read_yaml.Rd man/dettl_create_log_table.Rd man/dettl_db_args.Rd man/dettl_locate_config.Rd man/dettl_new.Rd man/dettl_run.Rd man/dettl_save.Rd man/expand_wildcards.Rd man/get_fk_constraints.Rd man/get_network_dependencies.Rd man/get_non_empty_columns.Rd man/get_postgres_fk.Rd man/get_sqlite_fk.Rd man/git_branch.Rd man/git_email.Rd man/git_hash.Rd man/git_repo_is_clean.Rd man/git_root_directory.Rd man/git_user.Rd man/insert_into_returning.Rd man/load_sources.Rd man/parse_constraints.Rd man/parse_sql_date.Rd man/postgres_insert_empty_row.Rd man/prepare_example_db.Rd man/prepare_test_import.Rd man/read_function_fields.Rd man/read_r_config.Rd man/read_sql_config.Rd man/run_extract.Rd man/run_transform.Rd man/setup_dettl.Rd man/sql_dialect.Rd man/sqlite_enable_fk.Rd man/sqlite_execute_query.Rd man/sqlite_insert_empty_row.Rd man/test_extract.Rd man/test_transform.Rd man/update_child_tables.Rd man/verify_data.Rd man/verify_table.Rd

scripts/connect_db.sh

scripts/cycle_example.R

scripts/test_db_start.sh

scripts/test_db_stop.sh

scripts/update_web.sh

tests/testthat.R tests/testthat/broken_example/R/extract.R tests/testthat/broken_example/R/script.R

tests/testthat/broken_example/dettl.yml

tests/testthat/dettl_config.yml

tests/testthat/example/R/extract.R tests/testthat/example/R/load.R tests/testthat/example/R/test_extract.R tests/testthat/example/R/test_load.R tests/testthat/example/R/test_transform.R tests/testthat/example/R/transform.R tests/testthat/example/R/verification_queries.R

tests/testthat/example/data/people.csv

tests/testthat/example/dettl.yml

tests/testthat/example_automatic_load/R/extract.R tests/testthat/example_automatic_load/R/test_extract.R tests/testthat/example_automatic_load/R/test_load.R tests/testthat/example_automatic_load/R/test_transform.R tests/testthat/example_automatic_load/R/transform.R tests/testthat/example_automatic_load/R/verification_queries.R

tests/testthat/example_automatic_load/data/jobs.csv

tests/testthat/example_automatic_load/data/people.csv

tests/testthat/example_automatic_load/dettl.yml

tests/testthat/example_create_table/R/extract.R tests/testthat/example_create_table/R/test_extract.R tests/testthat/example_create_table/R/test_load.R tests/testthat/example_create_table/R/test_transform.R tests/testthat/example_create_table/R/transform.R tests/testthat/example_create_table/R/verification_queries.R

tests/testthat/example_create_table/data/hobbies.csv

tests/testthat/example_create_table/dettl.yml

tests/testthat/example_failing_extract_test/R/extract.R tests/testthat/example_failing_extract_test/R/load.R tests/testthat/example_failing_extract_test/R/test_extract.R tests/testthat/example_failing_extract_test/R/test_load.R tests/testthat/example_failing_extract_test/R/test_transform.R tests/testthat/example_failing_extract_test/R/transform.R tests/testthat/example_failing_extract_test/R/verification_queries.R

tests/testthat/example_failing_extract_test/data/people.csv

tests/testthat/example_failing_extract_test/dettl.yml

tests/testthat/example_failing_test/R/extract.R tests/testthat/example_failing_test/R/load.R tests/testthat/example_failing_test/R/test_load.R tests/testthat/example_failing_test/R/test_queries.R tests/testthat/example_failing_test/R/transform.R

tests/testthat/example_failing_test/data/people.csv

tests/testthat/example_failing_test/dettl.yml

tests/testthat/example_failing_transform_test/R/extract.R tests/testthat/example_failing_transform_test/R/load.R tests/testthat/example_failing_transform_test/R/test_extract.R tests/testthat/example_failing_transform_test/R/test_load.R tests/testthat/example_failing_transform_test/R/test_transform.R tests/testthat/example_failing_transform_test/R/transform.R tests/testthat/example_failing_transform_test/R/verification_queries.R

tests/testthat/example_failing_transform_test/data/people.csv

tests/testthat/example_failing_transform_test/dettl.yml

tests/testthat/example_load_template/R/extract.R tests/testthat/example_load_template/R/load.R tests/testthat/example_load_template/R/script.R tests/testthat/example_load_template/R/test.R tests/testthat/example_load_template/R/transform.R

tests/testthat/example_load_template/dettl.yml

tests/testthat/example_load_template/import.sql

tests/testthat/example_no_transaction/R/extract.R tests/testthat/example_no_transaction/R/load.R tests/testthat/example_no_transaction/R/test_extract.R tests/testthat/example_no_transaction/R/test_load.R tests/testthat/example_no_transaction/R/test_transform.R tests/testthat/example_no_transaction/R/transform.R tests/testthat/example_no_transaction/R/verification_queries.R

tests/testthat/example_no_transaction/data/people.csv

tests/testthat/example_no_transaction/dettl.yml

tests/testthat/example_pre_post_load/R/extract.R tests/testthat/example_pre_post_load/R/post_load.R tests/testthat/example_pre_post_load/R/pre_load.R tests/testthat/example_pre_post_load/R/test_extract.R tests/testthat/example_pre_post_load/R/test_load.R tests/testthat/example_pre_post_load/R/test_transform.R tests/testthat/example_pre_post_load/R/transform.R tests/testthat/example_pre_post_load/R/verification_queries.R

tests/testthat/example_pre_post_load/data/jobs.csv

tests/testthat/example_pre_post_load/data/people.csv

tests/testthat/example_pre_post_load/dettl.yml

tests/testthat/example_relative_path/R/extract.R tests/testthat/example_relative_path/R/load.R tests/testthat/example_relative_path/R/test_extract.R tests/testthat/example_relative_path/R/test_load.R tests/testthat/example_relative_path/R/test_transform.R tests/testthat/example_relative_path/R/transform.R tests/testthat/example_relative_path/R/verification_queries.R

tests/testthat/example_relative_path/data/people.csv

tests/testthat/example_relative_path/dettl.yml

tests/testthat/example_sql_only/R/test_load.R tests/testthat/example_sql_only/R/verification_queries.R

tests/testthat/example_sql_only/dettl.yml

tests/testthat/example_sql_only/import.sql

tests/testthat/example_sql_pre_post_load/R/post_load.R tests/testthat/example_sql_pre_post_load/R/pre_load.R tests/testthat/example_sql_pre_post_load/R/test_load.R tests/testthat/example_sql_pre_post_load/R/verification_queries.R

tests/testthat/example_sql_pre_post_load/dettl.yml

tests/testthat/example_sql_pre_post_load/import.sql

tests/testthat/example_tests/connection_extract_test.R tests/testthat/example_tests/connection_load_test.R tests/testthat/example_tests/connection_transform_test.R tests/testthat/example_tests/empty_extract_test.R tests/testthat/example_tests/failing_extract_test.R tests/testthat/example_tests/failing_load_test.R tests/testthat/example_tests/failing_transform_test.R tests/testthat/example_tests/passing_extract_test.R tests/testthat/example_tests/passing_load_test.R tests/testthat/example_tests/passing_transform_test.R tests/testthat/helper-aaa.R tests/testthat/helper-db.R tests/testthat/helper-dettl-config.R tests/testthat/helper-dettl.R tests/testthat/simple_example/R/extract.R tests/testthat/simple_example/R/script.R tests/testthat/simple_example/R/test.R tests/testthat/simple_example/R/transform.R

tests/testthat/simple_example/dettl.yml

tests/testthat/template_dettl_config/dettl_config.yml

tests/testthat/test-automatic-load-order.R tests/testthat/test-automatic-load.R tests/testthat/test-connection-cleanup.R tests/testthat/test-data-import-object.R tests/testthat/test-data-write-error.R tests/testthat/test-db.R tests/testthat/test-dettl-auto-load-create.R tests/testthat/test-dettl-config.R tests/testthat/test-dettl-runner.R tests/testthat/test-envir.R tests/testthat/test-extract-runner.R tests/testthat/test-foreign-key-constraints.R tests/testthat/test-foreign-keys.R tests/testthat/test-git.R tests/testthat/test-import-config.R tests/testthat/test-initialise.R tests/testthat/test-insert-into-returning.R tests/testthat/test-load-runner.R tests/testthat/test-load.R tests/testthat/test-log-import.R tests/testthat/test-main.R tests/testthat/test-mode.R tests/testthat/test-new.R tests/testthat/test-no-transaction.R tests/testthat/test-not-null-constraints.R tests/testthat/test-pre-post-load.R tests/testthat/test-relative-path.R tests/testthat/test-run-automatic-load.R tests/testthat/test-run-create.R tests/testthat/test-save-data.R tests/testthat/test-sql-import.R tests/testthat/test-sql-load.R tests/testthat/test-test-helper.R tests/testthat/test-test-runner.R tests/testthat/test-transform-runner.R tests/testthat/test-utils-assert.R tests/testthat/test-utils.R

vignettes/.gitignore

vignettes/dettl.Rmd

vignettes/images/cycle_example.png

vimc/dettl documentation built on Oct. 6, 2022, 2:13 p.m.