~drizzle-trunk/drizzle/development : contents of drizzled/statement/create

~drizzle-trunk/drizzle/development : (revision 1933.1.1)

/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
 *
 *  Copyright (C) 2009 Sun Microsystems
 *
 *  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 "drizzled/show.h"
#include "drizzled/session.h"
#include "drizzled/statement/create_index.h"
#include "drizzled/statement/alter_table.h"
#include "drizzled/db.h"

namespace drizzled
{

bool statement::CreateIndex::execute()
{
  TableList *first_table= (TableList *) session->lex->select_lex.table_list.first;
  TableList *all_tables= session->lex->query_tables;

  /* Chicken/Egg... we need to search for the table, to know if the table exists, so we can build a full identifier from it */
  message::TablePtr original_table_message;
  {
    TableIdentifier identifier(first_table->getSchemaName(), first_table->getTableName());
    if (plugin::StorageEngine::getTableDefinition(*session, identifier, original_table_message) != EEXIST)
    {
      my_error(ER_BAD_TABLE_ERROR, MYF(0), identifier.getSQLPath().c_str());
      return true;
    }
  }

  /*
    CREATE INDEX and DROP INDEX are implemented by calling ALTER
    TABLE with proper arguments.

    In the future ALTER TABLE will notice that the request is to
    only add indexes and create these one by one for the existing
    table without having to do a full rebuild.
  */

  assert(first_table == all_tables && first_table != 0);
  if (! session->endActiveTransaction())
  {
    return true;
  }

  bool res;
  if (original_table_message->type() == message::Table::STANDARD )
  {
    TableIdentifier identifier(first_table->getSchemaName(), first_table->getTableName());
    create_info.default_table_charset= plugin::StorageEngine::getSchemaCollation(identifier);

    res= alter_table(session, 
                     identifier,
                     identifier,
                     &create_info, 
                     *original_table_message,
                     create_table_message, 
                     first_table,
                     &alter_info,
                     0, (Order*) 0, 0);
  }
  else
  {
    TableIdentifier catch22(first_table->getSchemaName(), first_table->getTableName());
    Table *table= session->find_temporary_table(catch22);
    assert(table);
    {
      TableIdentifier identifier(first_table->getSchemaName(), first_table->getTableName(), table->getMutableShare()->getPath());
      create_info.default_table_charset= plugin::StorageEngine::getSchemaCollation(identifier);

      res= alter_table(session, 
                       identifier,
                       identifier,
                       &create_info, 
                       *original_table_message,
                       create_table_message, 
                       first_table,
                       &alter_info,
                       0, (Order*) 0, 0);
    }
  }

  return res;
}

} /* namespace drizzled */

1100.3.62 by Padraig O'Sullivan Created a CreateIndex class and DropIndex class instead of a	1	/* -- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; --
	2	* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
	3	*
	4	* Copyright (C) 2009 Sun Microsystems
	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
1241.9.36 by Monty Taylor ZOMG. I deleted drizzled/server_includes.h.	21	#include "config.h"
1130.3.13 by Monty Taylor Finished cleaning namespaces in drizzled/statement	22	#include "drizzled/show.h"
	23	#include "drizzled/session.h"
	24	#include "drizzled/statement/create_index.h"
	25	#include "drizzled/statement/alter_table.h"
