annovarR (version 1.0.0)

del: Delete table or database (text file, sqlite, mysql)

Description

Delete table or database (text file, sqlite, mysql)

Usage

del(filename = "", sqlite.connect.params = list(),
  mysql.connect.params = list(), del.type = "database",
  db.type = "sqlite", verbose = FALSE, ...)

Arguments

filename

Path of text format data

sqlite.connect.params

Connect to sqlite database params [dbname, table.name]

mysql.connect.params

Mysql parameters, [host, dbname, table.name, user, password etc.]

del.type

file (for filename), database (for sqlite and MySQL), table (for sqlite and MySQL) be supported (delete file, delete sqlite db file, delete table in sqlite db, delete table in MySQL db and delete database in MySQL database)

db.type

txt, sqlite or mysql

verbose

Ligical indicating wheather show the log message

...

Other parameters be used in dbSendQuery

Examples

# NOT RUN {
db <- tempfile()
file.create(db)
del(db, del.type = 'file')
test.dat <- system.file('extdata', 'demo/sqlite.dat.txt', package = 'annovarR')
test.sqlite <- sprintf('%s/snp.test.sqlite', tempdir())
x <- sqlite.build(filename = test.dat, list(dbname = test.sqlite, 
table.name = 'snp_test'))
del(sqlite.connect.params = list(dbname = test.sqlite, 
table.name = 'snp_test'), del.type = 'table')
del(sqlite.connect.params = list(dbname = test.sqlite, 
table.name = 'snp_test'))
# }