Master Feature index

These small sample programs are used as our regression testing suite as well as illustrating a few minor functions each time. As well as this list, we have grouped the samples by numeric order.

Note: these samples are not completely up to date with the now over 80 small samples included with OOFILE. We are continuing to annotate samples as part of our ongoing documentation improvements. Recent documentation work has mainly focussed on our reference manual, generated from comments in the source.

A

Abstract class

Defining for use in derived tables ooftst19

display() function-as used in listboxes ooftst35

Inheritance from (derived tables) ooftst19

Adding Data

Adding multiple records at once (eg test data) ooftst01.h
Adding related data ooftst02.h
Adding text to a text field using += ooftst28

Copying the data from one database into another ooftst37
From file to a table with extra fields ooftst41
From file to a table with incorrect field sizes ooftst41
From file to a table with unspecified fields/sizes ooftst41

From streams ooftst10
Modifying related data ooftst06

Transfer of data in memory using adoptBody() ooftst31

See also individual field types by name

 

B

BLOBS

Appending to ooftst31

Copy to using setBytes() ooftst31

Creating database with blobs ooftst31

dbBLOB - definition Fields
Insert data by transfer of ownership using adoptBody() ooftst31

Modification using setBytes() ooftst31
oofBLOB - appending ooftst30
oofBLOB - assignment ooftst30

See also Buffers

Boolean Fields

Indexed ooftst32 
oofBool tests ooftst30

Used in searches ooftst32 

Buffers

Defining ooftst31

Copying using memcpy() ooftst31

See also BLOBS

 

C

Cache

Adding record to cache ooftst06

Modifying a record that is in cache ooftst06
Moving to record in cache (unsaved) ooftst16
Reverting to previously saved data using revert() ooftst34
Saving a record from cache using saveRecord() ooftst06

Calculated Fields

Cloning tables with ooftst29
Declaring saveRecord() so fields will be calculated ooftst32
Defining ooftst29
Defining calculater ooftst29

Defining fields calculated from others by overriding saveRecord() ooftst32
Searches using ooftst29
Sorting by ooftst29

Char fields

between() ooftst07.h

dbChar definition Fields

oofChar tests ooftst30

outside()  ooftst07.h

Cloning

Cloning search results.  ooftst01
Cloning a full table in RAM ooftst25

Cloning a sort-suspended table ooftst21
Create an empty clone (in RAM) ooftst25

Read-only fields ooftst12

Resuming sorting in sort-suspended clone ooftst21
Tables with calculated fields ooftst29
See also Copying

Compound Index definition

Compound fields ooftst12
Sort/search using compound fields ooftst12

Condition tests

between() - character field ooftst07.h

between() - date fields ooftst07.h
between() - numeric fields  ooftst07.h

Duplicate detection using valueIsDuplicate() ooftst36

Empty table test - using isEmpty()  ooftst02

equal() - numeric fields ooftst07.h

outside() - character field ooftst07.h

outside() - date fields ooftst07.h

outside() - numeric fields ooftst07.h

Connection

cTree-style connection ooftst28

dbase connection ooftst41

Persistent RAM connection ooftst34

RAM connection ooftst04

See also Create a new database

Copying

Buffers using memcpy() ooftst31

Cloning search results.  ooftst01

Database into table in RAM ooftst25
From one database to another using copyAllFrom() ooftst37
Read-only fields ooftst12

See also Cloning

Counting

Count records in a selection using count() ooftst02

Counting related data ooftst26

CR

Conversion of line endings to that of current platform ooftst43

Create a new database

C-tree table ooftst25
Database that has first been defined  ooftst01

See also Connection

 

D

Database

Adding data (See Adding data)

Connecting (See Connection)

Creating (See Create a new database)

Defining (See Defining)

Describing the schema ooftst02

Opening (See Opening a database)

Reverting to previously saved version ooftst34

Saving to this version ooftst34

Dates

Accessing the current date ooftst05

Accessing the current date-time ooftst05

between() ooftst07.h
Changing a date by relative offset ooftst05
Changing the default date order (eg MM/DD/YYYY) ooftst05

Conversion from date to stream ooftst05
Conversion from istream to date ooftst05

Conversion from string to date ooftst05

Conversion from string to date-time ooftst05

Format masks (for output) example ooftst33

Format masks (for output) documentation

oofDate - incrementing ooftst30
oofDateTime - incrementing ooftst30
outside() ooftst07.h
Range searches ooftst07.h
Setting a base year ooftst05
Storing a date ooftst05
See also Field Types

dbBLOB

Defining as field ooftst31

See also BLOBS

dbBool

