learn/bookStore_vxWorks7.c

#include <stdio.h>
                                                    
#include "rdm.h"
                                                    
#include "bookStore_structs.h"
                                                    
#include "bookStore_cat.h"
                                                    
#include "rdmstartupapi.h"
                                                    
 
/* Write a row to from author and book tables */
                                                    
static RDM_RETCODE writeARow (RDM_DB db)
{
RDM_RETCODE rc;
RDM_TABLE_ID tables[] = {TABLE_BOOK, TABLE_AUTHOR};
 
char last_name[13];
char full_name[35];
char bookid[14];
char title[105];
char price[10];
RDM_BCD_T dPrice;
char *inputs[5] = {last_name, full_name, bookid, title, price};
size_t len;
int ii = 0;
 
    printf ("ADDING AUTHOR TO DATABASE\nAuthor Last Name:\n");
    fgets (last_name, 13, stdin);
    printf ("Author Full Name:\n");
    fgets (full_name, 35, stdin);
    printf ("ADDING BOOK TO DATABASE\nTitle of Book:\n");
    fgets (title, 105, stdin);
    printf ("Enter id located on book:\n");
    fgets (bookid, 14, stdin);
    printf ("Price:\n");
    fgets (price, 10, stdin);
 
/* Remove newline character from fgets */
                                                    
while (ii < (sizeof (inputs) / sizeof (inputs[0])))
    {
        len = strlen (inputs[ii]);
if (inputs[ii][len - 1] == '\n')
        {
            inputs[ii][len - 1] = '\0';
        }
        ii++;
    }
 
/* Start an update transaction and lock the table */
                                                    
    rc = rdm_dbStartUpdate (db, tables, RDM_LEN (tables), NULL, 0, NULL);
if (rc == sOKAY)
    {
        AUTHOR authInsert; /* Row buffer */
        BOOK bookInsert;   /* Row buffer */
 
/* Populate the columns in the AUTHOR Row buffer */
                                                    
        strcpy_s (authInsert.LASTNAME, sizeof (authInsert.LASTNAME), last_name);
        strcpy_s (authInsert.FULLNAME, sizeof (authInsert.FULLNAME), full_name);
        authInsert._FULLNAME_has_value = RDM_COL_HAS_VALUE;
 
/* Insert a row into the table */
                                                    
        rc = rdm_dbInsertRow (
            db, TABLE_AUTHOR, &authInsert, sizeof (authInsert), NULL);
 
if (rc == sOKAY)
        {
/* Convert the string to a binary-coded decimal */
                                                    
rdm_bcdFromString (price, &dPrice);
 
/* Populate the columns in the BOOK Row buffer */
                                                    
            strcpy_s (bookInsert.TITLE, sizeof (bookInsert.TITLE), title);
            bookInsert._TITLE_has_value = RDM_COL_HAS_VALUE;
            strcpy_s (
                bookInsert.BOOKISBN, sizeof (bookInsert.BOOKISBN), bookid);
            bookInsert.PRICE = dPrice;
            bookInsert._PRICE_has_value = RDM_COL_HAS_VALUE;
 
/* Insert a row into the table */
                                                    
            rc = rdm_dbInsertRow (
                db, TABLE_BOOK, &bookInsert, sizeof (bookInsert), NULL);
        }
if (rc == sOKAY)
        {
/* Commit a transaction */
                                                    
            printf (
"The book %s by %s at a price of $%s was added to the database "
                                                    
"successfully.\n",
                title, full_name, price);
            rc = rdm_dbEnd (db);
        }
else
                                                    
        {
/* Abort the transaction */
                                                    
            fprintf (
                stderr,
"A problem occurred when adding data to the database.\n");
            fprintf (
                stderr, "Error: %s (%d): %s\n", rdm_retcodeGetName (rc), rc,
rdm_retcodeGetDescription (rc));
rdm_dbEndRollback (db);
        }
    }
return rc;
}
 
/* Read rows from author table */
                                                    
static RDM_RETCODE readRows(RDM_DB db)
{
RDM_TABLE_ID tables[] = { TABLE_AUTHOR };
RDM_RETCODE  rc;
    AUTHOR authRead;
 
RDM_CURSOR cursor = NULL;
 
    rc = rdm_dbStartRead(db, tables, RDM_LEN(tables), NULL);
if (rc == sOKAY)
    {
        rc = rdm_dbGetRows(db, TABLE_AUTHOR, &cursor);
if (rc == sOKAY)
        {
/* Navigate to the first row in the cursor */
                                                    
            printf("Displaying all of the authors in the author table\n");
            rc = rdm_cursorMoveToFirst(cursor);
while (rc == sOKAY)
            {
/* Read the row column values */
                                                    
                rc = rdm_cursorReadRow(cursor, &authRead, sizeof(authRead), NULL);
if (rc == sOKAY)
                {
                    printf("%s", authRead.LASTNAME);
 
/* Move to the next row in the cursor */
                                                    
                    rc = rdm_cursorMoveToNext(cursor);
                }
            }
 
/* We expect to break out of the loop with a sENDOFCURSOR code*/
                                                    
if (rc == sENDOFCURSOR)
            {
                rc = sOKAY;
            }
 
/* Free the cursor allocated in rdm_dbGetRows */
                                                    
rdm_cursorFree(cursor);
        }
 
/* release the read locks */
                                                    
rdm_dbEnd(db);
    }
return rc;
}
 
int main_bookStore(int argc, const char* const* argv)
{
RDM_RETCODE  rc;        /* Status/Error Return Code */
RDM_TFS      tfs;       /* TFS Handle */
RDM_DB       db;        /* Database Handle */
 
RDM_UNREF(argc);
RDM_UNREF(argv);
 
/* Allocate a TFS Handle */
                                                    
/* Allocate a TFS Handle */
                                                    
    rc = rdm_rdmAllocTFS(&tfs);
if (rc == sOKAY)
    {
/* Set the database location (docroot) to the /ram0 directory */
                                                    
        rc = rdm_tfsSetOption(tfs, "docroot", "/ram0");
if (rc == sOKAY)
        {
            rc = rdm_tfsInitialize(tfs);
if (rc == sOKAY)
            {
/* Allocate a database handle */
                                                    
                rc = rdm_tfsAllocDatabase(tfs, &db);
if (rc == sOKAY)
                {
                    rc = rdm_dbSetCatalog(db, bookStore_cat);
/* Open the database */
                                                    
                    rc = rdm_dbOpen(db, "bookStore", RDM_OPEN_SHARED);
if (rc == sOKAY)
                    {
/* Insert a row to database */
                                                    
                        rc = writeARow(db);
if (rc == sOKAY)
                        {
/* Read the rows */
                                                    
                            rc = readRows(db);
                        }
rdm_dbClose(db);
                    }
else
                                                    
                    {
                        printf("\nSorry, can't open bookStore database.\n");
                        printf("Error: %s (%d): %s\n", rdm_retcodeGetName(rc), rc, rdm_retcodeGetDescription(rc));
                    }
rdm_dbFree(db);
                }
            }
        }
rdm_tfsFree(tfs);
    }
 
if (rc != sOKAY)
    {
        printf("There was an error in this Tutorial\n");
return EXIT_FAILURE;
    }
return EXIT_SUCCESS;
}
 
RDM_STARTUP_EXAMPLE(bookStore)