aboutsummaryrefslogtreecommitdiffstats
path: root/UnitTests/SPDatabaseActionTest.m
diff options
context:
space:
mode:
Diffstat (limited to 'UnitTests/SPDatabaseActionTest.m')
-rw-r--r--UnitTests/SPDatabaseActionTest.m92
1 files changed, 92 insertions, 0 deletions
diff --git a/UnitTests/SPDatabaseActionTest.m b/UnitTests/SPDatabaseActionTest.m
new file mode 100644
index 00000000..f7704df5
--- /dev/null
+++ b/UnitTests/SPDatabaseActionTest.m
@@ -0,0 +1,92 @@
+//
+// SPDatabaseActionTest.m
+// sequel-pro
+//
+// Created by Max Lohrmann on 12.03.15.
+// Copyright (c) 2015 Max Lohrmann. 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.
+//
+// More info at <https://github.com/sequelpro/sequelpro>
+
+#import <OCMock/OCMock.h>
+#import <SenTestingKit/SenTestingKit.h>
+
+
+#import "SPDatabaseAction.h"
+#import <SPMySQL/SPMySQL.h>
+
+
+@interface SPDatabaseActionTest : SenTestCase
+
+- (void)testCreateDatabase_01_emptyName;
+- (void)testCreateDatabase_02_allParams;
+- (void)testCreateDatabase_03_nameOnly;
+
+@end
+
+@implementation SPDatabaseActionTest
+
+- (void)testCreateDatabase_01_emptyName
+{
+ id mockConnection = OCMStrictClassMock([SPMySQLConnection class]);
+ //OCMStrictClassMock would fail on any call, which is desired here
+
+ SPDatabaseAction *createDb = [[[SPDatabaseAction alloc] init] autorelease];
+ [createDb setConnection:mockConnection];
+ STAssertFalse([createDb createDatabase:@"" withEncoding:nil collation:nil],@"create database = NO with empty db name");
+
+ OCMVerifyAll(mockConnection);
+}
+
+
+- (void)testCreateDatabase_02_allParams
+{
+ id mockConnection = OCMStrictClassMock([SPMySQLConnection class]);
+
+ OCMExpect([mockConnection queryString:@"CREATE DATABASE `target_name` DEFAULT CHARACTER SET = `utf8` DEFAULT COLLATE = `utf8_bin_ci`"]);
+ OCMStub([mockConnection queryErrored]).andReturn(NO);
+
+ SPDatabaseAction *createDb = [[[SPDatabaseAction alloc] init] autorelease];
+ [createDb setConnection:mockConnection];
+
+ STAssertTrue([createDb createDatabase:@"target_name" withEncoding:@"utf8" collation:@"utf8_bin_ci"], @"create database return");
+
+ OCMVerifyAll(mockConnection);
+}
+
+- (void)testCreateDatabase_03_nameOnly
+{
+ id mockConnection = OCMStrictClassMock([SPMySQLConnection class]);
+
+ OCMExpect([mockConnection queryString:@"CREATE DATABASE `target_name`"]);
+ OCMStub([mockConnection queryErrored]).andReturn(NO);
+
+ SPDatabaseAction *createDb = [[[SPDatabaseAction alloc] init] autorelease];
+ [createDb setConnection:mockConnection];
+
+ STAssertTrue([createDb createDatabase:@"target_name" withEncoding:@"" collation:nil], @"create database return");
+
+ OCMVerifyAll(mockConnection);
+}
+
+@end