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

In JhuangLab/annovarR: Integrated Framework to Annotate Genetic Variants

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

db <- tempfile()
file.create(db)
del(db, del.type = 'file')
test.dat <- system.file('extdata', 'demo/sqlite.dat.txt', package = 'anor')
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'))

JhuangLab/annovarR documentation built on April 23, 2020, 10:51 p.m.