Test ScriptΒΆ

A demonstration script is provided in DIR/test/test.sql. Once compounds have been loaded as described in Load Test Data and Build Index or Loading the Test Table, the test script can be run:

$ sqlplus /nolog @test.sql

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 9 08:44:13 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Test user database orcl
Test user password
Connected.

Call completed.

dropping any existing index

Index dropped.

NCI compound table
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 SMILES                                             VARCHAR2(1000)

size of NCI table:
select count(*) "No Compounds" from nci_open;

No Compounds
------------
      260039

The test script demonstrates the three domain search operators, index rebuild and SQL filtering and can also be used to fully validate a cartridge install.

Previous topic

Configuration File

Next topic

Uninstalling the Cartridge