make.db.names-methods {RSQLite} | R Documentation

## Make R/S-Plus identifiers into legal SQL identifiers

### Description

These methods are straight-forward implementations of the corresponding generic functions.

### Methods

dbObj
  any SQLite object (e.g., `SQLiteDriver`).
snames
  a character vector of R/S-Plus identifiers (symbols) from which we need to make SQL identifiers.
name
  a character vector of SQL identifiers we want to check against keywords from the DBMS.
unique
  logical describing whether the resulting set of SQL names should be unique. Its default is `TRUE`. Following the SQL 92 standard, uniqueness of SQL identifiers is determined regardless of whether letters are upper or lower case.
allow.keywords
  logical describing whether SQL keywords should be allowed in the resulting set of SQL names. Its default is `TRUE`
keywords
  a character vector with SQL keywords, namely `.SQL92Keywords` defined in the `DBI` package.
case
  a character string specifying whether to make the comparison as lower case, upper case, or any of the two. it defaults to `any`.
...
  currently not used.

### References

The set of SQL keywords is stored in the character vector `.SQL92Keywords` and reflects the SQL ANSI/ISO standard as documented in "X/Open SQL and RDA", 1994, ISBN 1-872630-68-8. Users can easily override or update this vector.

SQLite does not add keywords to the SQL 92 standard.

See the Database Interface definition document `DBI.pdf` in the base directory of this package or http://developer.r-project.org/db.

### See Also

`SQLite`, `dbReadTable`, `dbWriteTable`, `dbExistsTable`, `dbRemoveTable`, `dbListTables`.

### Examples

    # This example shows how we could export a bunch of data.frames
    # into tables on a remote database.

    con <- dbConnect("SQLite", dbname = "sqlite.db")

    export <- c("trantime.email", "trantime.print", "round.trip.time.email")
    tabs <- make.db.names(export, unique = T, allow.keywords = T)

    for(i in seq(along = export) )
       dbWriteTable(con, name = tabs[i],  get(export[i]))

[Package Contents]