After you use create_cidr_lookup_table() and create_ip_source_table() use this function to do the lookup.

find_ips_in_cidrs(pgcon, ip_tbl, cidr_tbl, ip_col = "ip", cidr_col = "cidr")

Arguments

pgcon

a PostgreSQL DBI connection

ip_tbl

name of the IP table (valid PG table name syntax)

cidr_tbl

name of the CIDR table (valid PG table name syntax)

ip_col

Name of the column that holds the IP addresses in ip_tbl

cidr_col

Name of the column that holds the CIDR block in cidr_tbl

Examples

if (FALSE) {
DBI::dbConnect(
  odbc::odbc(),
  driver = "/usr/local/lib/psqlodbca.so",
  Database = "working",
  Host = "localhost"
) -> con

create_cidr_lookup_table(
  pgcon = con,
  tbl_name = "amazon_cidrs",
  drop = TRUE,
  xdf = system.file("extdat", "amzn-cidrs.csv", package = "pgcidr"),
)

create_ip_source_table(
  pgcon = con,
  tbl_name = "weblog",
  drop = TRUE,
  xdf = system.file("extdat", "weblog.csv", package = "pgcidr")
)

find_ips_in_cidrs(
  con, "weblog", "amazon_cidrs"
)

}