Skip to content

Instantly share code, notes, and snippets.

@cobbspur

cobbspur/gist:6462778

Created September 6, 2013 11:51
Show Gist options
  • Save cobbspur/6462778 to your computer and use it in GitHub Desktop.
Save cobbspur/6462778 to your computer and use it in GitHub Desktop.
Download ZIP
sqlite3
Raw
gistfile1.sh
HORUS /e/test/node-sqlite3(remote-binary) $ npm test
> sqlite3@2.1.15 pretest e:\test\node-sqlite3
> node test/support/createdb.js
Creating test database... This may take several minutes.
> sqlite3@2.1.15 test e:\test\node-sqlite3
> mocha -R spec --timeout 200000
query properties
√ should return the correct lastID
√ should return the correct changes count
blob
√ should insert blobs
√ should retrieve the blobs
cache
√ should cache Database objects while opening
√ should cache Database objects after they are open
constants
√ should have the right OPEN_* flags
√ should have the right error flags
error handling
√ throw when calling Database() without new
√ should error when calling Database#get on a missing table
√ Database#all prepare fail
√ Database#run prepare fail
√ Database#each prepare fail
√ Database#each prepare fail without completion handler
√ Database#get prepare fail with param binding
√ Database#all prepare fail with param binding
√ Database#run prepare fail with param binding
√ Database#each prepare fail with param binding
◦ Database#each prepare fail with param binding without completion handler:
√ Database#each prepare fail with param binding without completion handler
each
√ retrieve 100,000 rows with Statement#each (186ms)
√ Statement#each with complete callback
exec
√ Database#exec
√ retrieve database structure
fts
√ should create a new fts4 table
map
√ test Database#map() with two columns
√ test Database#map() with three columns
named columns
√ should create the table
√ should insert a value
√ should retrieve the values
named parameters
√ should create the table
√ should insert a value with $ placeholders
√ should insert a value with : placeholders
√ should insert a value with @ placeholders
√ should insert a value with @ placeholders using an array
√ should insert a value with indexed placeholders
√ should insert a value with autoindexed placeholders
√ should retrieve all inserted values
null error
√ should create a table (108ms)
√ should insert rows with lots of null values (10115ms)
√ should have created the database
open/close
√ should not be unable to open an inaccessible database
open and close non-existant database
√ should open the database
√ should close the database
√ should have created the file
creating database without create flag
√ should fail to open the database
√ should not have created the file
open and close memory database queuing
√ should open the database
√ should close the database
√ shouldn't close the database again
closing with unfinalized statements
√ should create a table
√ should prepare/run a statement
√ should fail to close the database
√ should succeed to close the database after finalizing
data types
√ should serialize Date()
√ should serialize RegExp()
√ should serialize float 4294967296.249
√ should serialize float 3.141592653589793
√ should serialize float 3924729304762836.5
√ should serialize float 1378468094837
√ should serialize float 912667.394828365
√ should serialize float 2.3948728634826374e+83
√ should serialize float 9.293476892934982e+300
√ should serialize float Infinity
√ should serialize float -9.293476892934982e+300
√ should serialize float -2.3948728634826374e+83
√ should serialize float -Infinity
√ should serialize integer 4294967299
√ should serialize integer 3924729304762836
√ should serialize integer 1378468094837
√ should serialize integer 2.3948728634826374e+83
√ should serialize integer 9.293476892934982e+300
√ should serialize integer Infinity
√ should serialize integer -9.293476892934982e+300
√ should serialize integer -2.3948728634826374e+83
√ should serialize integer -Infinity
parallel
√ should create the table (102ms)
√ should insert in parallel (100922ms)
√ should close the database
√ should verify that the database exists
prepare
invalid SQL
√ should fail preparing a statement with invalid SQL
simple prepared statement
√ should prepare, run and finalize the statement
inserting and retrieving rows
√ should create the table
√ should insert 1000 rows
√ should prepare a statement and run it 1005 times
√ should have retrieved 1005 rows
retrieving reset() function
√ should retrieve the same row over and over again
√ should have retrieved 10 rows
multiple get() parameter binding
√ should retrieve particular rows
√ should have retrieved 10 rows
prepare() parameter binding
√ should retrieve particular rows
√ should have retrieved 1 row
all()
√ should retrieve particular rows
√ should have retrieved all rows
all()
√ should retrieve particular rows
high concurrency
√ should create the table
√ should insert all values
√ should retrieve all values
test Database#get()
√ should get a row
√ should have retrieved all rows
Database#run() and Database#all()
√ should create the table
√ should insert 1000 rows
√ should retrieve all rows
profiling
√ should profile a create table
√ should profile a select
rerunning statements
√ should create the table
√ should insert repeatedly, reusing the same statement
√ should retrieve repeatedly, resuing the same statement
√ should have inserted and retrieved the right amount
scheduling
√ scheduling after the database was closed
√ scheduling a query with callback after the database was closed
√ running a query after the database was closed
serialize() and parallelize()
√ should toggle
√ should insert rows
√ should have inserted all the rows after synchronizing with serialize()
serialize(fn)
√ should call the callback
√ should have inserted and retrieved all rows
tracing
√ Database tracing
√ test disabling tracing #1
√ test disabling tracing #2
unicode
√ should create the table
√ should insert all values
√ should retrieve all values
√ should have inserted and retrieved the correct amount
123 passing (2m)
HORUS /e/test/node-sqlite3(remote-binary) $
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment