core16Example_main.c
Simple example which creates/inserts and reads a single record type with two fields which are referenced in a non-unique compound key. This example needs a compiled schema, core16Example.sdl.
/*
* COMPOUND KEY
* ------------
*
* This document describes the process to create a simple database
* containing a key, insert records, and read data through the key.
*
* For a full description of RDM keys, see Database Design in the
* Users Guide.
*
* This example contains a single record type with two fields which
* are referenced in a non-unique compound key.
*/
#include "rdm.h"
#include "rdmapi.h"
#include "rdmtfsapi.h"
#include "core16Example_structs.h"
#include "core16Example_cat.h"
#include "rdmstartupapi.h"
#include <string.h>
#include <stdio.h>
#include <stdlib.h>
static const INFO infos[] = {
RDM_EXPORT int32_t main_core16ExampleTutorial (int32_t argc, const char *const *argv)
{
RDM_RETCODE rc;
RDM_TFS tfs;
RDM_UNREF (argc);
RDM_UNREF (argv);
/* Allocate a TFS Handle */
rc = rdm_rdmAllocTFS (&tfs);
{
rc = rdm_tfsInitialize (tfs);
/* Allocate a database hande */
if (rc == sOKAY)
{
RDM_DB db;
rc = rdm_tfsAllocDatabase (tfs, &db);
if (rc == sOKAY)
{
RDM_TABLE_ID tables[] = {TABLE_INFO};
RDM_CURSOR cursor = NULL;
RDM_SEARCH_KEY key = {0};
INFO_MYKEY_KEY mykey = {"", 0, RDM_COL_HAS_VALUE,
rc = rdm_dbSetCatalog (db, core16Example_cat);
if (rc == sOKAY)
{
/* Open the database. */
if (rc != sOKAY)
{
printf ("I can't open the core16 database.");
}
}
if (rc == sOKAY)
{
/* Start an update transaction and lock the table */
rc = rdm_dbStartUpdate (
db, tables, RDM_LEN (tables), NULL, 0, NULL);
}
if (rc == sOKAY)
{
/* Remove all of the rows from the database */
rc = rdm_dbDeleteAllRowsFromDatabase (db);
if (rc == sOKAY)
{
/* Commit a transaction */
rc = rdm_dbEnd (db);
}
else
{
/* Abort the transaction */
rdm_dbEndRollback (db);
}
}
if (rc == sOKAY)
{
rc = rdm_dbStartUpdate (
db, tables, RDM_LEN (tables), NULL, 0, NULL);
}
if (rc == sOKAY)
{
uint32_t ii;
/* Insert the rows in the table */
{
rc = rdm_dbInsertRow (
db, TABLE_INFO, &infos[ii], sizeof (infos[ii]),
NULL);
}
if (rc == sOKAY)
{
/* Commit a transaction */
rc = rdm_dbEnd (db);
}
else
{
/* Abort the transaction */
rdm_dbEndRollback (db);
}
}
if (rc == sOKAY)
{
/* Do a key search on all 'John' records. We will set
the numKeyCols to 1 so that we will only use the name
portion of the key. We will retrieve all rows that
have a mychar value of 'John' and a myage value of
anything */
strcpy (mykey.mychar, "John");
mykey._mychar_has_value = RDM_COL_HAS_VALUE;
key.value = &mykey;
key.numKeyCols = 1;
key.stringLen = 0;
/* get a lock on the table */
}
if (rc == sOKAY)
{
db, KEY_INFO_MYKEY, &key, &key, &cursor);
if (rc == sOKAY)
{
rc = rdm_cursorMoveToFirst (cursor);
while (rc == sOKAY)
{
/* Read the full content of the current row */
rc = rdm_cursorReadRow (
cursor, &sInfo, sizeof (sInfo), NULL);
if (rc == sOKAY)
{
printf (
"Row found doing a search key range "
"lookup: "
"%s, %d\n",
sInfo.mychar, sInfo.myage);
}
/* Go to the next row in key order. */
if (rc == sOKAY)
{
rc = rdm_cursorMoveToNext (cursor);
}
}
/* We expect to break out of the loop when rc =
* sENDOFCURSOR
*/
{
rc = sOKAY;
}
/* Free the cursor allocated in the rdm_dbGet call */
rdm_cursorFree (cursor);
}
/* Free the lock on the table */
rdm_dbEnd (db);
}
rdm_dbFree (db);
}
}
rdm_tfsFree (tfs);
}
if (rc != sOKAY)
{
printf (
"There was an error in this Tutorial (%s - %s)\n",
return EXIT_FAILURE;
}
return EXIT_SUCCESS;
}
RDM_STARTUP_EXAMPLE (core16ExampleTutorial)
const char * rdm_retcodeGetName(RDM_RETCODE retcode)
Get the mnemonic name for an error or status code.
Header for the native RaimaDB Runtime API.
Header for the RaimaDB Core API.
RDM_RETCODE rdm_dbDeleteAllRowsFromDatabase(RDM_DB db)
Remove all rows from a database.
RDM_RETCODE rdm_dbStartRead(RDM_DB db, const RDM_TABLE_ID *tableIds, uint32_t numTableIds, RDM_TRANS *pTrans)
Get read locks.
RDM_RETCODE rdm_cursorReadRow(RDM_CURSOR cursor, void *colValues, size_t bytesIn, size_t *bytesOut)
Read all columns from a row.
RDM_RETCODE rdm_dbSetCatalog(RDM_DB db, const char *catalog)
Associate a catalog with an allocated database.
RDM_RETCODE rdm_dbOpen(RDM_DB db, const char *dbNameSpec, RDM_OPEN_MODE mode)
Open an existing RaimaDB database using the specified database handle.
RDM_RETCODE rdm_tfsAllocDatabase(RDM_TFS tfs, RDM_DB *pDb)
Allocate memory for a new RaimaDB db.
Header for the Transactional File Server (TFS) API.
const char * rdm_retcodeGetDescription(RDM_RETCODE retcode)
Invoke RaimaDB error handler.
RDM_RETCODE rdm_dbEndRollback(RDM_DB db)
End and rollback a transactional operation.
RDM_RETCODE rdm_dbInsertRow(RDM_DB db, RDM_TABLE_ID tableId, const void *colValues, size_t bytesIn, RDM_CURSOR *pCursor)
Insert a new row into a table at the specified rowId.
RDM_RETCODE rdm_dbStartUpdate(RDM_DB db, const RDM_TABLE_ID *writeTableIds, uint32_t numWriteTableIds, const RDM_TABLE_ID *readTableIds, uint32_t numReadTableIds, RDM_TRANS *pTrans)
Get write locks.
RDM_RETCODE rdm_dbGetRowsByKeyInSearchKeyRange(RDM_DB db, RDM_KEY_ID keyId, const RDM_SEARCH_KEY *startValue, const RDM_SEARCH_KEY *endValue, RDM_CURSOR *pCursor)
Associate an RDM_CURSOR with rows in a specified key range.
Internal RaimaDB Startup API used by startup macros.