~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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
46
47
48
49
50
51
52
53
54
55
56
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
/* - mode: c; c-basic-offset: 2; indent-tabs-mode: nil; -*-
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
 *
 *  Copyright (C) 2010 Brian Aker
 *
 *  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., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 */

#include <config.h>
#include <plugin/information_schema_dictionary/dictionary.h>

using namespace std;
using namespace drizzled;

TableConstraints::TableConstraints() :
  InformationSchema("TABLE_CONSTRAINTS")
{
  add_field("CONSTRAINT_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
  add_field("CONSTRAINT_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
  add_field("CONSTRAINT_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
  add_field("TABLE_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
  add_field("TABLE_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
  add_field("TABLE_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
  add_field("CONSTRAINT_TYPE");
  add_field("IS_DEFERRABLE", plugin::TableFunction::BOOLEAN, 0, false);
  add_field("INITIALLY_DEFERRED", plugin::TableFunction::BOOLEAN, 0, false);
}

TableConstraints::Generator::Generator(drizzled::Field **arg) :
  InformationSchema::Generator(arg),
  generator(getSession()),
  index_iterator(0)
{
  while (not (table_message= generator))
  { };
}

bool TableConstraints::Generator::populate()
{
  if (not table_message)
    return false;

  do 
  {
    if (index_iterator != table_message->indexes_size())
    {
      drizzled::message::Table::Index index= table_message->indexes(index_iterator);

      index_iterator++;

      if (index.is_primary() || index.is_unique())
      {
        /* Constraints live in the same catalog.schema as the table they refer too. */
        /* CONSTRAINT_CATALOG */
        push(table_message->catalog());

        /* CONSTRAINT_SCHEMA */
        push(table_message->schema());

        /* CONSTRAINT_NAME */
        push(index.name());

        /* TABLE_CATALOG */
        push(table_message->catalog());

        /* TABLE_SCHEMA */
        push(table_message->schema());

        /* TABLE_NAME */
        push(table_message->name());

        /* CONSTRAINT_TYPE */
        if (index.is_primary())
        {
          push("PRIMARY KEY");
        }
        else if (index.is_unique())
        {
          push("UNIQUE");
        }
        else
        {
          assert(0);
          push("UNIQUE");
        }

        /* IS_DEFERRABLE */
        push(false);

        /* INITIALLY_DEFERRED */
        push(false);

        return true;
      }
    }

    index_iterator= 0;

  } while ((table_message= generator));

  return false;
}