Last updated on 2026-10-10 16:51:14 CEST.
| Flavor | Version | Tinstall | Tcheck | Ttotal | Status | Flags |
|---|---|---|---|---|---|---|
| r-devel-linux-x86_64-debian-clang | 0.2.1 | 7.77 | 98.11 | 105.88 | ERROR | |
| r-devel-linux-x86_64-debian-gcc | 0.2.1 | 4.51 | 72.66 | 77.17 | ERROR | |
| r-devel-linux-x86_64-fedora-clang | 0.2.1 | 71.55 | ERROR | |||
| r-devel-linux-x86_64-fedora-gcc | 0.2.1 | 6.00 | 75.36 | 81.36 | 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.14 | 90.62 | 97.76 | 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 | 2.00 | 102.00 | 104.00 | 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 | 159.00 | 171.00 | ERROR |
Version: 0.2.1
Check: tests
Result: ERROR
Running ‘testthat.R’ [17s/61s]
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/RtmpIufvFn/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/RtmpIufvFn/file2c387f31f02bf7.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f3a207425.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f4799fae4.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f36fbb422.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f6f43e7f5.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f79ea5236.duckdb'
Empty data.frame - nothing to write.
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f25aa4a75.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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/file2c387f1b76cdb2.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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/parquet_2c387f3f17d3b6'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/parquet_2c387f3f17d3b6'
v caged_mov: 30 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_2c387f3f17d3b6'
-- Download CAGED Microdata ----------------------------------------------------
i 3 files to process
i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main
i Cache: '/home/hornik/tmp/scratch/RtmpIufvFn/caged_dl_2c387f1ad8b787'
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/RtmpIufvFn/caged_lay_mock_2c387f3bfee70a/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 15s ETA ETA: 15s
curl: (78) The file does not exist
==============================> 2/2 28.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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/parquet_test_2c387f3e289b3f'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/parquet_test_2c387f3e289b3f'
v caged_mov: 20 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_test_2c387f3e289b3f'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/novo_dir_2898047'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/novo_dir_2898047'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/novo_dir_2898047'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/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/RtmpIufvFn/parquet_ow_2c387f754274e2'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/parquet_ow_2c387f754274e2'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpIufvFn/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/RtmpIufvFn/parquet_ow_2c387f754274e2'
i caged_mov: already exists, skipping. Use `overwrite = TRUE`.
-- Done --
v 0 tables exported
i Output: '/home/hornik/tmp/scratch/RtmpIufvFn/parquet_ow_2c387f754274e2'
[ 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/RtmpIufvFn/caged_load_mock_2c387f2503aa4d.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/RtmpIufvFn/caged_adj_mock_2c387f4baccbd5.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’ [12s/50s]
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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f96162f464.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f94af281a8.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f95d937959.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f94bf524d6.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f9344d039e.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f94551ad97.duckdb'
Empty data.frame - nothing to write.
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f94dfab938.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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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.5s] ETA: ETA: 3s
==============================> 3/3 [2.7s] ETA: ETA: 0s
No valid competency to download.
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/file3bb0f979e21f87.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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/parquet_3bb0f928c6eac6'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/parquet_3bb0f928c6eac6'
v caged_mov: 30 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpL6AZJs/parquet_3bb0f928c6eac6'
-- Download CAGED Microdata ----------------------------------------------------
i 3 files to process
i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main
i Cache: '/home/hornik/tmp/scratch/RtmpL6AZJs/caged_dl_3bb0f92e2d978a'
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/RtmpL6AZJs/caged_lay_mock_3bb0f93b0ee22d/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 16s ETA ETA: 16s
curl: (78) The file does not exist
==============================> 2/2 29.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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/parquet_test_3bb0f963fed50e'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/parquet_test_3bb0f963fed50e'
v caged_mov: 20 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpL6AZJs/parquet_test_3bb0f963fed50e'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/novo_dir_3911929'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/novo_dir_3911929'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpL6AZJs/novo_dir_3911929'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/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/RtmpL6AZJs/parquet_ow_3bb0f92991ae0'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/parquet_ow_3bb0f92991ae0'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmpL6AZJs/parquet_ow_3bb0f92991ae0'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmpL6AZJs/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/RtmpL6AZJs/parquet_ow_3bb0f92991ae0'
i caged_mov: already exists, skipping. Use `overwrite = TRUE`.
-- Done --
v 0 tables exported
i Output: '/home/hornik/tmp/scratch/RtmpL6AZJs/parquet_ow_3bb0f92991ae0'
[ 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/RtmpL6AZJs/caged_load_mock_3bb0f947030ed2.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/RtmpL6AZJs/caged_adj_mock_3bb0f91ca3aa58.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/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.
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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a03354650489.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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a03318a8e897.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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a033427a7272.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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a0335a082616.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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a03396c2d8c.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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a033115656b6.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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a0333fd9565f.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.4s] 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.
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/Rtmp7IP6qj/working_dir/RtmprSarjR/file15a033750dcdf7.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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_15a03330448df7'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_15a03330448df7'
v caged_mov: 30 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_15a03330448df7'
-- Download CAGED Microdata ----------------------------------------------------
i 3 files to process
i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main
i Cache: '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/caged_dl_15a033797c83c8'
i Workers: 1
-- Summary --
v baixado: 3
Saving _problems/test-pipelines-145.R
-- caged_download_layouts ------------------------------------------------------
i Bases: "novo"
i Cache em '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/caged_lay_mock_15a0333d9434bb/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.9s ETA ETA: 12s
curl: (78) The file does not exist
==============================> 2/2 23s 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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_test_15a033491489da'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_test_15a033491489da'
v caged_mov: 20 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_test_15a033491489da'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/novo_dir_1417267'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/novo_dir_1417267'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/novo_dir_1417267'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_ow_15a0336cfbe6af'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_ow_15a0336cfbe6af'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_ow_15a0336cfbe6af'
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/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_ow_15a0336cfbe6af'
i caged_mov: already exists, skipping. Use `overwrite = TRUE`.
-- Done --
v 0 tables exported
i Output: '/tmp/Rtmp7IP6qj/working_dir/RtmprSarjR/parquet_ow_15a0336cfbe6af'
[ 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/Rtmp7IP6qj/working_dir/RtmprSarjR/caged_load_mock_15a03319354c9.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/Rtmp7IP6qj/working_dir/RtmprSarjR/caged_adj_mock_15a0335dec2d86.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’ [12s/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 /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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb49596d5e47.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb495f4ffd4b.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb496dc650a5.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb49160d4b2e.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb494dd4a213.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb494641c758.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb49238e0557.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.7s] ETA: ETA: 3s
==============================> 3/3 [2.8s] 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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/file3adb493af510ef.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_3adb4958d7b243'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_3adb4958d7b243'
v caged_mov: 30 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_3adb4958d7b243'
-- Download CAGED Microdata ----------------------------------------------------
i 3 files to process
i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main
i Cache: '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/caged_dl_3adb4945b9232a'
i Workers: 1
-- Summary --
v baixado: 3
Saving _problems/test-pipelines-145.R
-- caged_download_layouts ------------------------------------------------------
i Bases: "novo"
i Cache em '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/caged_lay_mock_3adb494335592a/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 12.6s ETA ETA: 13s
curl: (78) The file does not exist
==============================> 2/2 25.7s 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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_test_3adb496fb74a88'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_test_3adb496fb74a88'
v caged_mov: 20 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_test_3adb496fb74a88'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/novo_dir_3857225'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/novo_dir_3857225'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/novo_dir_3857225'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_ow_3adb4920ef1769'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_ow_3adb4920ef1769'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_ow_3adb4920ef1769'
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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_ow_3adb4920ef1769'
i caged_mov: already exists, skipping. Use `overwrite = TRUE`.
-- Done --
v 0 tables exported
i Output: '/tmp/Rtmp7DwRLc/working_dir/RtmpUcOK3p/parquet_ow_3adb4920ef1769'
[ 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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/caged_load_mock_3adb499ea7008.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/Rtmp7DwRLc/working_dir/RtmpUcOK3p/caged_adj_mock_3adb49b1998f9.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’ [17s/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/RtmprPwckn/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/RtmprPwckn/file1a67482e65718a.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a674854366730.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a6748431fc6d8.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a67486238e259.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a6748133fff76.duckdb'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a67483046bc0e.duckdb'
Empty data.frame - nothing to write.
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a674858717db3.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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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 [2.2s] ETA: ETA: 4s
==============================> 3/3 [3.4s] ETA: ETA: 0s
No valid competency to download.
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/file1a674843786026.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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/parquet_1a67487d4c3f14'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/parquet_1a67487d4c3f14'
v caged_mov: 30 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_1a67487d4c3f14'
-- Download CAGED Microdata ----------------------------------------------------
i 3 files to process
i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main
i Cache: '/home/hornik/tmp/scratch/RtmprPwckn/caged_dl_1a67485a30c651'
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/RtmprPwckn/caged_lay_mock_1a674873acaba9/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.6s ETA ETA: 16s
curl: (78) The file does not exist
==============================> 2/2 28.9s 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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/parquet_test_1a67483b3e7053'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/parquet_test_1a67483b3e7053'
v caged_mov: 20 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_test_1a67483b3e7053'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/novo_dir_1730376'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/novo_dir_1730376'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmprPwckn/novo_dir_1730376'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/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/RtmprPwckn/parquet_ow_1a67486153a603'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/parquet_ow_1a67486153a603'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603'
duckdb keeps downloaded extensions and secrets in a temporary directory:
i /home/hornik/tmp/scratch/RtmprPwckn/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/RtmprPwckn/parquet_ow_1a67486153a603'
i caged_mov: already exists, skipping. Use `overwrite = TRUE`.
-- Done --
v 0 tables exported
i Output: '/home/hornik/tmp/scratch/RtmprPwckn/parquet_ow_1a67486153a603'
[ 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/RtmprPwckn/caged_load_mock_1a67487a663d33.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/RtmprPwckn/caged_adj_mock_1a67483ab62d4b.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' [51s]
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_07_16_17_17_27527\Rtmpu8rx2q\file5cb882288781a.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_07_16_17_17_27527\Rtmpu8rx2q\file5cb8838b1734.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_07_16_17_17_27527\Rtmpu8rx2q\file5cb8862de1e66.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_07_16_17_17_27527\Rtmpu8rx2q\file5cb881f272e09.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_07_16_17_17_27527\Rtmpu8rx2q\file5cb88461a34c3.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_07_16_17_17_27527\Rtmpu8rx2q\file5cb8834555fb4.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_07_16_17_17_27527\Rtmpu8rx2q\file5cb883882321d.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 [5.1s] ETA: ETA: 10s
==============================> 3/3 [6.3s] 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_07_16_17_17_27527\Rtmpu8rx2q\file5cb887a5d6209.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_10_07_16_17_17_27527\Rtmpu8rx2q\parquet_5cb881bb9f34'
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_07_16_17_17_27527\Rtmpu8rx2q\parquet_5cb881bb9f34'
v caged_mov: 30 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: 'D:\temp\2026_10_07_16_17_17_27527\Rtmpu8rx2q\parquet_5cb881bb9f34'
-- Download CAGED Microdata ----------------------------------------------------
i 3 files to process
i Fonte: https://huggingface.co/datasets/alexsandroprado/caged/resolve/main
i Cache: 'D:\temp\2026_10_07_16_17_17_27527\Rtmpu8rx2q\caged_dl_5cb8824ae1d39'
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_07_16_17_17_27527\Rtmpu8rx2q\caged_lay_mock_5cb88467332b6/layouts'
-- Listando - "novo" --
i Consultando <ftp://ftp.mtps.gov.br/pdet/microdados/NOVO%20CAGED/>
v 2 arquivo(s) encontrado(s).
===============>--------------- 1/2 11.9s ETA ETA: 12s
==============================> 2/2 21.6s 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_07_16_17_17_27527\Rtmpu8rx2q\parquet_test_5cb882b74103c'
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_07_16_17_17_27527\Rtmpu8rx2q\parquet_test_5cb882b74103c'
v caged_mov: 20 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: 'D:\temp\2026_10_07_16_17_17_27527\Rtmpu8rx2q\parquet_test_5cb882b74103c'
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_07_16_17_17_27527\Rtmpu8rx2q/novo_dir_379784'
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_07_16_17_17_27527\Rtmpu8rx2q/novo_dir_379784'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: 'D:\temp\2026_10_07_16_17_17_27527\Rtmpu8rx2q/novo_dir_379784'
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_07_16_17_17_27527\Rtmpu8rx2q\parquet_ow_5cb8860f65752'
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_07_16_17_17_27527\Rtmpu8rx2q\parquet_ow_5cb8860f65752'
v caged_mov: 5 registros → 'caged_mov.parquet'
-- Done --
v 1 table exported
i Output: 'D:\temp\2026_10_07_16_17_17_27527\Rtmpu8rx2q\parquet_ow_5cb8860f65752'
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_07_16_17_17_27527\Rtmpu8rx2q\parquet_ow_5cb8860f65752'
i caged_mov: already exists, skipping. Use `overwrite = TRUE`.
-- Done --
v 0 tables exported
i Output: 'D:\temp\2026_10_07_16_17_17_27527\Rtmpu8rx2q\parquet_ow_5cb8860f65752'
[ 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_07_16_17_17_27527\Rtmpu8rx2q\caged_load_mock_5cb88143839ff.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_07_16_17_17_27527\Rtmpu8rx2q\caged_adj_mock_5cb8852501f92.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