| Top |
| float | retrieve_float () |
| void | series_info_init () |
| void | series_info_set_description () |
| int | get_native_db_data () |
| int | get_remote_db_data () |
| int | get_pcgive_db_data () |
| int | get_rats_db_data () |
| dbwrapper * | read_rats_db () |
| dbwrapper * | read_pcgive_db () |
| dbwrapper * | dbwrapper_new () |
| void | dbwrapper_destroy () |
| int | set_db_name () |
| const char * | get_db_name () |
| int | dbnomics_is_open () |
| int | set_odbc_dsn () |
| int | db_set_sample () |
| int | db_get_series () |
| int | db_delete_series_by_name () |
| int | db_delete_series_by_number () |
| int | db_range_check () |
| int | check_db_import_conversion () |
| int | transcribe_db_data () |
| int | lib_spread_db_data () |
| int | lib_spread_dbnomics_data () |
| int | compact_dataset () |
| int | expand_dataset () |
| int | midas_days_per_period () |
| #define | DB_DESCRIP_LEN |
| #define | DB_INIT_ROWS |
| enum | DBError |
| typedef | dbnumber |
| SERIESINFO | |
| dbwrapper | |
| #define | ODBC_OBSCOLS |
| ODBC_info | |
| netfloat |
int get_rats_db_data (const char *fname,SERIESINFO *sinfo,double **Z);
Read the actual data values for a series from a RATS database.
dbwrapper * read_rats_db (const char *fname,FILE *fp);
Read the series info from a RATS 4.0 database: read the base block at offset 0 in the data file, and recurse through the directory entries.
dbwrapper * read_pcgive_db (const char *fname,FILE *fp);
Read the series info from a PcGive database, .in7 file
void
dbwrapper_destroy (dbwrapper *dw);
Frees all resources associated with dw
as well as the pointer
itself.
int db_range_check (int db_pd,const char *db_stobs,const char *db_endobs,const char *varname,DATASET *dset);
int transcribe_db_data (DATASET *dset,int targv,const double *src,int pd,int nobs,char *stobs,CompactMethod cmethod);
int lib_spread_db_data (double **dbZ,SERIESINFO *sinfo,DATASET *dset,PRN *prn);
int compact_dataset (DATASET *dset,int newpd,CompactMethod default_method,int wkstart,int repday);
Compact the data set from higher to lower frequency.
dset |
dataset struct. |
|
newpd |
target data frequency. |
|
default_method |
code for the default compaction method. |
|
wkstart |
the day on which a week is deemed to start: 1 for Monday or 7 for Sunday; relevant only for daily to weekly compaction. |
|
repday |
"representative day" for conversion from daily
to weekly data (with method |
int expand_dataset (DATASET *dset,int newpd);
Expand the data set from lower to higher frequency: an "expert" option. This is supported only for expansion from annual to quarterly or monthly, or from quarterly to monthly.
typedef struct {
int t1, t2, v;
char varname[VNAMELEN];
char *descrip;
int nobs;
char stobs[OBSLEN];
char endobs[OBSLEN];
int pd;
int offset;
int err;
int undated;
void *data;
} SERIESINFO;
typedef struct {
char *fname;
int dbtype;
int nv;
int nalloc;
SERIESINFO *sinfo;
} dbwrapper;
typedef struct {
char *dsn;
char *username;
char *password;
char *query;
char **fmts;
char coltypes[ODBC_OBSCOLS];
double **X;
char **S;
gretl_string_table *gst;
int nrows;
int obscols;
int nvars;
} ODBC_info;