QueryKit: Add DELETE query tests.

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