database.h

一个数据库引擎,可以创建和读写DBF格式的数据库文件

#ifndef _DATABASE_H_
#define _DATABASE_H_

#include "stddefs.h"
#include "funcdef.h"

#define DBF_IS_PACKED	0x0001
#define DBF_NO_PACKED	0x0000
#define NOT_DELETE_REC  0x0000
#define IS_DELETE_REC	0x0001

#define SORT_ASCENDING	0	//从小到大排序
#define SORT_DESCENDING 1	//从大到小排序

sint CreateDBF(schar *name, struct TTableField *fields, uchar num, uint mode);
sint PackDBF(schar *src);

sint DeleteRec(struct FCFILE *file, ulong recno);
ulong AppendRec(struct FCFILE *file);
sint UpdateRec(struct FCFILE *file, ulong recno, uchar fieldno, schar *data);
sint ReadRec(struct FCFILE *file, ulong recno, uchar fieldno, schar *data);
sint InsertRec(struct FCFILE *file, ulong recno);

ulong GetRecCount(struct FCFILE *file);
uchar GetFieldCount(struct FCFILE *file);
sint GetFieldNameByNo(struct FCFILE *file, uchar fieldno, schar *name);
sint GetRecStatus(struct FCFILE *file, ulong recno);

ulong GetNextOneValidRec(struct FCFILE *file,ulong recno, uchar flag);
ulong GetPriOneValidRec(struct FCFILE *file,ulong recno, uchar flag);
uchar GetNextValidRecArray(struct FCFILE *file, ulong recno,ulong *array, uchar count);
uchar GetPriValidRecArray(struct FCFILE *file, ulong recno,ulong *array, uchar count);
ulong GetValidRecCount(struct FCFILE *file);

sint Idx_CreateFile(schar *name, uchar fieldnum, uchar *fieldno, uchar sorttype);
sint Idx_OpenFile(schar *name, struct FCFILE *dbffile);
sint Idx_CloseFile(void);
sint Idx_DelRec(uint recno);
sint Idx_AppendRec(uint recno, schar *str);
sint Idx_UpdateRec(uint recno, schar *str);
//获得首记录
//返回-1表示不存在记录
//返回1表示成功
sint GetFirstSortedRec(uint *recno);
//获得下一个记录
//返回-1表示不存在记录
//返回1表示成功
sint GetNextSortedRec(uint *recno);
//获得上一个记录
//返回-1表示不存在记录
//返回1表示成功
sint GetPriSortedRec(uint *recno);
//获得最后一个记录
//返回-1表示不存在记录
//返回1表示成功
sint GetLastSortedRec(uint *recno);

sint CreateIdxChain(uint *chain);

#endif