| blob | 9c386e15755b4345c180ecd665d057eb992565e8 |
2 R version 2.6.2 (2008-02-08)
3 Copyright (C) 2008 The R Foundation for Statistical Computing
4 ISBN 3-900051-07-0
6 R is free software and comes with ABSOLUTELY NO WARRANTY.
7 You are welcome to redistribute it under certain conditions.
8 Type 'license()' or 'licence()' for distribution details.
10 R is a collaborative project with many contributors.
11 Type 'contributors()' for more information and
12 'citation()' on how to cite R or R packages in publications.
14 Type 'demo()' for some demos, 'help()' for on-line help, or
15 'help.start()' for an HTML browser interface to help.
16 Type 'q()' to quit R.
18 > library(filehash)
19 Simple key-value database (1.0-2 2007-11-05)
20 >
21 > ######################################################################
22 > ## Test 'filehashRDS' class
23 >
24 > dbCreate("mydbRDS", "RDS")
25 [1] TRUE
26 > db <- dbInit("mydbRDS", "RDS")
27 > show(db)
28 'filehashRDS' database 'mydbRDS'
29 >
30 > ## Put some data into it
31 > set.seed(1000)
32 > dbInsert(db, "a", 1:10)
33 > dbInsert(db, "b", rnorm(100))
34 > dbInsert(db, "c", 100:1)
35 > dbInsert(db, "d", runif(1000))
36 > dbInsert(db, "other", "hello")
37 >
38 > dbList(db)
39 [1] "a" "b" "c" "d" "other"
40 >
41 > dbExists(db, "e")
42 [1] FALSE
43 > dbExists(db, "a")
44 [1] TRUE
45 >
46 > env <- db2env(db)
47 > ls(env)
48 [1] "a" "b" "c" "d" "other"
49 >
50 > env$a
51 [1] 1 2 3 4 5 6 7 8 9 10
52 > env$b
53 [1] -0.44577826 -1.20585657 0.04112631 0.63938841 -0.78655436 -0.38548930
54 [7] -0.47586788 0.71975069 -0.01850562 -1.37311776 -0.98242783 -0.55448870
55 [13] 0.12138119 -0.12087232 -1.33604105 0.17005748 0.15507872 0.02493187
56 [19] -2.04658541 0.21315411 2.67007166 -1.22701601 0.83424733 0.53257175
57 [25] -0.64682496 0.60316126 -1.78384414 0.33494217 0.56097572 1.22093565
58 [31] -0.21145359 0.69942953 -0.70643668 -0.46515095 -1.76619861 0.18928860
59 [37] -0.36618068 1.05760118 -0.74162146 -1.34835905 -0.51730643 1.41173570
60 [43] 0.18546503 -0.04369144 -0.21591338 1.46377535 0.22966664 0.10762363
61 [49] -1.37810256 -0.96818288 0.25171138 -1.09469370 0.39764284 -0.99630200
62 [55] 0.10057801 0.95368028 -1.79032293 0.31170122 2.55398801 -0.86083776
63 [61] 0.54392844 -0.39233804 1.23544190 1.19608644 -0.49574690 -0.29434122
64 [67] -0.57349748 1.61920873 -0.95692767 0.04123712 -1.49831044 0.66095916
65 [73] 0.28545762 1.38886629 -0.15934361 -0.46091890 0.16843807 1.39549302
66 [79] 0.72842626 0.33508995 1.16927649 0.24796682 -0.35814947 1.38349332
67 [85] 0.41206917 -0.12300786 -0.06622931 -2.32249088 -1.04565650 2.05787502
68 [91] 1.97153237 -1.92099520 0.46212607 -0.16072406 -0.10421153 0.46783940
69 [97] 0.44392082 0.82855281 -0.38705012 2.01893816
70 > env$c
71 [1] 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83
72 [19] 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65
73 [37] 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47
74 [55] 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29
75 [73] 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11
76 [91] 10 9 8 7 6 5 4 3 2 1
77 > str(env$d)
78 num [1:1000] 0.0854 0.3317 0.5647 0.4989 0.4549 ...
79 > env$other
80 [1] "hello"
81 >
82 > env$b <- rnorm(100)
83 > mean(env$b)
84 [1] -0.02208835
85 >
86 > env$a[1:5] <- 5:1
87 > print(env$a)
88 [1] 5 4 3 2 1 6 7 8 9 10
89 >
90 > dbDelete(db, "c")
91 >
92 > tryCatch(print(env$c), error = function(e) cat(as.character(e)))
93 Error in dbFetch(db, key): unable to obtain value for key 'c'
94 > tryCatch(dbFetch(db, "c"), error = function(e) cat(as.character(e)))
95 Error in dbFetch(db, "c"): unable to obtain value for key 'c'
96 >
97 > ## Check trailing '/' problem
98 > dbCreate("testRDSdb", "RDS")
99 [1] TRUE
100 > db <- dbInit("testRDSdb/", "RDS")
101 > print(db)
102 'filehashRDS' database 'testRDSdb'
103 >
104 > ######################################################################
105 > ## test filehashDB1 class
106 >
107 > dbCreate("mydb", "DB1")
108 [1] TRUE
109 > db <- dbInit("mydb", "DB1")
110 >
111 > ## Put some data into it
112 > set.seed(1000)
113 > dbInsert(db, "a", 1:10)
114 > dbInsert(db, "b", rnorm(100))
115 > dbInsert(db, "c", 100:1)
116 > dbInsert(db, "d", runif(1000))
117 > dbInsert(db, "other", "hello")
118 >
119 > dbList(db)
120 [1] "a" "b" "other" "c" "d"
121 >
122 > env <- db2env(db)
123 > ls(env)
124 [1] "a" "b" "c" "d" "other"
125 >
126 > env$a
127 [1] 1 2 3 4 5 6 7 8 9 10
128 > env$b
129 [1] -0.44577826 -1.20585657 0.04112631 0.63938841 -0.78655436 -0.38548930
130 [7] -0.47586788 0.71975069 -0.01850562 -1.37311776 -0.98242783 -0.55448870
131 [13] 0.12138119 -0.12087232 -1.33604105 0.17005748 0.15507872 0.02493187
132 [19] -2.04658541 0.21315411 2.67007166 -1.22701601 0.83424733 0.53257175
133 [25] -0.64682496 0.60316126 -1.78384414 0.33494217 0.56097572 1.22093565
134 [31] -0.21145359 0.69942953 -0.70643668 -0.46515095 -1.76619861 0.18928860
135 [37] -0.36618068 1.05760118 -0.74162146 -1.34835905 -0.51730643 1.41173570
136 [43] 0.18546503 -0.04369144 -0.21591338 1.46377535 0.22966664 0.10762363
137 [49] -1.37810256 -0.96818288 0.25171138 -1.09469370 0.39764284 -0.99630200
138 [55] 0.10057801 0.95368028 -1.79032293 0.31170122 2.55398801 -0.86083776
139 [61] 0.54392844 -0.39233804 1.23544190 1.19608644 -0.49574690 -0.29434122
140 [67] -0.57349748 1.61920873 -0.95692767 0.04123712 -1.49831044 0.66095916
141 [73] 0.28545762 1.38886629 -0.15934361 -0.46091890 0.16843807 1.39549302
142 [79] 0.72842626 0.33508995 1.16927649 0.24796682 -0.35814947 1.38349332
143 [85] 0.41206917 -0.12300786 -0.06622931 -2.32249088 -1.04565650 2.05787502
144 [91] 1.97153237 -1.92099520 0.46212607 -0.16072406 -0.10421153 0.46783940
145 [97] 0.44392082 0.82855281 -0.38705012 2.01893816
146 > env$c
147 [1] 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83
148 [19] 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65
149 [37] 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47
150 [55] 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29
151 [73] 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11
152 [91] 10 9 8 7 6 5 4 3 2 1
153 > str(env$d)
154 num [1:1000] 0.0854 0.3317 0.5647 0.4989 0.4549 ...
155 > env$other
156 [1] "hello"
157 >
158 > env$b <- rnorm(100)
159 > mean(env$b)
160 [1] -0.02208835
161 >
162 > env$a[1:5] <- 5:1
163 > print(env$a)
164 [1] 5 4 3 2 1 6 7 8 9 10
165 >
166 > dbDelete(db, "c")
167 >
168 > tryCatch(print(env$c), error = function(e) cat(as.character(e)))
169 Error in readSingleKey(con, map, key): unable to obtain value for key 'c'
170 > tryCatch(dbFetch(db, "c"), error = function(e) cat(as.character(e)))
171 Error in readSingleKey(con, map, key): unable to obtain value for key 'c'
172 >
173 > numbers <- rnorm(100)
174 > dbInsert(db, "numbers", numbers)
175 > b <- dbFetch(db, "numbers")
176 > stopifnot(all.equal(numbers, b))
177 > stopifnot(identical(numbers, b))
178 >
179 >
180 >
181 >
182 > ######################################################################
183 > ######################################################################
184 > ## Test everything on all database formats
185 >
186 > types <- c("DB1", "RDS")
187 > set.seed(1000)
188 >
189 > for(type in types) {
190 + cat("-----------------\n")
191 + cat("-----------------\n")
192 + cat("TESTING TYPE", type, "\n")
193 + cat("-----------------\n")
194 + cat("-----------------\n")
195 +
196 + name <- paste("mydb", type, sep = "")
197 + dbCreate(name, type)
198 + db <- dbInit(name, type)
199 +
200 + dbInsert(db, "a", 1:10) ## integer
201 + dbInsert(db, "b", rnorm(100)) ## numeric
202 + dbInsert(db, "c", 100:1) ## integer
203 + dbInsert(db, "d", runif(1000)) ## numeric
204 + dbInsert(db, "other", "hello") ## character
205 +
206 + ## Use extractor/replacement methods
207 + db$list <- as.list(1:100)
208 + db$dataf <- data.frame(x = rnorm(2000), y = rnorm(2000), z = rnorm(2000))
209 +
210 + show(db)
211 +
212 + str(db$dataf)
213 + str(db$list)
214 + print(db$d)
215 + print(db$a)
216 + print(db$b)
217 + print(db$c)
218 + print(db$other)
219 +
220 + env <- db2env(db)
221 + ls(env)
222 +
223 + print(env$a)
224 + print(env$b)
225 + print(env$c)
226 + str(env$d)
227 + print(env$other)
228 +
229 + env$b <- rnorm(100)
230 + mean(env$b)
231 +
232 + env$a[1:5] <- 5:1
233 + print(env$a)
234 +
235 + with(db, print(mean(b)))
236 +
237 + r <- lapply(db, summary)
238 + str(r)
239 +
240 + dbDelete(db, "c")
241 +
242 + tryCatch(print(env$c), error = function(e) cat(as.character(e)))
243 + tryCatch(dbFetch(db, "c"), error = function(e) cat(as.character(e)))
244 +
245 + numbers <- rnorm(100)
246 + dbInsert(db, "numbers", numbers)
247 + b <- dbFetch(db, "numbers")
248 + stopifnot(all.equal(numbers, b))
249 + stopifnot(identical(numbers, b))
250 + }
251 -----------------
252 -----------------
253 TESTING TYPE DB1
254 -----------------
255 -----------------
256 'filehashDB1' database 'mydbDB1'
257 'data.frame': 2000 obs. of 3 variables:
258 $ x: num -0.151 -0.105 0.759 -1.243 -0.590 ...
259 $ y: num 0.523 0.198 -1.162 1.067 1.275 ...
260 $ z: num 1.616 -1.061 0.296 -0.315 -0.267 ...
261 List of 100
262 $ : int 1
263 $ : int 2
264 $ : int 3
265 $ : int 4
266 $ : int 5
267 $ : int 6
268 $ : int 7
269 $ : int 8
270 $ : int 9
271 $ : int 10
272 $ : int 11
273 $ : int 12
274 $ : int 13
275 $ : int 14
276 $ : int 15
277 $ : int 16
278 $ : int 17
279 $ : int 18
280 $ : int 19
281 $ : int 20
282 $ : int 21
283 $ : int 22
284 $ : int 23
285 $ : int 24
286 $ : int 25
287 $ : int 26
288 $ : int 27
289 $ : int 28
290 $ : int 29
291 $ : int 30
292 $ : int 31
293 $ : int 32
294 $ : int 33
295 $ : int 34
296 $ : int 35
297 $ : int 36
298 $ : int 37
299 $ : int 38
300 $ : int 39
301 $ : int 40
302 $ : int 41
303 $ : int 42
304 $ : int 43
305 $ : int 44
306 $ : int 45
307 $ : int 46
308 $ : int 47
309 $ : int 48
310 $ : int 49
311 $ : int 50
312 $ : int 51
313 $ : int 52
314 $ : int 53
315 $ : int 54
316 $ : int 55
317 $ : int 56
318 $ : int 57
319 $ : int 58
320 $ : int 59
321 $ : int 60
322 $ : int 61
323 $ : int 62
324 $ : int 63
325 $ : int 64
326 $ : int 65
327 $ : int 66
328 $ : int 67
329 $ : int 68
330 $ : int 69
331 $ : int 70
332 $ : int 71
333 $ : int 72
334 $ : int 73
335 $ : int 74
336 $ : int 75
337 $ : int 76
338 $ : int 77
339 $ : int 78
340 $ : int 79
341 $ : int 80
342 $ : int 81
343 $ : int 82
344 $ : int 83
345 $ : int 84
346 $ : int 85
347 $ : int 86
348 $ : int 87
349 $ : int 88
350 $ : int 89
351 $ : int 90
352 $ : int 91
353 $ : int 92
354 $ : int 93
355 $ : int 94
356 $ : int 95
357 $ : int 96
358 $ : int 97
359 $ : int 98
360 $ : int 99
361 $ : int 100
362 [1] 0.0854352312 0.3316667471 0.5647474113 0.4988875357 0.4549256244
363 [6] 0.3444632683 0.8050380212 0.5526374415 0.5511888175 0.7088424857
364 [11] 0.5765092573 0.6338055327 0.6516049723 0.5544591143 0.0129555443
365 [16] 0.4392611873 0.8477273071 0.1352571349 0.8855990036 0.8185912033
366 [21] 0.7735210934 0.3778223174 0.3861684878 0.3591320706 0.4100315070
367 [26] 0.5909395602 0.4481065569 0.8411005267 0.9652063434 0.6147267120
368 [31] 0.3106476567 0.2117491271 0.6132038878 0.6070439217 0.0673663057
369 [36] 0.2224709834 0.9476418942 0.3744519060 0.5934468687 0.8299442150
370 [41] 0.7153775131 0.9439060055 0.3736372874 0.0090909339 0.6766091336
371 [46] 0.8933530806 0.8572066391 0.7297727927 0.6272155368 0.7850897417
372 [51] 0.2507421058 0.8008506845 0.2022370566 0.4918040764 0.0911277412
373 [56] 0.5406048116 0.5883122159 0.3250015129 0.2496413526 0.7463861406
374 [61] 0.3047467875 0.2039074083 0.7866609362 0.4283743554 0.8506583921
375 [66] 0.0192040738 0.5718160812 0.8128366023 0.4970834465 0.5690444799
376 [71] 0.3037259362 0.1359403688 0.8684922687 0.3461252903 0.0689221087
377 [76] 0.5471815197 0.0821542267 0.2361435546 0.5385908810 0.6602703035
378 [81] 0.6015333275 0.7988281474 0.6884819551 0.8691610752 0.2080122896
379 [86] 0.5278386013 0.8151805329 0.3296346162 0.1184773815 0.6719716969
380 [91] 0.3619973769 0.3558653591 0.8893864034 0.1893253904 0.9557033733
381 [96] 0.1533113683 0.5132960051 0.9383841609 0.7615170551 0.1011696639
382 [101] 0.1704297124 0.4408224842 0.7873878591 0.0541163238 0.5402572309
383 [106] 0.7654479912 0.9092930253 0.8010619704 0.4885069500 0.6556037692
384 [111] 0.0343017397 0.7327473771 0.1590065490 0.3124339830 0.6217819755
385 [116] 0.0879779919 0.5521404501 0.2816009752 0.1403129981 0.0085281907
386 [121] 0.5737429049 0.8742344230 0.8223076670 0.0732984487 0.9770625748
387 [126] 0.9809658446 0.3828808407 0.6118004131 0.3332487843 0.9544811179
388 [131] 0.3798328359 0.1917859847 0.6585271070 0.8906781629 0.6786895625
389 [136] 0.2417491097 0.2658483454 0.8205738219 0.5012379275 0.6398877944
390 [141] 0.6412304998 0.7976637566 0.2216439412 0.6208319988 0.4295907994
391 [146] 0.0355515005 0.2070023373 0.0132593811 0.0967147979 0.6628242296
392 [151] 0.1153017625 0.2336622644 0.9715980461 0.7202959347 0.8893687541
393 [156] 0.7862257482 0.5916489705 0.8629492191 0.4259699073 0.6684449837
394 [161] 0.9539104549 0.2908537900 0.8477931530 0.6875390320 0.9327072632
395 [166] 0.2534178093 0.8670040902 0.7824801693 0.6920940259 0.5045849117
396 [171] 0.5193294226 0.7420272219 0.3015756910 0.4670909126 0.7946272672
397 [176] 0.1273778491 0.8648307470 0.6916326554 0.3478335682 0.9718916803
398 [181] 0.3588273618 0.5884457384 0.1226242380 0.3932015731 0.2384131299
399 [186] 0.1936495516 0.6364444343 0.1142622838 0.6654437815 0.1754562722
400 [191] 0.9516279118 0.9634985465 0.7195864585 0.9403487807 0.5570387216
401 [196] 0.8039627410 0.6343147671 0.9263033413 0.1757997628 0.5891879704
402 [201] 0.8207679223 0.2093629048 0.7674316594 0.6709972240 0.0462589560
403 [206] 0.7536007944 0.4077833125 0.3725291463 0.2547819251 0.3900080617
404 [211] 0.4696105367 0.0860889144 0.5619618907 0.1625430319 0.4623443473
405 [216] 0.7724219218 0.8314257013 0.8469363297 0.2628740615 0.2816950411
406 [221] 0.4295042739 0.7315676087 0.7888013560 0.0459240410 0.4447637091
407 [226] 0.0118214316 0.0195731085 0.7234098569 0.2365296890 0.8270309425
408 [231] 0.0515375226 0.3036282507 0.4821176352 0.5973966757 0.3068439227
409 [236] 0.6236403508 0.3423592087 0.9600423055 0.3207409706 0.0914225986
410 [241] 0.0641806035 0.9719074157 0.2127341654 0.7938381573 0.0489972748
411 [246] 0.0180059520 0.7526714944 0.7397932671 0.9138100340 0.7792744155
412 [251] 0.5049637528 0.1644733048 0.0655883509 0.3560164163 0.6953833695
413 [256] 0.0447414094 0.8006531117 0.6320148823 0.2997210142 0.0439242697
414 [261] 0.1952924696 0.6874526374 0.2036105136 0.3229785929 0.9773665196
415 [266] 0.7790756056 0.0263116008 0.6080571972 0.2699623469 0.6614044646
416 [271] 0.6320176723 0.8589296017 0.6528968541 0.3123495113 0.1797682215
417 [276] 0.2786002597 0.9822677225 0.6038638630 0.1758801553 0.8005028947
418 [281] 0.2114984063 0.0858763668 0.7656367049 0.7718884652 0.4855243512
419 [286] 0.0414698303 0.7609126284 0.9777074000 0.4803093681 0.0654509212
420 [291] 0.5440346119 0.4789234861 0.6863103597 0.1908400867 0.6803376900
421 [296] 0.0006929785 0.5442034160 0.0766114877 0.1419466236 0.2347743947
422 [301] 0.7238253308 0.9576701631 0.4543517926 0.7059831570 0.7191401061
423 [306] 0.3228020610 0.8198205424 0.0954776362 0.3593949955 0.8190381036
424 [311] 0.7268849269 0.7803967961 0.2670598086 0.1003152174 0.5920364822
425 [316] 0.9535639407 0.0354446841 0.7793172617 0.8545019156 0.3968923823
426 [321] 0.2585781724 0.9904418630 0.0905639562 0.3527191631 0.3604609950
427 [326] 0.6451110078 0.9811036622 0.0481594517 0.9701380169 0.5283703289
428 [331] 0.5519234650 0.7353968294 0.5638858816 0.6871426962 0.7703703393
429 [336] 0.7517527805 0.9539787367 0.8229940562 0.6145059988 0.9720121073
430 [341] 0.0819533400 0.9670719153 0.7648337588 0.7015651448 0.8054000882
431 [346] 0.0080709192 0.3221653125 0.1830257948 0.4139989030 0.4308542225
432 [351] 0.2407666065 0.1700461204 0.4074939641 0.1738993591 0.3330566748
433 [356] 0.1016531242 0.2796280992 0.2709083683 0.8289768139 0.7807363898
434 [361] 0.6748670822 0.6857043167 0.8553620819 0.6040103612 0.2030963395
435 [366] 0.1800023715 0.4235784069 0.5882171560 0.8655402400 0.4408006563
436 [371] 0.9626049192 0.3317427998 0.9532335128 0.4185730324 0.1108705867
437 [376] 0.0329201943 0.9790936091 0.7837962946 0.3876142679 0.0460715906
438 [381] 0.1457201717 0.0149701789 0.3081410916 0.8783646198 0.3079671494
439 [386] 0.9898699357 0.0375891053 0.4024047698 0.0705146135 0.7489526528
440 [391] 0.4257817222 0.1340571239 0.3799437166 0.3850573602 0.5260431133
441 [396] 0.9946615503 0.3734488764 0.6456703506 0.3164920341 0.7976555002
442 [401] 0.7352730806 0.2385597094 0.1457986925 0.4186369595 0.5182549101
443 [406] 0.0275274655 0.4515226826 0.3505558167 0.8480949425 0.2145793817
444 [411] 0.2909131234 0.5906582521 0.0390370002 0.9426913820 0.1389254802
445 [416] 0.8266724544 0.1923252342 0.3257318228 0.1684314108 0.2977504851
446 [421] 0.5039621538 0.7208892675 0.9021799848 0.6685001268 0.0039136857
447 [426] 0.8576771810 0.5583138110 0.9670708936 0.5096680240 0.2892274330
448 [431] 0.3895423373 0.3333406949 0.2728205237 0.2188924926 0.4555648349
449 [436] 0.6553391237 0.1163466314 0.5448125298 0.9074992710 0.0298152859
450 [441] 0.3257353986 0.7430575022 0.7537619299 0.2800017863 0.9179969574
451 [446] 0.8355729589 0.0735012020 0.2533329199 0.7303299438 0.2981674217
452 [451] 0.8150366510 0.8985516187 0.7234929244 0.4883427636 0.5441877334
453 [456] 0.7992766229 0.9457735464 0.1032690667 0.3215785408 0.3732553010
454 [461] 0.0347593988 0.8252921794 0.9830590878 0.2532411763 0.6775159845
455 [466] 0.4862605091 0.2406161099 0.2631505111 0.8040039828 0.2892458690
456 [471] 0.3025672073 0.7968714333 0.7192492662 0.4289734182 0.4719925392
457 [476] 0.3119352811 0.8451098776 0.6488574436 0.8040351805 0.2654021005
458 [481] 0.3027630080 0.0869889327 0.2321292653 0.0507496784 0.8388996907
459 [486] 0.1130708903 0.4318675338 0.5239880860 0.8144197082 0.2161642176
460 [491] 0.7323912797 0.8446405516 0.6537595713 0.8712930423 0.7551817757
461 [496] 0.2901879696 0.1939961775 0.0983964135 0.3415141217 0.0296060217
462 [501] 0.3419971652 0.6503933801 0.0748852962 0.8605450471 0.1571344656
463 [506] 0.1887570808 0.7576830366 0.0714583180 0.3233700737 0.1208202201
464 [511] 0.5380740401 0.9564977505 0.9419561021 0.1090860052 0.2285546663
465 [516] 0.9963642778 0.2298582380 0.0975702845 0.7035056413 0.9842570503
466 [521] 0.3569286377 0.3015958937 0.3895906953 0.2380308525 0.2488219438
467 [526] 0.9800336501 0.4585187782 0.8938138490 0.1189431725 0.8857695800
468 [531] 0.1927160893 0.8101867125 0.2378052713 0.0649456314 0.7560605207
469 [536] 0.1234873312 0.2528847668 0.9476029114 0.7739267193 0.4759166015
470 [541] 0.0947261450 0.3267775506 0.9194004834 0.5625763929 0.0323594145
471 [546] 0.9756423105 0.9311067001 0.4846838785 0.9793252479 0.4238566174
472 [551] 0.8377422900 0.2349773305 0.7701432975 0.5053263796 0.9239359791
473 [556] 0.4844491698 0.3508993087 0.2589112110 0.1597704703 0.3646460790
474 [561] 0.7475900007 0.7058701471 0.8157423614 0.1401913844 0.9235463929
475 [566] 0.3427820890 0.5146063566 0.1760889930 0.1120290062 0.9266372498
476 [571] 0.9583033400 0.8053163996 0.2423713985 0.5197267316 0.2694383045
477 [576] 0.0496993246 0.4409096546 0.2011047846 0.8902011416 0.4553314727
478 [581] 0.9520521543 0.3464248898 0.0436060198 0.7520235772 0.5329083584
479 [586] 0.7313639286 0.1021099496 0.3042955936 0.7861252504 0.5074641183
480 [591] 0.3586304744 0.9870025897 0.4115822825 0.9532517530 0.4849171927
481 [596] 0.3411332576 0.4139247441 0.5172836010 0.8949506874 0.3219827858
482 [601] 0.2556207215 0.1491172235 0.4304069611 0.9101897713 0.4799511041
483 [606] 0.7790202957 0.5275662753 0.0422722846 0.7002356409 0.4964175227
484 [611] 0.6652913033 0.1290123616 0.4827875162 0.5189846549 0.3571762985
485 [616] 0.9086360605 0.6039426562 0.7836822255 0.4751758946 0.0318603772
486 [621] 0.5102313648 0.5107342354 0.5846482925 0.7603435463 0.0814094299
487 [626] 0.8321765231 0.4539743254 0.6242030268 0.2005723445 0.5175452554
488 [631] 0.3809539329 0.3198872393 0.7025540809 0.6178590760 0.3124474047
489 [636] 0.5544444339 0.2063372848 0.5238685790 0.3628784136 0.1613642240
490 [641] 0.0075959007 0.0573183729 0.1169165524 0.2278120143 0.5935628293
491 [646] 0.2241717998 0.1511279496 0.5930031426 0.4141457465 0.2451946638
492 [651] 0.5760794657 0.6924065996 0.7109021416 0.3041037882 0.2836333169
493 [656] 0.1600129718 0.0915889635 0.6201357166 0.2340737116 0.9491414211
494 [661] 0.1756925227 0.6096907766 0.8182033012 0.2989584436 0.7232519772
495 [666] 0.1105760196 0.5282476158 0.5092515962 0.5271834801 0.9079475864
496 [671] 0.6996072175 0.1844833435 0.6382130643 0.7066280982 0.8712538329
497 [676] 0.1530769516 0.7463359560 0.2699001324 0.3570197572 0.3826778673
498 [681] 0.2972962959 0.9843541544 0.6077558650 0.1755171847 0.1352093879
499 [686] 0.4063974412 0.7478995656 0.5558586959 0.2263861697 0.0126794700
500 [691] 0.2901005549 0.1389400347 0.9320796148 0.0475984046 0.5628461416
501 [696] 0.2720442475 0.9447449397 0.6908432371 0.2182255771 0.4919997312
502 [701] 0.9467618710 0.1019515696 0.7065617426 0.5872676675 0.6340912464
503 [706] 0.3163621339 0.6310711422 0.3521876293 0.4714761286 0.1831269760
504 [711] 0.6619066098 0.9238610726 0.9735451241 0.4665582392 0.3185840535
505 [716] 0.1142864376 0.6636715743 0.8103113216 0.0838748340 0.2937777352
506 [721] 0.5355614389 0.7264555390 0.8886665201 0.9229308080 0.7426961048
507 [726] 0.1375928556 0.3184234947 0.7738670772 0.3294537566 0.7871285693
508 [731] 0.6893540674 0.7192982116 0.0418543415 0.7472859826 0.9205920796
509 [736] 0.4087732290 0.0727011841 0.6531351288 0.4997070064 0.2146235069
510 [741] 0.4459155630 0.8044290603 0.6166915977 0.9941799091 0.4862152496
511 [746] 0.4953292652 0.5165993867 0.0913195161 0.6078246285 0.5376315527
512 [751] 0.4618062801 0.8810779122 0.0888983789 0.6982162150 0.4417499681
513 [756] 0.4964880659 0.6073216074 0.4341369229 0.3438716887 0.0625396855
514 [761] 0.6388235714 0.3079331245 0.1904661991 0.1305323334 0.0749499649
515 [766] 0.1185142146 0.8675032833 0.6634250234 0.6302358527 0.8548378672
516 [771] 0.6937717278 0.1443915262 0.5778443413 0.0193092171 0.9564449457
517 [776] 0.5355743244 0.9566860006 0.2882841586 0.6840394926 0.4189503065
518 [781] 0.4596286889 0.5285673868 0.2941927824 0.1374698502 0.3767472948
519 [786] 0.5016612334 0.5891727076 0.6215043641 0.4548259024 0.7839942782
520 [791] 0.0263802579 0.6788966293 0.5443989269 0.5704419911 0.7521949538
521 [796] 0.5248809040 0.3480630890 0.9440991473 0.2252732227 0.6438856001
522 [801] 0.7554406156 0.9870325555 0.6513802321 0.3139407663 0.4623061167
523 [806] 0.7398230694 0.0256483222 0.1108805682 0.2528364020 0.1440067221
524 [811] 0.5048178870 0.0852029191 0.6631001893 0.3044339821 0.2362612060
525 [816] 0.3859201453 0.6656843482 0.7276345873 0.4936096617 0.8281120548
526 [821] 0.3088128071 0.6039635686 0.0554083253 0.8733986951 0.9451999043
527 [826] 0.9678990317 0.6999367608 0.2824048707 0.4292927734 0.0018944622
528 [831] 0.3416322565 0.3949416718 0.8408870571 0.2824994919 0.8928356601
529 [836] 0.8463543567 0.0620620567 0.3769223604 0.3300825139 0.6780334490
530 [841] 0.3357550295 0.6453575869 0.5698393541 0.2057345607 0.6610898443
531 [846] 0.7533315793 0.7409615032 0.7383066353 0.0225102720 0.2365964791
532 [851] 0.1766230382 0.5768224034 0.6362084085 0.3742553354 0.7561457893
533 [856] 0.4559300542 0.1716436436 0.4984405560 0.9366781039 0.4728337459
534 [861] 0.6516216532 0.1443418479 0.6428982851 0.1215503588 0.6630558625
535 [866] 0.0411749387 0.7797437450 0.8528050347 0.1165207725 0.9549038215
536 [871] 0.9703717094 0.8852239556 0.3594537440 0.1098882833 0.5432653688
537 [876] 0.0928524870 0.3546290307 0.5275352753 0.2289542800 0.3159632385
538 [881] 0.4961508620 0.5523079997 0.9251680013 0.8577218736 0.9011192177
539 [886] 0.9030264474 0.6918147507 0.8523223700 0.0604533993 0.8526742253
540 [891] 0.0163630696 0.5432671641 0.5092910314 0.2390526908 0.0828290198
541 [896] 0.8784414344 0.7134177159 0.0475412642 0.3985768629 0.0210510734
542 [901] 0.5116730989 0.3177091267 0.3282294406 0.2182018633 0.6205041243
543 [906] 0.5522109668 0.0570246326 0.7110546301 0.2984543515 0.2949080346
544 [911] 0.1179513838 0.4041150333 0.0769016445 0.4161153589 0.4674332815
545 [916] 0.5206705425 0.7556017707 0.9319027467 0.2061321011 0.0114199279
546 [921] 0.6030536226 0.3154445069 0.3751967507 0.9831246212 0.6444245589
547 [926] 0.9048293617 0.1293796808 0.5295402941 0.4142817655 0.3267794535
548 [931] 0.3642824588 0.1595846473 0.9722835252 0.7802280572 0.6741620130
549 [936] 0.8195988273 0.7583861838 0.3958937323 0.6675134310 0.4560652112
550 [941] 0.8010165973 0.8701125355 0.6646963777 0.0769015353 0.7817027550
551 [946] 0.2941636802 0.7643362358 0.1096932625 0.7303733265 0.5348280030
552 [951] 0.1250162788 0.5945668800 0.0585208272 0.5658478229 0.5842022174
553 [956] 0.8011143715 0.4090691071 0.8491941830 0.7920619480 0.3351711882
554 [961] 0.8448088020 0.9888757956 0.9761950527 0.5776879638 0.8625227255
555 [966] 0.7050706095 0.0755925649 0.2196378214 0.2892277052 0.5452344858
556 [971] 0.9666887717 0.8474882438 0.5169417318 0.0283452258 0.6194404990
557 [976] 0.2972792885 0.9111714733 0.8374701389 0.4085322623 0.8459324772
558 [981] 0.7503197831 0.5223434882 0.5549757613 0.3318467210 0.0420289545
559 [986] 0.9649427948 0.3220456387 0.6681591440 0.5475204238 0.1957228847
560 [991] 0.0003872991 0.8177040324 0.1350760681 0.5321858458 0.9053328328
561 [996] 0.5984349318 0.5402164215 0.6917448288 0.0577554428 0.8021184867
562 [1] 1 2 3 4 5 6 7 8 9 10
563 [1] -0.44577826 -1.20585657 0.04112631 0.63938841 -0.78655436 -0.38548930
564 [7] -0.47586788 0.71975069 -0.01850562 -1.37311776 -0.98242783 -0.55448870
565 [13] 0.12138119 -0.12087232 -1.33604105 0.17005748 0.15507872 0.02493187
566 [19] -2.04658541 0.21315411 2.67007166 -1.22701601 0.83424733 0.53257175
567 [25] -0.64682496 0.60316126 -1.78384414 0.33494217 0.56097572 1.22093565
568 [31] -0.21145359 0.69942953 -0.70643668 -0.46515095 -1.76619861 0.18928860
569 [37] -0.36618068 1.05760118 -0.74162146 -1.34835905 -0.51730643 1.41173570
570 [43] 0.18546503 -0.04369144 -0.21591338 1.46377535 0.22966664 0.10762363
571 [49] -1.37810256 -0.96818288 0.25171138 -1.09469370 0.39764284 -0.99630200
572 [55] 0.10057801 0.95368028 -1.79032293 0.31170122 2.55398801 -0.86083776
573 [61] 0.54392844 -0.39233804 1.23544190 1.19608644 -0.49574690 -0.29434122
574 [67] -0.57349748 1.61920873 -0.95692767 0.04123712 -1.49831044 0.66095916
575 [73] 0.28545762 1.38886629 -0.15934361 -0.46091890 0.16843807 1.39549302
576 [79] 0.72842626 0.33508995 1.16927649 0.24796682 -0.35814947 1.38349332
577 [85] 0.41206917 -0.12300786 -0.06622931 -2.32249088 -1.04565650 2.05787502
578 [91] 1.97153237 -1.92099520 0.46212607 -0.16072406 -0.10421153 0.46783940
579 [97] 0.44392082 0.82855281 -0.38705012 2.01893816
580 [1] 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83
581 [19] 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65
582 [37] 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47
583 [55] 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29
584 [73] 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11
585 [91] 10 9 8 7 6 5 4 3 2 1
586 [1] "hello"
587 [1] 1 2 3 4 5 6 7 8 9 10
588 [1] -0.44577826 -1.20585657 0.04112631 0.63938841 -0.78655436 -0.38548930
589 [7] -0.47586788 0.71975069 -0.01850562 -1.37311776 -0.98242783 -0.55448870
590 [13] 0.12138119 -0.12087232 -1.33604105 0.17005748 0.15507872 0.02493187
591 [19] -2.04658541 0.21315411 2.67007166 -1.22701601 0.83424733 0.53257175
592 [25] -0.64682496 0.60316126 -1.78384414 0.33494217 0.56097572 1.22093565
593 [31] -0.21145359 0.69942953 -0.70643668 -0.46515095 -1.76619861 0.18928860
594 [37] -0.36618068 1.05760118 -0.74162146 -1.34835905 -0.51730643 1.41173570
595 [43] 0.18546503 -0.04369144 -0.21591338 1.46377535 0.22966664 0.10762363
596 [49] -1.37810256 -0.96818288 0.25171138 -1.09469370 0.39764284 -0.99630200
597 [55] 0.10057801 0.95368028 -1.79032293 0.31170122 2.55398801 -0.86083776
598 [61] 0.54392844 -0.39233804 1.23544190 1.19608644 -0.49574690 -0.29434122
599 [67] -0.57349748 1.61920873 -0.95692767 0.04123712 -1.49831044 0.66095916
600 [73] 0.28545762 1.38886629 -0.15934361 -0.46091890 0.16843807 1.39549302
601 [79] 0.72842626 0.33508995 1.16927649 0.24796682 -0.35814947 1.38349332
602 [85] 0.41206917 -0.12300786 -0.06622931 -2.32249088 -1.04565650 2.05787502
603 [91] 1.97153237 -1.92099520 0.46212607 -0.16072406 -0.10421153 0.46783940
604 [97] 0.44392082 0.82855281 -0.38705012 2.01893816
605 [1] 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83
606 [19] 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65
607 [37] 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47
608 [55] 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29
609 [73] 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11
610 [91] 10 9 8 7 6 5 4 3 2 1
611 num [1:1000] 0.0854 0.3317 0.5647 0.4989 0.4549 ...
612 [1] "hello"
613 [1] 5 4 3 2 1 6 7 8 9 10
614 [1] 0.02281714
615 List of 7
616 $ a :Class 'table' Named num [1:6] 1 3.25 5.5 5.5 7.75 10
617 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
618 $ b :Class 'table' Named num [1:6] -2.3570 -0.6414 0.0420 0.0228 0.6593 ...
619 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
620 $ list : 'table' chr [1:100, 1:3] "1" "1" "1" "1" ...
621 ..- attr(*, "dimnames")=List of 2
622 .. ..$ : NULL
623 .. ..$ : chr [1:3] "Length" "Class" "Mode"
624 $ other:Class 'table' Named chr [1:3] "1" "character" "character"
625 .. ..- attr(*, "names")= chr [1:3] "Length" "Class" "Mode"
626 $ c :Class 'table' Named num [1:6] 1.0 25.8 50.5 50.5 75.2 ...
627 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
628 $ d :Class 'table' Named num [1:6] 0.000387 0.253300 0.506400 0.498500 0.749300 ...
629 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
630 $ dataf: 'table' chr [1:6, 1:3] "Min. :-3.18310 " "1st Qu.:-0.67523 " "Median :-0.00818 " "Mean :-0.00079 " ...
631 ..- attr(*, "dimnames")=List of 2
632 .. ..$ : chr [1:6] "" "" "" "" ...
633 .. ..$ : chr [1:3] " x" " y" " z"
634 Error in readSingleKey(con, map, key): unable to obtain value for key 'c'
635 Error in readSingleKey(con, map, key): unable to obtain value for key 'c'
636 -----------------
637 -----------------
638 TESTING TYPE RDS
639 -----------------
640 -----------------
641 database 'mydbRDS' already exists
642 'filehashRDS' database 'mydbRDS'
643 'data.frame': 2000 obs. of 3 variables:
644 $ x: num -1.639 -0.287 0.254 1.052 -0.911 ...
645 $ y: num 0.189 1.584 -1.001 -1.048 0.364 ...
646 $ z: num 1.074 -1.852 -0.528 -0.093 0.739 ...
647 List of 100
648 $ : int 1
649 $ : int 2
650 $ : int 3
651 $ : int 4
652 $ : int 5
653 $ : int 6
654 $ : int 7
655 $ : int 8
656 $ : int 9
657 $ : int 10
658 $ : int 11
659 $ : int 12
660 $ : int 13
661 $ : int 14
662 $ : int 15
663 $ : int 16
664 $ : int 17
665 $ : int 18
666 $ : int 19
667 $ : int 20
668 $ : int 21
669 $ : int 22
670 $ : int 23
671 $ : int 24
672 $ : int 25
673 $ : int 26
674 $ : int 27
675 $ : int 28
676 $ : int 29
677 $ : int 30
678 $ : int 31
679 $ : int 32
680 $ : int 33
681 $ : int 34
682 $ : int 35
683 $ : int 36
684 $ : int 37
685 $ : int 38
686 $ : int 39
687 $ : int 40
688 $ : int 41
689 $ : int 42
690 $ : int 43
691 $ : int 44
692 $ : int 45
693 $ : int 46
694 $ : int 47
695 $ : int 48
696 $ : int 49
697 $ : int 50
698 $ : int 51
699 $ : int 52
700 $ : int 53
701 $ : int 54
702 $ : int 55
703 $ : int 56
704 $ : int 57
705 $ : int 58
706 $ : int 59
707 $ : int 60
708 $ : int 61
709 $ : int 62
710 $ : int 63
711 $ : int 64
712 $ : int 65
713 $ : int 66
714 $ : int 67
715 $ : int 68
716 $ : int 69
717 $ : int 70
718 $ : int 71
719 $ : int 72
720 $ : int 73
721 $ : int 74
722 $ : int 75
723 $ : int 76
724 $ : int 77
725 $ : int 78
726 $ : int 79
727 $ : int 80
728 $ : int 81
729 $ : int 82
730 $ : int 83
731 $ : int 84
732 $ : int 85
733 $ : int 86
734 $ : int 87
735 $ : int 88
736 $ : int 89
737 $ : int 90
738 $ : int 91
739 $ : int 92
740 $ : int 93
741 $ : int 94
742 $ : int 95
743 $ : int 96
744 $ : int 97
745 $ : int 98
746 $ : int 99
747 $ : int 100
748 [1] 0.6387145407 0.0300150807 0.0124043636 0.3094322826 0.6135372985
749 [6] 0.2820592772 0.6598895253 0.9437998557 0.2766320356 0.0164247942
750 [11] 0.8432591564 0.5196172660 0.9261893067 0.6877312420 0.7048435996
751 [16] 0.4443689797 0.4490187347 0.1516726343 0.5236731027 0.0507931672
752 [21] 0.2836353467 0.5940655184 0.7199827081 0.2557071333 0.1448665122
753 [26] 0.9555982244 0.6560763945 0.4429272509 0.4870223799 0.9547431592
754 [31] 0.8303009698 0.4934785920 0.1038236348 0.9558885715 0.3886803559
755 [36] 0.5467246824 0.1309491789 0.5487137102 0.5254788210 0.5574899898
756 [41] 0.0187134307 0.4441799785 0.1501867296 0.0200309195 0.8426052041
757 [46] 0.8586024581 0.0738435811 0.2812543779 0.8564886525 0.1052593288
758 [51] 0.9517018918 0.9323833983 0.3649808273 0.8682014141 0.9440094426
759 [56] 0.2116835362 0.3244568158 0.5914930596 0.1831775061 0.1138817070
760 [61] 0.4488661815 0.6877160412 0.4686476011 0.8824504698 0.6571975714
761 [66] 0.2075113871 0.8147176304 0.7985334140 0.3266832035 0.7537444993
762 [71] 0.1434954968 0.0273213172 0.3544582294 0.0763125909 0.6533909440
763 [76] 0.0640564791 0.6386990070 0.6373181453 0.7982611482 0.6635971505
764 [81] 0.5091338011 0.9602724470 0.4061612594 0.4486073786 0.3769140074
765 [86] 0.6803358560 0.9857847076 0.9717754354 0.3770275493 0.4174903892
766 [91] 0.4602804645 0.2252947700 0.3517002040 0.4961224457 0.2948396408
767 [96] 0.7000416485 0.4921564499 0.1972502421 0.1311005019 0.2167374734
768 [101] 0.1477429012 0.1688077482 0.7966405791 0.8898473976 0.9130889329
769 [106] 0.2623901793 0.3597230643 0.5432391861 0.2772660481 0.6366584762
770 [111] 0.6452377045 0.5861705425 0.6430255859 0.8831985751 0.9612189298
771 [116] 0.2239324751 0.8254658077 0.4439892056 0.6023518040 0.4701732723
772 [121] 0.4368000384 0.0610768907 0.5316433941 0.0968671157 0.8998338943
773 [126] 0.8762083489 0.9751962901 0.4684648176 0.4744663958 0.6348561489
774 [131] 0.3704594886 0.0813565252 0.9506419587 0.5686775721 0.0677767508
775 [136] 0.4590357388 0.2605611694 0.5750283683 0.3047910961 0.8799367768
776 [141] 0.7902066424 0.0724682561 0.2121882809 0.4799871468 0.6389617687
777 [146] 0.0923602451 0.7438367952 0.9789688368 0.9856042566 0.9413182882
778 [151] 0.3461513517 0.2913601073 0.0492540735 0.1223286483 0.0536250668
779 [156] 0.7600596601 0.3589178377 0.7102472247 0.1282570167 0.5667545414
780 [161] 0.3463599300 0.2557511649 0.3370114511 0.5682456589 0.0259351963
781 [166] 0.0066271110 0.1826211321 0.8908900355 0.8341091573 0.0480621750
782 [171] 0.1721253968 0.0958843490 0.8321860351 0.1856448844 0.5946975921
783 [176] 0.1788480591 0.7669691748 0.9863881753 0.0964079835 0.7288441530
784 [181] 0.3736637419 0.3913918345 0.5963157357 0.2402688249 0.7870056781
785 [186] 0.9346818083 0.1883969973 0.6516569071 0.5138975179 0.8245589784
786 [191] 0.6259653317 0.4503198208 0.1147471098 0.9035448737 0.7948573453
787 [196] 0.3755903356 0.9410621687 0.8765695898 0.1256447900 0.7828818441
788 [201] 0.0210907713 0.7950055115 0.4388557221 0.4504781791 0.2243176706
789 [206] 0.2198458049 0.5444716194 0.6641884784 0.1563156587 0.1273040301
790 [211] 0.9789279941 0.5699815350 0.3717663251 0.6843391240 0.3721403864
791 [216] 0.3134270287 0.6738637530 0.1045707464 0.7953125401 0.1321494223
792 [221] 0.8064783621 0.0476636693 0.7650995341 0.9063298183 0.9092856634
793 [226] 0.8197239831 0.3389866473 0.4500934228 0.3566465646 0.4062127741
794 [231] 0.0455081325 0.8919052265 0.3216221917 0.4349100464 0.0437116157
795 [236] 0.2608911830 0.6601819077 0.8927604884 0.7353992176 0.1587393768
796 [241] 0.4429510611 0.3274859029 0.4924950982 0.8544421138 0.3893712796
797 [246] 0.9192288385 0.1804643068 0.7675239493 0.6447117508 0.0310369029
798 [251] 0.1543480486 0.0850077055 0.3572204958 0.8278228473 0.8541962178
799 [256] 0.7850890053 0.3330630672 0.7419590915 0.7632378528 0.0073092082
800 [261] 0.3031442044 0.8346709488 0.2591169449 0.4418235237 0.4204715993
801 [266] 0.6394111111 0.6715181516 0.4438189506 0.9460343875 0.2518064710
802 [271] 0.7068659356 0.3123622690 0.3143788117 0.4609810645 0.5046041457
803 [276] 0.8453921762 0.8170968504 0.6625867083 0.1565591018 0.0091809463
804 [281] 0.5121615564 0.6727111218 0.5913213103 0.5962504072 0.7449586673
805 [286] 0.1738902773 0.7747431058 0.7113513222 0.9104376137 0.0601080852
806 [291] 0.2046696306 0.6786852726 0.3153981040 0.8204478810 0.5411596114
807 [296] 0.0908619626 0.8977951535 0.6563660139 0.8019893223 0.7135585409
808 [301] 0.9191912278 0.8520331860 0.7516321728 0.2870862910 0.1865943451
809 [306] 0.3368673171 0.3825829152 0.9378643662 0.7855412636 0.1305636971
810 [311] 0.5754655832 0.3536599758 0.9245344196 0.0957150934 0.3490608498
811 [316] 0.0065585575 0.2458059425 0.3296419492 0.3780640340 0.1454844244
812 [321] 0.6165540689 0.3367144323 0.8042373287 0.3573310606 0.2408009081
813 [326] 0.4525309654 0.3638986729 0.1182601796 0.7085078808 0.1783940580
814 [331] 0.6949111023 0.1963923539 0.9198062271 0.4124257569 0.0571714111
815 [336] 0.2248976897 0.1705277758 0.5563755964 0.4757383587 0.0407900894
816 [341] 0.8611306313 0.1374702395 0.6435172369 0.0530377442 0.6806002799
817 [346] 0.0303402471 0.5170387274 0.2595760170 0.2625517230 0.2815352322
818 [351] 0.3573397223 0.7275754418 0.3844811043 0.2069828780 0.0180586830
819 [356] 0.5405192676 0.3990528253 0.8895807527 0.8158685062 0.2822673679
820 [361] 0.0754147521 0.1436153064 0.9901589931 0.6960031125 0.1861099671
821 [366] 0.3398862493 0.9187002059 0.3637635102 0.2080340681 0.2804064692
822 [371] 0.9188405529 0.8835949141 0.5319665635 0.4730151049 0.3799372108
823 [376] 0.0123721918 0.7580239004 0.2734377775 0.1868928524 0.4532958081
824 [381] 0.5515022038 0.6693680685 0.4857085771 0.3223225237 0.3652348164
825 [386] 0.2072432972 0.8470060402 0.1740701084 0.6757437356 0.0138690867
826 [391] 0.5929620664 0.2392789989 0.0732145177 0.7798515209 0.1216484199
827 [396] 0.3979706489 0.8700617512 0.9861690924 0.1208634826 0.6965414903
828 [401] 0.1856438064 0.8614969256 0.7137844360 0.8778244993 0.9625419406
829 [406] 0.0367069761 0.8344179317 0.5600103289 0.2676673268 0.2526453680
830 [411] 0.7089203678 0.4400842320 0.4438905062 0.3731957516 0.3484217857
831 [416] 0.9204966554 0.7040270315 0.0169647834 0.4152506385 0.3124454254
832 [421] 0.3263477220 0.0069893750 0.2127333614 0.6699522722 0.2740735873
833 [426] 0.4240923033 0.2664061657 0.2975628241 0.1078042486 0.0544743866
834 [431] 0.8735946026 0.1822446228 0.2005415789 0.0871806487 0.9309499022
835 [436] 0.9378758231 0.8708991536 0.8945109064 0.9516177131 0.5507402837
836 [441] 0.3033531446 0.0734737313 0.4854535977 0.3152702888 0.7541199957
837 [446] 0.5523009319 0.1706555609 0.3362328580 0.4376637805 0.0855472840
838 [451] 0.1729284641 0.4749517620 0.1931662881 0.6948627501 0.8454339930
839 [456] 0.3681469734 0.1741359234 0.8701205421 0.9211323592 0.7833777643
840 [461] 0.0462073225 0.4651794448 0.6919678189 0.9192523970 0.1208101064
841 [466] 0.6898931477 0.0218155484 0.5385128167 0.5831947178 0.5498489041
842 [471] 0.1280601867 0.1010281933 0.2131820729 0.9897299167 0.9647969664
843 [476] 0.1070329684 0.4337630663 0.1249327401 0.0236136955 0.4276285025
844 [481] 0.8385928762 0.9626177158 0.3948890225 0.5372896919 0.5740846077
845 [486] 0.5499589124 0.6717018117 0.0057916783 0.7292175004 0.1108673830
846 [491] 0.5654647015 0.8887470386 0.8336399097 0.6925377578 0.5737003139
847 [496] 0.4484763765 0.7689939605 0.3702727049 0.4227202022 0.3204780610
848 [501] 0.5915183770 0.4360398857 0.4734913653 0.7903230712 0.8656996905
849 [506] 0.9779227942 0.8734779542 0.5307038201 0.7646852091 0.6462345128
850 [511] 0.9479479792 0.3597502119 0.2451354302 0.6457403842 0.4756655863
851 [516] 0.6200751101 0.9684695846 0.0207726001 0.4842613449 0.4282667411
852 [521] 0.8241746605 0.9673714188 0.2852411757 0.3885763898 0.3800319212
853 [526] 0.4711144515 0.7244385588 0.5842438475 0.8174887439 0.0100727947
854 [531] 0.3236736134 0.7087788901 0.7769720557 0.6681320844 0.0089637113
855 [536] 0.8820040680 0.5087036067 0.9754031310 0.5347245203 0.1288755103
856 [541] 0.1318320287 0.9723865958 0.6640758929 0.8370988243 0.5434201886
857 [546] 0.5483741122 0.2951936701 0.4880860748 0.0226106620 0.0332891392
858 [551] 0.7606457672 0.5273670414 0.8762987910 0.0453667424 0.8885838769
859 [556] 0.0454372561 0.8776813082 0.7107246835 0.0050538490 0.7327775497
860 [561] 0.6747196277 0.2566586190 0.5486797988 0.7463824518 0.8534353042
861 [566] 0.3826997429 0.9066356635 0.4351417855 0.2417831321 0.1459502168
862 [571] 0.2768835700 0.4416421696 0.0924007380 0.8163334641 0.2948592587
863 [576] 0.5727983911 0.0941330297 0.1536893921 0.0129193028 0.1730190306
864 [581] 0.9495979240 0.1519723376 0.9368932333 0.1755402384 0.7764486815
865 [586] 0.0516933748 0.2677211890 0.1298390308 0.5517395746 0.2464952967
866 [591] 0.0021523533 0.9962251242 0.8064601764 0.4823947735 0.2648309241
867 [596] 0.2383078393 0.1598076078 0.9730372007 0.8161273929 0.8781062404
868 [601] 0.0228087020 0.3795653093 0.9930983912 0.9972092540 0.7196104587
869 [606] 0.2378080643 0.5776951807 0.2008751556 0.0902750290 0.6617062495
870 [611] 0.8400331354 0.4417475406 0.9863885408 0.8302259517 0.1337666197
871 [616] 0.0738898849 0.9956850938 0.1329581260 0.3449783677 0.3135565748
872 [621] 0.6206157980 0.8644049636 0.7676632798 0.9521700833 0.1719843722
873 [626] 0.0313819950 0.2036059878 0.0881471911 0.6651161183 0.1284234910
874 [631] 0.9638902911 0.4608347001 0.9852427184 0.1795441210 0.9745623430
875 [636] 0.1002329215 0.9270720393 0.2886859875 0.3187317627 0.1221574186
876 [641] 0.7633414904 0.8482974842 0.8426246126 0.5894711921 0.4854730410
877 [646] 0.3408334304 0.0419170549 0.1644459285 0.6851356679 0.3255178332
878 [651] 0.2716695666 0.2160494102 0.1620664599 0.5737795064 0.7948465007
879 [656] 0.9912306312 0.9869640938 0.7477377946 0.6314170551 0.1352300916
880 [661] 0.1077217229 0.4428929582 0.2255308493 0.1029511034 0.5919921198
881 [666] 0.0650887033 0.9407473719 0.0141327549 0.8036098161 0.8999259083
882 [671] 0.0466886805 0.5942855319 0.1503500433 0.8043895690 0.1001886833
883 [676] 0.0078061686 0.3819091092 0.8973933663 0.7462573687 0.0005439643
884 [681] 0.7374731274 0.7165140584 0.5713243817 0.8274915209 0.8413579557
885 [686] 0.1731979295 0.9770560234 0.6257215617 0.0501777048 0.5414242411
886 [691] 0.0483450776 0.7650518802 0.1196657515 0.4136801718 0.1027943471
887 [696] 0.5490300984 0.4476259390 0.7243191700 0.8425943395 0.9944208746
888 [701] 0.8192696038 0.4632320907 0.3080494376 0.6293173318 0.9875962755
889 [706] 0.7002343033 0.3349426147 0.3620751204 0.9518767975 0.3917544514
890 [711] 0.7956712304 0.3377789026 0.2703791943 0.1612661378 0.4291477285
891 [716] 0.7032251961 0.3326110558 0.2029593422 0.2066116796 0.1675528588
892 [721] 0.7161840780 0.0366585238 0.3223191972 0.3440453445 0.7988508989
893 [726] 0.1430401488 0.6307817521 0.2814401009 0.2585955269 0.8153055192
894 [731] 0.9513115215 0.0320493556 0.9734351237 0.1938178691 0.6280122674
895 [736] 0.5529617216 0.3069537776 0.6470390870 0.6376673803 0.1323410829
896 [741] 0.1198820632 0.8224504285 0.9606559477 0.1895738852 0.7112787578
897 [746] 0.3979244162 0.2030619427 0.7235543265 0.9714335129 0.2167588540
898 [751] 0.0455651563 0.4231072261 0.9995910663 0.2853147713 0.9716681608
899 [756] 0.1771973756 0.5867976896 0.5413526464 0.4952694627 0.6293044917
900 [761] 0.9341696338 0.4689419717 0.6820630021 0.2760080630 0.2241237541
901 [766] 0.7212392432 0.7439587982 0.7960617125 0.9261175306 0.5487930872
902 [771] 0.0516592760 0.5298937892 0.1506226112 0.0427407778 0.1337312819
903 [776] 0.2311297357 0.5380458788 0.1802579549 0.2997475979 0.5049906918
904 [781] 0.8420332707 0.8052793425 0.7697944343 0.8579511833 0.2581993251
905 [786] 0.3375827803 0.6045529759 0.8863069916 0.9355403571 0.0933678974
906 [791] 0.1421240726 0.6709683498 0.8140065132 0.3942106552 0.0394056907
907 [796] 0.1426575487 0.3981383098 0.2461039096 0.9262944707 0.5124734198
908 [801] 0.4660482171 0.2491559554 0.0717250456 0.5249307698 0.2843963313
909 [806] 0.6882906905 0.5572838399 0.7771217099 0.7970378653 0.5290680246
910 [811] 0.6396470906 0.2907641809 0.6048755017 0.0311177177 0.5176429308
911 [816] 0.3792151464 0.8127932688 0.1531892624 0.0103432646 0.8598605820
912 [821] 0.5796349938 0.9851769209 0.6073984441 0.4347032295 0.5331391660
913 [826] 0.9665269672 0.3967667348 0.6106957665 0.9095455329 0.1477980532
914 [831] 0.0900182920 0.0440397142 0.6868908138 0.4934884529 0.0753628011
915 [836] 0.5011233035 0.4566323042 0.3714105582 0.8324586651 0.6129457208
916 [841] 0.9310450540 0.6051076120 0.5468066062 0.4338129184 0.7539935505
917 [846] 0.7379511185 0.2785636894 0.9135504176 0.5476361243 0.6284328389
918 [851] 0.3372011264 0.2834706611 0.7700430760 0.1904323276 0.5759021684
919 [856] 0.4668135212 0.4221736854 0.0090115825 0.7099300984 0.3216980053
920 [861] 0.6328048920 0.0837341342 0.3644928422 0.9602430479 0.8663198361
921 [866] 0.9887377082 0.8446590968 0.0136303827 0.8042396051 0.4770229370
922 [871] 0.0472149821 0.5708209751 0.3632416064 0.3532106257 0.9630601762
923 [876] 0.4414536108 0.3983629518 0.2618820833 0.9635558166 0.6365389675
924 [881] 0.0008625404 0.1417376786 0.3816505731 0.3697324765 0.8104454949
925 [886] 0.2348012934 0.5661451411 0.1733327634 0.8606214693 0.5432346524
926 [891] 0.3578474892 0.4557638054 0.4686445389 0.0926225120 0.9910041904
927 [896] 0.1214232477 0.6399174051 0.0760840951 0.2050533139 0.1696795460
928 [901] 0.5263495003 0.8604489681 0.6121890547 0.6753816295 0.2116817595
929 [906] 0.8133096450 0.5671839125 0.4065440523 0.9173581619 0.9364484858
930 [911] 0.8266185969 0.6651796699 0.9834544940 0.9606529642 0.6658224522
931 [916] 0.2368268648 0.9857052942 0.4702534988 0.9436706447 0.8993327427
932 [921] 0.7765492445 0.7674000179 0.2625085462 0.5309468543 0.7228742761
933 [926] 0.6108590765 0.4416601700 0.4324988413 0.7721880260 0.2523462344
934 [931] 0.3289293221 0.9962456613 0.6564230141 0.6015945782 0.0034949263
935 [936] 0.0468934050 0.1328322238 0.1703887328 0.4848130983 0.6061729221
936 [941] 0.0708268350 0.3816180737 0.8924493170 0.1727524919 0.4141729255
937 [946] 0.6797552989 0.7811053905 0.3191388007 0.4738513157 0.0983882295
938 [951] 0.2857178918 0.5318469517 0.3892039696 0.3350571808 0.1234910807
939 [956] 0.9152490706 0.3655281211 0.8118985086 0.1194550493 0.1795726828
940 [961] 0.1155332329 0.5031597684 0.7192315643 0.0440412543 0.1405542523
941 [966] 0.3317748674 0.1473083384 0.3779559813 0.7691302388 0.4655976051
942 [971] 0.4668723769 0.4245577394 0.1004751183 0.8444068942 0.5240187540
943 [976] 0.9623211988 0.9803233340 0.5102567873 0.9205365269 0.0110943939
944 [981] 0.8751330383 0.6044383538 0.7235146277 0.7192091935 0.4096230587
945 [986] 0.8696354670 0.3829307496 0.5087752375 0.6347813625 0.1824362788
946 [991] 0.8964539331 0.1200193174 0.2635866511 0.8832599944 0.8949610076
947 [996] 0.4817341862 0.8229932482 0.4389541277 0.9297572365 0.3502037239
948 [1] 1 2 3 4 5 6 7 8 9 10
949 [1] 0.69090156 0.16781532 0.03708303 1.13934230 -0.34892883 0.53257823
950 [7] 0.41196532 0.29727053 -0.77705800 -1.16641658 -0.32247663 1.86033385
951 [13] -0.00895859 1.35502013 0.71933249 -1.57466718 0.53305356 -0.53202436
952 [19] 0.89197081 -1.60991615 -0.34869921 -1.51593739 1.15746626 0.52752877
953 [25] -0.53079668 0.07235495 -0.18145013 -0.04878661 0.79858182 0.97083959
954 [31] 0.47810332 1.68789416 0.38809433 1.89433068 -0.80007964 -0.65812275
955 [37] -0.47552085 -0.06008382 0.61592922 0.53818355 -0.24226882 1.88832736
956 [43] -0.46589928 -0.78710908 2.00923412 1.07868599 1.02601719 0.67967194
957 [49] -0.71363362 -0.50910926 0.98989024 -1.22563051 1.08032906 0.67602798
958 [55] -0.11597793 0.12110286 -2.91236684 -0.09252194 0.93143090 -0.87399480
959 [61] 0.26818758 -0.42325317 2.21349480 -0.99277572 -0.78922118 -0.96693305
960 [67] 0.16640377 -0.46142872 2.65825342 0.07362205 0.92181678 -0.86855048
961 [73] 0.18138322 0.24998974 0.03474838 0.03677082 0.81956746 0.02810622
962 [79] 1.37981014 -1.43349407 0.11880801 -0.88946161 0.35789300 -0.64090948
963 [85] -0.56510936 0.60601891 0.91107928 0.98267402 -0.64078577 0.09021369
964 [91] -1.23349750 0.08247785 -0.65047589 -0.20009290 1.26693701 0.05862062
965 [97] 0.70392775 -0.46445789 -0.58599691 0.12076423
966 [1] 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83
967 [19] 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65
968 [37] 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47
969 [55] 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29
970 [73] 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11
971 [91] 10 9 8 7 6 5 4 3 2 1
972 [1] "hello"
973 [1] 1 2 3 4 5 6 7 8 9 10
974 [1] 0.69090156 0.16781532 0.03708303 1.13934230 -0.34892883 0.53257823
975 [7] 0.41196532 0.29727053 -0.77705800 -1.16641658 -0.32247663 1.86033385
976 [13] -0.00895859 1.35502013 0.71933249 -1.57466718 0.53305356 -0.53202436
977 [19] 0.89197081 -1.60991615 -0.34869921 -1.51593739 1.15746626 0.52752877
978 [25] -0.53079668 0.07235495 -0.18145013 -0.04878661 0.79858182 0.97083959
979 [31] 0.47810332 1.68789416 0.38809433 1.89433068 -0.80007964 -0.65812275
980 [37] -0.47552085 -0.06008382 0.61592922 0.53818355 -0.24226882 1.88832736
981 [43] -0.46589928 -0.78710908 2.00923412 1.07868599 1.02601719 0.67967194
982 [49] -0.71363362 -0.50910926 0.98989024 -1.22563051 1.08032906 0.67602798
983 [55] -0.11597793 0.12110286 -2.91236684 -0.09252194 0.93143090 -0.87399480
984 [61] 0.26818758 -0.42325317 2.21349480 -0.99277572 -0.78922118 -0.96693305
985 [67] 0.16640377 -0.46142872 2.65825342 0.07362205 0.92181678 -0.86855048
986 [73] 0.18138322 0.24998974 0.03474838 0.03677082 0.81956746 0.02810622
987 [79] 1.37981014 -1.43349407 0.11880801 -0.88946161 0.35789300 -0.64090948
988 [85] -0.56510936 0.60601891 0.91107928 0.98267402 -0.64078577 0.09021369
989 [91] -1.23349750 0.08247785 -0.65047589 -0.20009290 1.26693701 0.05862062
990 [97] 0.70392775 -0.46445789 -0.58599691 0.12076423
991 [1] 100 99 98 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83
992 [19] 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65
993 [37] 64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47
994 [55] 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29
995 [73] 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11
996 [91] 10 9 8 7 6 5 4 3 2 1
997 num [1:1000] 0.6387 0.0300 0.0124 0.3094 0.6135 ...
998 [1] "hello"
999 [1] 5 4 3 2 1 6 7 8 9 10
1000 [1] 0.03005505
1001 List of 7
1002 $ a :Class 'table' Named num [1:6] 1 3.25 5.5 5.5 7.75 10
1003 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
1004 $ b :Class 'table' Named num [1:6] -3.03800 -0.60010 0.00485 0.03006 0.79600 ...
1005 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
1006 $ c :Class 'table' Named num [1:6] 1.0 25.8 50.5 50.5 75.2 ...
1007 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
1008 $ d :Class 'table' Named num [1:6] 0.000544 0.229700 0.474700 0.492200 0.761300 ...
1009 .. ..- attr(*, "names")= chr [1:6] "Min." "1st Qu." "Median" "Mean" ...
1010 $ dataf: 'table' chr [1:6, 1:3] "Min. :-3.3974640 " "1st Qu.:-0.6794130 " "Median : 0.0065051 " "Mean :-0.0008243 " ...
1011 ..- attr(*, "dimnames")=List of 2
1012 .. ..$ : chr [1:6] "" "" "" "" ...
1013 .. ..$ : chr [1:3] " x" " y" " z"
1014 $ list : 'table' chr [1:100, 1:3] "1" "1" "1" "1" ...
1015 ..- attr(*, "dimnames")=List of 2
1016 .. ..$ : NULL
1017 .. ..$ : chr [1:3] "Length" "Class" "Mode"
1018 $ other:Class 'table' Named chr [1:3] "1" "character" "character"
1019 .. ..- attr(*, "names")= chr [1:3] "Length" "Class" "Mode"
1020 Error in dbFetch(db, key): unable to obtain value for key 'c'
1021 Error in dbFetch(db, "c"): unable to obtain value for key 'c'
1022 >
1023 >
1024 > ################################################################################
1025 > ## Other tests
1026 >
1027 > rm(list = ls())
1028 >
1029 >
1030 > dbCreate("testLoadingDB", "DB1")
1031 [1] TRUE
1032 > db <- dbInit("testLoadingDB", "DB1")
1033 >
1034 > set.seed(234)
1035 >
1036 > db$a <- rnorm(100)
1037 > db$b <- runif(1000)
1038 >
1039 > dbLoad(db) ## 'a', 'b'
1040 > summary(a)
1041 Min. 1st Qu. Median Mean 3rd Qu. Max.
1042 -3.036000 -0.642100 0.172000 0.004131 0.614100 2.107000
1043 > summary(b)
1044 Min. 1st Qu. Median Mean 3rd Qu. Max.
1045 0.004583 0.229900 0.478600 0.482200 0.729200 0.999800
1046 >
1047 > rm(list = ls())
1048 > db <- dbInit("testLoadingDB", "DB1")
1049 >
1050 > dbLazyLoad(db)
1051 >
1052 > summary(a)
1053 Min. 1st Qu. Median Mean 3rd Qu. Max.
1054 -3.036000 -0.642100 0.172000 0.004131 0.614100 2.107000
1055 > summary(b)
1056 Min. 1st Qu. Median Mean 3rd Qu. Max.
1057 0.004583 0.229900 0.478600 0.482200 0.729200 0.999800
1058 >
1059 >
1060 >
1061 > ################################################################################
1062 > ## Check dbReorganize
1063 >
1064 > dbCreate("test_reorg", "DB1")
1065 [1] TRUE
1066 > db <- dbInit("test_reorg", "DB1")
1067 >
1068 > set.seed(1000)
1069 > dbInsert(db, "a", 1)
1070 > dbInsert(db, "a", 1)
1071 > dbInsert(db, "a", 1)
1072 > dbInsert(db, "a", 1)
1073 > dbInsert(db, "b", rnorm(1000))
1074 > dbInsert(db, "b", rnorm(1000))
1075 > dbInsert(db, "b", rnorm(1000))
1076 > dbInsert(db, "b", rnorm(1000))
1077 > dbInsert(db, "c", runif(1000))
1078 > dbInsert(db, "c", runif(1000))
1079 > dbInsert(db, "c", runif(1000))
1080 > dbInsert(db, "c", runif(1000))
1081 >
1082 > summary(db$b)
1083 Min. 1st Qu. Median Mean 3rd Qu. Max.
1084 -2.76800 -0.65520 -0.06100 -0.01269 0.65240 3.73900
1085 > summary(db$c)
1086 Min. 1st Qu. Median Mean 3rd Qu. Max.
1087 0.0002346 0.2416000 0.4813000 0.4938000 0.7492000 0.9992000
1088 >
1089 > print(file.info(db@datafile)$size)
1090 [1] 64980
1091 >
1092 > dbReorganize(db)
1093 reorganizing database contents...
1094 database reorganized; reload database with 'dbInit'
1095 [1] TRUE
1096 >
1097 > db <- dbInit("test_reorg", "DB1")
1098 >
1099 > print(file.info(db@datafile)$size)
1100 [1] 16245
1101 >
1102 > summary(db$b)
1103 Min. 1st Qu. Median Mean 3rd Qu. Max.
1104 -2.76800 -0.65520 -0.06100 -0.01269 0.65240 3.73900
1105 > summary(db$c)
1106 Min. 1st Qu. Median Mean 3rd Qu. Max.
1107 0.0002346 0.2416000 0.4813000 0.4938000 0.7492000 0.9992000
1108 >