3 ######################################################################
4 ## Test 'filehashRDS' class
6 dbCreate("mydbRDS", "RDS")
7 db <- dbInit("mydbRDS", "RDS")
10 ## Put some data into it
12 dbInsert(db, "a", 1:10)
13 dbInsert(db, "b", rnorm(100))
14 dbInsert(db, "c", 100:1)
15 dbInsert(db, "d", runif(1000))
16 dbInsert(db, "other", "hello")
40 tryCatch(print(env$c), error = function(e) cat(as.character(e)))
41 tryCatch(dbFetch(db, "c"), error = function(e) cat(as.character(e)))
43 ## Check trailing '/' problem
44 dbCreate("testRDSdb", "RDS")
45 db <- dbInit("testRDSdb/", "RDS")
48 ######################################################################
49 ## test filehashDB1 class
51 dbCreate("mydb", "DB1")
52 db <- dbInit("mydb", "DB1")
54 ## Put some data into it
56 dbInsert(db, "a", 1:10)
57 dbInsert(db, "b", rnorm(100))
58 dbInsert(db, "c", 100:1)
59 dbInsert(db, "d", runif(1000))
60 dbInsert(db, "other", "hello")
81 tryCatch(print(env$c), error = function(e) cat(as.character(e)))
82 tryCatch(dbFetch(db, "c"), error = function(e) cat(as.character(e)))
85 dbInsert(db, "numbers", numbers)
86 b <- dbFetch(db, "numbers")
87 stopifnot(all.equal(numbers, b))
88 stopifnot(identical(numbers, b))
90 ################################################################################
96 dbCreate("testLoadingDB", "DB1")
97 db <- dbInit("testLoadingDB", "DB1")
104 dbLoad(db) ## 'a', 'b'
109 db <- dbInit("testLoadingDB", "DB1")
118 ################################################################################
119 ## Check dbReorganize
121 dbCreate("test_reorg", "DB1")
122 db <- dbInit("test_reorg", "DB1")
129 dbInsert(db, "b", rnorm(1000))
130 dbInsert(db, "b", rnorm(1000))
131 dbInsert(db, "b", rnorm(1000))
132 dbInsert(db, "b", rnorm(1000))
133 dbInsert(db, "c", runif(1000))
134 dbInsert(db, "c", runif(1000))
135 dbInsert(db, "c", runif(1000))
136 dbInsert(db, "c", runif(1000))
141 print(file.info(db@datafile)$size)
145 db <- dbInit("test_reorg", "DB1")
147 print(file.info(db@datafile)$size)
153 ################################################################################
154 ## Taken from the vignette
163 dbInsert(db, "a", rnorm(100))
164 value <- dbFetch(db, "a")
167 dbInsert(db, "b", 123)
174 ################################################################################
177 db <- createQ("testq")