diff options
author | drx777 <david.rekowski@gmx.de> | 2010-04-28 17:11:41 +0000 |
---|---|---|
committer | drx777 <david.rekowski@gmx.de> | 2010-04-28 17:11:41 +0000 |
commit | f36685ae1bee7b9274de27414ab8b64dbc57770f (patch) | |
tree | 269b242812332fab9bfdbe37955fbfbe72a87def /Source/SPTableCopy.h | |
parent | 29b42d1c3b751781fb70684f5bb779001d19b1f3 (diff) | |
download | sequelpro-f36685ae1bee7b9274de27414ab8b64dbc57770f.tar.gz sequelpro-f36685ae1bee7b9274de27414ab8b64dbc57770f.tar.bz2 sequelpro-f36685ae1bee7b9274de27414ab8b64dbc57770f.zip |
This changeset implements renaming and duplicating databases on a server. Details as follows:
* altered MCPConnection listTablesFromDB:like: to return NSArray
* altered MCPConnection listFieldsFromTable:like: to use backtick quoted
strings for table and fieldnames
* added MCPConnection listTablesFromDB for a complete table list
* added SPStringAdditions.h to various files to prevent warnings
* added sheets for duplicate/rename DB in DBView.xib
* added duplicate/rename menu items to MainMenu.xib
* added outlets in TableDocument: databaseNewSheet databaseRenameSheet
databaseCopyNameField databaseRenameNameField copyOnlyStructureButton
copyDatabaseButton renameDatabaseButton
* added methods in TableDocument: getConnection, copyDatabase, renameDatabase,
_copyDatabase, _renameDatabase
* added OCMock Framework for object mocking in tests
* added group Others/DatabaseActions
Diffstat (limited to 'Source/SPTableCopy.h')
-rw-r--r-- | Source/SPTableCopy.h | 74 |
1 files changed, 74 insertions, 0 deletions
diff --git a/Source/SPTableCopy.h b/Source/SPTableCopy.h new file mode 100644 index 00000000..23cf9dc1 --- /dev/null +++ b/Source/SPTableCopy.h @@ -0,0 +1,74 @@ +// +// $Id: $ +// +// SPTableCopy.h +// sequel-pro +// +// Created by David Rekowski on Apr 13, 2010 +// +// 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., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA +// +// More info at <http://code.google.com/p/sequel-pro/> + +#import <Foundation/Foundation.h> +#import <MCPKit/MCPConnection.h> + +/** + * The SPTableCopy class povides functionality to copy tables between databases. + */ +@interface SPTableCopy : NSObject { + MCPConnection *connection; + NSObject *parent; +} + +/** + * @property MCPConnection references the MCPKit connection to MySQL; it has to be set. + */ +@property (retain) MCPConnection *connection; + +/** + * @property the parent object that issues the action, needs to provide stuff like tableWindow for messages + */ +@property (retain) NSObject *parent; + +/** + * This method copies a table structure from one db to another. + * + * @param name name of the table in the source database + * @param sourceDB name of the source database + * @param targetDB name of the target database + */ +- (BOOL)copyTable:(NSString *)name from: (NSString *)sourceDB to: (NSString *)targetDB; + +/** + * This method moves a table from one db to another. + * + * @param name name of the table in the source database + * @param sourceDB name of the source database + * @param targetDB name of the target database + */ +- (BOOL)moveTable:(NSString *)name from: (NSString *)sourceDB to: (NSString *)targetDB; + +/** + * This method copies a table including its data from one db to another. + * + * @param name name of the table in the source database + * @param sourceDB name of the source database + * @param targetDB name of the target database + * @param copyWithContent whether to copy the content too, otherwise only structure + */ +- (BOOL)copyTable:(NSString *)tableName from: (NSString *)sourceDB to: (NSString *)targetDB withContent:(BOOL)copyWithContent; + +@end |