db.h File Reference

---

Detailed Description

Database system module C header file.

REVISION

• 10/22/2003 M.GAO
  Initial creation.

Definition in file db.h.

#include "../feature.h"
#include "../MESSAGE/message.h"
#include "../GENERIC/generic.h"
#include "../fat/fat.h"

Include dependency graph for db.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Data Structures
struct	st_DBIDTREE
	DB ID tree structure definition. More...
struct	st_DBHEADER
	DB header structure definition. More...
struct	st_DBINFO
	DB information structure definition. More...
struct	st_DBQUERYCTL
	DB query control structure definition. More...
struct	st_DBREGIST
	DB registration structure definition. More...
struct	st_DBPAICTL
	DB PAI module control data structure definition. More...
struct	st_DBNAV
	DB navigation support structure. More...
Defines
#define	DB_MAXLFN   32
	Maximum DB file name length, this definition over rides FAT definition to save memory.
#define	DB_REGIST2SRAM
	Move registration to SRAM to save memory.
#define	DB_MAX_ID   0x018
	Maximum database ID.
#define	DB_OPENMAX   4
	Maximum num of concurrent opened DBs.
#define	DB_MAXRECLEN   512
	Maximum length of record in words.
#define	DB_MAXFIELDLEN   256
	Maximum length of record field in words.
#define	DB_MAXNAMELEN   32
	Maximum DB key name in words.
Enumerations
enum	DB_FEXTNAME
	DB file extention name enumeration definition.
Functions
BOOL	DB_add2child (DB_MDBOFFSET, DB_ID, const DB_DATA *)
	Function adds specified record to given child DB.
BOOL	DB_deleteRecord (DB_ID, DB_ENTRY)
	Function deletes specified record from the root database, it also updtes all corresponding child database.
BOOL	DB_deleteRecordByMdb (DB_ID, DB_MDBOFFSET)
	Function deletes specified record indexed by root offset from the root database, it also updtes all corresponding child database.
BOOL	DB_removeRecord (DB_ID, DB_ENTRY, DB_ENTRY)
	Function removes specified record reference from the child database.
DB_FIELDLEN	DB_getField (const DB_DATA *, DB_FIELDIDX, DB_DATA *, st_DBINFO *)
	Function gets interpreted data of the specified record field out of given record.
DB_ENTRY	DB_getSaiByMdb (ULONG, DB_ID)
	Function calculates SAI entry based on MDB offset.
DB_MDBOFFSET	DB_getMdbByRecord (DB_ID, const unsigned short *)
	Function checks return the MDB offset by record data.
st_DBINFO *	DB_info (DB_HDL)
	Function returns information of specified database.
BOOL	DB_init (void)
	Function initializes DB controls.
DB_HDL	DB_queryFirst (DB_ID, DB_FIELDIDX, DB_ENTRY, DB_ENTRY, DB_DATA *)
	Function queries the specified database and sets up query controls.
BOOL	DB_queryNext (DB_HDL, DB_ENTRY, DB_DATA *)
	Function queries database through specified database handle.
BOOL	DB_queryClose (DB_HDL)
	Function closes the specified database query operation and releases corresponding control data object.
DB_ID	DB_parentID (DB_ID)
	Function returns parent DB ID of the givent the child DB.
DB_ID	DB_childID (DB_ID, DB_FIELDIDX)
	Function returns child DB ID givent the child field index.
void	DB_setSyncMark (const char *)
	Function sets the DB sync mark.
BOOL	DB_checkSyncMark (const char *)
	Function checks the DB sync mark.
BOOL	DB__addSAIentry (DB_ID, DB_ENTRY, DB_MDBOFFSET, DB_PAIOFFSET)
	Function adds a new SAI entry.
BOOL	DB__deleteChildRecord (DB_ID, DB_ENTRY)
	Function deletes an entry form a child DB.
DB_FIELDIDX	DB__fieldIndex (DB_ID)
	Function returns field index of given child database under its parent.
DB_FIELDLEN	DB__getField (const DB_DATA *, DB_FIELDIDX, DB_DATA *)
	Function gets data of the specified record field out of given record with all escape/delimiter characters stripped.
BOOL	DB__getRecord (File *, DB_DATA *)
	Function reads back a record from specified file.
BOOL	DB__info (DB_ID, st_DBINFO *)
	Function returns information of specified database, this function is only available internally to DB module.
DB_DATA *	DB__locateField (const DB_DATA *, DB_FIELDIDX)
	Function locates position of the specified field.
DB_FNAME	DB__name (DB_ID, DB_FEXTNAME)
	Function returns the database header file name.
DB_RECLEN	DB__recordLen (const DB_DATA *)
	Function returns length in words of the specified record field.
BOOL	DB__recordPosition (DB_ID, DB_ENTRY *, const DB_DATA *, BOOL)
	Function checks to see if specified record exists in DB.
BOOL	DB__removePAIentry (DB_ID, DB_MDBOFFSET, DB_PAIOFFSET, unsigned short *)
	Function removes specified PAI entry.
DB_ID	DB__rootID (DB_ID)
	Function returns root DB ID of specified child ID.
Variables
const char	strDBDIR []
	GLOBAL DATA.

---

Function Documentation

BOOL DB__addSAIentry (  DB_ID  id, DB_ENTRY  entry, DB_MDBOFFSET  mdb, DB_PAIOFFSET  pai )

Function adds a new SAI entry. Parameters: id  DB ID. entry  Entry added. mdb  DB MDB offset. pai  DB PAI offset. Returns: TRUE if successfully added, otherwise FALSE. Definition at line 3459 of file db.c. References DB__name(), FAT_fclose(), FAT_finsert(), FAT_fopen(), FAT_fread(), FAT_fseek(), FAT_fwrite(), r_b, SEEK_HEAD, SEEK_MID, and File::size. Referenced by DB__insert2leaf(), and DB_insertRecord(). { unsigned long offset[2]; unsigned long fsize; unsigned short entryNum; File * idxfile; /* Update record number. */ idxfile = FAT_fopen(DB__name(id, SAI), r_b); fsize = idxfile->size; FAT_fseek(idxfile, DB_SAIENTRYNUMOFFSET, SEEK_HEAD); FAT_fread(idxfile, &entryNum, 1); entryNum++; FAT_fseek(idxfile, -1, SEEK_MID); FAT_fwrite(idxfile, &entryNum, 1); /* Load buffer. */ offset[0] = mdb; offset[1] = pai; /* Check to see if there is any free entries. */ if((long)fsize >= (long)((unsigned long)(entryNum + DB_SAIFIRSTENTRY + 1)<<2) ){ FAT_finsert( idxfile, ( (unsigned long)entry << 2), (unsigned short *)offset, 4, fsize); } else { FAT_finsert(idxfile, ( (unsigned long)entry << 2), (unsigned short *)offset, 4, 0L); } FAT_fclose(idxfile); return TRUE; }

