aboutsummaryrefslogtreecommitdiffstats
path: root/Frameworks/QueryKit/Tests/QKDeleteQueryTests.m
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 /Frameworks/QueryKit/Tests/QKDeleteQueryTests.m
parent6c58456bcb63e9a32c32704ada1998fe6a3800ea (diff)
downloadsequelpro-e014abf5d279304ca2f8ca3aafdb31023697e74a.tar.gz
sequelpro-e014abf5d279304ca2f8ca3aafdb31023697e74a.tar.bz2
sequelpro-e014abf5d279304ca2f8ca3aafdb31023697e74a.zip
QueryKit: Add DELETE query tests.
Diffstat (limited to 'Frameworks/QueryKit/Tests/QKDeleteQueryTests.m')
-rw-r--r--Frameworks/QueryKit/Tests/QKDeleteQueryTests.m123
1 files changed, 123 insertions, 0 deletions
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