| Line 33... |
Line 33... |
| 33 |
Column names correspond exactly to the variable names of the ordinary data frames. E.g.
|
33 |
Column names correspond exactly to the variable names of the ordinary data frames. E.g.
|
| 34 |
Petal.Length will have a column name Petal.Length in the table. This is possible
|
34 |
Petal.Length will have a column name Petal.Length in the table. This is possible
|
| 35 |
because SQLite allows almost any kind of column name as long as it is quoted by
|
35 |
because SQLite allows almost any kind of column name as long as it is quoted by
|
| 36 |
square brakets ([ ]). You're on your own if you try to be a smartass on this. Also,
|
36 |
square brakets ([ ]). You're on your own if you try to be a smartass on this. Also,
|
| 37 |
an extra column named \emph{row name} (with the space between the words), of type
|
37 |
an extra column named \emph{row name} (with the space between the words), of type
|
| 38 |
text is used to store the data frame row names is set as the table's primary key.
|
38 |
text is used to store the data frame row names and is set as the table's primary key.
|
| 39 |
So please don't use \emph{row name} as a variable name.}
|
39 |
So please don't use \emph{row name} as a variable name.}
|
| 40 |
\item{[factor <colname>] and [ordered <colname>]}{stores the levels and level labels
|
40 |
\item{[factor <colname>] and [ordered <colname>]}{stores the levels and level labels
|
| 41 |
for each factor variable in the SDF. One such table will be created for every
|
41 |
for each factor variable in the SDF. One such table will be created for every
|
| 42 |
factor or ordered var, even if two variables share the same level labels. Besides
|
42 |
factor or ordered var, even if two variables share the same level labels. Besides
|
| 43 |
storing the level data, it is used to mark a column as being a factor.}
|
43 |
storing the level data, it is used to mark a column as being a factor.}
|
| Line 77... |
Line 77... |
| 77 |
name, or the default internal name if none is provided.
|
77 |
name, or the default internal name if none is provided.
|
| 78 |
}
|
78 |
}
|
| 79 |
\author{Miguel A. R. Manese}
|
79 |
\author{Miguel A. R. Manese}
|
| 80 |
\note{
|
80 |
\note{
|
| 81 |
The full path is used to avoid attaching the same db which may have different relative path
|
81 |
The full path is used to avoid attaching the same db which may have different relative path
|
| 82 |
after the user changes directory after loading SQLiteDF (see \code{attachSdf}.
|
82 |
after the user changes directory after loading SQLiteDF (see \code{attachSdf}).
|
| 83 |
}
|
83 |
}
|
| 84 |
\seealso{
|
84 |
\seealso{
|
| 85 |
\code{\link[SQLiteDF]{lsSdf}}
|
85 |
\code{\link[SQLiteDF]{lsSdf}}
|
| 86 |
\code{\link[SQLiteDF]{getSdf}}
|
86 |
\code{\link[SQLiteDF]{getSdf}}
|
| 87 |
\code{\link[SQLiteDF]{attachSdf}}
|
87 |
\code{\link[SQLiteDF]{attachSdf}}
|
The R Project SVN
R-packages