Here is the call graph for this function:

BOOL DB__deleteChildRecord (  DB_ID  id, DB_ENTRY  entry )

Function deletes an entry form a child DB. It is the caller's responsibility to make sure the PAI entries are all cleared or it is deleted from root, in which case there is no PAI at all. Function deletes the child DB entry and updates all its children if any. Parameters: id  DB ID. entry  DB entry. Returns: TRUE if record successfully deleted, otherwise FALSE. Definition at line 2079 of file db.c. References DB__getField(), DB__getRecord(), DB__name(), DB__removePAIentry(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), FAT_fwrite(), st_DBIDTREE::node, r_b, rb, SEEK_HEAD, and SEEK_MID. Referenced by DB_deleteRecord(), DB_deleteRecordByMdb(), and DB_removeRecord(). { DB_ID childID; st_DBIDNODE * node; DB_MDBOFFSET offset; DB_PAIOFFSET pai; unsigned short entryNum; unsigned short entryLeft; File * idxfile; File * dbfile; DB_SAIOFFSET sai; DB_FIELDIDX fldidx; USHORT fldlen; USHORT usTmp, usLen; USHORT buf[DB_MAXRECLEN]; unsigned long fld[32];// Assuming that one field could hold up to // 32 valid offset values. // Get MDB offset from SAI file. idxfile = FAT_fopen(DB__name(id, SAI), r_b); FAT_fseek(idxfile, (unsigned long)(entry+DB_SAIFIRSTENTRY)<<2, SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&offset, 2); // Remove SAI entry. FAT_fseek(idxfile, DB_SAIENTRYNUMOFFSET, SEEK_HEAD); FAT_fread(idxfile, &entryNum, 1); DB_assert(entryNum, DB__DELETECHILDRECORD); /* Decrement entry number. */ FAT_fseek(idxfile, -1, SEEK_MID); entryNum--; FAT_fwrite(idxfile, &entryNum, 1); /* Process the rest of the entries. */ usTmp = (unsigned long)(entryNum - entry)<<2; FAT_fseek(idxfile, (unsigned long)(entry + DB_SAIFIRSTENTRY) << 2, SEEK_HEAD); while(usTmp) { /* Skip the current entry which should be deleted. */ FAT_fseek(idxfile, 4, SEEK_MID); if(usTmp > DB_MAXRECLEN ) usLen = DB_MAXRECLEN; else usLen = (unsigned short)usTmp; FAT_fread(idxfile, (unsigned short *)buf, usLen); FAT_fseek(idxfile, (long)((long)(-4) - usLen ), SEEK_MID); FAT_fwrite(idxfile, (unsigned short *)buf, usLen); usTmp -= usLen; } buf[0] = buf[1] = buf[2] = buf[3] = 0; /* Zero out last entry. */ FAT_fwrite(idxfile, (unsigned short *)buf, 4); FAT_fclose(idxfile); /* Mark entry as deleted. */ dbfile = FAT_fopen(DB__name(id, MDB), r_b); // Read back the entire record here. FAT_fseek(dbfile, offset, SEEK_HEAD); DB__getRecord(dbfile, (DB_DATA *)buf); FAT_fseek(dbfile, offset, SEEK_HEAD); FAT_fread(dbfile, (unsigned short *)&usTmp, 1); usTmp |= RECORD_DELETED; FAT_fseek(dbfile, -1, SEEK_MID); FAT_fwrite(dbfile, (unsigned short *)&usTmp, 1); FAT_fclose(dbfile); /* Check all the children database. */ node = &DB_idtree.node[id]; fldidx = 0; if(node->child) { node = node->child; while(node->next) { node = node->next; childID = node->id; fldidx++; fldlen = DB__getField(buf, fldidx, fld)>>1; // Sort all SAIs in field if any. _sortSAI(fld, fldlen); idxfile = FAT_fopen(DB__name(childID, SAI), rb); FAT_fseek(idxfile, DB_SAIENTRYNUMOFFSET, SEEK_HEAD); FAT_fread(idxfile, &entryNum, 1); // Note that entry has to be checked from the end of file to // support recursively deleting. while( (entryNum) && (fldlen) ) { entryNum--; FAT_fseek(idxfile, ((unsigned long)(entryNum + DB_SAIFIRSTENTRY)<<2), SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&sai, 2); FAT_fread(idxfile, (unsigned short *)&pai, 2); if( sai == fld[fldlen-1]) { fldlen--; // If pai == 0, there is no PAI entries available, does // NOT need to check. if(pai) DB__removePAIentry(childID, offset, pai, &entryLeft); } else continue; // if( (sai != fld[fldlen-1]) || (pai == 0) ) continue; // fldlen may have been post decremented already. if(pai == 0) continue; if(entryLeft == 0) { /* Close file before deleting SAI entry. */ FAT_fclose(idxfile); // The first entry always(?) points to the default empty record, // do not delete it even when it is empty since it defaults to // have at least one virtual record. if(entryNum != 0) { DB__deleteChildRecord(childID, entryNum); } /* Reopen SAI file after deleting. */ idxfile = FAT_fopen(DB__name(childID, SAI), rb); } } /* Close file before return. */ FAT_fclose(idxfile); } } return TRUE; }

Here is the call graph for this function:

DB_FIELDIDX DB__fieldIndex (  DB_ID  id  )

Function returns field index of given child database under its parent. Parameters: id  Child DB ID. Returns: Field index. Definition at line 3396 of file db.c. References st_DBIDTREE::node. Referenced by DB_add2child(), and DB_removeRecord(). { st_DBIDNODE * node; DB_FIELDIDX fldidx; fldidx = 0; node = &DB_idtree.node[id]; /* The very first child does not have previous node. */ while(node->prev) { fldidx++; node = node->prev; } return fldidx; }

DB_FIELDLEN DB__getField (  const DB_DATA *  pRecord, DB_FIELDIDX  fldIdx, DB_DATA *  pData )

Function gets data of the specified record field out of given record with all escape/delimiter characters stripped. Parameters: pRecord  DB record data. fldIdx  DB field index. pData  Field data buffer. Returns: Data length in words. Definition at line 1911 of file db.c. References DB__locateField(). Referenced by DB__deleteChildRecord(), DB_getField(), and DB_getMdbByRecord(). { const unsigned short * pSrc; unsigned short * pDst; pSrc = (const unsigned short *)DB__locateField(pRecord, fldIdx); if( NULL == pSrc ) { /* Unable to locate the specified field. */ return 0; } if( (*pSrc == DB_RECDLMT)||(*pSrc == DB_FLDDLMT) ) { /* Empty record. */ return 0; } pDst = (unsigned short *)pData; /* Start to fetch field. */ while(1) { if( *pSrc == DB_ESCCHAR) { pSrc++; *pDst++ = *pSrc++; } else{ *pDst++ = *pSrc++; } if( (*pSrc == DB_RECDLMT)||(*pSrc == DB_FLDDLMT) ) break; } return (pDst - (unsigned short *)pData); }

