CRAN Package Check Results for Package datacaged

Last updated on 2026-10-06 00:48:52 CEST.

Flavor	Version	T_install	T_check	T_total	Status
r-devel-linux-x86_64-debian-clang	0.2.1	7.86	95.46	103.32	ERROR
r-devel-linux-x86_64-debian-gcc	0.2.1	5.34	70.56	75.90	ERROR
r-devel-linux-x86_64-fedora-clang	0.2.1	6.00	70.64	76.64	ERROR
r-devel-linux-x86_64-fedora-gcc	0.2.1			74.61	ERROR
r-devel-windows-x86_64	0.2.1	10.00	148.00	158.00	OK
r-patched-linux-x86_64	0.2.1	7.66	87.14	94.80	ERROR
r-release-linux-x86_64	0.2.1				ERROR
r-release-macos-arm64	0.2.1	2.00	101.00	103.00	OK
r-release-macos-x86_64	0.2.1	6.00	222.00	228.00	OK
r-release-windows-x86_64	0.2.1	13.00	134.00	147.00	ERROR
r-oldrel-macos-arm64	0.2.1				OK
r-oldrel-macos-x86_64	0.2.1	6.00	211.00	217.00	OK
r-oldrel-windows-x86_64	0.2.1	12.00	158.00	170.00	ERROR

