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. --- .../QueryKit/QueryKit.xcodeproj/project.pbxproj | 6 + Frameworks/QueryKit/Tests/QKDeleteQueryTests.h | 40 +++++++ Frameworks/QueryKit/Tests/QKDeleteQueryTests.m | 123 +++++++++++++++++++++ Frameworks/QueryKit/Tests/QKTestConstants.h | 3 +- Frameworks/QueryKit/Tests/QKTestConstants.m | 3 +- 5 files changed, 173 insertions(+), 2 deletions(-) create mode 100644 Frameworks/QueryKit/Tests/QKDeleteQueryTests.h create mode 100644 Frameworks/QueryKit/Tests/QKDeleteQueryTests.m (limited to 'Frameworks/QueryKit') 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 = ""; }; 179FEEC815B6CE50009B34F0 /* QKTestCase.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKTestCase.h; sourceTree = ""; }; 179FEEC915B6CE50009B34F0 /* QKTestCase.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = QKTestCase.m; sourceTree = ""; }; + 179FEF8C15BA7EB0009B34F0 /* QKDeleteQueryTests.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKDeleteQueryTests.h; sourceTree = ""; }; + 179FEF8D15BA7EB0009B34F0 /* QKDeleteQueryTests.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = QKDeleteQueryTests.m; sourceTree = ""; }; 17E5951614F301DF0054EE08 /* QKQuery.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKQuery.h; sourceTree = ""; }; 17E5951714F301DF0054EE08 /* QKQuery.m */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.objc; path = QKQuery.m; sourceTree = ""; }; 17E5951814F301DF0054EE08 /* QKQueryOperators.h */ = {isa = PBXFileReference; fileEncoding = 4; lastKnownFileType = sourcecode.c.h; path = QKQueryOperators.h; sourceTree = ""; }; @@ -209,6 +212,8 @@ 17322A7514FA647200F0CF9B /* DELETE Tests */ = { isa = PBXGroup; children = ( + 179FEF8C15BA7EB0009B34F0 /* QKDeleteQueryTests.h */, + 179FEF8D15BA7EB0009B34F0 /* QKDeleteQueryTests.m */, ); name = "DELETE Tests"; sourceTree = ""; @@ -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 +#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