Here is the call graph for this function:

BOOL DB__getRecord (  File *  file, DB_DATA *  pData )

Function reads back a record from specified file. It is the caller's responsibility to make sure buffer is long enough to hold the record with maximum length. Parameters: file  DB data file. pData  DB record data buffer. Returns: TRUE if valid record is found, otherwise FALSE. Definition at line 3343 of file db.c. References DB_MAXRECLEN, and FAT_fread(). Referenced by DB__deleteChildRecord(), DB_add2child(), DB_getField(), DB_queryFirst(), DB_queryNext(), and DB_removeRecord(). { unsigned short * p; unsigned short len; // This is from queryFirst. if(pData == NULL) return TRUE; // Let's split it to speed up, since normally record will be // 256 words less. p = (unsigned short *)pData; len = FAT_fread(file, p, DB_MAXRECLEN/2); // check for record delimiter, for safe?. while( 1 ) { if( *p == DB_RECDLMT ) { if( *(p-1) != DB_ESCCHAR ) return TRUE; } p++; if ( (p-(unsigned short *)pData) >= len ) break; } // Second attempt. if( len != DB_MAXRECLEN/2) return FALSE; p = (unsigned short *)pData+DB_MAXRECLEN/2; len = FAT_fread(file, p, DB_MAXRECLEN/2); // check for record delimiter, for safe?. while( 1 ) { if( *p == DB_RECDLMT ) { if( *(p-1) != DB_ESCCHAR ) return TRUE; } p++; if ( (p-(unsigned short *)pData) == len ) break; } return TRUE; }

Here is the call graph for this function:

BOOL DB__info (  DB_ID  id, st_DBINFO *  pInfo )

