From e014abf5d279304ca2f8ca3aafdb31023697e74a Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Sat, 21 Jul 2012 06:28:09 +0000 Subject: QueryKit: Add DELETE query tests. --- Frameworks/QueryKit/Tests/QKDeleteQueryTests.h | 40 ++++++++ Frameworks/QueryKit/Tests/QKDeleteQueryTests.m | 123 +++++++++++++++++++++++++ Frameworks/QueryKit/Tests/QKTestConstants.h | 3 +- Frameworks/QueryKit/Tests/QKTestConstants.m | 3 +- 4 files changed, 167 insertions(+), 2 deletions(-) create mode 100644 Frameworks/QueryKit/Tests/QKDeleteQueryTests.h create mode 100644 Frameworks/QueryKit/Tests/QKDeleteQueryTests.m (limited to 'Frameworks/QueryKit/Tests') 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 +#import + +@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 -- cgit v1.2.3