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 Production on Mon Apr 9 08:44:13 2012

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

Test user database orcl
Test user password

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

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