awora.h

Go to the documentation of this file.

/*
** Copyright (C) 2002 Russell Leighton
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*/


#ifndef __AW_ORA__
#define __AW_ORA__

#include "awdb.h"

#include "monitor.h"

#include "wire.h"

#include "regexmatch.h"

#include <oratypes.h>
/* LDA and CDA struct declarations */
#include <ocidfn.h>
#include <ociapr.h>


/*

Changes:

01-28-03 Russell Leighton
Make connect/noconnect stateful

*/

#define MAX_ITEM_BUFFER_SIZE    33
#define MAX_SELECT_LIST_SIZE    12
#define MAX_SQL_IDENTIFIER      31

/*  internal/external datatype codes */
#define VARCHAR2_TYPE            1
#define NUMBER_TYPE              2
#define INT_TYPE                 3
#define FLOAT_TYPE               4
#define STRING_TYPE              5
#define ROWID_TYPE              11
#define DATE_TYPE               12

/*  ORACLE error codes used in demonstration programs */
#define VAR_NOT_IN_LIST       1007
#ifndef NO_DATA_FOUND
#  define NO_DATA_FOUND         1403
#endif
#define NULL_VALUE_RETURNED   1405

/*  some SQL and OCI function codes */
#define FT_INSERT                3
#define FT_SELECT                4
#define FT_UPDATE                5
#define FT_DELETE                9

#define FC_OOPEN                14

#define PARSE_NO_DEFER           0
#define PARSE_V7_LNG             2

/* Declare structures for query information. */
struct describe
{
    sb4             dbsize;
    sb2             dbtype;
    sb1             buf[MAX_ITEM_BUFFER_SIZE];
    sb4             buflen;
    sb4             dsize;
    sb2             precision;
    sb2             scale;
    sb2             nullok;
};

struct define
{
    ub1             buf[MAX_ITEM_BUFFER_SIZE];
    float           flt_buf;
    sword           int_buf;
    sb2             indp;
    ub2             col_retlen, col_retcode;
};

/* END crap ripped off from demo */


typedef struct {
  
  byte_t 
   *user,
   *passwd,
   *db;

} aw_ora_cinfo_t ;

typedef struct {
  
  /* oracle handles */
  Lda_Def 
   lda;
  ub4
   hda[HDA_SIZE/sizeof(ub4)];
  Cda_Def 
   cda;
  struct describe 
   desc[MAX_SELECT_LIST_SIZE];
  struct define   
   def[MAX_SELECT_LIST_SIZE];

} aw_ora_conn_t;

typedef struct {
  
  int32_t
    prev_connected, /* value for previous attempt */
    connected;      /* 1 for connected, -1 for not connected */

  u_int32_t
   connection_attempts;

  aw_ora_conn_t
   *conn;

  /* array 1-1 with the watchers, each val marks
     if a match occured during the probe, could be a bitmap, but I am being lazy */
  u_int32_t
   *match_markers;
  
} aw_ora_state_t ;

byte_t *aw_ora_error(Lda_Def *lda, Cda_Def *cursor, text *msg, sword msgsize);

void aw_ora_init(void);

int32_t aw_ora_initialized(void);

void aw_ora_disconnect(aw_ora_cinfo_t *cinfo, aw_ora_state_t *state, aw_logger_t *logger, int32_t close);

void aw_ora_disconnect_all(aw_ora_cinfo_t *cinfo, aw_ora_state_t *state, aw_logger_t *logger);

void aw_ora_connect(aw_ora_cinfo_t *cinfo, aw_ora_state_t *state, aw_logger_t *logger);

sword aw_ora_describe_define(Lda_Def *lda, Cda_Def *cda, struct describe *desc, struct define *def);

#endif

Aware 0.11.1 Copyright (C) 1998-2005 Russell Leighton (russ@elegant-software.com)