The sample-databases.tar package

The sample database contains the following scripts and tests:

test_sample_test_cases.py

The main script, which sets up the database and is used to run queries.

Setup

This folder contains setup scripts.

createDatabase.sh

Creates a database that is named inventory.

createTables.sh

Creates all of the necessary tables in the inventory database.

globalObjects.sh

Creates global objects (users, group, roles) on the system.

insertData.sh

Loads data into tables.

Queries

This folder contains all of the predefined queries, which run on tables. It includes queries for aggregates, stored procedures, inner join, alter objects, views, mvies, basc ddl and dml.