Kexi API Documentation (2.0 alpha)
	Overview Class Hierarchy Classes Classes (annotated) Members Source Files

KexiDB::QuerySchema Class Reference

#include <queryschema.h>

Inheritance diagram for KexiDB::QuerySchema:

List of all members.

---

Detailed Description

KexiDB::QuerySchema provides information about database query.

The query that can be executed using KexiDB-compatible SQL database engine or used as an introspection tool. KexiDB parser builds QuerySchema objects by parsing SQL statements.

Definition at line 221 of file queryschema.h.

Public Types
enum	FieldsExpandedOptions { Default, Unique, WithInternalFields, WithInternalFieldsAndRowID }
enum	ColumnsOrderOptions { UnexpandedList, UnexpandedListWithoutAsterisks, ExpandedList }
Public Member Functions
	QuerySchema ()
	QuerySchema (TableSchema *tableSchema)
virtual	~QuerySchema ()
virtual FieldList &	insertField (uint position, Field *field)
FieldList &	insertField (uint position, Field *field, bool visible)
FieldList &	insertField (uint position, Field *field, int bindToTable, bool visible=true)
FieldList &	addField (Field *field, bool visible=true)
FieldList &	addField (Field *field, int bindToTable, bool visible=true)
virtual void	removeField (Field *field)
FieldList &	addExpression (BaseExpr *expr, bool visible=true)
bool	isColumnVisible (uint position) const
void	setColumnVisible (uint position, bool v)
	Sets visibility flag for column at position to v.
FieldList &	addAsterisk (QueryAsterisk *asterisk, bool visible=true)
virtual void	clear ()
virtual QString	debugString ()
Connection *	connection () const
TableSchema *	masterTable () const
void	setMasterTable (TableSchema *table)
TableSchema::List *	tables () const
void	addTable (TableSchema *table, const QCString &alias=QCString())
void	removeTable (TableSchema *table)
TableSchema *	table (const QString &tableName) const
bool	contains (TableSchema *table) const
Field *	findTableField (const QString &tableOrTableAndFieldName) const
QCString	columnAlias (uint position) const
bool	hasColumnAlias (uint position) const
void	setColumnAlias (uint position, const QCString &alias)
int	tableBoundToColumn (uint columnPosition) const
QCString	tableAlias (uint position) const
int	tablePositionForAlias (const QCString &name) const
int	tablePosition (const QString &tableName) const
QValueList< int >	tablePositions (const QString &tableName) const
bool	hasTableAlias (uint position) const
int	columnPositionForAlias (const QCString &name) const
void	setTableAlias (uint position, const QCString &alias)
Relationship::List *	relationships () const
Relationship *	addRelationship (Field *field1, Field *field2)
Field::List *	asterisks () const
virtual Field *	field (const QString &name, bool expanded=true)
Field *	field (uint id)
QueryColumnInfo *	columnInfo (const QString &identifier, bool expanded=true)
QueryColumnInfo::Vector	fieldsExpanded (FieldsExpandedOptions options=Default)
QueryColumnInfo::Vector	internalFields ()
QueryColumnInfo *	expandedOrInternalField (uint index)
QMap< QueryColumnInfo *, int >	columnsOrder (ColumnsOrderOptions options=ExpandedList)
QValueVector< int >	pkeyFieldsOrder ()
uint	pkeyFieldsCount ()
QueryColumnInfo::List *	autoIncrementFields ()
QString	statement () const
void	setStatement (const QString &s)
QString	autoIncrementSQLFieldsList (Driver *driver)
void	setWhereExpression (BaseExpr *expr)
BaseExpr *	whereExpression () const
void	addToWhereExpression (KexiDB::Field *field, const QVariant &value, int relation= '=')
void	setOrderByColumnList (const OrderByColumnList &list)
OrderByColumnList &	orderByColumnList () const
QuerySchemaParameterList	parameters ()
Static Public Member Functions
static QString	sqlColumnsList (QueryColumnInfo::List *infolist, Driver *driver)
Protected Member Functions
void	init ()
void	computeFieldsExpanded ()
Protected Attributes
QuerySchemaPrivate *	d
Friends
class	Connection
class	QuerySchemaPrivate

