1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
\name{saveCNEToSQLite-methods}
\docType{methods}
\alias{saveCNEToSQLite}
\title{
Save CNE to SQLite
}
\description{
This function saves the CNE results into a local SQLite database.
}
\usage{
saveCNEToSQLite(x, dbName, tableName=NULL, overwrite=FALSE)
}
\arguments{
\item{x}{
An object of \code{CNE}, with CNEFinal computed or
a \code{GRangePairs} object.
}
\item{dbName}{
\code{character}(1): the filename of the local SQLite database.
}
\item{tableName}{
\code{character}(1): the name of table for this CNE data table.
When it is NULL, the table name will be inferred from the assembly filenames
and scanning window/identity, in the format of "danRer10_hg38_49_50".
}
\item{overwrite}{
\code{boolean}(1):
whether or not to overwrite the existing table.
}
}
\details{
before loading into an SQLite database,
a bin indexing system is used to index the CNE range,
which provides faster SQL query.
}
\author{
Ge Tan
}
\examples{
dbName <- tempfile()
data(cneFinalListDanRer10Hg38)
tableNames <- paste("danRer10", "hg38", names(cneFinalListDanRer10Hg38),
sep="_")
for(i in 1:length(cneFinalListDanRer10Hg38)){
saveCNEToSQLite(cneFinalListDanRer10Hg38[[i]], dbName, tableNames[i],
overwrite=TRUE)
}
}
|
