~drizzle-trunk/drizzle/development

1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
1
/* - mode: c; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
4
 *  Copyright (C) 2010 Brian Aker
5
 *
6
 *  This program is free software; you can redistribute it and/or modify
7
 *  it under the terms of the GNU General Public License as published by
8
 *  the Free Software Foundation; either version 2 of the License, or
9
 *  (at your option) any later version.
10
 *
11
 *  This program is distributed in the hope that it will be useful,
12
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
13
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14
 *  GNU General Public License for more details.
15
 *
16
 *  You should have received a copy of the GNU General Public License
17
 *  along with this program; if not, write to the Free Software
18
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
19
 */
20
2173.2.1 by Monty Taylor
Fixes incorrect usage of include
21
#include <config.h>
22
#include <plugin/information_schema_dictionary/dictionary.h>
1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
23
24
using namespace std;
25
using namespace drizzled;
26
27
ReferentialConstraints::ReferentialConstraints() :
28
  InformationSchema("REFERENTIAL_CONSTRAINTS")
29
{
30
  add_field("CONSTRAINT_CATALOG");
31
  add_field("CONSTRAINT_SCHEMA");
32
  add_field("CONSTRAINT_NAME");
33
  add_field("UNIQUE_CONSTRAINT_CATALOG");
34
  add_field("UNIQUE_CONSTRAINT_SCHEMA");
35
  add_field("UNIQUE_CONSTRAINT_NAME");
36
  add_field("MATCH_OPTION");
37
  add_field("UPDATE_RULE");
38
  add_field("DELETE_RULE");
39
}
40
41
ReferentialConstraints::Generator::Generator(drizzled::Field **arg) :
42
  InformationSchema::Generator(arg),
1861.4.8 by Brian Aker
Adds in a portion of the ref constraints table.
43
  foreign_key_generator(getSession())
1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
44
{
45
}
46
47
bool ReferentialConstraints::Generator::populate()
48
{
1861.4.8 by Brian Aker
Adds in a portion of the ref constraints table.
49
  drizzled::generator::FieldPair field_pair;
50
  while (!!(field_pair= foreign_key_generator))
51
  {
52
    const drizzled::message::Table *table_message= field_pair.first;
53
    const message::Table::ForeignKeyConstraint &foreign_key(table_message->fk_constraint(field_pair.second));
54
55
    // CONSTRAINT_CATALOG
56
    push(table_message->catalog());
57
58
    // CONSTRAINT_SCHEMA
59
    push(table_message->schema());
60
61
    // CONSTRAINT_NAME
62
    push(foreign_key.name());
63
64
    // UNIQUE_CONSTRAINT_CATALOG
65
    push(table_message->catalog());
66
    
67
    // UNIQUE_CONSTRAINT_SCHEMA
68
    push(table_message->schema());
69
70
    // UNIQUE_CONSTRAINT_NAME
71
    push(" ");
72
    
73
    // MATCH_OPTION 
74
    push(drizzled::message::type(foreign_key.match()));
75
    
76
    //UPDATE_RULE
77
    push(drizzled::message::type(foreign_key.update_option()));
78
79
    //DELETE_RULE
80
    push(drizzled::message::type(foreign_key.delete_option()));
81
82
    return true;
83
  }
84
85
  return false;
1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
86
}