mirror of
https://github.com/VCMP-SqMod/SqMod.git
synced 2024-11-08 00:37:15 +01:00
260 lines
8.0 KiB
C
260 lines
8.0 KiB
C
/* Copyright (c) 2011, Monty Program Ab
|
|
Copyright (c) 2011, Oleksandr Byelkin
|
|
|
|
Redistribution and use in source and binary forms, with or without
|
|
modification, are permitted provided that the following conditions are
|
|
met:
|
|
|
|
1. Redistributions of source code must retain the above copyright
|
|
notice, this list of conditions and the following disclaimer.
|
|
|
|
2. Redistributions in binary form must the following disclaimer in
|
|
the documentation and/or other materials provided with the
|
|
distribution.
|
|
|
|
THIS SOFTWARE IS PROVIDED BY <COPYRIGHT HOLDER> ``AS IS'' AND ANY
|
|
EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
|
|
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
|
|
PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL <COPYRIGHT HOLDER> OR
|
|
CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
|
|
SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
|
|
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
|
|
USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
|
|
ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
|
|
OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
|
|
OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
|
|
SUCH DAMAGE.
|
|
*/
|
|
|
|
#ifndef ma_dyncol_h
|
|
#define ma_dyncol_h
|
|
|
|
#ifdef __cplusplus
|
|
extern "C" {
|
|
#endif
|
|
|
|
#ifndef LIBMARIADB
|
|
#include <decimal.h>
|
|
#include <my_decimal_limits.h>
|
|
#endif
|
|
#include <mysql.h>
|
|
|
|
#ifndef longlong_defined
|
|
#if defined(HAVE_LONG_LONG) && SIZEOF_LONG != 8
|
|
typedef unsigned long long int ulonglong; /* ulong or unsigned long long */
|
|
typedef long long int longlong;
|
|
#else
|
|
typedef unsigned long ulonglong; /* ulong or unsigned long long */
|
|
typedef long longlong;
|
|
#endif
|
|
#define longlong_defined
|
|
#endif
|
|
|
|
|
|
#ifndef _my_sys_h
|
|
typedef struct st_dynamic_string
|
|
{
|
|
char *str;
|
|
size_t length,max_length,alloc_increment;
|
|
} DYNAMIC_STRING;
|
|
#endif
|
|
|
|
struct st_mysql_lex_string
|
|
{
|
|
char *str;
|
|
size_t length;
|
|
};
|
|
typedef struct st_mysql_lex_string MYSQL_LEX_STRING;
|
|
typedef struct st_mysql_lex_string LEX_STRING;
|
|
/*
|
|
Limits of implementation
|
|
*/
|
|
#define MAX_TOTAL_NAME_LENGTH 65535
|
|
#define MAX_NAME_LENGTH (MAX_TOTAL_NAME_LENGTH/4)
|
|
|
|
/* NO and OK is the same used just to show semantics */
|
|
#define ER_DYNCOL_NO ER_DYNCOL_OK
|
|
|
|
enum enum_dyncol_func_result
|
|
{
|
|
ER_DYNCOL_OK= 0,
|
|
ER_DYNCOL_YES= 1, /* For functions returning 0/1 */
|
|
ER_DYNCOL_FORMAT= -1, /* Wrong format of the encoded string */
|
|
ER_DYNCOL_LIMIT= -2, /* Some limit reached */
|
|
ER_DYNCOL_RESOURCE= -3, /* Out of resourses */
|
|
ER_DYNCOL_DATA= -4, /* Incorrect input data */
|
|
ER_DYNCOL_UNKNOWN_CHARSET= -5, /* Unknown character set */
|
|
ER_DYNCOL_TRUNCATED= 2 /* OK, but data was truncated */
|
|
};
|
|
|
|
typedef DYNAMIC_STRING DYNAMIC_COLUMN;
|
|
|
|
enum enum_dynamic_column_type
|
|
{
|
|
DYN_COL_NULL= 0,
|
|
DYN_COL_INT,
|
|
DYN_COL_UINT,
|
|
DYN_COL_DOUBLE,
|
|
DYN_COL_STRING,
|
|
DYN_COL_DECIMAL,
|
|
DYN_COL_DATETIME,
|
|
DYN_COL_DATE,
|
|
DYN_COL_TIME,
|
|
DYN_COL_DYNCOL
|
|
};
|
|
|
|
typedef enum enum_dynamic_column_type DYNAMIC_COLUMN_TYPE;
|
|
|
|
struct st_dynamic_column_value
|
|
{
|
|
DYNAMIC_COLUMN_TYPE type;
|
|
union
|
|
{
|
|
long long long_value;
|
|
unsigned long long ulong_value;
|
|
double double_value;
|
|
struct {
|
|
MYSQL_LEX_STRING value;
|
|
MARIADB_CHARSET_INFO *charset;
|
|
} string;
|
|
#ifndef LIBMARIADB
|
|
struct {
|
|
decimal_digit_t buffer[DECIMAL_BUFF_LENGTH];
|
|
decimal_t value;
|
|
} decimal;
|
|
#endif
|
|
MYSQL_TIME time_value;
|
|
} x;
|
|
};
|
|
|
|
typedef struct st_dynamic_column_value DYNAMIC_COLUMN_VALUE;
|
|
|
|
#ifdef MADYNCOL_DEPRECATED
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_create(DYNAMIC_COLUMN *str,
|
|
uint column_nr, DYNAMIC_COLUMN_VALUE *value);
|
|
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_create_many(DYNAMIC_COLUMN *str,
|
|
uint column_count,
|
|
uint *column_numbers,
|
|
DYNAMIC_COLUMN_VALUE *values);
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_update(DYNAMIC_COLUMN *org, uint column_nr,
|
|
DYNAMIC_COLUMN_VALUE *value);
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_update_many(DYNAMIC_COLUMN *str,
|
|
uint add_column_count,
|
|
uint *column_numbers,
|
|
DYNAMIC_COLUMN_VALUE *values);
|
|
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_exists(DYNAMIC_COLUMN *org, uint column_nr);
|
|
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_list(DYNAMIC_COLUMN *org, DYNAMIC_ARRAY *array_of_uint);
|
|
|
|
enum enum_dyncol_func_result
|
|
dynamic_column_get(DYNAMIC_COLUMN *org, uint column_nr,
|
|
DYNAMIC_COLUMN_VALUE *store_it_here);
|
|
#endif
|
|
|
|
/* new functions */
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_create_many_num(DYNAMIC_COLUMN *str,
|
|
uint column_count,
|
|
uint *column_numbers,
|
|
DYNAMIC_COLUMN_VALUE *values,
|
|
my_bool new_string);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_create_many_named(DYNAMIC_COLUMN *str,
|
|
uint column_count,
|
|
MYSQL_LEX_STRING *column_keys,
|
|
DYNAMIC_COLUMN_VALUE *values,
|
|
my_bool new_string);
|
|
|
|
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_update_many_num(DYNAMIC_COLUMN *str,
|
|
uint add_column_count,
|
|
uint *column_keys,
|
|
DYNAMIC_COLUMN_VALUE *values);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_update_many_named(DYNAMIC_COLUMN *str,
|
|
uint add_column_count,
|
|
MYSQL_LEX_STRING *column_keys,
|
|
DYNAMIC_COLUMN_VALUE *values);
|
|
|
|
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_exists_num(DYNAMIC_COLUMN *org, uint column_nr);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_exists_named(DYNAMIC_COLUMN *str, MYSQL_LEX_STRING *name);
|
|
|
|
/* List of not NULL columns */
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_list_num(DYNAMIC_COLUMN *str, uint *count, uint **nums);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_list_named(DYNAMIC_COLUMN *str, uint *count,
|
|
MYSQL_LEX_STRING **names);
|
|
|
|
/*
|
|
if the column do not exists it is NULL
|
|
*/
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_get_num(DYNAMIC_COLUMN *org, uint column_nr,
|
|
DYNAMIC_COLUMN_VALUE *store_it_here);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_get_named(DYNAMIC_COLUMN *str, MYSQL_LEX_STRING *name,
|
|
DYNAMIC_COLUMN_VALUE *store_it_here);
|
|
|
|
my_bool mariadb_dyncol_has_names(DYNAMIC_COLUMN *str);
|
|
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_check(DYNAMIC_COLUMN *str);
|
|
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_json(DYNAMIC_COLUMN *str, DYNAMIC_STRING *json);
|
|
|
|
void mariadb_dyncol_free(DYNAMIC_COLUMN *str);
|
|
|
|
#define mariadb_dyncol_init(A) memset((A), 0, sizeof(DYNAMIC_COLUMN))
|
|
#define dynamic_column_initialize(A) mariadb_dyncol_init((A))
|
|
#define dynamic_column_column_free(A) mariadb_dyncol_free((A))
|
|
|
|
/* conversion of values to 3 base types */
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_val_str(DYNAMIC_STRING *str, DYNAMIC_COLUMN_VALUE *val,
|
|
MARIADB_CHARSET_INFO *cs, char quote);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_val_long(longlong *ll, DYNAMIC_COLUMN_VALUE *val);
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_val_double(double *dbl, DYNAMIC_COLUMN_VALUE *val);
|
|
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_unpack(DYNAMIC_COLUMN *str,
|
|
uint *count,
|
|
MYSQL_LEX_STRING **names, DYNAMIC_COLUMN_VALUE **vals);
|
|
|
|
int mariadb_dyncol_column_cmp_named(const MYSQL_LEX_STRING *s1,
|
|
const MYSQL_LEX_STRING *s2);
|
|
|
|
enum enum_dyncol_func_result
|
|
mariadb_dyncol_column_count(DYNAMIC_COLUMN *str, uint *column_count);
|
|
|
|
#define mariadb_dyncol_value_init(V) \
|
|
do {\
|
|
(V)->type= DYN_COL_NULL;\
|
|
} while(0)
|
|
|
|
/*
|
|
Prepare value for using as decimal
|
|
*/
|
|
void mariadb_dyncol_prepare_decimal(DYNAMIC_COLUMN_VALUE *value);
|
|
|
|
|
|
#ifdef __cplusplus
|
|
}
|
|
#endif
|
|
#endif
|