Check Details

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [16s/66s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da238ccd90.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da3d1fd157.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da1af5c612.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da1c92d647.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da524fc9f.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da4e81fea4.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da187c52fe.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [2s] ETA: ETA: 4s ==============================> 3/3 [3.2s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpNQjHvs/file2194da2b87e1b0.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_2194da8c00acc' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_2194da8c00acc' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_2194da8c00acc' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmpNQjHvs/caged_dl_2194da4a626f14' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/RtmpNQjHvs/caged_lay_mock_2194da41c59125/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 18.3s ETA ETA: 18s curl: (78) The file does not exist ==============================> 2/2 31.6s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_test_2194dad4436de' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_test_2194dad4436de' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_test_2194dad4436de' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpNQjHvs/novo_dir_2200794' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/novo_dir_2200794' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/novo_dir_2200794' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_ow_2194da732056b0' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_ow_2194da732056b0' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_ow_2194da732056b0' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/RtmpNQjHvs/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_ow_2194da732056b0' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmpNQjHvs/parquet_ow_2194da732056b0' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/RtmpNQjHvs/caged_load_mock_2194da3fd7c88a.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/RtmpNQjHvs/caged_adj_mock_2194da6dc028ae.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-devel-linux-x86_64-debian-clang

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [11s/46s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec37b7cd18.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec73afa5d7.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec767d35dd.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec1196727b.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec5e95cef1.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec1b0560cd.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec316a8535.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [1.4s] ETA: ETA: 3s ==============================> 3/3 [2.5s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/Rtmp52cHWv/file1df3ec117d3547.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_1df3ec4b8f8b53' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_1df3ec4b8f8b53' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_1df3ec4b8f8b53' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/Rtmp52cHWv/caged_dl_1df3ec514aee60' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/Rtmp52cHWv/caged_lay_mock_1df3ec66acb81c/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 15.9s ETA ETA: 16s curl: (78) The file does not exist ==============================> 2/2 29.5s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_test_1df3ec6beec3af' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_test_1df3ec6beec3af' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_test_1df3ec6beec3af' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp52cHWv/novo_dir_1962988' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/novo_dir_1962988' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/novo_dir_1962988' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_ow_1df3ec1bdf7b1a' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_ow_1df3ec1bdf7b1a' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_ow_1df3ec1bdf7b1a' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp52cHWv/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_ow_1df3ec1bdf7b1a' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/Rtmp52cHWv/parquet_ow_1df3ec1bdf7b1a' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/Rtmp52cHWv/caged_load_mock_1df3ecbebc480.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/Rtmp52cHWv/caged_adj_mock_1df3ecf4877b.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-devel-linux-x86_64-debian-gcc

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [11s/63s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b444d281c5.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b44452da65e8.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b444eb4b735.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b44433c4b665.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b4443b620fd4.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Connected to '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b4443d1c7f2d.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- datacaged - '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b444822be60.duckdb' File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [1.8s] ETA: ETA: 4s ==============================> 3/3 [2.9s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- datacaged - '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/file37b4446ce3c8ae.duckdb File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_37b444848c36a' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_37b444848c36a' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_37b444848c36a' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_dl_37b44433f4834d' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_lay_mock_37b4445d877de9/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 18.7s ETA ETA: 19s curl: (78) The file does not exist ==============================> 2/2 32.4s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_test_37b4447a804bea' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_test_37b4447a804bea' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_test_37b4447a804bea' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/novo_dir_3650628' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/novo_dir_3650628' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/novo_dir_3650628' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb was built with libc++ (not libstdc++) on Linux, so DuckDB extensions are disabled: * Loading a prebuilt (libstdc++) extension could crash R (https://github.com/duckdb/duckdb-r/issues/1107). * INSTALL/LOAD of an extension will error, and automatic extension loading is off. i Pass duckdb(allow_extensions = FALSE) to accept this and silence this message. i Pass duckdb(allow_extensions = TRUE) to attempt loading anyway (may crash R). i See ?duckdb for details. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/parquet_ow_37b4444ab222b' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_load_mock_37b44475db8659.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/tmp/Rtmpq8jH9H/working_dir/Rtmpm3uDE2/caged_adj_mock_37b4444dbc9484.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-devel-linux-x86_64-fedora-clang

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [11s/38s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c2eaee6b5.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c19a44422.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c4f5e7069.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c3e5def75.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c66a1f91a.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c6895a0b4.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c2e484120.duckdb File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [1.3s] ETA: ETA: 3s ==============================> 3/3 [2.5s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/file349e2c4f71d364.duckdb File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_349e2c6fde2add' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_349e2c6fde2add' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_349e2c6fde2add' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/caged_dl_349e2c51a9d061' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/caged_lay_mock_349e2c1d39a88d/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 11.4s ETA ETA: 11s curl: (78) The file does not exist ==============================> 2/2 22.8s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_test_349e2c1a4b3a3d' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_test_349e2c1a4b3a3d' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_test_349e2c1a4b3a3d' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/novo_dir_3448364' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/novo_dir_3448364' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/novo_dir_3448364' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_ow_349e2c778973a6' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_ow_349e2c778973a6' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_ow_349e2c778973a6' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /data/localhost/ripley/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_ow_349e2c778973a6' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/parquet_ow_349e2c778973a6' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/caged_load_mock_349e2c3024ebfa.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/tmp/RtmpcFFku8/working_dir/RtmpfF9y0f/caged_adj_mock_349e2c1d84c437.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-devel-linux-x86_64-fedora-gcc

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [16s/62s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec7680eb1f.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec76609482.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173eca6325e4.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec3b014daa.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec6ec597dd.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec48e7812f.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec30dc9ed4.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [2s] ETA: ETA: 4s ====================>---------- 2/3 [2.6s] ETA: ETA: 1s ==============================> 3/3 [3.2s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/RtmpQ9Nfli/file1173ec1bc74a78.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_1173ec3c34ef11' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_1173ec3c34ef11' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_1173ec3c34ef11' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/RtmpQ9Nfli/caged_dl_1173ec77010bc9' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/RtmpQ9Nfli/caged_lay_mock_1173ec3a4612af/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 15.7s ETA ETA: 16s curl: (78) The file does not exist ==============================> 2/2 29.1s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_test_1173ec40ce0359' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_test_1173ec40ce0359' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_test_1173ec40ce0359' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpQ9Nfli/novo_dir_1143788' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/novo_dir_1143788' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/novo_dir_1143788' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i /home/hornik/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/RtmpQ9Nfli/parquet_ow_1173ec40ea7442' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/RtmpQ9Nfli/caged_load_mock_1173ec28108d0b.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/RtmpQ9Nfli/caged_adj_mock_1173ec31326179.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-patched-linux-x86_64

Version: 0.2.1
Check: tests
Result: ERROR Running ‘testthat.R’ [16s/64s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a7fd81763.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a5dd69df1.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a79a84c49.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a194cdfed.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a2ffb049e.duckdb' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Connected to '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a7398a3da.duckdb' Empty data.frame - nothing to write. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a88f089.duckdb' --- File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [1.8s] ETA: ETA: 4s ==============================> 3/3 [3s] ETA: ETA: 0s No valid competency to download. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- datacaged - '/home/hornik/tmp/scratch/Rtmp3nbdX7/file2c734a73d5bc63.duckdb' - File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_2c734a3ad744d5' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_2c734a3ad744d5' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_2c734a3ad744d5' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: '/home/hornik/tmp/scratch/Rtmp3nbdX7/caged_dl_2c734a65f910e8' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em '/home/hornik/tmp/scratch/Rtmp3nbdX7/caged_lay_mock_2c734a4c74a1e8/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). curl: (78) The file does not exist ===============>--------------- 1/2 16.7s ETA ETA: 17s curl: (78) The file does not exist ==============================> 2/2 30.2s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_test_2c734a536e5cc' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_test_2c734a536e5cc' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_test_2c734a536e5cc' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp3nbdX7/novo_dir_2913098' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/novo_dir_2913098' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/novo_dir_2913098' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_ow_2c734a5077bd16' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_ow_2c734a5077bd16' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_ow_2c734a5077bd16' duckdb keeps downloaded extensions and secrets in a temporary directory: i /home/hornik/tmp/scratch/Rtmp3nbdX7/duckdb This is removed when the R session ends. * Extensions are re-downloaded each session. * Secrets are lost. i Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users). i Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message). i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_ow_2c734a5077bd16' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: '/home/hornik/tmp/scratch/Rtmp3nbdX7/parquet_ow_2c734a5077bd16' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/Rtmp3nbdX7/caged_load_mock_2c734a6cdb7325.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `/home/hornik/tmp/scratch/Rtmp3nbdX7/caged_adj_mock_2c734a5f3dca31.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-release-linux-x86_64

Version: 0.2.1
Check: tests
Result: ERROR Running 'testthat.R' [41s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d8149179b2.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d817973848.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d84f4c2e88.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d84eac3d7a.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d86ec66836.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d87b6d6fd9.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d829ce1e9e.d File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [4s] ETA: ETA: 8s ==============================> 3/3 [5.2s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\file617d85141276b.d File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_617d876776e2d' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_617d876776e2d' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_617d876776e2d' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_dl_617d8551f453' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_lay_mock_617d8641d410e/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). ===============>--------------- 1/2 10.3s ETA ETA: 10s ==============================> 2/2 19.7s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_test_617d86d434cd' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_test_617d86d434cd' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_test_617d86d434cd' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag/novo_dir_399320' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag/novo_dir_399320' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag/novo_dir_399320' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: 'D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\parquet_ow_617d81a013872' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_load_mock_617d86f0a51c3.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `D:\temp\2026_09_29_12_06_12_14923\RtmpGUD0ag\caged_adj_mock_617d832013f31.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-release-windows-x86_64

Version: 0.2.1
Check: tests
Result: ERROR Running 'testthat.R' [48s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(datacaged) datacaged 0.2.1 - Microdados do CAGED em DuckDB Fonte: https://huggingface.co/datasets/alexsandroprado/caged Verifique a conexão com: caged_status() Uso rápido: caged_load(years = 2023, months = 1, db_path = "caged.duckdb") Ajuda : help(package = "datacaged") | ?caged_load > > test_check("datacaged") Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... Querying HuggingFace repository (<https://huggingface.co/api/datasets/alexsandroprado/caged/tree/main>)... duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f9083bb64342.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to ':memory:' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f908522822bc.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. i 1 competencia ja no banco - pulando. i Use `overwrite_competencies = TRUE` para forcar. No new data to insert. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f9082c122ed2.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f90834056a9c.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_antigo" criada. v 16 registro inserido em "caged_antigo" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f9087aeb3951.duckdb' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_ajustes" criada. v 10 registro inserido em "caged_ajustes" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Connected to 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f9084afc6e35.duckdb' Empty data.frame - nothing to write. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f9081c0b55e0.du File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202302 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 3 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" v 10 registro inserido em "caged_mov" ==========>-------------------- 1/3 [4.3s] ETA: ETA: 9s ====================>---------- 2/3 [5s] ETA: ETA: 3s ==============================> 3/3 [5.5s] ETA: ETA: 0s No valid competency to download. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Nenhum arquivo valido para parsear. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- datacaged - 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\file4f90857ce7c2b.du File size: 0.5 MB -- Tables -- * "caged_mov" Records : 20 Periods : 202301 - 202301 duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 50 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 30 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_4f908f031c2b' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_4f908f031c2b' v caged_mov: 30 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_4f908f031c2b' -- Download CAGED Microdata ---------------------------------------------------- i 3 files to process i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main i Cache: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\caged_dl_4f908179c7395' i Workers: 1 -- Summary -- v baixado: 3 Saving _problems/test-pipelines-145.R -- caged_download_layouts ------------------------------------------------------ i Bases: "novo" i Cache em 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\caged_lay_mock_4f9086a739f9/layouts' -- Listando - "novo" -- i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/> v 2 arquivo(s) encontrado(s). ===============>--------------- 1/2 10.9s ETA ETA: 11s ==============================> 2/2 19.8s ETA ETA: 0s -- Summary -- ! naoencontrado: 2 Saving _problems/test-pipelines-223.R duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 15 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 20 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_test_4f908615b7ed5' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_test_4f908615b7ed5' v caged_mov: 20 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_test_4f908615b7ed5' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9/novo_dir_325896' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9/novo_dir_325896' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9/novo_dir_325896' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. Tabela "caged_mov" criada. v 5 registro inserido em "caged_mov" Directory created: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_ow_4f90865ad10d9' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_ow_4f90865ad10d9' v caged_mov: 5 registros → 'caged_mov.parquet' -- Done -- v 1 table exported i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_ow_4f90865ad10d9' duckdb is storing downloaded extensions and secrets under ~/.duckdb: i C:\Users\CRAN/.duckdb This persists across sessions and is shared with the DuckDB CLI and other clients. i Run duckdb(shared_home = FALSE) to use a temporary directory instead. i See ?duckdb_storage for details and alternatives. -- Exportando para Parquet ----------------------------------------------------- i 1 table to export i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_ow_4f90865ad10d9' i caged_mov: already exists, skipping. Use `overwrite = TRUE`. -- Done -- v 0 tables exported i Output: 'D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\parquet_ow_4f90865ad10d9' [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] ══ Skipped tests (5) ═══════════════════════════════════════════════════════════ • On CRAN (5): 'test-availability.R:30:3', 'test-database.R:287:3', 'test-status.R:22:3', 'test-status.R:43:3', 'test-update-parquet.R:66:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Error ('test-pipelines.R:143:3'): caged_load() cria banco DuckDB com tabela caged_mov ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\caged_load_mock_4f90815a46d6e.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:143:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) ── Error ('test-pipelines.R:216:3'): caged_adjustments_load() cria banco com tabela caged_ajustes ── Error in `duckdb::duckdb(dbdir = db_path, read_only = read_only)`: `read_only` can't be applied to the database instance for `D:\temp\2026_10_02_20_03_24_4589\RtmpG8gjV9\caged_adj_mock_4f90825d9261b.duckdb`, which already exists. * These settings take effect only when the instance is created. * Release it with `duckdb_shutdown()` first, or pass them to the `duckdb()` call that creates it. Backtrace: ▆ 1. ├─base::suppressMessages(...) at test-pipelines.R:216:3 2. │ └─base::withCallingHandlers(...) 3. └─datacaged::caged_adjustments_load(...) 4. └─datacaged::caged_info(db_path) 5. └─datacaged::caged_connect(db_path, read_only = TRUE, quiet = TRUE) 6. └─duckdb::duckdb(dbdir = db_path, read_only = read_only) 7. └─duckdb:::warn_instance_settings_ignored(...) 8. └─rlang::abort(...) [ FAIL 2 | WARN 0 | SKIP 5 | PASS 187 ] Error: ! Test failures. Execution halted Flavor: r-oldrel-windows-x86_64