Defining as field ooftst32

Indexing ooftst32

See also Boolean fields

dbChar

Defining as field ooftst01.h

Indexing ooftst01.h

See also Text, Strings or Char fields

dbDate/dbDateTime

Defining dbDate as field ooftst01.h

Defining dbDateTime as field ooftst07.h

dbDate method tests ooftst05

dbDateTime method tests ooftst05

Indexing dbDate field ooftst01.h

Indexing dbDateTime field ooftst07.h

See also Dates or Time

dbLong/dbUlong

Defining dbLong as field ooftst01.h

Defining dbUlong as field ooftst07.h

Indexing dbLong field ooftst01.h

Indexing dbUlongTime field ooftst07.h

See Numeric fields

dbReal

Defining as field ooftst07.h

Indexing Time field ooftst07.h

See Numeric fields

dbShort/dbUshort

Defining as field ooftst07.h

Indexing field ooftst07.h

See Numeric fields

dbText

Defining as field ooftst01.h

See also Text, Strings or Char fields

dbTime

dbTime method tests ooftst05

See also Dates or Time

dbViews

See also Views

Defining databases

Class containing a database ooftst23

Create a RAM-based table from a c-tree table ooftst25
Fields (See Fields, Field types or individual type of field)
Relationships ooftst02 and ooftst02.h

Runtime diagnostics to avoid common mistakes. ooftst22 *
Simple schema ooftst01.h
Using an abstract base class and mixin inheritance ooftst19

Defining tables

Deleting Data

Single record ooftst09

Testing deletion of single ooftst09

Testing deletion of whole database ooftst39
Whole database using deleteAll() ooftst09

Describing a database

Describing the schema of a database ooftst02

Duplicate Records

Ignoring duplicates - using ignoreDuplicateRecords() ooftst36
Ignoring duplicates - using stIgnoreDuplicateRecords ooftst36
Noticing duplicates - using noticeDuplicateRecords ooftst36
Testing for duplicate detection ooftst36

 

E

Empty set

Testing for - using count()  ooftst02

Testing for - using isEmpty()  ooftst02

Errors

Common errors example in: ooftst22

Creating your own using dbconnect::raise ooftst08

Evaluation

Evaluation of current field using value()  ooftst01

 

F

Fields

Adding data using += ooftst28
Calculated (See Calculated fields)
Compound fields ooftst12
Defining  ooftst01.h
Indexing (See Indexing)
Modifying  ooftst01.h

Printing by passing to cout ooftst02
Searching (See Searching)
Sorting (See Sorting)

See also individual field type by name

Field types

dbDate tests ooftst05

dbDateTime tests ooftst05

dbTime tests ooftst05

dbView tests (for some field types) ooftst30
OOF_String tests ooftst30
oofBlob tests ooftst30
oofBool tests ooftst30
oofChar tests ooftst30
oofDate tests ooftst30
oofDateTime tests ooftst30
oofLong tests ooftst30
oofReal tests ooftst30
oofShort tests ooftst30
oofString tests ooftst30
oofText tests ooftst30
oofTime testsooftst30
oofULong tests ooftst30
oofUShort tests ooftst30
See also individual field type by name

Formatting

Date format masks ooftst33
dbViews (See Views)

OOF_String formatting ooftst30

 

G

Go to record

Go to a particular record ooftst01

Go to a particular related record ooftst16

See also Retrieving or Navigation of database

 

H

I

Importing Data

From another database using copyAllFrom() ooftst37

Input from a C++ stream ooftst10
Suppress indexing and rebuild indices for fast import ooftst23

Indexing

Define compound index ooftst12
Define simple index ooftst01.h

Lack of index -> searching ooftst13
Non-acceptance of null entries ooftst38

Non-indexed keyword searches ooftst28
No-nulls index ooftst38

Rebuild indices (for fast import) ooftst23

Reindexing after adding data (using saveRecord()) ooftst28
Retrieving a particular record in a sorted list  ooftst01
Search by compound index ooftst12
Suppress indexing ooftst23

Table-level indexing ooftst28

Inheritance

Abstract class - defining ooftst19

Abstract class - deriving table from ooftst19

Mixin inheritance -defining ooftst19 

Mixin inheritance - deriving table from ooftst19

 

J

K

Keywords

Keyword indexing and searches ooftst28
Word parser ooftst27

 

L

Listbox

Listbox simulation ooftst35

 

M

Memory

Transfer of ownership using adoptBody() ooftst31
See also Cache

Mixin class

Defining ooftst19

Used in derived table ooftst19

Modifying data

See Adding data, Copying, Deleting data or Saving

 

