sqlite_master_to_df: Transform sqlite_master table to a dataframe.

In f-hafner/magutils: Utilities for loading data from MAG-Proquest database

Transform sqlite_master table to a dataframe.

Description

This is a wrapper to query sqlite_master from the sqlite database.

Usage

sqlite_master_to_df(conn, temp = FALSE)

Arguments

conn	An object of class SQLiteConnection to a sqlite database.
temp	Should sqlite_temp_master be queried, instead of sqlite_master? Default is FALSE. This can be useful when looking for temporary tables and indexes on them.

Value

A dataframe with type, name, tbl_name and sql statement from sqlite_master.

Examples

conn <- connect_to_db(db_example("AcademicGraph.sqlite"))
dplyr::glimpse(sqlite_master_to_df(conn))

f-hafner/magutils documentation built on Sept. 20, 2023, 5:05 a.m.