aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2012-07-21 05:39:14 +0000
committerstuconnolly <stuart02@gmail.com>2012-07-21 05:39:14 +0000
commit156a0e45f7ef5d4a3badc09bec0bff66ed3d2400 (patch)
tree3bec535ffc28eab9d5a897cffb2e255383d2bc5d
parent3f9fe159d05993fede4338135d48866133ef38b5 (diff)
downloadsequelpro-156a0e45f7ef5d4a3badc09bec0bff66ed3d2400.tar.gz
sequelpro-156a0e45f7ef5d4a3badc09bec0bff66ed3d2400.tar.bz2
sequelpro-156a0e45f7ef5d4a3badc09bec0bff66ed3d2400.zip
QueryKit: Add test to check the explicit use of a database name in an update query.
-rw-r--r--Frameworks/QueryKit/Tests/QKUpdateQueryTests.m9
1 files changed, 9 insertions, 0 deletions
diff --git a/Frameworks/QueryKit/Tests/QKUpdateQueryTests.m b/Frameworks/QueryKit/Tests/QKUpdateQueryTests.m
index afeb9434..892e526f 100644
--- a/Frameworks/QueryKit/Tests/QKUpdateQueryTests.m
+++ b/Frameworks/QueryKit/Tests/QKUpdateQueryTests.m
@@ -86,6 +86,15 @@
STAssertTrue([[[self query] query] hasPrefix:@"UPDATE"], nil);
}
+- (void)testUpdateQueryUsingDatabaseAndTableIsCorrect
+{
+ [[self query] setDatabase:QKTestDatabaseName];
+
+ NSString *query = [NSString stringWithFormat:@"UPDATE %1$@%2$@%1$@.%1$@%3$@%1$@", [self identifierQuote], QKTestDatabaseName, QKTestTableName];
+
+ STAssertTrue([[[self query] query] hasPrefix:query], nil);
+}
+
- (void)testUpdateQueryFieldsAreCorrect
{
NSString *query = [NSString stringWithFormat:@"UPDATE %1$@%2$@%1$@ SET %1$@%3$@%1$@ = '%4$@', %1$@%5$@%1$@ = '%6$@'", [self identifierQuote], QKTestTableName, QKTestFieldOne, QKTestUpdateValueOne, QKTestFieldTwo, QKTestUpdateValueTwo];