~drizzle-trunk/drizzle/development

1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
1999.6.1 by kalebral at gmail
update Copyright strings to a more common format to help with creating the master debian copyright file
4
 *  Copyright (C) 2009 Sun Microsystems, Inc.
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
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 <drizzled/show.h>
23
#include <drizzled/session.h>
24
#include <drizzled/statement/savepoint.h>
25
#include <drizzled/transaction_services.h>
26
#include <drizzled/named_savepoint.h>
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
27
28
#include <string>
29
#include <deque>
30
31
using namespace std;
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
32
1130.3.12 by Monty Taylor
using namespace drizzled; to namespace drizzled { in statement/
33
namespace drizzled
34
{
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
35
36
bool statement::Savepoint::execute()
37
{
2227.4.1 by Olaf van der Spek
Statement::session()
38
  if (! (session().options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN)))
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
39
  {
2005.1.1 by David Shrewsbury
Fix for when SAVEPOINT or ROLLBACK TO SAVEPOINT starts a transaction with AUTOCOMMIT off and no BEGIN; also fix temp_tables test so it runs correctly independent of other tests
40
    /* AUTOCOMMIT is on and not in a BEGIN */
2227.4.1 by Olaf van der Spek
Statement::session()
41
    session().my_ok();
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
42
  }
43
  else
44
  {
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
45
    /*
2005.1.1 by David Shrewsbury
Fix for when SAVEPOINT or ROLLBACK TO SAVEPOINT starts a transaction with AUTOCOMMIT off and no BEGIN; also fix temp_tables test so it runs correctly independent of other tests
46
     * If AUTOCOMMIT is off and resource contexts are empty then we need
47
     * to start a transaction. It will be empty when SAVEPOINT starts the
48
     * transaction. Table affecting statements do this work in lockTables()
49
     * by calling startStatement().
50
     */
2227.4.1 by Olaf van der Spek
Statement::session()
51
    if ( (session().options & OPTION_NOT_AUTOCOMMIT) &&
2224.2.2 by Olaf van der Spek
Refactor
52
         (transaction().all.getResourceContexts().empty() == true) )
2005.1.1 by David Shrewsbury
Fix for when SAVEPOINT or ROLLBACK TO SAVEPOINT starts a transaction with AUTOCOMMIT off and no BEGIN; also fix temp_tables test so it runs correctly independent of other tests
53
    {
2227.4.1 by Olaf van der Spek
Statement::session()
54
      if (session().startTransaction() == false)
2005.1.1 by David Shrewsbury
Fix for when SAVEPOINT or ROLLBACK TO SAVEPOINT starts a transaction with AUTOCOMMIT off and no BEGIN; also fix temp_tables test so it runs correctly independent of other tests
55
      {
56
        return false;
57
      }
58
    }
59
60
    /*
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
61
     * Look through the savepoints.  If we find one with
62
     * the same name, delete it.
63
     */
64
    TransactionServices &transaction_services= TransactionServices::singleton();
2224.2.2 by Olaf van der Spek
Refactor
65
    deque<NamedSavepoint> &savepoints= transaction().savepoints;
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
66
    deque<NamedSavepoint>::iterator iter;
67
68
    for (iter= savepoints.begin();
69
         iter != savepoints.end();
70
         ++iter)
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
71
    {
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
72
      NamedSavepoint &sv= *iter;
73
      const string &sv_name= sv.getName();
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
74
      if (my_strnncoll(system_charset_info,
2224.2.8 by Olaf van der Spek
Statement::lex()
75
                       (unsigned char *) lex().ident.str,
76
                       lex().ident.length,
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
77
                       (unsigned char *) sv_name.c_str(),
78
                       sv_name.size()) == 0)
79
        break;
80
    }
81
    if (iter != savepoints.end())
82
    {
83
      NamedSavepoint &sv= *iter;
2227.4.2 by Olaf van der Spek
Statement::session()
84
      (void) transaction_services.releaseSavepoint(session(), sv);
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
85
      savepoints.erase(iter);
86
    }
87
    
2224.2.8 by Olaf van der Spek
Statement::lex()
88
    NamedSavepoint newsv(lex().ident.str, lex().ident.length);
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
89
2227.4.2 by Olaf van der Spek
Statement::session()
90
    if (transaction_services.setSavepoint(session(), newsv))
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
91
    {
92
      return true;
93
    }
94
    else
95
    {
1273.1.4 by Jay Pipes
This patch significantly reworks the way that
96
      savepoints.push_front(newsv);
2227.4.1 by Olaf van der Spek
Statement::session()
97
      session().my_ok();
1100.3.51 by Padraig O'Sullivan
Extracted the SAVEPOINT command into its own class and implementation files.
98
    }
99
  }
100
  return false;
101
}
1130.3.12 by Monty Taylor
using namespace drizzled; to namespace drizzled { in statement/
102
103
} /* namespace drizzled */