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

In JhuangLab/annovarR: Integrated Framework to Annotate Genetic Variants

Description

Generate search index of anor 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 = 'anor')
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)

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