aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2012-07-21 06:28:09 +0000
committerstuconnolly <stuart02@gmail.com>2012-07-21 06:28:09 +0000
commite014abf5d279304ca2f8ca3aafdb31023697e74a (patch)
tree10b4b0c3c1c1916f15538a844cde01c9f26de981
parent6c58456bcb63e9a32c32704ada1998fe6a3800ea (diff)
downloadsequelpro-e014abf5d279304ca2f8ca3aafdb31023697e74a.tar.gz
sequelpro-e014abf5d279304ca2f8ca3aafdb31023697e74a.tar.bz2
sequelpro-e014abf5d279304ca2f8ca3aafdb31023697e74a.zip
QueryKit: Add DELETE query tests.
-rw-r--r--Frameworks/QueryKit/QueryKit.xcodeproj/project.pbxproj6
-rw-r--r--Frameworks/QueryKit/Tests/QKDeleteQueryTests.h40
-rw-r--r--Frameworks/QueryKit/Tests/QKDeleteQueryTests.m123
-rw-r--r--Frameworks/QueryKit/Tests/QKTestConstants.h3
-rw-r--r--Frameworks/QueryKit/Tests/QKTestConstants.m3
5 files changed, 173 insertions, 2 deletions
diff --git a/Frameworks/QueryKit/QueryKit.xcodeproj/project.pbxproj b/Frameworks/QueryKit/QueryKit.xcodeproj/project.pbxproj
index 91dc8e16..10c9a3c6 100644
--- a/Frameworks/QueryKit/QueryKit.xcodeproj/project.pbxproj
+++ b/Frameworks/QueryKit/QueryKit.xcodeproj/project.pbxproj
@@ -22,6 +22,7 @@
1757801E15A9A14400CDF67A /* QKQueryGenericParameter.h in Headers */ = {isa = PBXBuildFile; fileRef = 1757801C15A9A14400CDF67A /* QKQueryGenericParameter.h */; settings = {ATTRIBUTES = (Public, ); }; };
1757801F15A9A14400CDF67A /* QKQueryGenericParameter.m in Sources */ = {isa = PBXBuildFile; fileRef = 1757801D15A9A14400CDF67A /* QKQueryGenericParameter.m */; };
179FEECA15B6CE50009B34F0 /* QKTestCase.m in Sources */ = {isa = PBXBuildFile; fileRef = 179FEEC915B6CE50009B34F0 /* QKTestCase.m */; };
+ 179FEF8E15BA7EB0009B34F0 /* QKDeleteQueryTests.m in Sources */ = {isa = PBXBuildFile; fileRef = 179FEF8D15BA7EB0009B34F0 /* QKDeleteQueryTests.m */; };
17E5951F14F301DF0054EE08 /* QKQuery.h in Headers */ = {isa = PBXBuildFile; fileRef = 17E5951614F301DF0054EE08 /* QKQuery.h */; settings = {ATTRIBUTES = (Public, ); }; };
17E5952014F301DF0054EE08 /* QKQuery.m in Sources */ = {isa = PBXBuildFile; fileRef = 17E5951714F301DF0054EE08 /* QKQuery.m */; };
17E5952114F301DF0054EE08 /* QKQueryOperators.h in Headers */ = {isa = PBXBuildFile; fileRef = 17E5951814F301DF0054EE08 /* QKQueryOperators.h */; settings = {ATTRIBUTES = (Public, ); }; };
@@ -73,6 +74,8 @@
179FEEC515B6CD55009B34F0 /* QKSelectQueryGroupByTests.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKSelectQueryGroupByTests.h; sourceTree = "<group>"; };
179FEEC815B6CE50009B34F0 /* QKTestCase.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKTestCase.h; sourceTree = "<group>"; };
179FEEC915B6CE50009B34F0 /* QKTestCase.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = QKTestCase.m; sourceTree = "<group>"; };
+ 179FEF8C15BA7EB0009B34F0 /* QKDeleteQueryTests.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKDeleteQueryTests.h; sourceTree = "<group>"; };
+ 179FEF8D15BA7EB0009B34F0 /* QKDeleteQueryTests.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = QKDeleteQueryTests.m; sourceTree = "<group>"; };
17E5951614F301DF0054EE08 /* QKQuery.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKQuery.h; sourceTree = "<group>"; };
17E5951714F301DF0054EE08 /* QKQuery.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = QKQuery.m; sourceTree = "<group>"; };
17E5951814F301DF0054EE08 /* QKQueryOperators.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKQueryOperators.h; sourceTree = "<group>"; };
@@ -209,6 +212,8 @@
17322A7514FA647200F0CF9B /* DELETE Tests */ = {
isa = PBXGroup;
children = (
+ 179FEF8C15BA7EB0009B34F0 /* QKDeleteQueryTests.h */,
+ 179FEF8D15BA7EB0009B34F0 /* QKDeleteQueryTests.m */,
);
name = "DELETE Tests";
sourceTree = "<group>";
@@ -411,6 +416,7 @@
17577F6715A98FEA00CDF67A /* QKTestConstants.m in Sources */,
1726972915AAF6CE009586E1 /* QKQueryTests.m in Sources */,
179FEECA15B6CE50009B34F0 /* QKTestCase.m in Sources */,
+ 179FEF8E15BA7EB0009B34F0 /* QKDeleteQueryTests.m in Sources */,
);
runOnlyForDeploymentPostprocessing = 0;
};
diff --git a/Frameworks/QueryKit/Tests/QKDeleteQueryTests.h b/Frameworks/QueryKit/Tests/QKDeleteQueryTests.h
new file mode 100644
index 00000000..eadef575
--- /dev/null
+++ b/Frameworks/QueryKit/Tests/QKDeleteQueryTests.h
@@ -0,0 +1,40 @@
+//
+// $Id$
+//
+// QKDeleteQueryTests.h
+// QueryKit
+//
+// Created by Stuart Connolly (stuconnolly.com) on July 21, 2012
+// Copyright (c) 2012 Stuart Connolly. All rights reserved.
+//
+// Permission is hereby granted, free of charge, to any person
+// obtaining a copy of this software and associated documentation
+// files (the "Software"), to deal in the Software without
+// restriction, including without limitation the rights to use,
+// copy, modify, merge, publish, distribute, sublicense, and/or sell
+// copies of the Software, and to permit persons to whom the
+// Software is furnished to do so, subject to the following
+// conditions:
+//
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+//
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
+// OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
+// HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
+// WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
+// FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
+// OTHER DEALINGS IN THE SOFTWARE.
+
+#import "QKTestCase.h"
+
+#import <QueryKit/QueryKit.h>
+#import <SenTestingKit/SenTestingKit.h>
+
+@interface QKDeleteQueryTests : QKTestCase
+
++ (void)addTestForDatabase:(QKQueryDatabase)database withIdentifierQuote:(NSString *)quote toTestSuite:(SenTestSuite *)testSuite;
+
+@end
diff --git a/Frameworks/QueryKit/Tests/QKDeleteQueryTests.m b/Frameworks/QueryKit/Tests/QKDeleteQueryTests.m
new file mode 100644
index 00000000..fea25f12
--- /dev/null
+++ b/Frameworks/QueryKit/Tests/QKDeleteQueryTests.m
@@ -0,0 +1,123 @@
+//
+// $Id$
+//
+// QKDeleteQueryTests.m
+// QueryKit
+//
+// Created by Stuart Connolly (stuconnolly.com) on July 21, 2012
+// Copyright (c) 2012 Stuart Connolly. All rights reserved.
+//
+// Permission is hereby granted, free of charge, to any person
+// obtaining a copy of this software and associated documentation
+// files (the "Software"), to deal in the Software without
+// restriction, including without limitation the rights to use,
+// copy, modify, merge, publish, distribute, sublicense, and/or sell
+// copies of the Software, and to permit persons to whom the
+// Software is furnished to do so, subject to the following
+// conditions:
+//
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+//
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
+// OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
+// HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
+// WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
+// FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
+// OTHER DEALINGS IN THE SOFTWARE.
+
+#import "QKDeleteQueryTests.h"
+#import "QKTestConstants.h"
+
+@implementation QKDeleteQueryTests
+
+#pragma mark -
+#pragma mark Initialisation
+
++ (id)defaultTestSuite
+{
+ SenTestSuite *testSuite = [[SenTestSuite alloc] initWithName:NSStringFromClass(self)];
+
+ [self addTestForDatabase:QKDatabaseUnknown withIdentifierQuote:EMPTY_STRING toTestSuite:testSuite];
+ [self addTestForDatabase:QKDatabaseMySQL withIdentifierQuote:QKMySQLIdentifierQuote toTestSuite:testSuite];
+ [self addTestForDatabase:QKDatabasePostgreSQL withIdentifierQuote:QKPostgreSQLIdentifierQuote toTestSuite:testSuite];
+
+ return [testSuite autorelease];
+}
+
++ (void)addTestForDatabase:(QKQueryDatabase)database withIdentifierQuote:(NSString *)quote toTestSuite:(SenTestSuite *)testSuite
+{
+ for (NSInvocation *invocation in [self testInvocations])
+ {
+ SenTestCase *test = [[QKDeleteQueryTests alloc] initWithInvocation:invocation database:database identifierQuote:quote];
+
+ [testSuite addTest:test];
+
+ [test release];
+ }
+}
+
+#pragma mark -
+#pragma mark Setup
+
+- (void)setUp
+{
+ QKQuery *query = [QKQuery queryTable:QKTestTableName];
+
+ [query setQueryType:QKDeleteQuery];
+
+ [query setQueryDatabase:[self database]];
+ [query setUseQuotedIdentifiers:[self identifierQuote] && [[self identifierQuote] length] > 0];
+
+ [self setQuery:query];
+}
+
+#pragma mark -
+#pragma mark Tests
+
+- (void)testDeleteQueryTypeIsCorrect
+{
+ STAssertTrue([[[self query] query] hasPrefix:@"DELETE"], nil);
+}
+
+- (void)testDeleteQueryFromTableIsCorrect
+{
+ NSString *query = [NSString stringWithFormat:@"DELETE FROM %1$@%2$@%1$@", [self identifierQuote], QKTestTableName];
+
+ STAssertTrue([[[self query] query] isEqualToString:query], nil);
+}
+
+- (void)testDeleteQueryFromDatabaseTableIsCorrect
+{
+ [[self query] setDatabase:QKTestDatabaseName];
+
+ NSString *query = [NSString stringWithFormat:@"DELETE FROM %1$@%2$@%1$@.%1$@%3$@%1$@", [self identifierQuote], QKTestDatabaseName, QKTestTableName];
+
+ STAssertTrue([[[self query] query] isEqualToString:query] , nil);
+}
+
+- (void)testDeleteQueryWithSingleConstraintIsCorrect
+{
+ [[self query] addParameter:QKTestFieldOne operator:QKEqualityOperator value:[NSNumber numberWithUnsignedInteger:QKTestParameterOne]];
+
+ NSString *query = [NSString stringWithFormat:@"DELETE FROM %1$@%2$@%1$@ WHERE %1$@%3$@%1$@ %4$@ %5$@", [self identifierQuote], QKTestTableName, QKTestFieldOne, [QKQueryUtilities stringRepresentationOfQueryOperator:QKEqualityOperator], [NSNumber numberWithUnsignedInteger:QKTestParameterOne]];
+
+ STAssertTrue([[[self query] query] isEqualToString:query] , nil);
+}
+
+- (void)testDeleteQueryWithMultipleConstraintsIsCorrect
+{
+ [[self query] addParameter:QKTestFieldOne operator:QKEqualityOperator value:[NSNumber numberWithUnsignedInteger:QKTestParameterOne]];
+ [[self query] addParameter:QKTestFieldTwo operator:QKNotEqualOperator value:QKTestParameterTwo];
+
+ NSString *opOne = [QKQueryUtilities stringRepresentationOfQueryOperator:QKEqualityOperator];
+ NSString *opTwo = [QKQueryUtilities stringRepresentationOfQueryOperator:QKNotEqualOperator];
+
+ NSString *query = [NSString stringWithFormat:@"DELETE FROM %1$@%2$@%1$@ WHERE %1$@%3$@%1$@ %4$@ %5$@ AND %1$@%6$@%1$@ %7$@ '%8$@'", [self identifierQuote], QKTestTableName, QKTestFieldOne, opOne, [NSNumber numberWithUnsignedInteger:QKTestParameterOne], QKTestFieldTwo, opTwo, QKTestParameterTwo];
+
+ STAssertTrue([[[self query] query] isEqualToString:query] , nil);
+}
+
+@end
diff --git a/Frameworks/QueryKit/Tests/QKTestConstants.h b/Frameworks/QueryKit/Tests/QKTestConstants.h
index 7c200d3e..1d401c71 100644
--- a/Frameworks/QueryKit/Tests/QKTestConstants.h
+++ b/Frameworks/QueryKit/Tests/QKTestConstants.h
@@ -41,4 +41,5 @@ extern NSString *QKTestFieldFour;
extern NSString *QKTestUpdateValueOne;
extern NSString *QKTestUpdateValueTwo;
-extern NSUInteger QKTestParameterOne; \ No newline at end of file
+extern NSUInteger QKTestParameterOne;
+extern NSString *QKTestParameterTwo; \ No newline at end of file
diff --git a/Frameworks/QueryKit/Tests/QKTestConstants.m b/Frameworks/QueryKit/Tests/QKTestConstants.m
index bf16aa9c..7da57cf6 100644
--- a/Frameworks/QueryKit/Tests/QKTestConstants.m
+++ b/Frameworks/QueryKit/Tests/QKTestConstants.m
@@ -39,4 +39,5 @@ NSString *QKTestFieldFour = @"test_field4";
NSString *QKTestUpdateValueOne = @"update_one";
NSString *QKTestUpdateValueTwo = @"update_two";
-NSUInteger QKTestParameterOne = 10; \ No newline at end of file
+NSUInteger QKTestParameterOne = 10;
+NSString *QKTestParameterTwo = @"test_value"; \ No newline at end of file