R-packages – /trunk/SQLiteDF/tests/tests.R

Rev 3808 – - new sqlite.vector(vec), creates a 1-column sdf from a vector ...

mrmanese — Thu, 21 Sep 2006 10:37:31 +0000

mrmanese – 12 file(s) modified
- new sqlite.vector(vec), creates a 1-column sdf from a vector
- sqlite.matrix : dimnames, [, other experimental stuff
- sort.sqlite.vector sorts to a table to the sdf, no more creating a new

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/man/sqlite.matrix.Rd
+ /trunk/SQLiteDF/man/sqlite.vector.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/init.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_matrix.c
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/tests/tests.R
+ /trunk/SQLiteDF/TODO

Rev 3684 – - moved default data dir to ./.SQLiteDF - "generalized" sqlite ...

mrmanese — Tue, 05 Sep 2006 00:27:46 +0000

mrmanese – 12 file(s) modified
- moved default data dir to ./.SQLiteDF
- "generalized" sqlite vector, in that any table column can be used as an
sqlite.vector (previously, only columns of table sdf_data)
- fixed sqlite.matrix rownames

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_external.c
~ /trunk/SQLiteDF/src/sqlite_matrix.c
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3509 – - added sqlite.matrix and some of its methods - fixed ...

mrmanese — Mon, 28 Aug 2006 00:02:55 +0000

mrmanese – 10 file(s) modified
- added sqlite.matrix and some of its methods
- fixed print.sqlite.data.frame bug
- added msg when an existing workspace.db is loaded

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
+ /trunk/SQLiteDF/man/sqlite.matrix.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_matrix.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3473 – - added mean.sqlite.vector, fixed summary.sqlite.vector, added summary.sqlite.data.frame - is.list.sqlite.vector === ...

mrmanese — Wed, 23 Aug 2006 14:28:55 +0000

mrmanese – 10 file(s) modified
- added mean.sqlite.vector, fixed summary.sqlite.vector, added
summary.sqlite.data.frame
- is.list.sqlite.vector === FALSE
- fixed version conditionals for generic sort
- fixed sdfImportSQLite, added test case
- fixed _copy_factor_levels2
- checked on linux (R-2.3.0, R-devel)

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_external.c
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3471 – - added [], [n], [,] indexing for sdf. added tests ...

mrmanese — Wed, 23 Aug 2006 03:05:26 +0000

mrmanese – 15 file(s) modified
- added [], [n], [,] indexing for sdf. added tests for those
- added Prof. Bates print.sqlite.data.frame with modifications,
print.sqlite.vector
- changed inameSdf to return filename too
- changed some Rprintf to error() and warning()
- added doc for rbindSdf
- fixed bug in sort.sqlite.vector
- fixed bug in sdf_get_index, where a new sdf is added to the workspace twice
(one in _create_sdf_skeleton2 and another in sdf_get_index)
- sort() still does not work for 2.3.x (not generic)

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/cleanup
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/man/getSdf.Rd
~ /trunk/SQLiteDF/man/inameSdf.Rd
+ /trunk/SQLiteDF/man/rbindSdf.Rd
~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/init.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3458 – - added all.equal.sqlite.vector - added == for character - updated ...

mrmanese — Tue, 22 Aug 2006 16:56:49 +0000

mrmanese – 6 file(s) modified
- added all.equal.sqlite.vector
- added == for character
- updated test script
- used conditional on NAMESPACE for sort
- R CMD check runs for me in linux (R-devel, R-2.3.0), windows (R-2.3.0)

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3457 – - removed rbind S3, replaced with rbindSdf() - fixed rbindSdf() ...

mrmanese — Tue, 22 Aug 2006 12:51:27 +0000

mrmanese – 10 file(s) modified
- removed rbind S3, replaced with rbindSdf()
- fixed rbindSdf() for devel
- fixed a couple of sqlite.vector functions that still does "inheritance"
- re-added DBI in depends because it has no namespace and DBI::: does not work
- added head(), tail(). however both do not follow the original's row names yet
- added optional tests for sdfImportDBI, rbindSdf
- added doc for typeSvec, has.typeSvec
- runs for me in both R-devel, R-2.3.1

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
+ /trunk/SQLiteDF/man/typeSvec.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/utils.c
+ /trunk/SQLiteDF/tests/example.db
~ /trunk/SQLiteDF/tests/tests.R

Rev 3456 – - sqlite.data.frame now does not inherit from data.frame - sqlite.vector ...

mrmanese — Tue, 22 Aug 2006 02:34:28 +0000

mrmanese – 10 file(s) modified
- sqlite.data.frame now does not inherit from data.frame
- sqlite.vector does not inherit from the builtin data types
- added attribute sdf.vector.type to hold the type of sqlite.vector
- commented out summary() tests in tests.R, added tests n classes of sdf's
- added function typeSvec and is.typeSvec to query type of sqlite.vector
- fixed row.names comparison. I guess I put that before checking in and after
running tests, because ==.sqlite.vector is not implemented, only Ops.sqlite.vector.
- updated version to 0.1.13

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/cleanup
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3446 – - added symbols SDF_RowNamesSymbol, SDF_DimSymbols, SDF_DimNamesSymbols. SDF row ...

mrmanese — Mon, 21 Aug 2006 01:17:37 +0000

mrmanese – 12 file(s) modified
- added symbols SDF_RowNamesSymbol, SDF_DimSymbols, SDF_DimNamesSymbols. SDF
row names is now attached to SDF_RowNamesSymbol ("sdf.row.names")
- added row.names.sqlite.data.frame
- added src/win/opcode.h
- used ScalarLogical(), ScalarInteger(), ...
- removed ";" in All.R
- removed eval()
- made configure, cleanup executable

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/cleanup
~ /trunk/SQLiteDF/configure
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
+ /trunk/SQLiteDF/src/win
+ /trunk/SQLiteDF/src/win/opcodes.h
~ /trunk/SQLiteDF/tests/tests.R

Rev 3434 – - added docs in HACKING - fixed latex error on ...

mrmanese — Sat, 19 Aug 2006 20:58:44 +0000

mrmanese – 9 file(s) modified
- added docs in HACKING
- fixed latex error on sqlite.data.frame.Rd
- changed configure to copy libsqlite3.la to SQLite/ (like configure.win)
- finished Ops (%%, %/%), and Math (round, signif, log)
- fixed bug on operand order for Ops
- added test cases

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/HACKING
~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/Makevars
x /trunk/SQLiteDF/src/Makevars.win
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3432 – - added configure files from Prof. Ripley - added documentations ...

mrmanese — Sat, 19 Aug 2006 03:41:16 +0000

mrmanese – 17 file(s) modified
- added configure files from Prof. Ripley
- added documentations for inameSDF, sdfImportSQLite, sdfImportDBI, sdflm.
- added HACKING notes
- added list of functions known to work in SQLiteDF.package.Rd
- changed sqlite_vector accumulator to long double, fixed the accuracy problem

2006-08-18 Douglas Bates <bates@R-project.org>
* R/All.R (with.sqlite.data.frame, summary.sqlite.vector,
as.logical.sqlite.vector, as.integer.sqlite.vector,
as.double.sqlite.vector): Modify calling sequence of S3 methods to
correspond to generic.
* man/sqlite.data.frame.Rd: add keywords

~ /trunk/SQLiteDF/ChangeLog
+ /trunk/SQLiteDF/cleanup
+ /trunk/SQLiteDF/configure
+ /trunk/SQLiteDF/configure.win
+ /trunk/SQLiteDF/HACKING
x /trunk/SQLiteDF/inst
+ /trunk/SQLiteDF/man/inameSdf.Rd
+ /trunk/SQLiteDF/man/sdfImportDBI.Rd
+ /trunk/SQLiteDF/man/sdfImportSQLite.Rd
+ /trunk/SQLiteDF/man/sdflm.Rd
~ /trunk/SQLiteDF/man/SQLiteDF.package.Rd
~ /trunk/SQLiteDF/R/All.R
+ /trunk/SQLiteDF/sqlite-3.3.7.tar.gz
~ /trunk/SQLiteDF/src/Makevars
x /trunk/SQLiteDF/src/sqlite3.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3426 – - fixed R-devel tests failure - removed Depends on biglm, ...

mrmanese — Fri, 18 Aug 2006 09:58:04 +0000

mrmanese – 5 file(s) modified
- fixed R-devel tests failure
- removed Depends on biglm, DBI. used namespace qualifiers
- added ChangeLog
- added tests on summary
- added version in DESCRIPTION, starting at 0.1.11

+ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3419 – - fix on USE_SDF1 bug, when a function uses 2 ...

mrmanese — Thu, 17 Aug 2006 10:49:23 +0000

mrmanese – 10 file(s) modified
- fix on USE_SDF1 bug, when a function uses 2 sdf's the 1st may be unloaded
because of low use count
- fix on transactions
- started implementing sqlite.matrix
- commented out parts of the test that fails due to "minor technicalities" (precision, NA). will test them again...
- summary works, almost the same as original df except for NA handling

~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_external.c
+ /trunk/SQLiteDF/src/sqlite_matrix.c
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3358 – - added methods is.list and as.list to sdf's. lapply (sapply) ...

mrmanese — Tue, 01 Aug 2006 00:12:26 +0000

mrmanese – 9 file(s) modified
- added methods is.list and as.list to sdf's. lapply (sapply) now works
- rbind(sdf, df) works, however no "labeled" rbind
- finished Op group (%% & %/% implemented wrongly for now...)
- with.sqlite.data.frame is already working
- sort.sqlite.vector() is working
- renamed USE_SDF to USE_SDF1, restricted it to only use buf1 and below.
there was something affected by this, which calls USE_SDF twice (initially
i thought it would only be used on top of funcs, so using all buffers is
ok. if you use it in the middle of the func, it would overwrite all buffers).
- fixed sdf_get_row_count, _create_svector1 (renamed from *2, added ordered),
renamed _create_sdf_skeleton2 to skeleton1 because it uses USE_SDF1,
changed _get_row_count2 to have quoted and non-quoted option
- added tests

~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3324 – - added documentation - finished Summary group, cummulative stuffs in ...

mrmanese — Mon, 17 Jul 2006 00:58:12 +0000

mrmanese – 16 file(s) modified
- added documentation
- finished Summary group, cummulative stuffs in Math group for sqlite.vector
- revised tests to use stop()
- started rbind for data frames

+ /trunk/SQLiteDF/man/attachSdf.Rd
+ /trunk/SQLiteDF/man/detachSdf.Rd
+ /trunk/SQLiteDF/man/dupSdf.Rd
~ /trunk/SQLiteDF/man/getSdf.Rd
+ /trunk/SQLiteDF/man/lsSdf.Rd
+ /trunk/SQLiteDF/man/renameSdf.Rd
~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
~ /trunk/SQLiteDF/man/SQLiteDF.package.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3284 – - Added test script - Fixed compile error for Ubuntu ...

mrmanese — Wed, 05 Jul 2006 02:58:15 +0000

mrmanese – 5 file(s) modified
- Added test script
- Fixed compile error for Ubuntu dapper (?), as tested by Mr. Medri.

~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/utils.c
+ /trunk/SQLiteDF/tests
+ /trunk/SQLiteDF/tests/tests.R