gddMatch: Build matches using basic pattern matching.

In EarthCubeGeochron/geodiveR: Utilities For GeoDeepDive In R

Description

A wrapper for the DBI::dbGetQuery() that provides support for basic pattern matching.

Usage

gddMatch(con, name, table, col, pattern, rows = FALSE, paper = FALSE)

Arguments

con	A database connection to the GDD database.
name	The name used to identify the query.
table	The table of interest.
col	The table column.
pattern	A Postgres-compliant (and case-sensitive) regex pattern. https://www.postgresql.org/docs/9.3/static/functions-matching.html.
rows	Do you want to return the explicit rows (default is FALSE)?
paper	Is the analysis at the sentence level or at the level of the paper? (default FALSE)

Examples

## Not run: 
library(geodiveR)
library(DBI)
  con <- dbConnect(drv = "PostgreSQL",
                   user = "postgres",
                   password = "postgres",
                   host = "localhost",
                   port = "5432",
                   dbname = "deepdive")

 july_sent <- gddMatch(con = con,
                       table = 'sentences',
                       col = 'words',
                       pattern = 'July',
                       name = "JulyQuery")

## End(Not run)

EarthCubeGeochron/geodiveR documentation built on May 25, 2019, 8:29 p.m.