-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 28/06/13 01:12, Sqlite Dog wrote:
> I'm wondering is there available sample "feature-tight"
> "limit-striking" SQLite database (or SQL script) for GUI manager
> testing purposes?
You can certainly measure coverage of sqlite3.c itself when running your
testing. That will tell you what parts of functionality you haven't
exercised.
As far as I can tell the SQLite test suite does small pieces at a time
rather than a single huge file that does everything at once. However you
may be able to capture all the pieces and join them together.
My own test suite (several times larger than all my other code combined)
also only does small pieces and concatenating them wouldn't work since
names etc are reused.
> - identifier names contains spaces,
Here is your starter schema (and perfectly valid):
create table ""("" "");
If your code runs on a platform that is UTF-16 (or worse UCS-16) make sure
you test with code points above 65535.
For performance testing this could be helpful with the --dump-sql arg:
https://code.google.com/p/apsw/source/browse/tools/speedtest.py
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iEYEARECAAYFAlHNTSsACgkQmOOfHg372QQa5gCfQzrw5m8fFpuT9u29nTTkymZm
jhUAnRqEuC8opRWsjsni2TYJa2xLZaTh
=3+mD
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