N

Navigation of database

Go to a particular record ooftst01

Go to a particular related record ooftst16

Listbox scrolling simulation ooftst35

Previous record to the current  ooftst01

Non-indexed fields

Keyword searches on suppressed-index fields ooftst28

Retrieval of data ooftst13

Numeric fields

between()  ooftst07.h

Definitions Fields
equal() ooftst07.h

Field testing ooftst30

outside() ooftst07.h

Range searches  ooftst07.h

 

O

oofBLOB

oofBlob tests ooftst30

See also BLOBS

oofBool

oofBool tests ooftst30
See also Boolean fields

oofChar

oofChar tests ooftst30
See also Text, Strings or Char fields

oofDate/oofDateTime

oofDate tests ooftst30
oofDateTime tests ooftst30
See Dates or Time

oofLong/oofUlong

oofLong tests ooftst30
oofULong tests ooftst30
See Numeric fields

oofReal

oofReal tests ooftst30
See Numeric fields

oofShort/oofUshort

oofShort tests ooftst30

oofUShort tests ooftst30
See Numeric fields

OOF_String/oofString

OOF_String tests ooftst30
oofString tests ooftst30
See also Text, Strings or Char fields

oofText

oofText tests ooftst30
See also Text, Strings or Char fields

oofTime

oofTime testsooftst30
See Dates or Time

Opening a database

Create a RAM-based table from a c-tree table. ooftst25
Open a simple database  ooftst01
Open two c-tree databases sequentially. ooftst15
Open two c-tree databases simultaneously. ooftst24

Output

Date format masks ooftst33

Entire database using cout ooftst02

Multiple tables by explicit iteration ooftst02

Multiple tables by explicit iteration - using dbView ooftst02

Schema of the database ooftst02 

Search field ooftst07.h

Single table using cout  ooftst01

Single table using a dbView ooftst01
Stream output - file as ooftst04

See also Views

 

P

Parser

See Word Parser

Print

Database (whole) using cout ooftst02

Display function (as for a listbox) ooftst35

Multiple tables by explicitly iterating over file ooftst02
Multiple tables using a dbView ooftst02

Output stream file ooftst04

Single field by passing to cout ooftst01

Single table database using cout  ooftst01

 

Q

Queries

Ad-hoc query definition ooftst20 

recordNumber(query) ooftst40

 

R

Random data

FunctionTestData() ooftst11

Test data generator ooftst11

Rebuild database

Rebuild indices (for fast import) ooftst23

Reflective operations

Finding the name of given field ooftst38

Finding the source table for a record using fieldTable() ooftst29

Finding the source table for a record using source() ooftst06

Relationships

Adding related data - Join relationship ooftst02.h
Adding related data - pointer relationship ooftst16
Counting related data ooftst26
Defining the relationship - join relationship ooftst02 and ooftst02.h
Defining the relationship - pointer relationship ooftst16.h
Intersecting related data ooftst26

Report Writer

Adding fields via dbView - columnar report ooftst04

Adding fields via dbView - pageWise report ooftst04

html reports ooftst14
         Columnar plain html results
         PageWise plain html results
         Columnar Netscape tables results
         PageWise Netscape tables results
Plain character reports - results ooftst04
Setting column widths ooftst04
Specifying pageWise reports ooftst04

Retrieving

Field name using fieldName() ooftst38

Go to a particular record ooftst01

Go to a particular related record ooftst16
Non-indexed data ooftst13
Previous record to the current  ooftst01
Previously saved data using .revert ooftst34
Record number (current) using recordNumber() ooftst35
Record number (single record) using recordNumber(query) ooftst40

Records using a single field  ooftst01
Single record by relative number in a sorted list ooftst01
See also Searching

 

S

Saving

Saving a record using saveRecord() ooftst06

Saving the database so that we may later revert() to this version ooftst34

Schema

Describing the schema of a database ooftst02
Mismatch - a table with extra fields ooftst41
Mismatch - a table with incorrect field sizes ooftst41
Mismatch - a table with unspecified fields/sizes ooftst41
Read schema from file to empty table ooftst41

Scrolling

Go to a particular record ooftst01

Go to a particular related record ooftst16

Listbox simulation ooftst35

Previous record to the current  ooftst01

Searching

Ad-hoc query definition ooftst20

Array of words ooftst28

between() - Character field ooftst07.h

between() - Date field ooftst07.h
between() - Numeric field ooftst07.h
Calculated fields ooftst29
Cloning search results. ooftst01
Combinatorial search ooftst12
Combining the results of two searches  ooftst01
Compound index search ooftst12
Compound statement ooftst12
Comprehensive workout - without indexes ooftst17
Comprehensive workout ooftst07 and ooftst07.h

