# NOT RUN {
<!-- %% @test .port Database port number -->
<!-- %% @test .dbname Database name -->
## set up the database connection
## Assume that .port is port number and .dbname is the database name
cid <- db.connect(port = .port, dbname = .dbname, verbose = FALSE)
## create a table from the example data.frame "abalone"
x <- as.db.data.frame(abalone, conn.id = cid, verbose = FALSE)
## set sex to be a categorical variable
x$sex <- as.factor(x$sex)
is.factor(x$sex)
is.factor(x)
db.disconnect(cid, verbose = FALSE)
# }
Run the code above in your browser using DataLab