R-packages – /trunk/SQLiteDF/src/sqlite_dataframe.h

Rev 4160 – - updated to sqlite-3.3.13 - added R function sdfSelect, added ...

mrmanese — Thu, 22 Feb 2007 01:13:25 +0000

mrmanese – 17 file(s) modified
- updated to sqlite-3.3.13
- added R function sdfSelect, added tests for that
- fixes & enhancements on _get_factor_levels1, _get_vector_index_typed_result, etc.

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/cleanup
~ /trunk/SQLiteDF/configure.win
~ /trunk/SQLiteDF/DESCRIPTION
+ /trunk/SQLiteDF/man/sdfSelect.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
x /trunk/SQLiteDF/sqlite-3.3.7.tar.gz
+ /trunk/SQLiteDF/sqlite-3.3.13.tar.gz
+ /trunk/SQLiteDF/src/exports.h
~ /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/src/utils.c
~ /trunk/SQLiteDF/tests/tests.R

Rev 3821 – - inlined _expand_buf - fixed sql buffer resizing in sdf_get_index ...

mrmanese — Tue, 26 Sep 2006 11:01:49 +0000

mrmanese – 12 file(s) modified
- inlined _expand_buf
- fixed sql buffer resizing in sdf_get_index
- added sdflm2

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/DESCRIPTION
+ /trunk/SQLiteDF/man/sdflm2.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
+ /trunk/SQLiteDF/src/boundedQRf.f
~ /trunk/SQLiteDF/src/init.c
+ /trunk/SQLiteDF/src/sqlite_biglm.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/utils.c
~ /trunk/SQLiteDF/TODO

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 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 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 3435 – - configure file fixes from Prof. Ripley - added native ...

mrmanese — Sat, 19 Aug 2006 23:03:27 +0000

mrmanese – 8 file(s) modified
- configure file fixes from Prof. Ripley
- added native routines registration

~ /trunk/SQLiteDF/ChangeLog
~ /trunk/SQLiteDF/configure
+ /trunk/SQLiteDF/src/init.c
x /trunk/SQLiteDF/src/Makevars
~ /trunk/SQLiteDF/src/Makevars.in
+ /trunk/SQLiteDF/src/Makevars.win (copied from /trunk/SQLiteDF/src/Makevars@3434)
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h

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 3397 – - added sdflm, as.data.frame.sdf, eval, sdfImportDBI, sdfImportSQLite - added Requires ...

mrmanese — Fri, 11 Aug 2006 02:48:52 +0000

mrmanese – 10 file(s) modified
- added sdflm, as.data.frame.sdf, eval, sdfImportDBI, sdfImportSQLite
- added Requires DBI, biglm in DESCRIPTION
- corrected generic-ized is.list, length (already generic)
- added "begin", "commit" in sdf_create_sdf, rbind, and row ops. absence of
which was the cause of the slowness
- factored out _prepare_attach2() w/c checks the # of attached sqlite db's
and detaches as necessary.
- fixed bug on detecting R character type, STRSXP instead of CHARSXP
- added utility _str_tolower(), file name & line number in _sqlite_error
- override stats::quantile env
- change Makevars to link statically

~ /trunk/SQLiteDF/DESCRIPTION
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/Makevars
~ /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/sqlite_workspace.c
~ /trunk/SQLiteDF/src/utils.c

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 3308 – - added windows dll's, Makevar.win. windows dll still has the ...

mrmanese — Mon, 10 Jul 2006 00:44:48 +0000

mrmanese – 8 file(s) modified
- added windows dll's, Makevar.win. windows dll still has the default 10 max
attached db
- added USE_SDF, w/c does the juggling of which db to be attached

+ /trunk/SQLiteDF/inst/sqlite/win/libsqlite3.a
+ /trunk/SQLiteDF/inst/sqlite/win/sqlite3.def
+ /trunk/SQLiteDF/inst/sqlite/win/sqlite3.dll
+ /trunk/SQLiteDF/src/Makevars.win
~ /trunk/SQLiteDF/src/sqlite_dataframe.c
~ /trunk/SQLiteDF/src/sqlite_dataframe.h
~ /trunk/SQLiteDF/src/sqlite_vector.c
~ /trunk/SQLiteDF/src/sqlite_workspace.c

Rev 3307 – - moved libsqlite3.* to inst/sqlite/linux, added inst/sqlite/win to have ...

mrmanese — Mon, 10 Jul 2006 00:38:39 +0000

mrmanese – 13 file(s) modified
- moved libsqlite3.* to inst/sqlite/linux, added inst/sqlite/win to have
sqlite windows static dll
- change libsqlite3.a to have 31 max attach-ed db's
- most of Math.sqlite.vector is working already
- fixed sdf_attach_sdf
- factored out creation of sdf in _create_sdf_skeleton2
- added dupSdf, renameSdf

x /trunk/SQLiteDF/inst/sqlite/libsqlite3.a
x /trunk/SQLiteDF/inst/sqlite/libsqlite3.la
+ /trunk/SQLiteDF/inst/sqlite/linux
+ /trunk/SQLiteDF/inst/sqlite/linux/libsqlite3.a (copied from /trunk/SQLiteDF/inst/sqlite/libsqlite3.a@3306)
+ /trunk/SQLiteDF/inst/sqlite/linux/libsqlite3.la (copied from /trunk/SQLiteDF/inst/sqlite/libsqlite3.la@3306)
+ /trunk/SQLiteDF/inst/sqlite/win
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/Makevars
~ /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

Rev 3281 – - added row.names support for sdf - -pedantic cleanups - ...

mrmanese — Tue, 04 Jul 2006 02:38:08 +0000

mrmanese – 11 file(s) modified
- added row.names support for sdf
- -pedantic cleanups
- fixes by Prof. Bates: duplicate include & sqlite3_stmt mis-declaration
- minor fixes

~ /trunk/SQLiteDF/DESCRIPTION
+ /trunk/SQLiteDF/man/getSdf.Rd
~ /trunk/SQLiteDF/man/sqlite.data.frame.Rd
~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/Makevars
~ /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

Rev 3255 – submit 2 - added sqlite.vector, its ...

mrmanese — Tue, 27 Jun 2006 03:57:28 +0000

mrmanese – 8 file(s) modified
submit 2
- added sqlite.vector, its indexers, length and conversion to ordinary vec
- indexers for sqlite.data.frame: [, [[, $
- attachSdf, detachSdf

~ /trunk/SQLiteDF/NAMESPACE
~ /trunk/SQLiteDF/R/All.R
~ /trunk/SQLiteDF/src/sqlite3.h
~ /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