helpers: Functions to facilitate the creation of 'poplite'\'s data...
In poplite: Tools for Simplifying the Population and Querying of SQLite Databases

Description Usage Arguments Value Author(s) See Also Examples

These functions facilitate the creation of TableSchemaList objects from existing or supplementary R data structures such as the data.frame.

1
2
3

makeSchemaFromData(tab.df, name=NULL,dta.func=NULL)
makeSchemaFromFunction(dta.func, name,...)
correct.df.names(tab.df)

`tab.df`	A `data.frame` representing a database table
`name`	Desired name of the database table
`dta.func`	An optional function which will take a specified object and turn it into a SQLite table. The function parameters should have the same names as the objects supplied to `populate`.
`...`	Arbitary objects provided to the function specified in `dta.func`. They should be of the same type and be named like the objects to be passed to `populate`.

`makeSchemaFromData`	A `TableSchemaList` object
`makeSchemaFromData`	A `TableSchemaList` object
`correct.df.names`	A `data.frame` with valid names for SQLite

Daniel Bottomly

TableSchemaList

  if (require(Lahman))
  { 
    franches <- makeSchemaFromData(TeamsFranchises, name="team_franch")
    show(franches)
    
    makeSchemaFromFunction(function(x) head(x),  name="team_franch", x=TeamsFranchises)

    test.df <- TeamsFranchises
    names(test.df)[1] <- "franch.ID"
    
    names(test.df)
    
    names(correct.df.names(test.df))
  }