int
main()
{
string SSN1 = "123-45-1001";
string SSN2 = "123-45-1002";
string SSN3 = "123-45-1003";
string SSN4 = "123-45-1004";
string SSN5 = "123-45-1005";
string Name1 = "Chess";
string Name2 = "Bridge";
string Name3 = "Tennis";
time_t today;
Person *p;
Club *c;
Membership *m;
int handle;
today = time( &today );
// load the specific configuration file
//
if ( msqlLoadConfigFile( "/web/kochut/public_html/msql.conf" ) == -1 ) {
cerr << "mSQL error: " << msqlErrMsg << endl;
cerr << "\nProbable cause: SQL server is not running.\n";
cerr << "\n or server miscunfiguration in msql.conf.\n";
cerr << "\nSolution: Reconfigure/Restart the server\n";
exit(1);
}
// connect to the database server on ajax
//
if ( ( handle = msqlConnect( "ajax.cs.uga.edu" ) ) == -1 ) {
cerr << "mSQL error: " << msqlErrMsg << endl;
cerr << "\nProbable cause: SQL server is not running.\n";
cerr << "\nSolution: Restart the server\n";
exit(1);
}
// open database 'clubs'
//
if ( msqlSelectDB( handle, "clubs" ) == -1 ) {
cerr << "mSQL error: " << msqlErrMsg << endl;
cerr << "\nProbable cause: databse clubs does not exist.\n";
cerr << "\nSolution: create the database using msqladmin creat clubs\n";
exit(1);
}
// retrieve a Club object
//
try {
c = Club::DBRead( Name1, handle );
p = Person::DBRead( SSN1, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
p = Person::DBRead( SSN3, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
cout << "Added members to club: " << Name1 << endl;
// retrieve a Club object
//
c = Club::DBRead( Name2, handle );
p = Person::DBRead( SSN2, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
p = Person::DBRead( SSN3, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
p = Person::DBRead( SSN5, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
cout << "Added members to club: " << Name2 << endl;
// retrieve a Club object
//
c = Club::DBRead( Name3, handle );
p = Person::DBRead( SSN4, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
p = Person::DBRead( SSN2, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
p = Person::DBRead( SSN5, handle );
m = new Membership( p, c, today );
m->DBWrite( handle );
}
catch ( ClubsException &ce ) {
cerr << ce.get_Msg() << endl;
exit(1);
}
cout << "Added members to club: " << Name3 << endl;
cout << endl;
cout << "Club memberships have been written to the database.\n";
cout << "Closing the database.\n";
// close the database
//
msqlClose( handle );
return 0;
}
SQLRETURN SQLConnect( SQLHDBC hDrvDbc,
SQLCHAR *szDataSource,
SQLSMALLINT nDataSourceLength,
SQLCHAR *szUID,
SQLSMALLINT nUIDLength,
SQLCHAR *szPWD,
SQLSMALLINT nPWDLength
)
{
HDRVDBC hDbc = (HDRVDBC)hDrvDbc;
char szDATABASE[INI_MAX_PROPERTY_VALUE+1];
char szCONFIGFILE[INI_MAX_PROPERTY_VALUE+1];
char szHOST[INI_MAX_PROPERTY_VALUE+1];
/* SANITY CHECKS */
if( SQL_NULL_HDBC == hDbc )
return SQL_INVALID_HANDLE;
sprintf( hDbc->szSqlMsg, "hDbc=$%08lX szDataSource=(%s)", hDbc, szDataSource );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
if( hDbc->bConnected == 1 )
{
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, "SQL_ERROR Already connected" );
return SQL_ERROR;
}
if ( strlen( szDataSource ) > ODBC_FILENAME_MAX+INI_MAX_OBJECT_NAME )
{
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, "SQL_ERROR Given Data Source is too long. I consider it suspect." );
return SQL_ERROR;
}
/********************
* gather and use any required DSN properties
* - CONFIGFILE - for msqlLoadConfigFile() (has precedence over other properties)
* - DATABASE
* - HOST (localhost assumed if not supplied)
********************/
szDATABASE[0] = '\0';
szHOST[0] = '\0';
szCONFIGFILE[0] = '\0';
SQLGetPrivateProfileString( szDataSource, "DATABASE", "", szDATABASE, sizeof(szDATABASE), ".odbc.ini" );
if ( szDATABASE[0] == '\0' )
{
sprintf( hDbc->szSqlMsg, "SQL_ERROR Could not find Driver entry for %s in system information", szDataSource );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
return SQL_ERROR;
}
SQLGetPrivateProfileString( szDataSource, "HOST", "", szHOST, sizeof(szHOST), ".odbc.ini" );
SQLGetPrivateProfileString( szDataSource, "CONFIGFILE", "", szCONFIGFILE, sizeof(szCONFIGFILE), ".odbc.ini" );
/********************
* 1. initialise structures
* 2. try connection with database using your native calls
* 3. store your server handle in the extras somewhere
* 4. set connection state
* hDbc->bConnected = TRUE;
********************/
if ( szCONFIGFILE[0] != '\0' )
{
if ( msqlLoadConfigFile( szCONFIGFILE ) != 0 )
{
sprintf( hDbc->szSqlMsg, "SQL_ERROR %s", msqlErrMsg );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
sprintf( hDbc->szSqlMsg, "SQL_WARNING Failed to use (%s)", szCONFIGFILE );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
return SQL_ERROR;
}
}
if ( szHOST[0] == '\0' )
{
hDbc->hDbcExtras->hServer = msqlConnect( NULL ); /* this is faster than using localhost */
strcpy( szHOST, "localhost" );
}
else
hDbc->hDbcExtras->hServer = msqlConnect( szHOST );
if ( hDbc->hDbcExtras->hServer < 0 )
{
sprintf( hDbc->szSqlMsg, "SQL_ERROR %s", msqlErrMsg );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
sprintf( hDbc->szSqlMsg, "SQL_ERROR Failed to connect to (%s)", szHOST );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
return SQL_ERROR;
}
hDbc->bConnected = 1;
/* SET DATABASE */
if ( szDATABASE[0] != '\0' )
{
if ( msqlSelectDB( hDbc->hDbcExtras->hServer, szDATABASE ) == -1 )
{
sprintf( hDbc->szSqlMsg, "SQL_WARNING %s", msqlErrMsg );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
sprintf( hDbc->szSqlMsg, "SQL_WARNING Connected to server but failed to use database (%s)", szDATABASE );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
}
else
{
sprintf( hDbc->szSqlMsg, "SQL_INFO DATABASE=%s", szDATABASE );
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_WARNING, LOG_WARNING, hDbc->szSqlMsg );
}
}
logPushMsg( hDbc->hLog, __FILE__, __FILE__, __LINE__, LOG_INFO, LOG_INFO, "SQL_SUCCESS" );
return SQL_SUCCESS;
}
