Up

EOSQLExpression Class

Authors

Mirko Viviani (mirko.viviani@rccr.cremona.it)
Manuel Guesdon (mguesdon@orange-concept.com)

Version: 23472

Date: 2006-09-12 21:36:24 +0200 (Die, 12 Sep 2006)

Copyright: (C) 2000-2002,2003,2004,2005 Free Software Foundation, Inc.

Contents -

  1. Software documentation for the EOSQLExpression class
  2. Software documentation for the NSNumber(EOSQLFormatting) category
  3. Software documentation for the NSString(EOSQLFormatting) category

Software documentation for the EOSQLExpression class

EOSQLExpression : NSObject

Declared in:
EOAccess/EOSQLExpression.h
Availability: OpenStep

Description forthcoming.
Instance Variables

Method summary

deleteStatementWithQualifier: entity: 

+ (EOSQLExpression*) deleteStatementWithQualifier: (EOQualifier*)qualifier entity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

expressionForString: 

+ (EOSQLExpression*) expressionForString: (NSString*)string;
Availability: OpenStep

Description forthcoming.

formatSQLString: format: 

+ (NSString*) formatSQLString: (NSString*)sqlString format: (NSString*)format;
Availability: OpenStep

Description forthcoming.

formatStringValue: 

+ (NSString*) formatStringValue: (NSString*)string;
Availability: OpenStep

Description forthcoming.

formatValue: forAttribute: 

+ (NSString*) formatValue: (id)value forAttribute: (EOAttribute*)attribute;
Availability: OpenStep

Description forthcoming.

insertStatementForRow: entity: 

+ (EOSQLExpression*) insertStatementForRow: (NSDictionary*)row entity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

selectStatementForAttributes: lock: fetchSpecification: entity: 

+ (EOSQLExpression*) selectStatementForAttributes: (NSArray*)attributes lock: (BOOL)flag fetchSpecification: (EOFetchSpecification*)fetchSpecification entity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

setUseBindVariables: 

+ (void) setUseBindVariables: (BOOL)flag;
Availability: OpenStep

Description forthcoming.

setUseQuotedExternalNames: 

+ (void) setUseQuotedExternalNames: (BOOL)flag;
Availability: OpenStep

Description forthcoming.

sqlExpressionWithEntity: 

+ (id) sqlExpressionWithEntity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

sqlPatternFromShellPattern: 

+ (NSString*) sqlPatternFromShellPattern: (NSString*)pattern;
Availability: OpenStep

Description forthcoming.

sqlPatternFromShellPattern: withEscapeCharacter: 

+ (NSString*) sqlPatternFromShellPattern: (NSString*)pattern withEscapeCharacter: (unichar)escapeCharacter;
Availability: OpenStep

Description forthcoming.

updateStatementForRow: qualifier: entity: 

+ (EOSQLExpression*) updateStatementForRow: (NSDictionary*)row qualifier: (EOQualifier*)qualifier entity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

useBindVariables 

+ (BOOL) useBindVariables;
Availability: OpenStep

Description forthcoming.

useQuotedExternalNames 

+ (BOOL) useQuotedExternalNames;
Availability: OpenStep

Description forthcoming.

addBindVariableDictionary: 

- (void) addBindVariableDictionary: (NSMutableDictionary*)binding;
Availability: OpenStep

Description forthcoming.

addInsertListAttribute: value: 

- (void) addInsertListAttribute: (EOAttribute*)attribute value: (NSString*)value;
Availability: OpenStep

Description forthcoming.

addJoinClauseWithLeftName: rightName: joinSemantic: 

- (void) addJoinClauseWithLeftName: (NSString*)leftName rightName: (NSString*)rightName joinSemantic: (EOJoinSemantic)semantic;
Availability: OpenStep

Description forthcoming.

addOrderByAttributeOrdering: 

- (void) addOrderByAttributeOrdering: (EOSortOrdering*)sortOrdering;
Availability: OpenStep

Description forthcoming.

addSelectListAttribute: 

- (void) addSelectListAttribute: (EOAttribute*)attribute;
Availability: OpenStep

Description forthcoming.

addUpdateListAttribute: value: 

- (void) addUpdateListAttribute: (EOAttribute*)attribute value: (NSString*)value;
Availability: OpenStep

Description forthcoming.

aliasesByRelationshipPath 

- (NSMutableDictionary*) aliasesByRelationshipPath;
Availability: OpenStep

Description forthcoming.

appendItem: toListString: 

