23

 * Parameter type

    24

 */

    25

enum evsql_param_format {

    26

    EVSQL_FMT_TEXT,

    27

    EVSQL_FMT_BINARY,

    28

};

    29

    30

enum evsql_param_type {

    31

    EVSQL_PARAM_INVALID,

    32

    33

    EVSQL_PARAM_NULL,

    34

    35

    EVSQL_PARAM_STRING,

    36

    EVSQL_PARAM_UINT16,

    37

    EVSQL_PARAM_UINT32,

    38

    EVSQL_PARAM_UINT64,

    39

};

    40

    41

/*

    48

    enum evsql_param_format result_fmt;

    52

        // the param type

    53

        enum evsql_param_type type;

    54

    55

        // pointer to the raw data

    56

        const char *data_raw;

    57

    58

        // the value

    59

        union {

    60

            uint16_t uint16;

    61

            uint32_t uint32;

    62

            uint64_t uint64;

    63

        } data;

    65

        // the explicit length of the parameter if it's binary, zero for text.

    66

        // set to -1 to indicate that the value is still missing

    67

        ssize_t length;

    72

#define EVSQL_PARAMS(result_fmt)            { result_fmt, 

    73

#define EVSQL_PARAM(typenam)                    { EVSQL_PARAM_ ## typenam, NULL }

    74

#define EVSQL_PARAMS_END                        { EVSQL_PARAM_INVALID, NULL } \

    75

                                              } // <<<

    80

union evsql_result {

    81

    // libpq

    82

    PGresult *pq;

    83

};

    84

    90

    union evsql_result result;

    99

typedef void (*evsql_query_cb)(const struct evsql_result_info *res, void *arg);

   121

struct evsql_query *evsql_query_params (struct evsql *evsql, const char *command, const struct evsql_query_params *params, evsql_query_cb query_fn, void *cb_arg);

   122

   123

/*

   124

 * Param-building functions

   125

 */

   126

int evsql_param_string (struct evsql_query_params *params, size_t param, const char *ptr);

   127

int evsql_param_uint32 (struct evsql_query_params *params, size_t param, uint32_t uval);

   128

   129

/*

   130

 * Result-handling functions

   131

 */

   132

   133

// get error message associated with function

   134

const char *evsql_result_error (const struct evsql_result_info *res);

   135

   136

// number of rows in the result

   137

size_t evsql_result_rows (const struct evsql_result_info *res);

   138

   139

// number of columns in the result

   140

size_t evsql_result_cols (const struct evsql_result_info *res);

   141

   142

// fetch the raw binary value from a result set, and return it via ptr

   143

// if size is nonzero, check that the size of the field data matches

   144

int evsql_result_binary (const struct evsql_result_info *res, size_t row, size_t col, const char **ptr, size_t size, int nullok);

   145

int evsql_result_string (const struct evsql_result_info *res, size_t row, size_t col, const char **ptr, int nullok);

   146

   147

// fetch certain kinds of values from a binary result set

   148

int evsql_result_uint16 (const struct evsql_result_info *res, size_t row, size_t col, uint16_t *uval, int nullok);

   149

int evsql_result_uint32 (const struct evsql_result_info *res, size_t row, size_t col, uint32_t *uval, int nullok);

   150

int evsql_result_uint64 (const struct evsql_result_info *res, size_t row, size_t col, uint64_t *uval, int nullok);

   151

   152

// release the result set, freeing its memory

   153

void evsql_result_free (const struct evsql_result_info *res);

   154

   155

// platform-dependant aliases

   156

#define evsql_result_ushort evsql_result_uint16

   157

   158

#if _LP64

   159

#define evsql_result_ulong evsql_result_uint64

   160

#else

   161

#define evsql_result_ulong evsql_result_uint32

   162

#endif /* _LP64 */