aboutsummaryrefslogtreecommitdiffstats
path: root/UnitTests
diff options
context:
space:
mode:
Diffstat (limited to 'UnitTests')
-rw-r--r--UnitTests/mcpKitTest.h34
-rw-r--r--UnitTests/mcpKitTest.m85
-rw-r--r--UnitTests/stringCategoryAdditionsTest.h32
-rw-r--r--UnitTests/stringCategoryAdditionsTest.m54
4 files changed, 205 insertions, 0 deletions
diff --git a/UnitTests/mcpKitTest.h b/UnitTests/mcpKitTest.h
new file mode 100644
index 00000000..f2cdea92
--- /dev/null
+++ b/UnitTests/mcpKitTest.h
@@ -0,0 +1,34 @@
+//
+// mcpKitTest.h
+// sequel-pro
+//
+// Created by J Knight on 17/05/09.
+// Copyright 2009 J Knight. All rights reserved.
+//
+// This program is free software; you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation; either version 2 of the License, or
+// (at your option) any later version.
+//
+// This program is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+// GNU General Public License for more details.
+//
+// You should have received a copy of the GNU General Public License
+// along with this program; if not, write to the Free Software
+// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+//
+// More info at <http://code.google.com/p/sequel-pro/>
+//
+
+#import <SenTestingKit/SenTestingKit.h>
+#import "CMMCPConnection.h"
+#import "CMMCPResult.h"
+
+@interface mcpKitTest : SenTestCase {
+
+ CMMCPConnection *mySQLConnection;
+}
+
+@end
diff --git a/UnitTests/mcpKitTest.m b/UnitTests/mcpKitTest.m
new file mode 100644
index 00000000..b8425dde
--- /dev/null
+++ b/UnitTests/mcpKitTest.m
@@ -0,0 +1,85 @@
+//
+// mcpKitTest.m
+// sequel-pro
+//
+// Created by J Knight on 17/05/09.
+// Copyright 2009 J Knight. All rights reserved.
+//
+// This program is free software; you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation; either version 2 of the License, or
+// (at your option) any later version.
+//
+// This program is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+// GNU General Public License for more details.
+//
+// You should have received a copy of the GNU General Public License
+// along with this program; if not, write to the Free Software
+// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+//
+// More info at <http://code.google.com/p/sequel-pro/>
+//
+
+#import "mcpKitTest.h"
+
+
+@implementation mcpKitTest
+
+- (void)setUp
+{
+ // for now, we try an find the following database in the local connection
+ // if the connection fails for any reasons, tests are not run.
+ // http://downloads.mysql.com/docs/sakila-db.zip
+ // set up a user called 'sakila' with no password that has all privs on the
+ // database 'sakila'
+
+ mySQLConnection = [[CMMCPConnection alloc] initToSocket:@"/var/mysql/mysql.sock"
+ withLogin:@"sakila"
+ password:@""];
+
+ if ( ![mySQLConnection isConnected] ) {
+ [mySQLConnection dealloc];
+ mySQLConnection = nil;
+ STFail(@"unable to connect with server. No tests run!");
+ } else {
+ if ( ! [mySQLConnection selectDB:@"sakila"]) {
+ [mySQLConnection dealloc];
+ mySQLConnection = nil;
+ STFail(@"unable to use `sakila` database. No tests run!");
+ }
+ }
+}
+
+- (void)tearDown
+{
+ if( mySQLConnection != nil ) {
+ [mySQLConnection disconnect];
+ [mySQLConnection dealloc];
+ }
+}
+
+- (void)testServerVersion
+{
+ if( mySQLConnection == nil )
+ return;
+
+ STAssertTrue( [mySQLConnection serverMajorVersion] != 0, @"server version");
+}
+
+
+- (void)testTableList
+{
+ if( mySQLConnection == nil )
+ return;
+
+ CMMCPResult *theResult;
+
+ NSString *pQuery = @"SELECT * FROM actor";
+ theResult = [mySQLConnection queryString:pQuery];
+
+ STAssertEquals([theResult numOfRows],(my_ulonglong)200, @"actors table count" );
+}
+
+@end
diff --git a/UnitTests/stringCategoryAdditionsTest.h b/UnitTests/stringCategoryAdditionsTest.h
new file mode 100644
index 00000000..a89f78bb
--- /dev/null
+++ b/UnitTests/stringCategoryAdditionsTest.h
@@ -0,0 +1,32 @@
+//
+// stringCategoryAdditionsTest.h
+// sequel-pro
+//
+// Created by J Knight on 17/05/09.
+// Copyright 2009 J Knight. All rights reserved.
+//
+// This program is free software; you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation; either version 2 of the License, or
+// (at your option) any later version.
+//
+// This program is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+// GNU General Public License for more details.
+//
+// You should have received a copy of the GNU General Public License
+// along with this program; if not, write to the Free Software
+// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+//
+// More info at <http://code.google.com/p/sequel-pro/>
+//
+
+#import <SenTestingKit/SenTestingKit.h>
+
+
+@interface stringCategoryAdditionsTest : SenTestCase {
+
+}
+
+@end
diff --git a/UnitTests/stringCategoryAdditionsTest.m b/UnitTests/stringCategoryAdditionsTest.m
new file mode 100644
index 00000000..68b27ff7
--- /dev/null
+++ b/UnitTests/stringCategoryAdditionsTest.m
@@ -0,0 +1,54 @@
+//
+// stringCategoryAdditionsTest.m
+// sequel-pro
+//
+// Created by J Knight on 17/05/09.
+// Copyright 2009 J Knight. All rights reserved.
+//
+// This program is free software; you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation; either version 2 of the License, or
+// (at your option) any later version.
+//
+// This program is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+// GNU General Public License for more details.
+//
+// You should have received a copy of the GNU General Public License
+// along with this program; if not, write to the Free Software
+// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+//
+// More info at <http://code.google.com/p/sequel-pro/>
+//
+
+
+#import "stringCategoryAdditionsTest.h"
+#import "SPStringAdditions.h"
+
+@implementation stringCategoryAdditionsTest
+
+- (void)setUp
+{
+
+}
+
+- (void)tearDown
+{
+
+}
+
+- (void)testStringByRemovingCharactersInSet
+{
+ NSCharacterSet *junk = [NSCharacterSet characterSetWithCharactersInString:@"abc',ü"];
+ NSString *s = @"this is big, crazy st'ring";
+ NSString *expect = @"this is ig rzy string";
+ STAssertEqualObjects( [s stringByRemovingCharactersInSet:junk], expect, @"stringByRemovingCharactersInSet" );
+
+ // check UTF
+ s = @"In der Kürze liegt die Würz";
+ expect = @"In der Krze liegt die Wrz";
+ STAssertEqualObjects( [s stringByRemovingCharactersInSet:junk], expect, @"stringByRemovingCharactersInSet" );
+}
+
+@end