- (void) appendItem: (NSString*)itemString toListString: (NSMutableString*)listString;
Availability: OpenStep

Description forthcoming.

assembleDeleteStatementWithQualifier: tableList: whereClause: 

- (NSString*) assembleDeleteStatementWithQualifier: (EOQualifier*)qualifier tableList: (NSString*)tableList whereClause: (NSString*)whereClause;
Availability: OpenStep

Description forthcoming.

assembleInsertStatementWithRow: tableList: columnList: valueList: 

- (NSString*) assembleInsertStatementWithRow: (NSDictionary*)row tableList: (NSString*)tableList columnList: (NSString*)columnList valueList: (NSString*)valueList;
Availability: OpenStep

Description forthcoming.

assembleJoinClauseWithLeftName: rightName: joinSemantic: 

- (NSString*) assembleJoinClauseWithLeftName: (NSString*)leftName rightName: (NSString*)rightName joinSemantic: (EOJoinSemantic)semantic;
Availability: OpenStep

Description forthcoming.

assembleSelectStatementWithAttributes: lock: qualifier: fetchOrder: selectString: columnList: tableList: whereClause: joinClause: orderByClause: lockClause: 

- (NSString*) assembleSelectStatementWithAttributes: (NSArray*)attributes lock: (BOOL)lock qualifier: (EOQualifier*)qualifier fetchOrder: (NSArray*)fetchOrder selectString: (NSString*)selectString columnList: (NSString*)columnList tableList: (NSString*)tableList whereClause: (NSString*)whereClause joinClause: (NSString*)joinClause orderByClause: (NSString*)orderByClause lockClause: (NSString*)lockClause;
Availability: OpenStep

Description forthcoming.

assembleUpdateStatementWithRow: qualifier: tableList: updateList: whereClause: 

- (NSString*) assembleUpdateStatementWithRow: (NSDictionary*)row qualifier: (EOQualifier*)qualifier tableList: (NSString*)tableList updateList: (NSString*)updateList whereClause: (NSString*)whereClause;
Availability: OpenStep

Description forthcoming.

bindVariableDictionaries 

- (NSArray*) bindVariableDictionaries;
Availability: OpenStep

Description forthcoming.

bindVariableDictionaryForAttribute: value: 

- (NSMutableDictionary*) bindVariableDictionaryForAttribute: (EOAttribute*)attribute value: (id)value;
Availability: OpenStep

Description forthcoming.

entity 

- (EOEntity*) entity;
Availability: OpenStep

Description forthcoming.

externalNameQuoteCharacter 

- (NSString*) externalNameQuoteCharacter;
Availability: OpenStep

Description forthcoming.

initWithEntity: 

- (id) initWithEntity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

joinClauseString 

- (NSMutableString*) joinClauseString;
Availability: OpenStep

Description forthcoming.

joinExpression 

- (void) joinExpression;
Availability: OpenStep

Build join expression for all used relationships (call this) after all other query parts construction)

listString 

- (NSMutableString*) listString;
Availability: OpenStep

Description forthcoming.

lockClause 

- (NSString*) lockClause;
Availability: OpenStep

Description forthcoming.

mustUseBindVariableForAttribute: 

- (BOOL) mustUseBindVariableForAttribute: (EOAttribute*)att;
Availability: OpenStep

Description forthcoming.

orderByString 

- (NSMutableString*) orderByString;
Availability: OpenStep

Description forthcoming.

prepareDeleteExpressionForQualifier: 

- (void) prepareDeleteExpressionForQualifier: (EOQualifier*)qualifier;
Availability: OpenStep

Description forthcoming.

prepareInsertExpressionWithRow: 

- (void) prepareInsertExpressionWithRow: (NSDictionary*)row;
Availability: OpenStep

Description forthcoming.

prepareSelectExpressionWithAttributes: lock: fetchSpecification: 

- (void) prepareSelectExpressionWithAttributes: (NSArray*)attributes lock: (BOOL)lockFlag fetchSpecification: (EOFetchSpecification*)fetchSpecification;
Availability: OpenStep

Description forthcoming.

prepareUpdateExpressionWithRow: qualifier: 

- (void) prepareUpdateExpressionWithRow: (NSDictionary*)row qualifier: (EOQualifier*)qualifier;
Availability: OpenStep

Description forthcoming.

setStatement: 

- (void) setStatement: (NSString*)statement;
Availability: OpenStep

Description forthcoming.

setUseAliases: 

- (void) setUseAliases: (BOOL)useAliases;
Availability: OpenStep

