~drizzle-trunk/drizzle/development

1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
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>
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
22
2173.2.1 by Monty Taylor
Fixes incorrect usage of include
23
#include <plugin/show_dictionary/dictionary.h>
2263.3.11 by Olaf van der Spek
Open Tables
24
#include <drizzled/open_tables_state.h>
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
25
26
using namespace std;
27
using namespace drizzled;
28
1320.1.17 by Brian Aker
New code for a show temporary tables;
29
ShowTemporaryTables::ShowTemporaryTables() :
1874.2.4 by Brian Aker
Have show functions be invisible.
30
  show_dictionary::Show("SHOW_TEMPORARY_TABLES")
1320.1.17 by Brian Aker
New code for a show temporary tables;
31
{
2338.2.5 by Stewart Smith
use MAXIMUM_IDENTIFIER_LENGTH for SHOW_TEMPORARY_TABLES columns
32
  add_field("TABLE_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
33
  add_field("TABLE_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
1643.3.10 by Brian Aker
Column support, clean up of IS/DD for NULL type.
34
  add_field("RECORDS", plugin::TableFunction::NUMBER, 0, false);
35
  add_field("RECORD_LENGTH", plugin::TableFunction::NUMBER, 0, false);
1320.1.17 by Brian Aker
New code for a show temporary tables;
36
  add_field("ENGINE");
37
}
38
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
39
ShowTemporaryTables::Generator::Generator(Field **arg) :
1874.2.4 by Brian Aker
Have show functions be invisible.
40
  show_dictionary::Show::Generator(arg),
1604 by Brian Aker
REmove current_session for heap, show temp
41
  session(getSession())
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
42
{
2263.3.2 by Olaf van der Spek
Use open_tables
43
  table= session.open_tables.getTemporaryTables();
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
44
}
45
46
bool ShowTemporaryTables::Generator::populate()
47
{
1429.1.2 by Brian Aker
Update for show temporary tables;
48
  while (table)
49
  {
1532.1.15 by Brian Aker
Partial encapsulation of TableShare from Table.
50
    if (not isWild(table->getShare()->getTableName()))
1429.1.2 by Brian Aker
Update for show temporary tables;
51
    {
52
      break;
53
    }
1608 by Brian Aker
This encapsulates prev/next.
54
    table= table->getNext();
1429.1.2 by Brian Aker
Update for show temporary tables;
55
  }
56
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
57
  if (not table)
58
    return false;
59
60
  fill();
61
1608 by Brian Aker
This encapsulates prev/next.
62
  table= table->getNext();
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
63
64
  return true;
65
}
66
67
void ShowTemporaryTables::Generator::fill()
68
{
69
  /* TABLE_SCHEMA */
1532.1.15 by Brian Aker
Partial encapsulation of TableShare from Table.
70
  push(table->getShare()->getSchemaName());
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
71
72
  /* TABLE_NAME */
1532.1.15 by Brian Aker
Partial encapsulation of TableShare from Table.
73
  push(table->getShare()->getTableName());
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
74
1320.1.17 by Brian Aker
New code for a show temporary tables;
75
  /* RECORDS */
1320.1.18 by Brian Aker
Overhaul of SHOW TABLE STATUS.
76
  push(static_cast<uint64_t>(table->getCursor().records()));
1320.1.17 by Brian Aker
New code for a show temporary tables;
77
78
  /* RECORD_LENGTH */
79
  push(static_cast<uint64_t>(table->getRecordLength()));
80
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
81
  /* ENGINE */
1320.1.17 by Brian Aker
New code for a show temporary tables;
82
  push(table->getEngine()->getName());
1320.1.16 by Brian Aker
First pass through creating a DD for showing what temporary tables you
83
}