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

In annovarR: Integrated Framework to Annotate Genetic Variants

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

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)

annovarR documentation built on Jan. 9, 2018, 5:05 p.m.