Delimited list of words ooftst28

equal() ooftst07.h

Keywords - array of words ooftst28

Keywords - delimited list of words ooftst28

Keywords - single word ooftst28
Keywords - starting with partial string ooftst28

outside() - Character field ooftst07.h

outside() - Date field ooftst07.h
outside() - Numeric field ooftst07.h

Partial word ooftst28
Partial words from delimited list ooftst28

Passed as a parameter ooftst07.h
Range searches - Character field ooftst07.h

Range searches - Date field ooftst07.h
Range searches - Numeric field ooftst07.h
Refining a search ooftst13
Search within selection ooftst13
Simple single field searches  ooftst01
String search - multiple partial strings ooftst21
String search - sub-string combinations ooftst20   *
Using difference to reduce the search space  ooftst01
Using 'not' to invert the search selection. ooftst01
Using set intersection to reduce the search space  ooftst01
Wildcard text searching ooftst18
With a relationship (eg patient.visit->why="flu") ooftst02
See also Selections

Selections

Cloning search results  ooftst01
Combining the results of two searches  ooftst01
Counting related data ooftst26
Intersecting related data ooftst26
Searching within a selection ooftst13
Selecting a subset of the table using a dbView  ooftst01
Setting search selection  ooftst01
Using difference to reduce the search space  ooftst01
Using 'not' to invert the search selection  ooftst01
Using set intersection to reduce the search space  ooftst01
See also Searches or Sorting

Sorting

Allocating storage for static sort member ooftst21

Calculated fields ooftst29

Clone sort-suspended table ooftst21

Default sort order -> within table class ooftst33

Default sort order -> using static sorter field ooftst21

Nested sort - declaring - as static member of class ooftst21
Nested sort - declaring - as variable ooftst21

Nested sort - declaring - as temporary object ooftst21

resumeSorting() ooftst21
Reverse sorted field using operator>> ooftst21
Reverse sorted field using reverse() ooftst21

Setting a simple sort order  ooftst01
Sort by compound index ooftst12
Sort by multiple fields ooftst21
Sort by single field  ooftst01

suspendSorting() ooftst21
Suspended sorting ooftst21
Using a no nulls index ooftst38
See also Searches or Selections

Source

Finding the source table for a record using fieldTable() ooftst29

Finding the source table for a record using source() ooftst06

Streams

Clearing error state using clear() ooftst05

Creating records from ooftst10

Ignoring characters using ignore() ooftst05

Output - opening file as ooftst04

Strings

between() ooftst07.h

Concatenation using operator += ooftst28

Conversion of line endings to that of current platform ooftst43

Convert to date ooftst05

Convert to dateTime ooftst05

Convert to time ooftst05

OOF_String or oofString? ooftst30
oofString - append substrings ooftst30
oofString - convert string<->integer ooftst30
oofString - formatting ooftst30

outside()  ooftst07.h

Parsing for keywords ooftst27

Range searches ooftst07.h

truncateTrailingSpaces() ooftst10

Wildcard text searching ooftst18

Structure of database

Describing structure (schema) of database ooftst02

Updating by copying data from one database to another ooftst37

 

T

Tables - defining

Table operations

Copying data from one database to another using copyAllFrom() ooftst37

Finding the table a record belongs to using source() ooftst06

Finding the table a record belongs to using fieldTable() ooftst29

Rebuild indices (for fast import) ooftst23

Suppress indices ooftst23

Text

Conversion of line endings to that of current platform ooftst43

dbText - definition Fields
oofText - append substring ooftst30

Test database generation

FunctionTestData() ooftst11

Test data generator ooftst11

Time

Accessing current time ooftst05
Directly specifying time using dbDateTime functions ooftst05
oofTime - incrementing ooftst30
Storing a time ooftst05
See also Field Types

 

U

Unknowns

Field name of given field ooftst38

Source table ooftst06

Table belonging to selection of records ooftst29

 

V

Views (for displaying subsets of fields)

Adding fields  ooftst01

Creating  ooftst01
Passing in false ooftst04

Printing multiple tables using a dbView ooftst02
Used by report-writer - plain character - columnar  ooftst04
Used by report-writer - plain character -PageWise ooftst04
Used by report-writer - simple HTML reports ooftst14
Used with cout - predefined  ooftst01
Used with cout - temporary in list of expressions  ooftst01

 

W

Word parser

Reparsing with new string ooftst27

Stop-list -setting ooftst27
Word parser (used for generating keyword indices) ooftst27

X

Y

Z