objective-c-sql-query-builder
Public Member Functions | Protected Attributes
ZIMSqlUpsertStatement Class Reference

#import <ZIMSqlUpsertStatement.h>

Inheritance diagram for ZIMSqlUpsertStatement:
ZIMSqlInsertStatement <ZIMSqlStatement> <ZIMSqlDataManipulationCommand>

List of all members.

Public Member Functions

(void) - matching:
(id) - init [implementation]
(NSString *) - statement [implementation]

Protected Attributes

NSMutableSet * _compositeKey

Detailed Description

Discussion:
This class represents an SQL upsert statement. Execute as a transaction.
Updated:
2011-11-01
See also:
http://www.sqlite.org/lang_insert.html
http://www.sqlite.org/lang_update.html
http://stackoverflow.com/questions/418898/sqlite-upsert-not-insert-or-replace
http://www.firebirdsql.org/refdocs/langrefupd21-update-or-insert.html

Member Function Documentation

- (instancetype) init [implementation]

Reimplemented from ZIMSqlInsertStatement.

- (void) matching: (NSArray *)  columns
Signature:
matching:
Discussion:
This method will use the specified columns as the (composite) primary key or as a unique key to match against.
Parameters:
columnsThe columns to be matched.
Updated:
2012-03-17
- (NSString *) statement [implementation]
Signature:
statement
Discussion:
This method will return the SQL statement.
Returns:
The SQL statement that was constructed.
Updated:
2011-10-19

Reimplemented from ZIMSqlInsertStatement.


Member Data Documentation

- (NSMutableSet*) _compositeKey [protected]

The documentation for this class was generated from the following files:
 All Classes Files Functions Variables Properties Defines