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