#import <ZIMSqlCreateTriggerStatement.h>
List of all members.
Detailed Description
Member Function Documentation
- Signature:
- after:
- Discussion:
- This method causes the trigger to be fired after a specific command executes.
- Updated:
- 2011-07-27
- Signature:
- before:
- Discussion:
- This method causes the trigger to be fired before a specific command executes.
- Updated:
- 2011-07-27
- Signature:
- init
- Discussion:
- This method initializes the class.
- Returns:
- An instance of this class.
- Updated:
- 2012-03-20
- (instancetype) initWithXmlSchema: |
|
(NSData *) |
xml |
error: |
|
(NSError **) |
error |
|
|
| |
- Signature:
- initWithXmlSchema:error:
- Discussion:
- This method initializes the class via an XML file following Ziminji's "XML to DDL" schema.
- Parameters:
-
xml | The UTF-8 encoded string of XML. |
error | Used when an error occurs while processing the XML data. May be NULL. |
- Returns:
- An instance of this class.
- Updated:
- 2011-10-19
- See also:
- http://db.apache.org/ddlutils/
-
http://db.apache.org/ddlutils/schema/
- Signature:
- insteadOf:
- Discussion:
- This method causes the trigger to be fired instead of a specific command.
- Updated:
- 2011-07-27
- Signature:
- onDelete:
- Discussion:
- This method will cause the trigger to listen for a "DELETE" command on the specified table.
- Parameters:
-
table | The table the trigger will listen on. |
- Updated:
- 2011-10-30
- Signature:
- onInsert:
- Discussion:
- This method will cause the trigger to listen for an "INSERT" command on the specified table.
- Parameters:
-
table | The table the trigger will listen on. |
- Updated:
- 2011-10-30
- Signature:
- onUpdate:
- Discussion:
- This method will cause the trigger to listen for an "UPDATE" command on the specified table.
- Parameters:
-
table | The table the trigger will listen on. |
- Updated:
- 2011-10-30
- Signature:
- onUpdate:column:
- Discussion:
- This method will cause the trigger to listen for an "UPDATE" command on the specified column in the table.
- Parameters:
-
table | The table the trigger will listen on. |
column | The triggering column. |
- Updated:
- 2011-10-30
- (void) onUpdate: |
|
(NSString *) |
table |
columns: |
|
(NSSet *) |
columns |
|
|
| |
- Signature:
- onUpdate:columns:
- Discussion:
- This method will cause the trigger to listen for an "UPDATE" command on on one or more the specified columns in the table.
- Parameters:
-
table | The table the trigger will listen on. |
columns | The triggering columns. |
- Updated:
- 2011-10-30
- (void) parser: |
|
(NSXMLParser *) |
parser |
didEndElement: |
|
(NSString *) |
element |
namespaceURI: |
|
(NSString *) |
namespaceURI |
qualifiedName: |
|
(NSString *) |
qualifiedName |
|
|
| [implementation] |
- (void) parser: |
|
(NSXMLParser *) |
parser |
didStartElement: |
|
(NSString *) |
element |
namespaceURI: |
|
(NSString *) |
namespaceURI |
qualifiedName: |
|
(NSString *) |
qualifiedName |
attributes: |
|
(NSDictionary *) |
attributes |
|
|
| [implementation] |
- (void) parser: |
|
(NSXMLParser *) |
parser |
foundCDATA: |
|
(NSData *) |
CDATABlock |
|
|
| [implementation] |
- (void) parser: |
|
(NSXMLParser *) |
parser |
parseErrorOccurred: |
|
(NSError *) |
error |
|
|
| [implementation] |
- Signature:
- sql:
- Discussion:
- This method will set the SQL statement that will be used.
- Parameters:
-
statement | The SQL statement to be executed. |
- Updated:
- 2011-07-27
- Signature:
- statement
- Discussion:
- This method will return the SQL statement.
- Returns:
- The SQL statement that was constructed.
- Updated:
- 2011-10-19
Reimplemented from <ZIMSqlStatement>.
- Signature:
- trigger:
- Discussion:
- This method sets the name for the trigger in the SQL statement.
- Parameters:
-
trigger | The trigger's name. |
- Updated:
- 2011-07-29
- (void) trigger: |
|
(NSString *) |
trigger |
temporary: |
|
(BOOL) |
temporary |
|
|
| |
- Signature:
- trigger:temporary:
- Discussion:
- This method sets the name for the trigger in the SQL statement and whether it is temporary or not.
- Parameters:
-
trigger | The trigger's name. |
temporary | This establishes whether the trigger will be temporary. |
- Updated:
- 2011-10-30
- (void) when: |
|
(id) |
column1 |
operator: |
|
(NSString *) |
operator |
column: |
|
(id) |
column2 |
|
|
| |
- Signature:
- when:operator:column:
- Discussion:
- This method will add a when clause to the SQL statement.
- Parameters:
-
column1 | The column to be tested. |
operator | The operator to be used. |
column2 | The column to be compared. |
- Updated:
- 2012-03-23
- (void) when: |
|
(id) |
column1 |
operator: |
|
(NSString *) |
operator |
column: |
|
(id) |
column2 |
connector: |
|
(NSString *) |
connector |
|
|
| |
- Signature:
- when:operator:column:connector:
- Discussion:
- This method will add a when clause to the SQL statement.
- Parameters:
-
column1 | The column to be tested. |
operator | The operator to be used. |
column2 | The column to be compared. |
connector | The connector to be used. |
- Updated:
- 2012-03-23
- (void) when: |
|
(id) |
column |
operator: |
|
(NSString *) |
operator |
value: |
|
(id) |
value |
|
|
| |
- Signature:
- when:operator:value:
- Discussion:
- This method will add a when clause to the SQL statement.
- Parameters:
-
column | The column to be tested. |
operator | The operator to be used. |
value | The value to be compared. |
- Updated:
- 2012-03-23
- (void) when: |
|
(id) |
column |
operator: |
|
(NSString *) |
operator |
value: |
|
(id) |
value |
connector: |
|
(NSString *) |
connector |
|
|
| |
- Signature:
- when:operator:value:connector:
- Discussion:
- This method will add a when clause to the SQL statement.
- Parameters:
-
column | The column to be tested. |
operator | The operator to be used. |
value | The value to be compared. |
connector | The connector to be used. |
- Updated:
- 2012-03-23
- Signature:
- whenBlock:
- Discussion:
- This method will start or end a block.
- Parameters:
-
brace | The brace to be used; it is either an opening or closing brace. |
- Updated:
- 2011-07-27
- Signature:
- whenBlock:connector:
- Discussion:
- This method will start or end a block.
- Parameters:
-
brace | The brace to be used; it is either an opening or closing brace. |
connector | The connector to be used. |
- Updated:
- 2011-07-27
Member Data Documentation
- (NSError*) _error [protected] |
- (NSMutableArray*) _sql [protected] |
- (NSMutableArray*) _stack [protected] |
- (NSMutableArray*) _when [protected] |
The documentation for this class was generated from the following files: