procedure.h 4.9 KB
Newer Older
unknown's avatar
unknown committed
1
/* Copyright (C) 2000-2005 MySQL AB
unknown's avatar
unknown committed
2

unknown's avatar
unknown committed
3 4
   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
unknown's avatar
unknown committed
5
   the Free Software Foundation; version 2 of the License.
unknown's avatar
unknown committed
6

unknown's avatar
unknown committed
7 8 9 10
   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.
unknown's avatar
unknown committed
11

unknown's avatar
unknown committed
12 13 14 15 16 17 18
   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 */


/* When using sql procedures */

19
#ifdef USE_PRAGMA_INTERFACE
unknown's avatar
unknown committed
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
#pragma interface				/* gcc class implementation */
#endif

#define PROC_NO_SORT 1				/* Bits in flags */
#define PROC_GROUP   2				/* proc must have group */

/* Procedure items used by procedures to store values for send_fields */

class Item_proc :public Item
{
public:
  Item_proc(const char *name_par): Item()
  {
     this->name=(char*) name_par;
  }
  enum Type type() const { return Item::PROC_ITEM; }
  virtual void set(double nr)=0;
37
  virtual void set(const char *str,uint length,CHARSET_INFO *cs)=0;
unknown's avatar
unknown committed
38 39
  virtual void set(longlong nr)=0;
  virtual enum_field_types field_type() const=0;
40
  void set(const char *str) { set(str,(uint) strlen(str), default_charset()); }
unknown's avatar
unknown committed
41 42 43 44
  void make_field(Send_field *tmp_field)
  {
    init_make_field(tmp_field,field_type());
  }
45
  unsigned int size_of() { return sizeof(*this);}  
unknown's avatar
unknown committed
46 47 48 49 50 51 52 53 54 55 56
};

class Item_proc_real :public Item_proc
{
  double value;
public:
  Item_proc_real(const char *name_par,uint dec) : Item_proc(name_par)
  {
     decimals=dec; max_length=float_length(dec);
  }
  enum Item_result result_type () const { return REAL_RESULT; }
57
  enum_field_types field_type() const { return MYSQL_TYPE_DOUBLE; }
unknown's avatar
unknown committed
58 59
  void set(double nr) { value=nr; }
  void set(longlong nr) { value=(double) nr; }
60
  void set(const char *str,uint length,CHARSET_INFO *cs)
unknown's avatar
unknown committed
61 62 63 64 65
  {
    int err_not_used;
    char *end_not_used;
    value= my_strntod(cs,(char*) str,length, &end_not_used, &err_not_used);
  }
66
  double val_real() { return value; }
unknown's avatar
unknown committed
67
  longlong val_int() { return (longlong) value; }
unknown's avatar
unknown committed
68 69 70 71 72
  String *val_str(String *s)
  {
    s->set(value,decimals,default_charset());
    return s;
  }
unknown's avatar
unknown committed
73
  my_decimal *val_decimal(my_decimal *);
74
  unsigned int size_of() { return sizeof(*this);}  
unknown's avatar
unknown committed
75 76 77 78 79 80 81 82 83
};

class Item_proc_int :public Item_proc
{
  longlong value;
public:
  Item_proc_int(const char *name_par) :Item_proc(name_par)
  { max_length=11; }
  enum Item_result result_type () const { return INT_RESULT; }
84
  enum_field_types field_type() const { return MYSQL_TYPE_LONGLONG; }
unknown's avatar
unknown committed
85 86
  void set(double nr) { value=(longlong) nr; }
  void set(longlong nr) { value=nr; }
87
  void set(const char *str,uint length, CHARSET_INFO *cs)
88
  { int err; value=my_strntoll(cs,str,length,10,NULL,&err); }
89
  double val_real() { return (double) value; }
unknown's avatar
unknown committed
90
  longlong val_int() { return value; }
91
  String *val_str(String *s) { s->set(value, default_charset()); return s; }
unknown's avatar
unknown committed
92
  my_decimal *val_decimal(my_decimal *);
93
  unsigned int size_of() { return sizeof(*this);}  
unknown's avatar
unknown committed
94 95 96 97 98 99 100 101 102
};


class Item_proc_string :public Item_proc
{
public:
  Item_proc_string(const char *name_par,uint length) :Item_proc(name_par)
    { this->max_length=length; }
  enum Item_result result_type () const { return STRING_RESULT; }
103
  enum_field_types field_type() const { return MYSQL_TYPE_VARCHAR; }
104 105
  void set(double nr) { str_value.set(nr, 2, default_charset()); }
  void set(longlong nr) { str_value.set(nr, default_charset()); }
106 107
  void set(const char *str, uint length, CHARSET_INFO *cs)
  { str_value.copy(str,length,cs); }
108
  double val_real()
109
  { 
unknown's avatar
unknown committed
110 111
    int err_not_used;
    char *end_not_used;
unknown's avatar
unknown committed
112
    CHARSET_INFO *cs= str_value.charset();
113
    return my_strntod(cs, (char*) str_value.ptr(), str_value.length(),
unknown's avatar
unknown committed
114
		      &end_not_used, &err_not_used);
115 116 117
  }
  longlong val_int()
  { 
118
    int err;
119
    CHARSET_INFO *cs=str_value.charset();
120
    return my_strntoll(cs,str_value.ptr(),str_value.length(),10,NULL,&err);
121
  }
unknown's avatar
unknown committed
122 123 124 125
  String *val_str(String*)
  {
    return null_value ? (String*) 0 : (String*) &str_value;
  }
unknown's avatar
unknown committed
126
  my_decimal *val_decimal(my_decimal *);
127
  unsigned int size_of() { return sizeof(*this);}  
unknown's avatar
unknown committed
128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
};

/* The procedure class definitions */

class Procedure {
protected:
  List<Item> *fields;
  select_result *result;
public:
  const uint flags;
  ORDER *group,*param_fields;
  Procedure(select_result *res,uint flags_par) :result(res),flags(flags_par),
    group(0),param_fields(0) {}
  virtual ~Procedure() {group=param_fields=0; fields=0; }
  virtual void add(void)=0;
  virtual void end_group(void)=0;
  virtual int send_row(List<Item> &fields)=0;
  virtual bool change_columns(List<Item> &fields)=0;
  virtual void update_refs(void) {}
147
  virtual int end_of_records() { return 0; }
unknown's avatar
unknown committed
148 149 150 151
};

Procedure *setup_procedure(THD *thd,ORDER *proc_param,select_result *result,
			   List<Item> &field_list,int *error);