mkCreateTableString: Generate the SQL code for the CREATE TABLE command to...

In duncantl/RSQLiteVirtualTable: Create virtual tables from R Objects that can be used directly in an SQLite database

Generate the SQL code for the CREATE TABLE command to represent an R data frame

Description

This is a function that is called by the C code in this package when the virtual table for a data frame is being created. This maps the type of each column to its SQL equivalent.

Usage

mkCreateTableString(df, tableName = "tt")

Arguments

df	the R data frame
tableName	the name of the SQL table.

Value

A character string containing the SQL code for the CREATE TABLE command.

Author(s)

Duncan Temple Lang

References

https://www.sqlite.org/vtab.html

See Also

rsqliteVTable

Examples

data(mtcars)
mkCreateTableString(mtcars)

duncantl/RSQLiteVirtualTable documentation built on Nov. 23, 2023, 4:23 p.m.