Description forthcoming.

shouldUseBindVariableForAttribute: 

- (BOOL) shouldUseBindVariableForAttribute: (EOAttribute*)att;
Availability: OpenStep

Description forthcoming.

sqlStringForAttribute: 

- (NSString*) sqlStringForAttribute: (EOAttribute*)anAttribute;
Availability: OpenStep

Description forthcoming.

sqlStringForAttributeNamed: 

- (NSString*) sqlStringForAttributeNamed: (NSString*)name;
Availability: OpenStep

Description forthcoming.

sqlStringForAttributePath: 

- (NSString*) sqlStringForAttributePath: (NSArray*)path;
Availability: OpenStep

Description forthcoming.

sqlStringForConjoinedQualifiers: 

- (NSString*) sqlStringForConjoinedQualifiers: (NSArray*)qualifiers;
Availability: OpenStep

Description forthcoming.

sqlStringForDisjoinedQualifiers: 

- (NSString*) sqlStringForDisjoinedQualifiers: (NSArray*)qualifiers;
Availability: OpenStep

Description forthcoming.

sqlStringForKeyComparisonQualifier: 

- (NSString*) sqlStringForKeyComparisonQualifier: (EOKeyComparisonQualifier*)qualifier;
Availability: OpenStep

Description forthcoming.

sqlStringForKeyValueQualifier: 

- (NSString*) sqlStringForKeyValueQualifier: (EOKeyValueQualifier*)qualifier;
Availability: OpenStep

Description forthcoming.

sqlStringForNegatedQualifier: 

- (NSString*) sqlStringForNegatedQualifier: (EOQualifier*)qualifier;
Availability: OpenStep

Description forthcoming.

sqlStringForSchemaObjectName: 

- (NSString*) sqlStringForSchemaObjectName: (NSString*)name;
Availability: OpenStep

Description forthcoming.

sqlStringForSelector: value: 

- (NSString*) sqlStringForSelector: (SEL)selector value: (id)value;
Availability: OpenStep

Description forthcoming.

sqlStringForValue: attributeNamed: 

- (NSString*) sqlStringForValue: (id)value attributeNamed: (NSString*)attributeName;
Availability: OpenStep

Description forthcoming.

sqlStringForValue: caseInsensitiveLikeKey: 

- (NSString*) sqlStringForValue: (NSString*)valueString caseInsensitiveLikeKey: (NSString*)keyString;
Availability: OpenStep

Description forthcoming.

statement 

- (NSString*) statement;
Availability: OpenStep

Description forthcoming.

tableListWithRootEntity: 

- (NSString*) tableListWithRootEntity: (EOEntity*)entity;
Availability: OpenStep

Description forthcoming.

useAliases 

- (BOOL) useAliases;
Availability: OpenStep

Description forthcoming.

valueList 

- (NSMutableString*) valueList;
Availability: OpenStep

Description forthcoming.

whereClauseString 

- (NSString*) whereClauseString;
Availability: OpenStep

Description forthcoming.

Instance Variables for EOSQLExpression Class

_aliasesByRelationshipPath

@protected NSMutableDictionary* _aliasesByRelationshipPath;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_bindings

@protected NSMutableArray* _bindings;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_contextStack

@protected NSMutableArray* _contextStack;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_entity

@protected EOEntity* _entity;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_flags

@protected struct ... _flags;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_joinClauseString

@protected NSMutableString* _joinClauseString;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_listString

@protected NSMutableString* _listString;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_orderByString

@protected NSMutableString* _orderByString;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_statement

@protected NSString* _statement;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_valueListString

@protected NSMutableString* _valueListString;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.

_whereClauseString

@protected NSString* _whereClauseString;
Warning the underscore at the start of the name of this instance variable indicates that, even though it is not technically private, it is intended for internal use within the package, and you should not use the variable in other code.


Software documentation for the NSNumber(EOSQLFormatting) category

NSNumber(EOSQLFormatting)

Declared in:
EOAccess/EOSQLExpression.h
Availability: OpenStep

Description forthcoming.
Method summary

sqlString 

- (NSString*) sqlString;
Availability: OpenStep

Description forthcoming.

Software documentation for the NSString(EOSQLFormatting) category

NSString(EOSQLFormatting)

Declared in:
EOAccess/EOSQLExpression.h
Availability: OpenStep

Description forthcoming.
Method summary

sqlString 

- (NSString*) sqlString;
Availability: OpenStep

Description forthcoming.

Up