---

Member Enumeration Documentation

enum KexiDB::QuerySchema::ColumnsOrderOptions

Options used in columnsOrder(). Enumeration values: UnexpandedList  A map for unexpanded list is created. UnexpandedListWithoutAsterisks  A map for unexpanded list is created, with asterisks skipped. ExpandedList  A map for expanded list is created. Definition at line 592 of file queryschema.h.

enum KexiDB::QuerySchema::FieldsExpandedOptions

Options used in fieldsExpanded(). Enumeration values: Default  All fields are returned even if duplicated. Unique  Unique list of fields is returned. WithInternalFields  Like Default but internal fields (for lookup) are appended. WithInternalFieldsAndRowID  Like WithInternalFields but RowID (big int type) field is appended after internal fields. Definition at line 531 of file queryschema.h.

---

Constructor & Destructor Documentation

QuerySchema::QuerySchema (   )

Creates empty query object (without columns). Definition at line 500 of file queryschema.cpp. References init().

QuerySchema::QuerySchema (  TableSchema *  tableSchema  )

Creates query schema object that is equivalent to "SELECT * FROM table" sql command. Schema of table is used to contruct this query -- it is defined just adding all the fields to the query in natural order. To avoid problems (e.g. with fields added outside of Kexi using ALTER TABLE) we do not use "all-tables query asterisk" (see QueryAsterisk) item to achieve this effect. Properties such as the name and caption of the query are inherited from table schema. We consider that query schema based on table is not (a least yet) stored in a system table, so query connection is set to NULL (even if tableSchema's connection is not NULL). Id of the created query is set to 0. Definition at line 508 of file queryschema.cpp. References addField(), addTable(), d, init(), KexiDBWarn, KexiDB::SchemaData::m_caption, and KexiDB::SchemaData::m_name.

QuerySchema::~QuerySchema (   )  [virtual]

Definition at line 537 of file queryschema.cpp. References d.

---

Member Function Documentation

FieldList & QuerySchema::addAsterisk (  QueryAsterisk *  asterisk, bool  visible = true )

Adds asterisk at the and of columns list. Definition at line 687 of file queryschema.cpp. References addField(), and asterisks(). Referenced by addColumn().

FieldList & QuerySchema::addExpression (  BaseExpr *  expr, bool  visible = true )

Adds a field built on top of expr expression. This creates a new Field object and adds it to the query schema using addField(). Definition at line 671 of file queryschema.cpp. References addField(). Referenced by addColumn().

KexiDB::FieldList & QuerySchema::addField (  Field *  field, int  bindToTable, bool  visible = true )

Adds field to the columns list. Also binds to a table at bindToTable position. Use bindToTable==-1 if no table should be bound. If visible is true (the default), the field will be visible. See also: insertField() tableBoundToColumn(uint columnPosition) Definition at line 653 of file queryschema.cpp. References insertField(), and KexiDB::FieldList::m_fields.

KexiDB::FieldList & QuerySchema::addField (  Field *  field, bool  visible = true )

Adds field to the columns list. If visible is true (the default), the field will be visible. See also: insertField() Definition at line 648 of file queryschema.cpp. References insertField(), and KexiDB::FieldList::m_fields. Referenced by addAsterisk(), addColumn(), addExpression(), KexiFormView::initDataSource(), KexiBLOBBuffer::objectForId(), and QuerySchema().

Relationship * QuerySchema::addRelationship (  Field *  field1, Field *  field2 )

Adds a new relationship defined by field1 and field2. Both fields should belong to two different tables of this query. This is convenience function useful for a typical cases. It automatically creates Relationship object for this query. If one of the fields are primary keys, it will be detected and appropriate master-detail relation will be established. This functiuon does nothing if the arguments are invalid. Definition at line 1395 of file queryschema.cpp. References d, and KexiDB::Relationship::isEmpty().

void QuerySchema::addTable (  TableSchema *  table, const QCString &  alias = QCString() )

Adds table schema as one of tables used in a query. if alias is not empty, it will be assigned to this table using setTableAlias(position, alias) Definition at line 838 of file queryschema.cpp. References d, KexiDBDbg, KexiDBWarn, setTableAlias(), and tableAlias(). Referenced by buildSelectQuery(), and QuerySchema().

void QuerySchema::addToWhereExpression (  KexiDB::Field *  field, const QVariant &  value, int  relation = '=' )

Adds a part to WHERE expression. Simplifies creating of WHERE expression, if used instead of setWhereExpression(BaseExpr *expr). Definition at line 1465 of file queryschema.cpp. References AND, CHARACTER_STRING_LITERAL, d, INTEGER_CONST, KexiDB::Field::isFPNumericType(), KexiDB::Field::isIntegerType(), KexiDBExpr_Logical, KexiDBExpr_Relational, KexiDB::Field::name(), REAL_CONST, SQL_NULL, and KexiDB::Field::table(). Referenced by KexiBLOBBuffer::objectForId().

Field::List * QuerySchema::asterisks (   )  const

Returns: list of QueryAsterisk objects defined for this query Definition at line 1021 of file queryschema.cpp. References d. Referenced by addAsterisk().

QueryColumnInfo::List * QuerySchema::autoIncrementFields (   )

Returns: a list of field infos for all auto-incremented fields from master table of this query. This result is cached for efficiency. fieldsExpanded() is used for that. Reimplemented from KexiDB::FieldList. Definition at line 1408 of file queryschema.cpp. References d, KexiDB::QueryColumnInfo::field, fieldsExpanded(), KexiDB::Field::isAutoIncrement(), KexiDBWarn, masterTable(), and KexiDB::Field::table(). Referenced by autoIncrementSQLFieldsList(), and KexiDB::Connection::insertRow().

QString QuerySchema::autoIncrementSQLFieldsList (  Driver *  driver  )

Returns: cached sql list created using sqlColumnsList() on a list returned by autoIncrementFields(). Definition at line 1448 of file queryschema.cpp. References autoIncrementFields(), d, and sqlColumnsList(). Referenced by KexiDB::Connection::insertRow().

void QuerySchema::clear (   )  [virtual]

Removes all columns and their aliases from the columns list, removes all tables and their aliases from the tables list within this query. Sets master table information to NULL. Does not destroy any objects though. Clears name and all other properties. See also: FieldList::clear() Reimplemented from KexiDB::FieldList. Definition at line 548 of file queryschema.cpp. References KexiDB::SchemaData::clear(), KexiDB::FieldList::clear(), and d. Referenced by KexiQueryPart::TempData::clearQuery().

QCString QuerySchema::columnAlias (  uint  position  )  const

Returns: alias of a column at position or null string If there is no alias for this column or if there is no such column within the query defined. If the column is an expression and has no alias defined, a new unique alias will be generated automatically on this call. Definition at line 915 of file queryschema.cpp. References d. Referenced by computeFieldsExpanded(), KexiDB::Connection::selectStatement(), and KexiQueryDesignerGuiEditor::showFieldsOrRelationsForQueryInternal().

QueryColumnInfo * QuerySchema::columnInfo (  const QString &  identifier, bool  expanded = true )

Like QuerySchema::field(const QString& name) but returns not only Field object for identifier but entire QueryColumnInfo object. identifier can be: a fieldname an aliasname a tablename.fieldname a tablename.aliasname Note that if there are two occurrrences of the same name, only the first is accessible using this method. For instance, calling columnInfo("name") for "SELECT t1.name, t2.name FROM t1, t2" statement will only return the column related to t1.name and not t2.name, so you'll need to explicitly specify "t2.name" as the identifier to get the second column. Definition at line 1042 of file queryschema.cpp. References computeFieldsExpanded(), and d. Referenced by KexiDB::OrderByColumnList::appendField(), buildSelectQuery(), field(), and KexiFormDataProvider::invalidateDataSources().

int QuerySchema::columnPositionForAlias (  const QCString &  name  )  const

Returns: column position that has defined alias name. If there is no such alias, -1 is returned. Definition at line 985 of file queryschema.cpp. References d.

QMap< QueryColumnInfo *, int > QuerySchema::columnsOrder (  ColumnsOrderOptions  options = ExpandedList  )

Returns: a map for fast lookup of query columns' order. If options is UnexpandedList, each QueryColumnInfo pointer is mapped to the index within (unexpanded) list of fields, i.e. "*" or "table.*" asterisks are considered to be single items. If options is UnexpandedListWithoutAsterisks, each QueryColumnInfo pointer is mapped to the index within (unexpanded) list of columns that come from asterisks like "*" or "table.*" are not included in the map at all. If options is ExpandedList (the default) this method provides is exactly opposite information compared to vector returned by fieldsExpanded(). This method's result is cached by the QuerySchema object. Note: indices of internal fields (see internalFields()) are also returned here - in this case the index is counted as a sum of size(e) + i (where "e" is the list of expanded fields and i is the column index within internal fields list). This feature is used eg. at the end of Connection::updateRow() where need indices of fields (including internal) to update all the values in memory. Example use: let t be table (int id, name text, surname text) and q be query defined by a statement "select * from t". columnsOrder(ExpandedList) will return the following map: QueryColumnInfo(id)->0, QueryColumnInfo(name)->1, QueryColumnInfo(surname)->2. columnsOrder(UnexpandedList) will return the following map: QueryColumnInfo(id)->0, QueryColumnInfo(name)->0, QueryColumnInfo(surname)->0 because the column list is not expanded. This way you can use the returned index to get Field* pointer using field(uint) method of FieldList superclass. columnsOrder(UnexpandedListWithoutAsterisks) will return the following map: QueryColumnInfo(id)->0, Definition at line 1344 of file queryschema.cpp. References computeFieldsExpanded(), d, UnexpandedList, and UnexpandedListWithoutAsterisks. Referenced by KexiFormDataProvider::invalidateDataSources(), KexiQueryDesignerGuiEditor::showFieldsOrRelationsForQueryInternal(), and updateRowDataWithNewValues().

void QuerySchema::computeFieldsExpanded (   )  [protected]

Todo: (js): perhaps not all fields should be appended here Todo: QuerySchema itself will also support lookup fields... Definition at line 1117 of file queryschema.cpp. References columnAlias(), connection(), d, KexiDB::QueryColumnInfo::debugString(), KexiDB::QueryColumnInfo::field, KexiDB::FieldList::field(), KexiDB::FieldList::fieldCount(), KexiDB::FieldList::fields(), fieldsExpanded(), KexiDB::FieldList::fieldsIterator(), KexiDB::QueryColumnInfo::foreignColumn(), isColumnVisible(), KexiDB::Field::isQueryAsterisk(), KexiDBDbg, LOOKUP_COLUMN_KEY, KexiDB::LookupFieldSchema::RowSource::name(), KexiDB::QueryColumnInfo::setIndexForVisibleLookupValue(), KexiDB::Field::table(), KexiDB::LookupFieldSchema::RowSource::Table, table(), and KexiDB::LookupFieldSchema::RowSource::type(). Referenced by columnInfo(), columnsOrder(), fieldsExpanded(), and internalFields().

Connection * QuerySchema::connection (   )  const

If query was created using a connection, returns this connection object, otherwise NULL. Definition at line 697 of file queryschema.cpp. References KexiDB::TableSchema::connection(), and masterTable(). Referenced by computeFieldsExpanded(), KexiDB::rowCount(), KexiTableViewColumn::KexiTableViewColumn(), and KexiDB::Connection::selectStatement().

bool QuerySchema::contains (  TableSchema *  table  )  const

Returns: true if the query uses table. Definition at line 890 of file queryschema.cpp. References d.

QString QuerySchema::debugString (   )  [virtual]

Returns: string for debugging purposes. Reimplemented from KexiDB::FieldList. Definition at line 703 of file queryschema.cpp. References d, KexiDB::QueryColumnInfo::debugString(), KexiDB::FieldList::debugString(), field, KexiDB::FieldList::fieldCount(), fieldsExpanded(), KexiDB::FieldList::m_fields, masterTable(), KexiDB::SchemaData::name(), orderByColumnList(), KexiDB::SchemaData::schemaDataDebugString(), table(), tableAlias(), and tableBoundToColumn(). Referenced by KexiDB::Cursor::Cursor().

QueryColumnInfo * QuerySchema::expandedOrInternalField (  uint  index  )

Returns: info for expanded of internal field at index index. The returned field can be either logical or internal (for lookup), the latter case is true if index >= fieldsExpanded().count(). Equivalent of QuerySchema::fieldsExpanded(WithInternalFields).at(index). Definition at line 1111 of file queryschema.cpp. References fieldsExpanded(), and WithInternalFields. Referenced by KexiComboBoxTableEdit::createInternalEditor(), and KexiCSVExport::exportData().

Field* KexiDB::QuerySchema::field (  uint  id  )  [inline]

Returns: field id or NULL if there is no such a field. Reimplemented from KexiDB::FieldList. Definition at line 514 of file queryschema.h. References field.

Field * QuerySchema::field (  const QString &  name, bool  expanded = true )  [virtual]

Returns: field for identifier or 0 if no field for this name was found within the query. fieldsExpanded() method is used to lookup expanded list of the query fields, so queries with asterisks are processed well. If a field has alias defined, name is not taken into account, but only its alias. If a field has no alias: field's name is checked field's table and field's name are checked in a form of "tablename.fieldname", so you can provide identifier in this form to avoid ambiguity. If there are more than one fields with the same name equal to identifier, first-found is returned (checking is performed from first to last query field). Structures needed to compute result of this method are cached, so only first usage costs o(n) - another usages cost o(1). Example: Let query be defined by "SELECT T.B AS X, T.* FROM T" statement and let T be table containing fields A, B, C. Expanded list of columns for the query is: T.B AS X, T.A, T.B, T.C. Calling field("B") will return a pointer to third query column (not the first, because it is covered by "X" alias). Additionally, calling field("X") will return the same pointer. Calling field("T.A") will return the same pointer as field("A"). Definition at line 1036 of file queryschema.cpp. References columnInfo(), and KexiDB::QueryColumnInfo::field. Referenced by KexiFormView::initDataSource().

QueryColumnInfo::Vector QuerySchema::fieldsExpanded (  FieldsExpandedOptions  options = Default  )

Returns: fully expanded list of fields. QuerySchema::fields() returns vector of fields used for the query columns, but in a case when there are asterisks defined for the query, it does not expand QueryAsterisk objects to field lists but return every asterisk as-is. This could be inconvenient when you need just a fully expanded list of fields, so this method does the work for you. If options is Unique, each field is returned in the vector only once (first found field is selected). Note however, that the same field can be returned more than once if it has attached a different alias. For example, let t be TABLE( a, b ) and let query be defined by "SELECT *, a AS alfa FROM t" statement. Both fieldsExpanded(Default) and fieldsExpanded(Unique) will return [ a, b, a (alfa) ] list. On the other hand, for query defined by "SELECT *, a FROM t" statement, fieldsExpanded(Default) will return [ a, b, a ] list while fieldsExpanded(Unique) will return [ a, b ] list. If options is WithInternalFields or WithInternalFieldsAndRowID, additional internal fields are also appended to the vector. If options is WithInternalFieldsAndRowID, one fake BigInteger column is appended to make space for ROWID column used by KexiDB::Cursor implementations. For example, let persons be TABLE( surname, city_id ), let city_number reference cities.is in TABLE cities( id, name ) and let query q be defined by "SELECT * FROM t" statement. If we want to display persons' city names instead of city_id's. To do this, cities.name has to be retrieved as well, so the following statement should be used: "SELECT * FROM persons, cities.name LEFT OUTER JOIN cities ON persons.city_id=cities.id". Thus, calling fieldsExpanded(WithInternalFieldsAndRowID) will return 4 elements instead of 2: persons.surname, persons.city_id, cities.name, {ROWID}. The {ROWID} item is the placeholder used for fetching ROWID by KexiDB cursors. By default, all fields are returned in the vector even if there are multiple occurrences of one or more (options == Default). Note: You should assign the resulted vector in your space - it will be shared and implicity copied on any modification. This method's result is cached by QuerySchema object. Todo: js: UPDATE CACHE! Definition at line 1048 of file queryschema.cpp. References KexiDB::QueryColumnInfo::aliasOrName(), KexiDB::Field::BigInteger, computeFieldsExpanded(), d, Default, size, WithInternalFields, and WithInternalFieldsAndRowID. Referenced by KexiDB::OrderByColumnList::appendColumn(), autoIncrementFields(), computeFieldsExpanded(), debugString(), expandedOrInternalField(), KexiSimplePrintingEngine::init(), KexiDB::Connection::insertRow(), KexiFormDataProvider::invalidateDataSources(), KexiCSVExport::exportData(), and pkeyFieldsOrder().

Field * QuerySchema::findTableField (  const QString &  tableOrTableAndFieldName  )  const

Convenience function. Returns: table field by searching through all tables in this query. The field does not need to be included on the list of query columns. Similarly, query aliases are not taken into account. tableOrTableAndFieldName string may contain table name and field name with '.' character between them, e.g. "mytable.myfield". This is recommended way to avoid ambiguity. 0 is returned if the query has no such table defined of the table has no such field defined. If you do not provide a table name, the first field found is returned. QuerySchema::table("mytable")->field("myfield") could be alternative for findTableField("mytable.myfield") but it can crash if "mytable" is not defined in the query. See also: KexiDB::splitToTableAndFieldParts() Definition at line 895 of file queryschema.cpp. References d, KexiDB::FieldList::field(), KexiDB::SetFieldNameIfNoTableName, KexiDB::splitToTableAndFieldParts(), and table(). Referenced by KexiDB::OrderByColumnList::appendField(), buildSelectQuery(), and KexiQueryDesignerGuiEditor::showFieldsOrRelationsForQueryInternal().

bool QuerySchema::hasColumnAlias (  uint  position  )  const

Provided for convenience. Returns: true if a column at position has non empty alias defined within the query. If there is no alias for this column, or if there is no such column in the query defined, false is returned. Definition at line 921 of file queryschema.cpp. References d.

bool QuerySchema::hasTableAlias (  uint  position  )  const

Provided for convenience. Returns: true if a table at position (within FROM section of the the query) has non empty alias defined. If there is no alias for this table, or if there is no such table in the query defined, false is returned. Definition at line 980 of file queryschema.cpp. References d.

void QuerySchema::init (   )  [protected]

Definition at line 542 of file queryschema.cpp. References KexiDB::SchemaData::m_type, and KexiDB::QueryObjectType. Referenced by QuerySchema().

FieldList & QuerySchema::insertField (  uint  position, Field *  field, int  bindToTable, bool  visible = true )

Definition at line 566 of file queryschema.cpp. References d, KexiDB::FieldList::fieldCount(), KexiDB::FieldList::insertField(), KexiDB::Field::isExpression(), KexiDB::Field::isQueryAsterisk(), KexiDBDbg, KexiDBWarn, KexiDB::FieldList::m_fields, KexiDB::Field::name(), KexiDB::Field::table(), and tableAlias().

FieldList & QuerySchema::insertField (  uint  position, Field *  field, bool  visible )

Definition at line 555 of file queryschema.cpp. References insertField().

FieldList & QuerySchema::insertField (  uint  position, Field *  field )  [virtual]

Inserts field to the columns list at position. Inserted field will not be owned by this QuerySchema object, but still by corresponding TableSchema. As field object you can also pass KexiDB::QueryAsterisk, (see QueryAsterisk class description). Note: After inserting a field, corresponding table will be automatically added to query's tables list if it is not present there (see tables()). Field must have its table assigned. Added field will be visible. Use insertField(position, field, false) to add invisible field. Definition at line 561 of file queryschema.cpp. Referenced by addField(), and insertField().

QueryColumnInfo::Vector QuerySchema::internalFields (   )

Returns: list of fields internal fields used for lookup columns. Definition at line 1105 of file queryschema.cpp. References computeFieldsExpanded(), and d.

bool QuerySchema::isColumnVisible (  uint  position  )  const

Returns: visibility flag for column at position. By default column is visible. Definition at line 676 of file queryschema.cpp. Referenced by computeFieldsExpanded(), and KexiDB::Connection::selectStatement().

TableSchema * QuerySchema::masterTable (   )  const

Returns: table that is master to this query. All potentially-editable columns within this query belong just to this table. This method also can return NULL if there are no tables at all, or if previously assigned master table schema has been removed with removeTable(). Every query that has at least one table defined, should have assigned a master table. If no master table is assigned explicitym but this method there is only one table used for this query even if there are table aliases, a single table is returned here. (e.g. "T" table is returned for "SELECT T1.A, T2.B FROM T T1, T T2" statement). Definition at line 807 of file queryschema.cpp. References d, and tableAlias(). Referenced by autoIncrementFields(), connection(), debugString(), KexiDB::Connection::deleteAllRows(), KexiDB::Connection::deleteRow(), KexiDB::Cursor::init(), KexiDB::Connection::insertRow(), KexiTableViewColumn::KexiTableViewColumn(), pkeyFieldsOrder(), KexiDB::Connection::selectStatement(), and KexiDB::Connection::updateRow().

OrderByColumnList & QuerySchema::orderByColumnList (   )  const

Returns: a list of columns listed in ORDER BY section of the query. Read notes for setOrderByColumnList(). Definition at line 1527 of file queryschema.cpp. References d. Referenced by buildSelectQuery(), debugString(), KexiDB::Connection::selectStatement(), and KexiQueryDesignerGuiEditor::showFieldsOrRelationsForQueryInternal().

QuerySchemaParameterList QuerySchema::parameters (   )

Returns: query schema parameters. These are taked from the WHERE section (a tree of expression items). Definition at line 1532 of file queryschema.cpp. References whereExpression(). Referenced by KexiQueryView::executeQuery(), and KexiQueryParameters::getParameters().

uint QuerySchema::pkeyFieldsCount (   )

Returns: number of master table's primary key fields included in this query. This method is useful to quickly check whether the vector returned by pkeyFieldsOrder() if filled completely. User e.g. in Connection::updateRow() to check if entire primary key information is specified. Examples: let table T has (ID1 INTEGER, ID2 INTEGER, A INTEGER) fields, and let (ID1, ID2) is T's primary key. The query defined by "SELECT * FROM T" statement contains all T's primary key's fields as T is the master table, and thus pkeyFieldsCount() will return 2 (both primary key's fields are in the fieldsExpanded() list), and pkeyFieldsOrder() will return vector {0, 1}. The query defined by "SELECT A, ID2 FROM T" statement, and thus pkeyFieldsCount() will return 1 (only one primary key's field is in the fieldsExpanded() list), and pkeyFieldsOrder() will return vector {-1, 1}, as second primary key's field is at position #1 and first field is not specified at all within the query. Definition at line 1389 of file queryschema.cpp. References d, and pkeyFieldsOrder(). Referenced by KexiDB::Connection::deleteRow(), KexiDB::Connection::insertRow(), and KexiDB::Connection::updateRow().

QValueVector< int > QuerySchema::pkeyFieldsOrder (   )

Returns: table describing order of primary key (PKEY) fields within the query. Indexing is performed against vector returned by fieldsExpanded(). It is usable for e.g. Conenction::updateRow(), when we need to locate each primary key's field in a constant time. Returned vector is owned and cached by QuerySchema object. When you assign it, it is implicity shared. Its size is equal to number of primary key fields defined for master table (masterTable()->primaryKey()->fieldCount()). Each element of the returned vector: can belong to [0..fieldsExpanded().count()-1] if there is such primary key's field in the fieldsExpanded() list. can be equal to -1 if there is no such primary key's field in the fieldsExpanded() list. If there are more than one primary key's field included in the query, only first-found column (oin the fieldsExpanded() list) for each pkey's field is included. Returns empty vector if there is no master table or no master table's pkey. See also: example for pkeyFieldsCount(). Todo: js: UPDATE CACHE! Definition at line 1355 of file queryschema.cpp. References d, KexiDB::QueryColumnInfo::field, KexiDB::FieldList::fieldCount(), fieldsExpanded(), KexiDB::FieldList::indexOf(), KexiDBDbg, masterTable(), KexiDB::SchemaData::name(), KexiDB::Field::name(), KexiDB::TableSchema::primaryKey(), and KexiDB::Field::table(). Referenced by KexiDB::Connection::deleteRow(), KexiDB::Connection::insertRow(), pkeyFieldsCount(), and KexiDB::Connection::updateRow().

Relationship::List * QuerySchema::relationships (   )  const

Returns: a list of relationships defined for this query Definition at line 1016 of file queryschema.cpp. References d. Referenced by KexiDB::Connection::selectStatement(), and KexiQueryDesignerGuiEditor::showFieldsOrRelationsForQueryInternal().

void QuerySchema::removeField (  Field *  field  )  [virtual]

Removes field from the columns list. Use with care. Reimplemented from KexiDB::FieldList. Definition at line 659 of file queryschema.cpp. References d, KexiDB::Field::isQueryAsterisk(), and KexiDB::FieldList::removeField().

void QuerySchema::removeTable (  TableSchema *  table  )

Removes table schema from this query. This does not destroy table object but only takes it out of the list. If this table was master for the query, master table information is also invalidated. Definition at line 870 of file queryschema.cpp. References d.

void QuerySchema::setColumnAlias (  uint  position, const QCString &  alias )

Sets alias for a column at position, within the query. Passing empty string to alias clears alias for a given column. Definition at line 926 of file queryschema.cpp. References KexiDB::Field::captionOrName(), d, field, KexiDBWarn, and KexiDB::FieldList::m_fields. Referenced by buildSelectQuery().

void QuerySchema::setColumnVisible (  uint  position, bool  v )

Sets visibility flag for column at position to v. Definition at line 681 of file queryschema.cpp. References d, and KexiDB::FieldList::fieldCount().

void QuerySchema::setMasterTable (  TableSchema *  table  )

Sets master table of this query to table. This table should be also added to query's tables list using addTable(). If table equals NULL, nothing is performed. See also: masterTable() Definition at line 827 of file queryschema.cpp. References d. Referenced by buildSelectQuery().

void QuerySchema::setOrderByColumnList (  const OrderByColumnList &  list  )

Sets a list of columns for ORDER BY section of the query. Each name on the list must be a field or alias present within the query and must not be covered by aliases. If one or more names cannot be found within the query, the method will have no effect. Any previous ORDER BY settings will be removed. Note that this information is cleared whenever you call methods that modify list of columns (QueryColumnInfo), i.e. insertFiled(), addField(), removeField(), addExpression(), etc. (because OrderByColumn items can point to a QueryColumnInfo that's removed by these methods), so you should use setOrderByColumnList() method after the query is completely built. Definition at line 1521 of file queryschema.cpp. References d.

void QuerySchema::setStatement (  const QString &  s  )

Forces a query statement (i.e. no statement is composed from QuerySchema's content) Definition at line 1031 of file queryschema.cpp. References d.

void QuerySchema::setTableAlias (  uint  position, const QCString &  alias )

Sets alias for a table at position (within FROM section of the the query). Passing empty sting to alias clears alias for a given table (only for specified position). Definition at line 993 of file queryschema.cpp. References d, and KexiDBWarn. Referenced by addTable().

void QuerySchema::setWhereExpression (  BaseExpr *  expr  )

Sets a WHERE expression exp. It will be owned by this query, so you can forget about it. Previously set WHERE expression will be deleted. You can pass 0 to remove expresssion. Definition at line 1459 of file queryschema.cpp. References d. Referenced by buildSelectQuery().

QString QuerySchema::sqlColumnsList (  QueryColumnInfo::List *  infolist, Driver *  driver )  [static]

Returns: a string that is a result of concatenating all column names for infolist, with "," between each one. This is usable e.g. as argument like "field1,field2" for "INSERT INTO (xxx) ..". The result of this method is effectively cached, and it is invalidated when set of fields changes (e.g. using clear() or addField()). This method is similar to FieldList::sqlFieldsList() it just uses QueryColumnInfo::List instead of Field::List. Definition at line 1430 of file queryschema.cpp. References KexiDB::Driver::escapeIdentifier(). Referenced by autoIncrementSQLFieldsList().

QString QuerySchema::statement (   )  const

Returns: a preset statement (if any). Definition at line 1026 of file queryschema.cpp. References d. Referenced by KexiDB::Connection::selectStatement().