mirror of
https://github.com/php/pecl-database-dbase.git
synced 2026-03-24 07:22:13 +01:00
413bc9b4b4
Nullable fields are a FoxPro extension to DBF, and are implemented by adding a _NullFlags field of type '0' which stores a bitmask indicating which fields of the record are NULL. We're adding transparent support for nullable fields, i.e. the _NullFlags field is never shown to user, but rather when storing records with NULL values the _NullFlags are set appropriately, and when retrieving records with NULL values the respective elements are set to NULL. When creating a new DBF with dbase_create() the field specifications accept a further optional element (default is FALSE) that indicates whether the field is nullable. These nullable elements are ignored for DBASE_TYPE_DBASE. git-svn-id: http://svn.php.net/repository/pecl/dbase/trunk@340882 c90b9560-bf6c-de11-be94-00142212c4b1
102 lines
2.4 KiB
C
102 lines
2.4 KiB
C
/*
|
|
* Copyright (c) 1991, 1992, 1993 Brad Eacker,
|
|
* (Music, Intuition, Software, and Computers)
|
|
* All Rights Reserved
|
|
*/
|
|
|
|
/*
|
|
* dbf header structure on disk (pc dbase III)
|
|
*
|
|
* Basic info taken from:
|
|
* "File Formats for Popular PC Software"
|
|
* Jeff Walden
|
|
* (c) 1986 John Wiley & Sons, Inc.
|
|
*/
|
|
|
|
#ifndef DBF_H_
|
|
#define DBF_H_
|
|
|
|
#include <stdlib.h>
|
|
#include <string.h>
|
|
#ifdef WIN32
|
|
#include <io.h>
|
|
#else
|
|
#include <unistd.h>
|
|
#endif
|
|
|
|
/* So we can use O_BINARY on non-Win32 systems. */
|
|
#if !defined(O_BINARY) && !defined(WIN32)
|
|
#define O_BINARY (0)
|
|
#endif
|
|
|
|
struct dbf_dhead {
|
|
char dbh_dbt; /* memo (dbt) file present */
|
|
char dbh_date[3]; /* last update YY, MM, DD */
|
|
char dbh_records[4]; /* number of records LE */
|
|
char dbh_hlen[2]; /* header length LE */
|
|
char dbh_rlen[2]; /* record length LE */
|
|
char dbh_res[20]; /* padding */
|
|
};
|
|
#define DBH_DATE_YEAR 0 /* byte offset for year in dbh_date */
|
|
#define DBH_DATE_MONTH 1
|
|
#define DBH_DATE_DAY 2
|
|
|
|
/*
|
|
* field description on disk
|
|
*/
|
|
|
|
#define DBF_NAMELEN 11
|
|
|
|
struct dbf_dfield {
|
|
char dbf_name[DBF_NAMELEN]; /* name of field */
|
|
char dbf_type; /* type of field */
|
|
char dbf_fda[4]; /* something for dbase III */
|
|
char dbf_flen[2]; /* field length [and decimal if N] */
|
|
char dbf_flags; /* field flags (FoxPro) */
|
|
char dbf_res[13]; /* padding */
|
|
};
|
|
|
|
struct db_field {
|
|
char db_fname[DBF_NAMELEN+1]; /* 0 terminated */
|
|
char db_type; /* type of field */
|
|
int db_flen; /* length of field */
|
|
int db_fdc; /* number of decimals in field */
|
|
|
|
char *db_format; /* format for printing %s etc */
|
|
int db_foffset; /* offset within record */
|
|
int db_fnullable; /* nullable bit position */
|
|
};
|
|
typedef struct db_field dbfield_t;
|
|
|
|
struct db_head {
|
|
int db_fd;
|
|
unsigned char db_dbt; /* dbt present */
|
|
char db_date[9]; /* date of last update in db format */
|
|
long db_records; /* number of records */
|
|
int db_hlen; /* header length */
|
|
int db_rlen; /* record length */
|
|
|
|
int db_nfields; /* number of fields */
|
|
dbfield_t *db_fields; /* field info */
|
|
char *db_name; /* name of dbf file */
|
|
int db_cur_rec; /* current record */
|
|
int db_nnullable; /* number of nullable fields */
|
|
};
|
|
typedef struct db_head dbhead_t;
|
|
|
|
#define DBH_TYPE_NORMAL 0x03
|
|
#define DBH_TYPE_FOXPRO 0x30
|
|
#define DBH_TYPE_MEMO 0x83
|
|
|
|
/* dBase5 (for Win) allows that many */
|
|
#define DBH_MAX_FIELDS 1024
|
|
|
|
#define VALID_RECORD ' '
|
|
#define DELETED_RECORD '*'
|
|
|
|
#include "dbf_head.h"
|
|
#include "dbf_misc.h"
|
|
#include "dbf_rec.h"
|
|
|
|
#endif /* DBF_H_ */
|