sqlite.head: Show top n line of table of database in sqlite database

In JhuangLab/annovarR: Integrated Framework to Annotate Genetic Variants

Description

Show top n line of table of database in sqlite database

Usage

sqlite.head(
  sqlite.connect.params = list(dbname = "", table.name = ""),
  n = 10,
  extra.sql = NULL,
  verbose = FALSE,
  ...
)

Arguments

sqlite.connect.params	Connect to sqlite database params [dbname, table.name]
n	n lines will be selected
extra.sql	Extra sql statement
verbose	Ligical indicating wheather show the log message
...	Other parameters pass to dbGetQuery

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'))
sqlite.head(list(dbname = test.sqlite, table.name = 'snp_test'))

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