Function returns information of specified database, this function is only available internally to DB module. Parameters: id  DB ID. pInfo  Info data buffer. Returns: TRUE if info successfully retrieved, otherwise FALSE. Definition at line 1577 of file db.c. References st_DBINFO::attribute, st_DBINFO::bVirtual, DB__cdDBdir(), DB__name(), DB__rootID(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), st_DBREGIST::fname, st_DBINFO::id, st_DBIDTREE::node, st_DBINFO::numOfFields, st_DBINFO::numOfKeys, st_DBINFO::ptrXIM, rb, SEEK_HEAD, and st_DBINFO::status. Referenced by DB_insertRecord(), and DB_queryFirst(). { File * file; st_DBHEADER header; unsigned long signature; #if 1 pInfo->id = id; /* Check to see if id points to a virtual DB. */ if( DB_registration[id].fname == NULL ) { pInfo->bVirtual = TRUE; /* Virtual DB, access through its parent. */ id = DB_idtree.node[id].parent->id; } else pInfo->bVirtual = FALSE; #endif // Change to corresponding root DB directory. all files contained // in this directory. if(DB__cdDBdir(DB__name(DB__rootID(id), MDB)) == FALSE) return FALSE; if( (file = FAT_fopen(DB__name(id, MDB), rb) ) == NULL ) return FALSE; if( FAT_fread(file, (unsigned short *)&header, sizeof(st_DBHEADER)) != sizeof(st_DBHEADER) ) RETURN_ERROR; FAT_fseek(file, header.len - 2, SEEK_HEAD); FAT_fread(file, (unsigned short *)&signature, 2); /* Check signature here for safe. */ if( signature != DB_HEADER_SIGNATURE ) RETURN_ERROR; /* Copy information over. */ pInfo->attribute = header.attribute; pInfo->numOfFields = header.numOfFields; pInfo->numOfKeys = header.numOfKeys; pInfo->status = header.status; pInfo->ptrXIM = ((long)header.ptrXIMhi<<16)|header.ptrXIMlo; FAT_fclose(file); return TRUE; }

Here is the call graph for this function:

DB_DATA* DB__locateField (  const DB_DATA *  pRecord, DB_FIELDIDX  fldIdx )

Function locates position of the specified field. Parameters: pRecord  DB record data. fldIdx  Field index. Returns: Field data start pointer if specified field found, otherwise NULL. Definition at line 3151 of file db.c. Referenced by DB__addChildIdx(), and DB__getField(). { const unsigned short * pSrc; unsigned short count; count = 0; /* Skip the record flag. */ pSrc = (unsigned short *)pRecord + 1; if( fldIdx != 0 ) { while( 1 ) { if(*pSrc == DB_ESCCHAR) pSrc += 2; if(*pSrc == DB_RECDLMT) { /* End of record, field not found. */ return NULL; } if(*pSrc == DB_FLDDLMT) { /* Field detected. */ count++; if( count == fldIdx ) { pSrc++; break; } } pSrc++; } } return((DB_DATA *)pSrc); }

DB_FNAME DB__name (  DB_ID  id, DB_FEXTNAME  ext )

Function returns the database header file name. Parameters: id  DB ID. ext  Extention specifier. Returns: DB file name pointer. Definition at line 3101 of file db.c. References st_DBREGIST::fname, and st_DBREGIST::len. Referenced by DB__addSAIentry(), DB__deleteChildRecord(), DB__info(), DB__insert2leaf(), DB__recordPosition(), DB__removePAIentry(), DB_add2child(), DB_deleteRecord(), DB_deleteRecordByMdb(), DB_dspData(), DB_getField(), DB_getMdbByRecord(), DB_getSaiByMdb(), DB_insertRecord(), DB_queryFirst(), and DB_removeRecord(). { unsigned short len = DB_registration[id].len; #ifdef DB_REGIST2SRAM static char DBnameBUF[DB_MAXLFN]; char * pC = &DBnameBUF[len-1]; GEN_rdSRAM(DB_registration[id].fname, (unsigned short *)DBnameBUF, len+1); #else char * pC = DB_registration[id].fname; #endif switch( ext ) { case MDB: *pC-- = 'b'; *pC-- = 'd'; *pC = 'm'; break; case SAI: *pC-- = 'i'; *pC-- = 'a'; *pC = 's'; break; case PAI: *pC-- = 'i'; *pC-- = 'a'; *pC = 'p'; break; } #ifdef DB_REGIST2SRAM return (DB_FNAME)DBnameBUF; #else return DB_registration[id].fname; #endif }

DB_RECLEN DB__recordLen (  const DB_DATA *  pRecord  )

Function returns length in words of the specified record field. Parameters: pRecord  DB record. Returns: Record length in words. Definition at line 3070 of file db.c. Referenced by DB__addChildIdx(), DB_add2child(), and DB_removeRecord(). { unsigned short * pR; pR = (unsigned short *) pRecord; if(*pR == DB_RECDLMT) return 0; while( 1 ) { pR++; if( *pR == DB_RECDLMT ) { if( *(pR-1) != DB_ESCCHAR ) break; } } return (pR-(unsigned short *)pRecord+1); }

BOOL DB__recordPosition (  DB_ID  id, DB_ENTRY *  pPosition, const DB_DATA *  pRecord, BOOL  bIgnoreRule )

Function checks to see if specified record exists in DB. If it does, function also sets up the record position value, which is the SAI entry. if it does not, function sets up the position value to where it should be. Parameters: id  DB ID. pPosition  Position data pointer. pRecord  DB record. bIgnoreRule  If TRUE, search till end. Returns: TRUE if record found, otherwise FALSE. Definition at line 2979 of file db.c. References DB__compare(), DB__name(), DB_MAXFIELDLEN, FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), rb, SEEK_HEAD, and SEEK_MID. Referenced by DB__insert2leaf(), and DB_insertRecord(). { unsigned short field[DB_MAXFIELDLEN]; DB_ENTRY entry; /* SAI entry number. */ DB_MDBOFFSET offset; /* File offset in MDB file. */ short comp; /* Field compare result. */ File * idxfile; File * dbfile; /* Open MDB and SAI files. */ idxfile = FAT_fopen(DB__name(id, SAI), rb); dbfile = FAT_fopen(DB__name(id, MDB), rb); /* Points to the first valid entry. */ entry = DB_SAIFIRSTENTRY; /* SAI entry takes 64bits, 4 words per entry. */ FAT_fseek(idxfile, (long)entry << 2, SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&offset, 2); while(offset) { FAT_fseek(dbfile, offset, SEEK_HEAD); FAT_fread(dbfile, field, DB_MAXFIELDLEN); /* Only compare the primary field. */ comp = DB__compare(field, (unsigned short *)pRecord ); if( comp == 0) { /* Record found!. */ FAT_fclose(idxfile); FAT_fclose(dbfile); *pPosition = entry; return TRUE; } else if (comp < 0) { /* ASSUMPTIION: ** If data under this rule are not presorted, this rule must ** support multiple record references, which means any record ** can possibly occur multiple times under this rule. */ entry++; /* Skip PAI entry. */ FAT_fseek(idxfile, 2, SEEK_MID); FAT_fread(idxfile, (unsigned short *)&offset, 2); } else { if(bIgnoreRule == FALSE) break; else { entry++; /* Skip PAI entry. */ FAT_fseek(idxfile, 2, SEEK_MID); FAT_fread(idxfile, (unsigned short *)&offset, 2); } } } /* Record does not exist. */ FAT_fclose(idxfile); FAT_fclose(dbfile); /* Sets up position. */ *pPosition = entry; return FALSE; }

Here is the call graph for this function:

BOOL DB__removePAIentry (  DB_ID  id, DB_MDBOFFSET  entry, DB_PAIOFFSET  pai, unsigned short *  pEntryNum )

Function removes specified PAI entry. Parameters: id  DB ID. entry  DB data entry offset. pai  PAI start offset. pEntryNum  Pointer to number of entry left. Returns: TRUE if PAI successfully removed, otherwise FALSE. Definition at line 2662 of file db.c. References DB__name(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), FAT_fwrite(), File::flag, r_b, and SEEK_HEAD. Referenced by DB__deleteChildRecord(), and DB_removeRecord(). { st_DBPAICTL control; DB_PAIOFFSET rdstart; DB_PAIOFFSET wrstart; unsigned short dataleft; unsigned short counter; unsigned short rdlen; unsigned short wrlen; unsigned short ii; DB_MDBOFFSET rdbuf[DB_MAXPAIBUFLEN]; DB_MDBOFFSET wrbuf[DB_MAXPAIBUFLEN]; DB_MDBOFFSET * pWr; File * idxfile; idxfile = FAT_fopen(DB__name(id, PAI), r_b); FAT_fseek(idxfile, pai - sizeof(st_DBPAICTL), SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&control, sizeof(st_DBPAICTL)); rdstart = pai; wrstart = pai; dataleft = control.entryNum; *pEntryNum = control.entryNum; while(dataleft) { if(dataleft > DB_MAXPAIBUFLEN) rdlen = DB_MAXPAIBUFLEN << 1; else rdlen = dataleft << 1; counter = 0; FAT_fread(idxfile, (unsigned short *)rdbuf, rdlen); pWr = wrbuf; for(ii = 0; ii < (rdlen>>1); ii++) { if(rdbuf[ii] != entry) *pWr++ = rdbuf[ii]; else counter++; } wrlen = rdlen - (counter<<1); *pEntryNum -= counter; FAT_fseek(idxfile, wrstart, SEEK_HEAD); FAT_fwrite(idxfile, (unsigned short *)wrbuf, wrlen); wrstart += wrlen; dataleft -= (rdlen>>1); rdstart += rdlen; FAT_fseek(idxfile, rdstart, SEEK_HEAD); } /* Zero out all free entries. */ if( control.entryNum > *pEntryNum) { wrstart = pai + ( (long)(*pEntryNum) << 1 ); dataleft = (control.entryNum - *pEntryNum) << 1; for(ii = 0; ii < DB_MAXPAIBUFLEN; ii++) wrbuf[ii] = 0L; while(dataleft) { if(dataleft > (DB_MAXPAIBUFLEN<<1)) wrlen = (DB_MAXPAIBUFLEN<<1); else wrlen = dataleft; FAT_fseek(idxfile, wrstart, SEEK_HEAD); FAT_fwrite(idxfile, (unsigned short *)wrbuf, wrlen); wrstart += wrlen; dataleft -= wrlen; } } /* Update entryNum. */ if(*pEntryNum) { FAT_fseek(idxfile, pai - sizeof(st_DBPAICTL) + 2, SEEK_HEAD); FAT_fwrite(idxfile, pEntryNum, 1); } else { /* Mark this module to be free. */ FAT_fseek(idxfile, pai - sizeof(st_DBPAICTL) + 1, SEEK_HEAD); control.flag |= PAI_FREE; FAT_fwrite(idxfile, (unsigned short *)&control.flag, 1); FAT_fwrite(idxfile, pEntryNum, 1); } FAT_fclose(idxfile); return TRUE; }

Here is the call graph for this function:

DB_ID DB__rootID (  DB_ID  id  )

Function returns root DB ID of specified child ID. Parameters: id  Current DB ID. Returns: Corresponding root DB ID. Definition at line 1680 of file db.c. References st_DBIDTREE::node. Referenced by DB__info(), DB_add2child(), DB_deleteRecord(), DB_deleteRecordByMdb(), DB_dspData(), DB_getField(), DB_getMdbByRecord(), DB_getSaiByMdb(), and DB_removeRecord(). { st_DBIDNODE * node; node = &DB_idtree.node[id]; /* Traverse to root. */ while(node->parent) node = node->parent; return node->id; }

BOOL DB_add2child (  DB_MDBOFFSET  rootMdb, DB_ID  childID, const DB_DATA *  childRecord )

Function adds specified record to given child DB. Parameters: rootMdb  Root record MDB offset. childID  Child DB ID. childRecord  Child record. Returns: TRUE if successful, otherwise FALSE. Definition at line 2461 of file db.c. References DB__addChildIdx(), DB__cdDBdir(), DB__fieldIndex(), DB__getRecord(), DB__insert2leaf(), DB__name(), DB__recordLen(), DB__rootID(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), FAT_fwrite(), st_DBIDTREE::node, r_b, rb, SEEK_HEAD, SEEK_MID, and File::size. { DB_ID rootID; st_DBIDNODE * node; DB_FIELDIDX fldidx; DB_MDBOFFSET childMdb; DB_MDBOFFSET newOffset; DB_MDBOFFSET tmpMdb; DB_RECLEN originalLen; DB_RECLEN childLen; DB_RECLEN newLen; unsigned short flag; File * dbfile; File * idxfile; unsigned short record[DB_MAXRECLEN]; //unsigned short childRecord[DB_MAXRECLEN]; /* Fetch root MDB entry. */ rootID = DB__rootID(childID); if(DB__cdDBdir(DB__name(rootID, MDB)) == FALSE) return FALSE; //idxfile = FAT_fopen(DB__name(rootID, SAI), rb); //FAT_fseek(idxfile, (unsigned long)(rootEntry+DB_SAIFIRSTENTRY) << 2, SEEK_HEAD); //FAT_fread(idxfile, (unsigned short *)&mdb, 2); //FAT_fclose(idxfile); /* Fetch root record. */ dbfile = FAT_fopen(DB__name(rootID, MDB), rb); FAT_fseek(dbfile, rootMdb, SEEK_HEAD); DB__getRecord(dbfile, record); FAT_fclose(dbfile); /* Fetch child MDB entry. */ //idxfile = FAT_fopen(DB__name(childID, SAI), rb); //FAT_fseek(idxfile, (unsigned long)(childEntry+DB_SAIFIRSTENTRY) << 2, SEEK_HEAD); //FAT_fread(idxfile, (unsigned short *)&newOffset, 2); //FAT_fclose(idxfile); /* Fetch child record. */ //dbfile = FAT_fopen(DB__name(childID, MDB), rb); //FAT_fseek(dbfile, newOffset, SEEK_HEAD); //DB__getRecord(dbfile, childRecord); //FAT_fclose(dbfile); /* ID to field index. */ fldidx = DB__fieldIndex(childID); originalLen = DB__recordLen(record); childLen = DB__recordLen(childRecord); /* Insert to child. */ childMdb = DB__insert2leaf( childID, rootID, rootMdb, record, childRecord, childLen, TRUE); /* Update root DB field value. */ DB__addChildIdx(record, fldidx, childMdb); newLen = DB__recordLen(record); /* If newLen == originalLen, the original is able to hold the new ** index without extending record length, we'll just write back the ** new record. */ if(newLen == originalLen) { dbfile = FAT_fopen(DB__name(rootID, MDB), r_b); FAT_fseek(dbfile, rootMdb, SEEK_HEAD); FAT_fwrite(dbfile, (unsigned short *)record, newLen); FAT_fclose(dbfile); return TRUE; } else { /* Mark the original as deleted. */ dbfile = FAT_fopen(DB__name(rootID, MDB), r_b); newOffset = dbfile->size; FAT_fseek(dbfile, rootMdb, SEEK_HEAD); FAT_fread(dbfile, (unsigned short *)&flag, 1); flag |= RECORD_DELETED; FAT_fseek(dbfile, -1, SEEK_MID); FAT_fwrite(dbfile, (unsigned short *)&flag, 1); /* Append new to the end of file. */ FAT_fseek(dbfile, newOffset, SEEK_HEAD); FAT_fwrite(dbfile, (unsigned short *)record, newLen); FAT_fclose(dbfile); /* Search and replace SAI entry. */ idxfile = FAT_fopen(DB__name(rootID, SAI), r_b); FAT_fseek(idxfile,(unsigned long)(DB_SAIFIRSTENTRY) << 2,SEEK_HEAD); while(1) { FAT_fread(idxfile, (unsigned short*)&tmpMdb, 2); DB_assert(tmpMdb != 0, DB_ADD2CHILD); if(tmpMdb == rootMdb) { FAT_fseek(idxfile,-2,SEEK_MID); FAT_fwrite(idxfile, (unsigned short *)&newOffset, 2); break; } // Skip PAI entry. FAT_fread(idxfile, (unsigned short*)&tmpMdb, 2); } FAT_fclose(idxfile); /* Search and replace all children PAIs. */ node = &DB_idtree.node[rootID]; node = node->child; while(node->next) { _replacePAI(node->next->id, rootMdb, newOffset); node = node->next; } } return TRUE; }

Here is the call graph for this function:

BOOL DB_checkSyncMark (  const char *  drive  )

Function checks the DB sync mark. Parameters: drive  Drive letter string. Returns: TRUE if sync mark is set. Definition at line 216 of file db.c. References FAT_cd(), FAT_fclose(), FAT_fopen(), FAT_fread(), rb, and strDBDIR. { st_DBHEADER header; BOOL ret = TRUE; File * file; FAT_cd(drive); if( TRUE == FAT_cd(strDBDIR) ) { if( TRUE == FAT_cd(strAUDIODIR) ) { if(file = FAT_fopen(strAUDIO, rb)) { if( FAT_fread(file, (unsigned short *)&header, sizeof(st_DBHEADER)) == sizeof(st_DBHEADER) ) { if( !(header.status & 0x0002) ) ret = FALSE; } FAT_fclose(file); } } } return ret; }

Here is the call graph for this function:

DB_ID DB_childID (  DB_ID  rootID, DB_FIELDIDX  fldIdx )

Function returns child DB ID givent the child field index. Parameters: rootID  Root DB ID. fldIdx  Child field index. Returns: Child DB ID. Definition at line 1635 of file db.c. References st_DBIDTREE::node. Referenced by MENU__createPresetMenu(), and UI_setupPlayQ(). { st_DBIDNODE * node; node = &DB_idtree.node[rootID]; node = node->child; while(fldIdx--) { node = node->next; } return node->id; }

BOOL DB_deleteRecord (  DB_ID  id, DB_ENTRY  entry )

Function deletes specified record from the root database, it also updtes all corresponding child database. Parameters: id  DB ID. entry  DB entry. Returns: TRUE if record successfully deleted, otherwise FALSE. Definition at line 2011 of file db.c. References DB__cdDBdir(), DB__deleteChildRecord(), DB__name(), and DB__rootID(). { if(DB__cdDBdir(DB__name(DB__rootID(id), MDB)) == FALSE) return FALSE; return DB__deleteChildRecord(id, entry); }

Here is the call graph for this function:

BOOL DB_deleteRecordByMdb (  DB_ID  id, DB_MDBOFFSET  mdb )

Function deletes specified record indexed by root offset from the root database, it also updtes all corresponding child database. Parameters: id  DB ID. mdb  DB root mdb offset. Returns: TRUE if record successfully deleted, otherwise FALSE. Definition at line 2029 of file db.c. References DB__cdDBdir(), DB__deleteChildRecord(), DB__name(), DB__rootID(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), rb, and SEEK_HEAD. Referenced by UI_PSF_play(). { DB_MDBOFFSET offset; USHORT entryNum; DB_ENTRY entry = 1; File * idxfile; BOOL ret = FALSE; if(DB__cdDBdir(DB__name(DB__rootID(id), MDB)) == FALSE) return FALSE; // Fetch entry number from SAI file. idxfile = FAT_fopen(DB__name(id, SAI), rb); FAT_fseek(idxfile, DB_SAIENTRYNUMOFFSET, SEEK_HEAD); FAT_fread(idxfile, &entryNum, 1); FAT_fseek(idxfile, (unsigned long)(1+DB_SAIFIRSTENTRY)<<2, SEEK_HEAD); while(entryNum--) { if(2!=FAT_fread(idxfile, (unsigned short *)&offset, 2)) break; if(mdb == offset) { ret = TRUE; break; } // Skip the PAI entry. if(2!=FAT_fread(idxfile, (unsigned short *)&offset, 2)) break; entry++; } FAT_fclose(idxfile); if(TRUE == ret) return DB__deleteChildRecord(id, entry); return FALSE; }

Here is the call graph for this function:

DB_FIELDLEN DB_getField (  const DB_DATA *  pRecord, DB_FIELDIDX  fldIdx, DB_DATA *  pData, st_DBINFO *  pInfo )

Function gets interpreted data of the specified record field out of given record. Parameters: pInfo  DB info data pointer. pRecord  DB record data. fldIdx  DB field index. pData  Field data buffer. Returns: Data length in words. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Definition at line 1846 of file db.c. References DB__cdDBdir(), DB__getField(), DB__getRecord(), DB__name(), DB__rootID(), FAT_fclose(), FAT_fopen(), FAT_fseek(), st_DBINFO::id, st_DBIDTREE::node, st_DBINFO::numOfKeys, rb, and SEEK_HEAD. Referenced by UI_interpretAudioRecord(), UI_interpretFailedHisiRecord(), UI_interpretIdentifiedHisiRecord(), UI_interpretUnidentifiedHisiRecord(), and UI_setupPlayQ(). { st_DBIDNODE * node; DB_ID tmpid; DB_MDBOFFSET childMdb; File * file; unsigned short ii; unsigned short record[DB_MAXRECLEN]; if(NULL == pData) return 0; ii = DB__getField(pRecord, fldIdx, pData); if( (0==fldIdx)||(0==ii)||(fldIdx >= pInfo->numOfKeys) ) return ii; // Currently only the first child MDB in field is fetched, this is // definitely a hole in algorithm, since there might be more than // one there. I simply don't worry about it now because this // feature is not used anyway. childMdb = ((unsigned long)(*(unsigned short *)pData)<<16)|(*((unsigned short *)pData+1)); // Virtual DB, no data available. //if(pInfo->bVirtual == TRUE) return 0; /* Get field DB id. */ //node = DB_idtree.node[pInfo->id].child; node = DB_idtree.node[DB_rootID(pInfo->id)].child; for(ii = 0; ii < fldIdx; ii++ ) node = node->next; tmpid = node->id; DB__cdDBdir(DB__name(DB__rootID(tmpid), MDB)); /* Open child DB MDB file. */ file = FAT_fopen(DB__name(tmpid, MDB), rb); /* Seek to offset. */ FAT_fseek(file, childMdb, SEEK_HEAD); DB__getRecord(file, record); FAT_fclose(file); return( DB__getField(record, 0, pData) ); }

Here is the call graph for this function:

DB_MDBOFFSET DB_getMdbByRecord (  DB_ID  id, const unsigned short *  pData )

Function checks return the MDB offset by record data. Parameters: id  DB ID. pData  DB primary record data. Returns: MDB offset of record. Definition at line 1763 of file db.c. References DB__cdDBdir(), DB__getField(), DB__name(), DB__rootID(), DB_MAXFIELDLEN, FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), rb, SEEK_HEAD, and SEEK_MID. { unsigned short field[DB_MAXFIELDLEN]; DB_ENTRY entry; /* SAI entry number. */ DB_MDBOFFSET offset; /* File offset in MDB file. */ File * idxfile; File * dbfile; if(DB__cdDBdir(DB__name(DB__rootID(id), MDB)) == FALSE) return 0; /* Open MDB and SAI files. */ idxfile = FAT_fopen(DB__name(id, SAI), rb); dbfile = FAT_fopen(DB__name(id, MDB), rb); /* Points to the first valid entry. */ entry = DB_SAIFIRSTENTRY; /* SAI entry takes 64bits, 4 words per entry. */ FAT_fseek(idxfile, (long)entry << 2, SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&offset, 2); while(offset) { unsigned short len; FAT_fseek(dbfile, offset, SEEK_HEAD); FAT_fread(dbfile, field, DB_MAXFIELDLEN); /* Only compare the primary field. */ if(len = DB__getField(field, 0, field)) { unsigned short * pS = (unsigned short *)field; unsigned short * pD = (unsigned short *)pData; do { if(*pS++ != *pD++) break; } while(--len); if( 0 == len ) { /* Record found!. */ FAT_fclose(idxfile); FAT_fclose(dbfile); return offset; } } entry++; /* Skip PAI entry. */ FAT_fseek(idxfile, 2, SEEK_MID); FAT_fread(idxfile, (unsigned short *)&offset, 2); } /* Record does not exist. */ FAT_fclose(idxfile); FAT_fclose(dbfile); // Not found. return 0L; }

Here is the call graph for this function:

DB_ENTRY DB_getSaiByMdb (  ULONG  mdb, DB_ID  id )

Function calculates SAI entry based on MDB offset. Parameters: mdb  MDB offset. id  DB ID. Returns: DB SAI entry. Definition at line 1703 of file db.c. References DB__cdDBdir(), DB__name(), DB__rootID(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), rb, and SEEK_HEAD. Referenced by UI_SF_dbmenu(). { File * idxfile; unsigned long signature; DB_ENTRY entry; unsigned short entryNum; ULONG mdbEnt[2]; /* Change to corresponding root DB directory. */ if(DB__cdDBdir(DB__name(DB__rootID(id), MDB)) == FALSE) { return DB_INVALID_ENTRY; } /* Open SAI file. */ idxfile = FAT_fopen(DB__name(id, SAI), rb); /* Check SAI file signature for safe. */ FAT_fread(idxfile, (unsigned short *)&signature, 2); if( signature != DB_SAI_SIGNATURE ) { /* Invalid field access. */ FAT_fclose(idxfile); return DB_INVALID_ENTRY; } /* Check if dbEntry is valid. */ FAT_fseek(idxfile, DB_SAIENTRYNUMOFFSET, SEEK_HEAD); FAT_fread(idxfile, &entryNum, 1); FAT_fseek(idxfile, (unsigned long)(DB_SAIFIRSTENTRY)<<2, SEEK_HEAD); entry = 0; while(entryNum--) { FAT_fread(idxfile, (unsigned short *)&mdbEnt, 4); if(mdbEnt[0] == mdb) { FAT_fclose(idxfile); return entry; } entry++; } FAT_fclose(idxfile); return DB_INVALID_ENTRY; }

Here is the call graph for this function:

st_DBINFO* DB_info (  DB_HDL  hdl  )

Function returns information of specified database. Parameters: hdl  DB query handle. Returns: DB info data pointer. Definition at line 1517 of file db.c. Referenced by UI_setupPlayQ(). { return(&DB_qinfo[hdl]); }

BOOL DB_init (  void   )

Function initializes DB controls. Returns: TRUE if successfully initialized, otherwise FALSE. Definition at line 1487 of file db.c. References st_DBIDTREE::counter, st_DBREGIST::fname, and st_DBQUERYCTL::free. { unsigned short ii; /* Clear database regisration table. */ for ( ii = 0; ii < DB_MAX_ID; ii++ ) DB_registration[ii].fname = NULL; /* Reset database ID tree. */ DB_idtree.counter = 0; /* Reset all available query controls. */ for( ii = 0; ii < DB_OPENMAX; ii++ ) DB_qctl[ii].free = TRUE; /* Initialize DB tree globale controls. */ //DB_ctl.actvHdl = DB_INVALID_HDL; return TRUE; }

DB_ID DB_parentID (  DB_ID  id  )

Function returns parent DB ID of the givent the child DB. Parameters: id  Child DB ID. Returns: Parent DB ID. Definition at line 1659 of file db.c. References st_DBIDTREE::node. { st_DBIDNODE * node; node = &DB_idtree.node[id]; /* Traverse to parent. */ if(node->parent) node = node->parent; return node->id; }

BOOL DB_queryClose (  DB_HDL  hdl  )

Function closes the specified database query operation and releases corresponding control data object. Parameters: hdl  DB query handle. Returns: TRUE if handle successfully closed, otherwise FALSE. Definition at line 574 of file db.c. References st_DBQUERYCTL::dbfile, FAT_fclose(), st_DBQUERYCTL::free, and st_DBQUERYCTL::idxfile. Referenced by MENU__createPresetMenu(), UI_audioPresetUpdate(), UI_playQreset(), UI_playQshutdown(), UI_presetAudio(), and UI_setupPlayQ(). { st_DBQUERYCTL * pCtl; if(hdl == DB_INVALID_HDL ) return FALSE; pCtl = &DB_qctl[hdl]; if(pCtl->free == TRUE) return TRUE; FAT_fclose(pCtl->dbfile); FAT_fclose(pCtl->idxfile); pCtl->free = TRUE; return TRUE; }

Here is the call graph for this function:

DB_HDL DB_queryFirst (  DB_ID  id, DB_FIELDIDX  fldIdx, DB_ENTRY  fldEntry, DB_ENTRY  dbEntry, DB_DATA *  pData )

Function queries the specified database and sets up query controls. Parameters: id  DB ID. fldIdx  Query field index. fldEntry  Query field entry. dbEntry  DB data entry. First long word contains record MDB offset. pData  DB record data. Returns: Valid query handle if successful, otherwise DB_INVALID_HDL. Note that a valid handle return does NOT mean a valid record has been found, the record might be empty. Definition at line 377 of file db.c. References st_DBINFO::bVirtual, DB__getRecord(), DB__info(), DB__name(), st_DBQUERYCTL::dbfile, FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), st_DBQUERYCTL::free, st_DBQUERYCTL::idx, st_DBQUERYCTL::idxfile, st_DBIDTREE::node, st_DBINFO::numOfKeys, st_DBINFO::numOfPAIent, st_DBQUERYCTL::pai, rb, SEEK_HEAD, and st_DBQUERYCTL::step. Referenced by MENU__createPresetMenu(), UI_audioPresetUpdate(), UI_playQreset(), UI_presetAudio(), and UI_setupPlayQ(). { DB_HDL hdl; DB_ID tmpid; USHORT entryNum; unsigned short ii; st_DBQUERYCTL * pCtl; st_DBIDNODE * node; st_DBINFO * pInfo; /* Locate first available query control OBJ. */ for( ii = 0; ii < DB_OPENMAX; ii++ ) { if( DB_qctl[ii].free == TRUE ) break; } if ( ii == DB_OPENMAX ) return DB_INVALID_HDL; /* Valid handle found. */ hdl = ii; pCtl = &DB_qctl[hdl]; pCtl->free = FALSE; pInfo = &DB_qinfo[hdl]; if( DB__info(id, pInfo) == FALSE ) { pCtl->free = TRUE; return DB_INVALID_HDL; } // start querying. node = &DB_idtree.node[id]; /* Check to see if id points to a virtual DB. */ //if( DB_registration[id].fname == NULL ) if(pInfo->bVirtual == TRUE) { /* Virtual DB, access through its parent. */ node = node->parent; return( _query(node->id, dbEntry, pData, hdl) ); } /* Check to see if primary key is used to access the database. */ //if( fldIdx == 0 ) if( (fldIdx == 0)||(fldIdx == 0xffff) ) { /* Primary key detected, query DB directly. */ return( _query(id, dbEntry, pData, hdl) ); } /* Following code to access DB using specified key. */ /* Check to see if this is a valid key. */ //if( DB__info(id, &info) == FALSE ) return DB_INVALID_HDL; //if( fldIdx >= info.numOfKeys ) return DB_INVALID_HDL; if( fldIdx >= pInfo->numOfKeys ) { pCtl->free = TRUE; return DB_INVALID_HDL; } /* Fetch the access field DB ID. */ node = node->child; for(ii = 0; ii < fldIdx; ii++ ) node = node->next; tmpid = node->id; /* Locate the key. */ hdl = _query(tmpid, fldEntry, pData, hdl); if(hdl == DB_INVALID_HDL) return hdl; //pCtl = &DB_qctl[hdl]; /* Close current MDB file. */ FAT_fclose(pCtl->dbfile); /* Close current SAI file. */ FAT_fclose(pCtl->idxfile); /* Open MDB file. */ pCtl->dbfile = FAT_fopen(DB__name(id, MDB), rb); /* Open PAI file. */ pCtl->idxfile = FAT_fopen(DB__name(tmpid, PAI), rb); if( pCtl->pai == 0) { /* Empty PAI entry. */ pCtl->free = TRUE; FAT_fclose(pCtl->idxfile); FAT_fclose(pCtl->dbfile); return DB_INVALID_HDL; } /* PAI entry always takes 32 bits. */ pCtl->step = 1; /* Locate the entry number. */ FAT_fseek(pCtl->idxfile, pCtl->pai - 4, SEEK_HEAD); FAT_fread(pCtl->idxfile, &entryNum, 1); pInfo->numOfPAIent = entryNum+1; if(dbEntry > entryNum) { /* Empty PAI entry. */ pCtl->free = TRUE; FAT_fclose(pCtl->idxfile); FAT_fclose(pCtl->dbfile); return DB_INVALID_HDL; } pCtl->idx = pCtl->pai; #if 1 /* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ** I chose the confusing way to ease my UI application. :( ** Any query via PAI MUST add ONE entry offset, thus the UI ** can use the same code to query no matter it is via SAI or PAI, ** since "dbEntry == 0" always points to the default empty entry ** if we directly query the DB through SAI ( fldIdx == 0 ). ** !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! */ pCtl->idx -= 2; #endif /* Locate the record index. */ FAT_fseek(pCtl->idxfile, pCtl->idx + (dbEntry << 1), SEEK_HEAD); FAT_fread(pCtl->idxfile, (unsigned short *)&pCtl->pai, 2); /* Locate the record. */ FAT_fseek(pCtl->dbfile, pCtl->pai, SEEK_HEAD); /* Fetch record. */ if( DB__getRecord(pCtl->dbfile, pData) == FALSE ) { /* No record available. */ pCtl->free = TRUE; FAT_fclose(pCtl->idxfile); FAT_fclose(pCtl->dbfile); return DB_INVALID_HDL; } return hdl; }

Here is the call graph for this function:

BOOL DB_queryNext (  DB_HDL  hdl, DB_ENTRY  entry, DB_DATA *  pData )

Function queries database through specified database handle. Parameters: hdl  DB query handle. entry  DB data entry. pData  DB record data buffer. First long word contains record MDB offset. Returns: TRUE if successfully queried, otherwise FALSE. Definition at line 539 of file db.c. References DB__getRecord(), st_DBQUERYCTL::dbfile, FAT_fread(), FAT_fseek(), st_DBQUERYCTL::idx, st_DBQUERYCTL::idxfile, SEEK_HEAD, and st_DBQUERYCTL::step. Referenced by UI_playQprevious(), and UI_setupPlayQ(). { DB_MDBOFFSET mdb = 0L; USHORT * pD = pData; st_DBQUERYCTL * pCtl = &DB_qctl[hdl]; FAT_fseek(pCtl->idxfile, pCtl->idx + (entry<<pCtl->step),SEEK_HEAD); FAT_fread(pCtl->idxfile, (unsigned short *)&mdb, 2); /* Reached top / bottom ? */ if( mdb == 0 ) return FALSE; /* Locate the record. */ FAT_fseek(pCtl->dbfile, mdb, SEEK_HEAD); if(pD) { *(USHORT*)pD++ = mdb>>16; *(USHORT*)pD++ = mdb&0xffff; } return( DB__getRecord(pCtl->dbfile, pD) ); }

Here is the call graph for this function:

BOOL DB_removeRecord (  DB_ID  childId, DB_ENTRY  childEntry, DB_ENTRY  paiEntry )

Function removes specified record reference from the child database. Parameters: childId  Child DB ID. childEntry  child DB entry. paiEntry  child DB PAI entry. Returns: TRUE if record successfully removed, otherwise FALSE. Definition at line 255 of file db.c. References DB__cdDBdir(), DB__deleteChildRecord(), DB__fieldIndex(), DB__getRecord(), DB__name(), DB__recordLen(), DB__removePAIentry(), DB__rootID(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), FAT_fwrite(), r_b, rb, and SEEK_HEAD. { unsigned short entryNum; DB_MDBOFFSET root; DB_MDBOFFSET child; DB_PAIOFFSET pai; DB_FIELDIDX fldidx; DB_RECLEN len; File * idxfile; File * dbfile; unsigned short record[DB_MAXRECLEN]; if(DB__cdDBdir(DB__name(DB__rootID(childId), MDB)) == FALSE) return FALSE; fldidx = DB__fieldIndex(childId); /* Fetch child MDB offset. */ idxfile = FAT_fopen(DB__name(childId, SAI), rb); FAT_fseek(idxfile, (long)(childEntry + DB_SAIFIRSTENTRY) << 2, SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&child, 2); FAT_fread(idxfile, (unsigned short *)&pai, 2); FAT_fclose(idxfile); /* Update root record, remove child index. */ idxfile = FAT_fopen(DB__name(childId, PAI), rb); FAT_fseek(idxfile, pai+((paiEntry-1)<<1), SEEK_HEAD); FAT_fread(idxfile, (unsigned short *)&root, 2); FAT_fclose(idxfile); dbfile = FAT_fopen(DB__name(DB__rootID(childId), MDB), r_b); FAT_fseek(dbfile, root, SEEK_HEAD); DB__getRecord(dbfile, record); _removeChildIdx(record, fldidx, child); len = DB__recordLen(record); FAT_fseek(dbfile, root, SEEK_HEAD); FAT_fwrite(dbfile, (unsigned short *)record, len); FAT_fclose(dbfile); /* Search child PAI to remove specified parent entry. */ DB__removePAIentry(childId, root, pai, &entryNum); if(entryNum == 0) { /* No PAIs left for this entry, delete it. */ DB__deleteChildRecord(childId, childEntry); } return TRUE; }

Here is the call graph for this function:

void DB_setSyncMark (  const char *  drive  )

Function sets the DB sync mark. The mark is set by firmware and cleared by NSM. Parameters: drive  Drive letter string. Definition at line 181 of file db.c. References FAT_cd(), FAT_fclose(), FAT_fopen(), FAT_fread(), FAT_fseek(), FAT_fwrite(), r_b, SEEK_HEAD, st_DBINFO::status, and strDBDIR. { st_DBHEADER header; File * file; FAT_cd(drive); if( TRUE == FAT_cd(strDBDIR) ) { if( TRUE == FAT_cd(strAUDIODIR) ) { if(file = FAT_fopen(strAUDIO, r_b)) { FAT_fseek(file, 0, SEEK_HEAD); if( FAT_fread(file, (unsigned short *)&header, sizeof(st_DBHEADER)) == sizeof(st_DBHEADER) ) { header.status |= 0x0002; } FAT_fseek(file, 0, SEEK_HEAD); FAT_fwrite(file, (unsigned short *)&header, sizeof(st_DBHEADER)); FAT_fclose(file); } } } }

Here is the call graph for this function:

---