sqliteReadTable: Fetch a full table from an SQLite database

In kevinrue/sqlighter: Wrappers and extensions to the RSQLite package

Description

Fetch a full table from an SQLite database

Usage

sqliteReadTable(table, file)

Arguments

table	Name of the database table to fetch.
file	Path to the SQLite database file

Value

The table as a data.frame.

Examples

# Setup ----

library(RSQLite)

database_file <- tempfile()
conn <- dbConnect(SQLite(), dbname = database_file)
dbWriteTable(conn, "mtcars", mtcars[1:5, ])
dbWriteTable(conn, "USArrests", USArrests[1:5, ])
dbDisconnect(conn)

# Example ----

sqliteReadTable("mtcars", database_file)

kevinrue/sqlighter documentation built on Nov. 16, 2020, 5:59 p.m.