1235.4.23 by Stewart Smith fix includes for drizzled/db.h. Now only in .cc files, no header files. should make modifying db.h much less painful.	26	#include "drizzled/db.h"
1100.3.62 by Padraig O'Sullivan Created a CreateIndex class and DropIndex class instead of a	27
1130.3.12 by Monty Taylor using namespace drizzled; to namespace drizzled { in statement/	28	namespace drizzled
	29	{
1100.3.62 by Padraig O'Sullivan Created a CreateIndex class and DropIndex class instead of a	30
	31	bool statement::CreateIndex::execute()
	32	{
	33	TableList first_table= (TableList ) session->lex->select_lex.table_list.first;
	34	TableList *all_tables= session->lex->query_tables;
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	35
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	36	/* Chicken/Egg... we need to search for the table, to know if the table exists, so we can build a full identifier from it */
1910.2.15 by Brian Aker Update so that we use shared_ptr from the cache throughout more of the	37	message::TablePtr original_table_message;
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	38	{
1874.1.2 by Brian Aker Encapsulate table_name from table_list.	39	TableIdentifier identifier(first_table->getSchemaName(), first_table->getTableName());
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	40	if (plugin::StorageEngine::getTableDefinition(*session, identifier, original_table_message) != EEXIST)
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	41	{
1415 by Brian Aker Mass overhaul to use schema_identifier.	42	my_error(ER_BAD_TABLE_ERROR, MYF(0), identifier.getSQLPath().c_str());
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	43	return true;
	44	}
	45	}
	46
1100.3.62 by Padraig O'Sullivan Created a CreateIndex class and DropIndex class instead of a	47	/*
	48	CREATE INDEX and DROP INDEX are implemented by calling ALTER
	49	TABLE with proper arguments.
	50
	51	In the future ALTER TABLE will notice that the request is to
	52	only add indexes and create these one by one for the existing
	53	table without having to do a full rebuild.
	54	*/
	55
	56	assert(first_table == all_tables && first_table != 0);
	57	if (! session->endActiveTransaction())
	58	{
	59	return true;
	60	}
	61
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	62	bool res;
1910.2.15 by Brian Aker Update so that we use shared_ptr from the cache throughout more of the	63	if (original_table_message->type() == message::Table::STANDARD )
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	64	{
1874.1.2 by Brian Aker Encapsulate table_name from table_list.	65	TableIdentifier identifier(first_table->getSchemaName(), first_table->getTableName());
1415 by Brian Aker Mass overhaul to use schema_identifier.	66	create_info.default_table_charset= plugin::StorageEngine::getSchemaCollation(identifier);
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	67
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	68	res= alter_table(session,
1395.1.2 by Brian Aker More logic pulling from ALTER TABLE	69	identifier,
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	70	identifier,
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	71	&create_info,
1910.2.15 by Brian Aker Update so that we use shared_ptr from the cache throughout more of the	72	*original_table_message,
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	73	create_table_message,
	74	first_table,
	75	&alter_info,
1892.3.3 by tdavies struct order_st changed and renamed to c++ class named:Order	76	0, (Order*) 0, 0);
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	77	}
	78	else
	79	{
1874.1.2 by Brian Aker Encapsulate table_name from table_list.	80	TableIdentifier catch22(first_table->getSchemaName(), first_table->getTableName());
1864.3.14 by Brian Aker Remove cases where we do not use an identifier to find/delete temp tables,	81	Table *table= session->find_temporary_table(catch22);
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	82	assert(table);
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	83	{
1874.1.2 by Brian Aker Encapsulate table_name from table_list.	84	TableIdentifier identifier(first_table->getSchemaName(), first_table->getTableName(), table->getMutableShare()->getPath());
1415 by Brian Aker Mass overhaul to use schema_identifier.	85	create_info.default_table_charset= plugin::StorageEngine::getSchemaCollation(identifier);
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	86
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	87	res= alter_table(session,
1395.1.2 by Brian Aker More logic pulling from ALTER TABLE	88	identifier,
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	89	identifier,
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	90	&create_info,
1910.2.15 by Brian Aker Update so that we use shared_ptr from the cache throughout more of the	91	*original_table_message,
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	92	create_table_message,
	93	first_table,
	94	&alter_info,
1892.3.3 by tdavies struct order_st changed and renamed to c++ class named:Order	95	0, (Order*) 0, 0);
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	96	}
1389 by Brian Aker Large reord in ALTER TABLE for RENAME.	97	}
1502.1.30 by Brian Aker First pass on cleanup of Stewart's patch, plus re-engineer to make it work a	98
1100.3.62 by Padraig O'Sullivan Created a CreateIndex class and DropIndex class instead of a	99	return res;
	100	}
1130.3.12 by Monty Taylor using namespace drizzled; to namespace drizzled { in statement/	101
	102	} /* namespace drizzled */