home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
World of Shareware - Software Farm 2
/
wosw_2.zip
/
wosw_2
/
CPROG
/
CDB114.ZIP
/
TEST.C
< prev
next >
Wrap
Text File
|
1991-03-15
|
6KB
|
202 lines
/* test.c */
#include <stdio.h>
#include <stdlib.h>
#include "dbmgr.h"
#include "test.h"
void main( void);
char *dbNames[] =
{
"Customer",
"acctNbr",
"company",
"Address",
"zip",
"telephone",
"Invoice",
"invNbr",
"InvoiceLine"
};
#define CUSTOMER dbNames[0]
#define ACCTNBR dbNames[1]
#define COMPANY dbNames[2]
#define ADDRESS dbNames[3]
#define ZIP dbNames[4]
#define TELEPHONE dbNames[5]
#define INVOICE dbNames[6]
#define INVNBR dbNames[7]
#define INVOICELINE dbNames[8]
struct Customer customer[3] =
{
{1000L,"Fred Gwynne Company",0.00},
{1001L,"CompuServe Incorporated",0.00},
{1002L,"Microsoft",0.00},
};
struct Address address[4] =
{
{"124 South Columbus St.","Columbus","Oh","43201","6142883222"},
{"2000 Arlington Center Blvd","Columbus","Oh","43228","6144598600"},
{"12 North Fork Ave.","Redmond","WA","55555","5332341234"},
{"13 North Fork Ave.","Redmond","WA","55555","5332341235"},
};
void main( void)
{
long acctNbr = 1001L;
struct currency_index currency;
struct Customer t_customer;
struct Address t_address;
if( DbOpen( "test.dbd"))
{
printf( "Error opening test.dbd\n");
exit( 1);
}
/* Customer 1000 */
if( DbRecordAdd( CUSTOMER, &customer[0]))
{
printf( "Call: DbRecordAdd( CUSTOMER, &customer[0]))\n");
exit( 1);
}
if( DbRecordAdd( ADDRESS, &address[0]))
{
printf( "Call: DbRecordAdd( ADDRESS, &address[0]))\n");
exit( 1);
}
if( DbSetAdd( CUSTOMER, ADDRESS))
{
printf( "Call: DbSetAdd( CUSTOMER, ADDRESS))\n");
exit( 1);
}
/* Customer 1001 */
if( DbRecordAdd( CUSTOMER, &customer[1]))
{
printf( "Call: DbRecordAdd( CUSTOMER, &customer[1]))\n");
exit( 1);
}
if( DbRecordAdd( ADDRESS, &address[1]))
{
printf( "Call: DbRecordAdd( ADDRESS, &address[1]))\n");
exit( 1);
}
if( DbSetAdd( CUSTOMER, ADDRESS))
{
printf( "Call: DbSetAdd( CUSTOMER, ADDRESS))\n");
exit( 1);
}
/* Customer 1002 */
if( DbRecordAdd( CUSTOMER, &customer[2]))
{
printf( "Call: DbRecordAdd( CUSTOMER, &customer[2]))\n");
exit( 1);
}
if( DbRecordAdd( ADDRESS, &address[2]))
{
printf( "Call: DbRecordAdd( ADDRESS, &address[2]))\n");
exit( 1);
}
if( DbSetAdd( CUSTOMER, ADDRESS))
{
printf( "Call: DbSetAdd( CUSTOMER, ADDRESS))\n");
exit( 1);
}
if( DbRecordAdd( ADDRESS, &address[3]))
{
printf( "Call: DbRecordAdd( ADDRESS, &address[3]))\n");
exit( 1);
}
if( DbSetAdd( CUSTOMER, ADDRESS))
{
printf( "Call: DbSetAdd( CUSTOMER, ADDRESS))\n");
exit( 1);
}
/* Get the first customer by account number */
if( DbRecordFindFirst( CUSTOMER, ACCTNBR))
{
printf( "Call: DbRecordFindFirst( CUSTOMER, ACCTNBR))\n");
exit( 1);
}
if( DbRecordGetCurrent( CUSTOMER, ACCTNBR, &t_customer))
{
printf( "Call: DbRecordGetCurrent( CUSTOMER, ACCTNBR, &t_customer))\n");
exit( 1);
}
/* Save the currency */
if( DbRecordGetCurrency( CUSTOMER, ¤cy))
{
printf( "Call: DbRecordGetCurrency( CUSTOMER, ¤cy))\n");
exit( 1);
}
/* Get the last customer */
if( DbRecordGetLast( CUSTOMER, ACCTNBR, &t_customer))
{
printf( "Call: DbRecordGetLast( CUSTOMER, ACCTNBR, &t_customer))\n");
exit( 1);
}
/* Get the addresses */
if( DbSetFindFirst( CUSTOMER, ADDRESS))
{
printf( "Call: DbSetFindFirst( CUSTOMER, ADDRESS))\n");
exit( 1);
}
if( DbSetGetFirst( CUSTOMER, ADDRESS, &t_address))
{
printf( "Call: DbSetGetFirst( CUSTOMER, ADDRESS, &t_address))\n");
exit( 1);
}
if( DbSetGetNext( CUSTOMER, ADDRESS, &t_address))
{
printf( "Call: DbSetGetNext( CUSTOMER, ADDRESS, &t_address))\n");
exit( 1);
}
/* Restore the customer currency and retrieve the current customer */
if( DbRecordUpdCurrency( CUSTOMER, ¤cy))
{
printf( "Call: DbRecordUpdCurrency( CUSTOMER, ¤cy))\n");
exit( 1);
}
if( DbRecordGetCurrent( CUSTOMER, ACCTNBR, &t_customer))
{
printf( "Call: DbRecordGetCurrent( CUSTOMER, ACCTNBR, &t_customer))\n");
exit( 1);
}
/* Get customer 1001 */
if( DbRecordGetByKey( CUSTOMER, ACCTNBR, &t_customer, &acctNbr))
{
printf( "Call: DbRecordGetByKey( CUSTOMER, ACCTNBR, &t_customer, &acctNbr))\n");
exit( 1);
}
/* Get address */
if( DbRecordGetByKey( ADDRESS, ZIP, &t_address, "55555"))
{
printf( "Call: DbRecordGetByKey( ADDRESS, ZIP, &t_address, \"55555\"))\n");
exit( 1);
}
/* Get the owner of the address */
if( DbSetGetOwner( CUSTOMER, ADDRESS, &t_customer))
{
printf( "Call: DbSetGetOwner( CUSTOMER, ADDRESS, &t_customer))\n");
exit( 1);
}
DbFlush();
DbClose();
}