- Adds
ojo_eviction_cases
as a nice helper for users, and to version control our eviction identification methodology.
- Adds initial support for DuckDB
- Makes
{arrow}
and optional dependency and checks whether it is available whensource = "gcs"
is used inojo_tbl
.
- Adds initial support for Arrow.
- Uses
{lifecycle}
for function development status.
- Fixed bugs in
ojo_auth()
which prevented it from successfully backing up the.Renviron
file.
- Changed from Base R file paths to the
{fs}
package. - Adjusted GitHub Actions workflows to not run on draft PRs.
- Added spellcheck GitHub Actions.
- Changed SSL certs to all use
.pem
extensions
ojo_search_minutes()
now allows for queries that include a space. Postgres operators like|
,<->
, and!!
still work too; queries with spaces are now wrapped in quotes and treated as a single search string.ojo_crim_cases()
andojo_civ_cases()
were changed to make thecase_type
argument no longer case-sensitive. It also throws an error now when you ask for nonexistent values ofcase_type
.
- Fixed a bug related to the
rlang
package. - Removed
renv
from development environment in favor of package management using the DESCRIPTION file. This will only affect the development of the package going forward, and shouldn't affect analysts' use of the package.
- A fun loading message will now appear when the package is loaded. This can be disabled by setting
OJO_LOAD_MESSAGE=FALSE
in your local R environment. - The
{ojodb}
package now has its own tidyverse-compliant sticker design.
- The
ojo_list_
functions (ojo_list_schemas()
,ojo_list_tables()
, andojo_list_vars()
) now return a sorted list instead of an unsorted one. - Documentation and namespacing errors (e.g.
{dplyr}
functions missing an explicit.data
reference, missing namespace prefixes, etc.) were corrected. Consequently,devtools::check()
now passes with minimal warnings / notes.
- You can now use
ojo_collect
tocollect
but with a progress bar and helpful information.
- Added
ojo_version
function to return the version of the package. Useful for debugging.
- Exposed the
ojo_env
function to easily access the package-level environment where database connections are stored. - Changed the default behavior of
ojo_connect
to useDBI::dbConnect()
instead ofpool::dbPool()
. Connection pools are still available by passingpool = TRUE
toojo_connect
.
- You can now cancel queries immediately with
Ctrl + c
orCmd + c
in the console.
- Implemented schema scoping for
ojo_tbl
usingDBI::Id()
instead ofdbplyr::in_schema()
to match common practice.
- Allows lowercase inputs to the
district
argument ofojo_civ_cases
andojo_crim_cases
- You no longer need to import
{dplyr}
manually! - Database connections are handled for you by default. You won't even know it's there.
- Added Github Actions for automated package checks
- Added
{dplyr}
toDepends
field of the packageDescription
- Overhauled database connection management using package-level environment scoping. See
ojo_connect
,ojo_tbl
, andojo_query
for more information. - Replaced
{odbc}
dependency with{RPostgres}
- Add SQL file to create database roles
- Bump
{renv}
version to 0.17.0 - Add
docs/
folder to.gitignore
- Add
dontrun
to examples
- Fixed the
ojo_list_vars
function
- Removed direct class comparisons in favor of
inherits
- Added documentation for
ojo_add_issues
function - Removed improper data import and resulting hard dependency on
{readr}
- Added the
ojo_county_population
function, which will return the population for Oklahoma counties for the given years, in a format ready to join to OJO tables.
- Pruned as many dependencies as possible and moved many more to
Suggests
. - Added
person()
syntax toDESCRIPTION
.
- Added the function
ojo_fiscal_year
to return the fiscal year of a given Date. - Removed
ojo_table
alias for consistency and transparency.
- Added a
NEWS.md
file to track changes to the package. - Changed file name of png for portability.