annovarR (version 1.0.0)

sqlite.index: Generate search index of annovarR database table in sqlite

Description

Generate search index of annovarR database table in sqlite

Usage

sqlite.index(sqlite.connect.params = list(dbname = "", table.name = ""),
  index = "", cols = c(), verbose = FALSE, ...)

Arguments

sqlite.connect.params

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

index

Index name in sqlite

cols

Colnames needed to be index

verbose

Ligical indicating wheather show the log message

...

Other parameters be used in dbSendQuery

Examples

# NOT RUN {
test.sqlite <- sprintf('%s/snp.test.sqlite', tempdir())
test.dat <- system.file('extdata', 'demo/sqlite.dat.txt', package = 'annovarR')
x <- sqlite.build(filename = test.dat, list(dbname = test.sqlite, 
table.name = 'snp_test'))
x <- sqlite.index(list(dbname = test.sqlite, table.name = 'snp_test'), 
index = 'index4', cols = c('V1', 'V2'))
test.sqlite <- normalizePath(test.sqlite, '/')
file.remove(test.sqlite)
# }