Source

sqlalchemy_default / README.unittests

SQLALCHEMY UNIT TESTS
----------------------

SETUP
-----
To run unit tests (assuming unix-style commandline, adjust as needed for windows):

Python 2.4 or greater is required since the unit tests use decorators.

cd into the SQLAlchemy distribution directory.

Set up the PYTHONPATH.  In bash:

    export PYTHONPATH=./test/

On windows:

    set PYTHONPATH=test\

The unittest framework will automatically prepend the lib directory to
sys.path.  This forces the local version of SQLAlchemy to be used,
bypassing any setuptools-installed installations (setuptools places
.egg files ahead of plain directories, even if on PYTHONPATH,
unfortunately).

RUNNING ALL TESTS
-----------------
To run all tests:

    python test/alltests.py

COMMAND LINE OPTIONS
--------------------
Help is available via:

    python test/alltests.py --help

    usage: alltests.py [options] [tests...]
    
    options:
      -h, --help            show this help message and exit
      --dburi=DBURI         database uri (overrides --db)
      --db=DB               prefab database uri (sqlite, sqlite_file, postgres,
                            mysql, oracle, oracle8, mssql)
      --mockpool            use mock pool
      --verbose             enable stdout echoing/printing
      --log-info=LOG_INFO   turn on info logging for <LOG> (multiple OK)
      --log-debug=LOG_DEBUG
                            turn on debug logging for <LOG> (multiple OK)
      --quiet               suppress unittest output
      --nothreadlocal       dont use thread-local mod
      --enginestrategy=ENGINESTRATEGY
                engine strategy (plain or threadlocal, defaults to SA
                default)
      --coverage            Dump a full coverage report after running    

NON-SQLITE DATABASES
--------------------
The prefab database connections expect to log in to localhost on the
default port as user "scott", password "tiger", database "test" (where
applicable).  E.g. for postgresql the this translates to 
"postgres://scott:tiger@127.0.0.1:5432/test".

RUNNING INDIVIDUAL TESTS
-------------------------
Any unittest module can be run directly from the module file (same commandline options):

    python test/orm/mapper.py

Additionally, to run a speciic test within the module, specify it as ClassName.methodname:

    python test/orm/mapper.py MapperTest.testget

CONFIGURING LOGGING
---------------------
Logging is now available via Python's logging package.  Any area of SQLAlchemy can be logged 
through the unittest interface, such as:

Log mapper configuration, connection pool checkouts, and SQL statement execution:

    python test/orm/unitofwork.py --log-info=sqlalchemy.orm.mapper --log-debug=sqlalchemy.pool --log-info=sqlalchemy.engine

BUILT-IN COVERAGE REPORTING
------------------------------
Coverage is now integrated through the coverage.py module, included in the './test/' directory.  Running the test suite with
the --coverage switch will generate a local file ".coverage" containing coverage details, and a report will be printed
to standard output with an overview of the coverage gathered from the last unittest run (the file is deleted between runs).

After the suite has been run with --coverage, an annotated version of any source file can be generated
marking statements that are executed with > and statements that are missed with !, by running the coverage.py
utility with the "-a" (annotate) option, such as: 

    python ./test/coverage.py -a ./lib/sqlalchemy/sql.py

which will create a new annotated file ./lib/sqlalchemy/sql.py,cover .  Pretty cool !

TIPS
----
When running the tests on postgres, postgres gets slower and slower each time you run the tests.  
This seems to be related to the constant creation/dropping of tables.  Running a "VACUUM FULL" 
on the database will speed it up again.
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.