Difference between revisions of "Import sqlite test suite"

From CDOT Wiki
Jump to: navigation, search
(Related Bug List)
(To Do)
Line 38: Line 38:
  
 
*Research  
 
*Research  
**<strike>Find the default setting of SQLite files, tables, and values on Firefox 3</strike>
+
** SQLite itself
**Make a relationship tree that which classes or functions talk with SQLite
+
***<strike>SQLite test suite [http://www.sqlite.org/faq.html here]</strike>
**Run & <strike>understand the test program already built in the tests folder</strike>
+
** SQLite inside Firefox3
**<strike>SQLite test suite [http://www.sqlite.org/faq.html here]</strike>
+
***<strike>Find the default setting of SQLite files, tables, and values on Firefox 3</strike>
**<strike>TCL research [http://www.tcl.tk/ here]</strike>
+
***<strike>Find a relationship tree that which classes or functions talk with SQLite</strike>
 
+
***Run & <strike>understand the test program already built in the tests folder</strike>
*Programming
+
** ETC
**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>TCL research [http://www.tcl.tk/ here]</strike>
***process
 
****Add a new option into .mozconfig<pre>ac_add_options -enable-SQLitePopUp</pre>
 
****Bulid
 
****Run firefox
 
*****Open a new window when SQLite is called
 
*****Display communication between functions and SQLite
 
  
 
*Testing
 
*Testing

Revision as of 18:41, 17 October 2008

Project: Import sqlite test suite

Import sqlite test suite

Project Description

Mozilla uses an embedded version of SQLite extensively to store data such as bookmarks, history, etc. To insure that it runs properly within Mozilla, it would be good to add the entire sqlite test suite to Mozilla's tests, so that testing the browser also means testing sqlite. The sqlite test suite is written in TCL and needs to be ported to JavaScript. Some work has already been done, but more is required to get full test coverage.

Project Leader(s)

Park, KiWon

Project Contributor(s)


Project Details

bug 391756
http://www.0xdeadbeef.com/weblog/?p=368

Related Bug List

Bug 417037 - mozStorage chokes on databases over AFP

Bug 313553 - Move Session Storage to Database

Bug 403377 - add method for creating indices to mozIStorageConnection

Bug 385093 - --enable-storage comments in configure.in are misleading

To Do

  • Research
    • SQLite itself
      • SQLite test suite here
    • SQLite inside Firefox3
      • Find the default setting of SQLite files, tables, and values on Firefox 3
      • Find a relationship tree that which classes or functions talk with SQLite
      • Run & understand the test program already built in the tests folder
    • ETC
  • Testing
    • working and performance tests
    • data testing
    • TCL testing

Project News

Right Now,I am working on

SQLite test suite running test, but Now it has some problems. it says "permission error". now i'm googling.....


Working History

C:\Documents and Settings\user account name\Application Data\Mozilla\Firefox\Profiles\bulid name.default\
 Files: signons.sqlite / search.sqlite / places.sqlite / permissions.sqlite / formhistory.sqlite / downloads.sqlite
        / cookies.sqlite / content-prefs.sqlite
  • 2008/9/23
    • Find a bug that Sequence number’s jumping
      • I am searching that this is a reported bug or not, and when the numbers are jumping and why
        • File Name: places.sqlite
        • Summary: Sequence number is jumping
        • OS: Win XP SP2

Jump SEQ Num 20080823.gif

  • 2008/9/24
    • Research SQLite bugs & features here
  • 2008/9/25
    • My first testing : showing the test messages when SQLite is connected.
    • it is called over 20 times , when Firefox is just opened.

FirstCompile.gif

  • 2008/9/27
    • SQLite Test Suite testing and searching
  • 2008/9/29
    • TCL 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
  • 2008/10/1
    • SQLite test sample source ( suite ) code reading on Firefox site
      • mozilla/source/storage/test/unit
  • 2008/10/5
    • SQLite test suite running test