event_db_repository.h 3.16 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
#ifndef _EVENT_DB_REPOSITORY_H_
#define _EVENT_DB_REPOSITORY_H_
/* Copyright (C) 2004-2006 MySQL AB

   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 */

unknown's avatar
unknown committed
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
enum enum_events_table_field
{
  ET_FIELD_DB = 0,
  ET_FIELD_NAME,
  ET_FIELD_BODY,
  ET_FIELD_DEFINER,
  ET_FIELD_EXECUTE_AT,
  ET_FIELD_INTERVAL_EXPR,
  ET_FIELD_TRANSIENT_INTERVAL,
  ET_FIELD_CREATED,
  ET_FIELD_MODIFIED,
  ET_FIELD_LAST_EXECUTED,
  ET_FIELD_STARTS,
  ET_FIELD_ENDS,
  ET_FIELD_STATUS,
  ET_FIELD_ON_COMPLETION,
  ET_FIELD_SQL_MODE,
  ET_FIELD_COMMENT,
  ET_FIELD_COUNT /* a cool trick to count the number of fields :) */
};


int
evex_db_find_event_by_name(THD *thd, const LEX_STRING dbname,
                           const LEX_STRING ev_name,
                           TABLE *table);

unknown's avatar
unknown committed
46 47 48 49 50 51 52 53 54 55 56
int
events_table_index_read_for_db(THD *thd, TABLE *schema_table,
                               TABLE *event_table);

int
events_table_scan_all(THD *thd, TABLE *schema_table, TABLE *event_table);

int
fill_schema_events(THD *thd, TABLE_LIST *tables, COND * /* cond */);


unknown's avatar
unknown committed
57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
class Event_queue_element;

class Event_db_repository
{
public:
  Event_db_repository(){}
  ~Event_db_repository(){}

  int
  init_repository();

  void
  deinit_repository();

  int
  create_event(THD *thd, Event_timed *et, my_bool create_if_not,
              uint *rows_affected);

  int
  update_event(THD *thd, Event_timed *et, sp_name *new_name);

  int 
  drop_event(THD *thd, LEX_STRING db, LEX_STRING name, bool drop_if_exists,
             uint *rows_affected);

  int
  drop_schema_events(THD *thd, LEX_STRING schema);

  int
  drop_user_events(THD *thd, LEX_STRING definer);

  int
  find_event(THD *thd, sp_name *name, Event_timed **ett, TABLE *tbl,
             MEM_ROOT *root);

  int
  load_named_event(THD *thd, Event_timed *etn, Event_timed **etn_new);

  int
  find_event_by_name(THD *thd, LEX_STRING db, LEX_STRING name, TABLE *table);

unknown's avatar
unknown committed
98 99 100 101 102 103 104
  int
  open_event_table(THD *thd, enum thr_lock_type lock_type, TABLE **table);

  int
  fill_schema_events(THD *thd, TABLE_LIST *tables, char *db);

private:
unknown's avatar
unknown committed
105 106 107
  int
  drop_events_by_field(THD *thd, enum enum_events_table_field field,
                       LEX_STRING field_value);
unknown's avatar
unknown committed
108 109 110 111 112 113
  int
  index_read_for_db_for_i_s(THD *thd, TABLE *schema_table, TABLE *event_table,
                            char *db);

  int
  table_scan_all_for_i_s(THD *thd, TABLE *schema_table, TABLE *event_table);
unknown's avatar
unknown committed
114 115 116 117 118 119 120

  MEM_ROOT repo_root;

  /* Prevent use of these */
  Event_db_repository(const Event_db_repository &);
  void operator=(Event_db_repository &);
};
121 122
 
#endif /* _EVENT_DB_REPOSITORY_H_ */