Changes

Jump to: navigation, search

Import sqlite test suite

5,791 bytes added, 10:27, 13 November 2008
Releases
== Project Contributor(s) ==
 *[http://zenit.senecac.on.ca/wiki/index.php/User:AaronMT Aaron Train]* IRC & Class**[http://zenit.senecac.on.ca/wiki/index.php/User:David.humphrey David Humphrey]*[https://bugzilla.mozilla.org/show_bug.cgi?id=391756 Bugzilla( Bug 391756 - import the sqlite test suite into our test suite. )]** Shawn Wilsher** Peter Weilbacher
== Project Details ==
[https://bugzilla.mozilla.org/show_bug.cgi?id=391756 bug 391756] <br />
[http://www.0xdeadbeef.com/weblog/?p=368 http://www.0xdeadbeef.com/weblog/?p=368]
 
== Releases ==
*<b>Releases 0.1</b>-2008/10/15
**[https://bugzilla.mozilla.org/show_bug.cgi?id=391756 Mocha image]
***Fail the connection test.
***Shawn asks "version control"
*Releases 0.2
**add new code into "Makefile"
***<b>make test_c++:</b> it tests all c++ test code in the test folder
***<b>make test_js:</b> it tests all .js files in the unit folder
***<b>make test_js_file:</b> it tests a specific file in the unit folder
****ex)make test_js_file f=test_like.js
{|
|width="15px"|
|
 
{|class="collapsible collapsed" style="border-style:solid;border-width:thin;border-color:black"
!align="left" style="background-color:#ffffff; font-weight:bold;border-style:solid;border-width:thin;padding: 2px 2px 2px 2px;"|new codes in Makefile (/src/storage/test/)
|-
|
<pre>
#######################################################################
# SQLite Test Code
# C++ code test param : test_c++ or test_sqlite or TEST_SQLIITE
# .js code test :
test_js : testing all .js file in the unit folder
ex) make test_js
 
test_js_file: testing specific .js file in the unit folder
ex) make test_js_file f=test_like.js
#######################################################################
 
TEST_C_URL = $(DEPTH)/../$(OBJ_SUFFIX)-$(target)/dist/bin
TEST_JS_URL = $(DEPTH)/../$(OBJ_SUFFIX)-$(target)/storage/test
TEST_JS_SINGLE_URL = $(DEPTH)/../src/storage/test/unit
 
# C++ code test
# label the same names: test_c++ / test_sqlite / TEST_SQLIITE
# it calls a sqlite test file in the "obj/dist/bin" folder
 
TEST_SQLIITE:
$(TEST_C_URL)/$(PROGRAM)
 
test_c++: TEST_SQLIITE
test_sqlite:TEST_SQLIITE
 
#
# .js code test
# TEST_JS: test all .js files in the test folder
#
 
TEST_JS:
make -C $(TEST_JS_URL) check
 
test_js: TEST_JS
 
 
#
# specific .js code test
# TEST_JS_FILE f=js_file_name_dot_js
# ex) make test_js_file f=js_file_name_dot_js
#
 
TEST_JS_FILE:
make SOLO_FILE="$(f)" -C $(TEST_JS_URL) check-interactive
 
test_js_file:TEST_JS_FILE
</pre>
|}
 
 
|}
 
*Releases 0.3
 
== Related Bug List ==
[https://bugzilla.mozilla.org/show_bug.cgi?id=417037 Bug 417037] - mozStorage chokes on databases over AFP
 
[https://bugzilla.mozilla.org/show_bug.cgi?id=313553 Bug 313553] - Move Session Storage to Database
 
[https://bugzilla.mozilla.org/show_bug.cgi?id=403377 Bug 403377] - add method for creating indices to mozIStorageConnection
 
[https://bugzilla.mozilla.org/show_bug.cgi?id=385093 Bug 385093] - --enable-storage comments in configure.in are misleading
== To Do ==
*Makefile
**<strike>c++ code auto testing</strike>
**<strike>.js files auto testing</strike>
**<strike>sepcific .js file auto testing</strike>
*Research
**<strike>Make file</strike>** SQLite itself***<strike>Install SQLite</strike>***<strike>How to use SQLite</strike>***<strike>SQLite test suite [http://www.sqlite.org/faq.html here]</strike>** SQLite inside Firefox3***<strike>Find the default setting of SQLite files, tables, and values on Firefox 3</strike>**Make *<strike>Find a relation relationship tree that which classes or functions talk with SQLite</strike>***<strike>Run & understand the test program already built in the tests folder</strike>*Programming **Add new functions that when the firefox runs on test mode, it pops up a new window, and then shows only SQLite's communication parts and result<strike>[http://developer.mozilla.org/En/Storage Storage]</strike>***processETC****Add a new option into .mozconfig<prestrike>ac_add_options -enable-SQLitePopUpTCL research [http://www.tcl.tk/ here]</prestrike>****Bulid[http://developer.mozilla.org/En/XPCOM XPCOM]****Run firefox*****Open a new window when SQLite is called*****Display communication between functions and SQLitemozstorage
*Testing
**<strike>Function Test</strike>**<strike>working and performance tests</strike>
**data testing
**<strike>TCL testing</strike>
== Project News ==
 
<b>Right Now,I am working on </b>
* make a file list that call / connect SQLite files
the 0.2 make file makes working on .mozconf options, it should be 0.3
<b>Working History</b>
**** File Name: places.sqlite
**** Summary: Sequence number is jumping
**** OS: Win XP SP2[http://zenit.senecac.on.ca/wiki/index.php/Image:Jump_SEQ_Num_20080823.gif image] *<b>2008/9/24</b>**Research SQLite bugs & features [http://www.sqlite.org/cvstrac/timeline here] *<b>2008/9/25</b>**<b><i>My first testing</i></b> : showing the test messages when SQLite is connected.**it is called <b>over 20 times </b>, when Firefox is just opened. [http://zenit.senecac.on.ca/wiki/index.php/Image:Jump_SEQ_Num_20080823firstCompile.gifimage*<b>2008/9/27</b>**<b>SQLite Test Suite</b> testing and searching *<b>2008/9/29</b>**<b>[http://www.tcl.tk/man/tcl8.5/tutorial/tcltutorial.html TCL]</b> install and testing**SQLite test source ( suite ) code reading on SQLite site ***only inside "sqlite-3.6.3.tar.gz"(2.2M)**Reading ".test" files *<b>2008/10/1</b>**SQLite test sample source ( suite ) code reading on Firefox site***mozilla/source/storage/test/unit *<b>2008/10/5</b>**SQLite test suite running test *<b>2008/10/15</b>**Update Mocha image into Bugzilla and waiting Shawn Wilsher's review**Test SQLite connection on Firefox(Fail)***it needs a permission****Fix by "netscape.security.PrivilegeManager.enablePrivilege('UniversalXPConnect');"***File access error****Find that "It is available to trusted callers, meaning extensions and Firefox components only"****I'm thinking that the test suite as a extension, thus, looking "XPCOM" *<b>2008/10/16</b>**Shawn asks "Update & version control"***i am thinking the "configure menu" *<b>2008/10/17</b>**Peter Weilbacher says "Why we need the test suite, it already there, so, we just use SQLite's" *<b>2008/10/27</b>**Shawn says version control, but i don't get the idea *<b>2008/11/06</b>**Ted and Dave give a new idea that "https://bugzilla.mozilla.org/show_bug.cgi?id=391756"** changing make file *<b>2008/11/08</b>**find new command that***perl obj/_test_testing/mochitest/runtests.py****it opens an new window and starts tests***the folder "_test" has our testing files *<b>2008/11/09</b>** make -C test_folder check*** it checks all .js files in the test/unit folder** make SOLO_FILE="test_like.js" -C JS_FILE_URL check-interactive*** it checks a specific .js file *<b>2008/11/11</b>** i hope to get a file name(.js) which wants to testing from console, ** but it can not.. try to using Perl** ex) run_single_js.pl *<b>2008/11/13</b>** perl can get the file list, and get values from console** but, it can not run "make" command** it can use the shell command such as cp, echo, mv** but, i can not find that how to use "make" in perl *<b>2008/11/15</b>** go to easy way,** make file can get a value from console** ex) make file_name = test.js** echo $(file_name) : will print "test.js"
1
edit

Navigation menu