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

Description Usage Arguments Examples

View source: R/get.R

Description

Show top n line of table of database in sqlite database

Usage

1
2
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

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

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