An implementation of IFromTableSource that wraps around a SqlQueryExpression as a sub-query source. More...

Inheritance diagram for Deveel.Data.Sql.Query.FromTableSubQuerySource:

Public Member Functions
bool	MatchesReference (string catalog, string schema, string table)
	Checks if the table matches the given catalog, schema and table. More...

int	ResolveColumnCount (string catalog, string schema, string table, string column)
	Returns the number of instances we can resolve the given catalog, schema, table and column name to a column or columns within the current source. More...

ObjectName	ResolveColumn (string catalog, string schema, string table, string column)
	Resolves a variable within the current source. More...

Package Functions
	FromTableSubQuerySource (bool caseInsensitive, string uniqueKey, SqlQueryExpression queryExpression, QueryExpressionFrom fromSet, ObjectName alias)

Properties
SqlQueryExpression	QueryExpression `[get, private set]`

QueryExpressionFrom	QueryFrom `[get, private set]`

ObjectName	AliasName `[get, private set]`

bool	IgnoreCase `[get, private set]`

string	UniqueName `[get, private set]`

ObjectName[]	ColumnNames `[get]`

Properties inherited from Deveel.Data.Sql.Query.IFromTableSource
string	UniqueName `[get]`
	Gets a unique name given to this table source. More...

ObjectName[]	ColumnNames `[get]`
	Returns an array of ObjectName objects that references each column available in the table set item in order from left column to right column. More...

Private Member Functions
void	EnsureColumnNames ()
	Makes sure the columnNames list is created correctly. More...

bool	StringCompare (string str1, string str2)

bool	Matches (ObjectName name, string catalog, string schema, string table, string column)

Private Attributes
ObjectName[]	columnNames

Detailed Description

An implementation of IFromTableSource that wraps around a SqlQueryExpression as a sub-query source.

Definition at line 27 of file FromTableSubQuerySource.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Query.FromTableSubQuerySource.FromTableSubQuerySource	(	bool	caseInsensitive,
		string	uniqueKey,
		SqlQueryExpression	queryExpression,
		QueryExpressionFrom	fromSet,
		ObjectName	alias
	)

inlinepackage

Definition at line 30 of file FromTableSubQuerySource.cs.

                                                            {
             UniqueName = uniqueKey;
             QueryExpression = queryExpression;
             QueryFrom = fromSet;
             AliasName = alias;
             IgnoreCase = caseInsensitive;
         }

Member Function Documentation

void Deveel.Data.Sql.Query.FromTableSubQuerySource.EnsureColumnNames ( )

inlineprivate

Makes sure the columnNames list is created correctly.

Definition at line 76 of file FromTableSubQuerySource.cs.

                                          {
             if (columnNames == null) {
                 columnNames = QueryFrom.GetResolvedColumns();
 
                 // Are the variables aliased to a table name?
                 if (AliasName != null) {
                     for (int i = 0; i < columnNames.Length; ++i) {
                         columnNames[i] = new ObjectName(AliasName, columnNames[i].Name);
                     }
                 }
             }
         }

bool Deveel.Data.Sql.Query.FromTableSubQuerySource.Matches	(	ObjectName	name,
		string	catalog,
		string	schema,
		string	table,
		string	column
	)

inlineprivate

Definition at line 94 of file FromTableSubQuerySource.cs.

                                                                                                           {
             var tableName = name.Parent;
             var schemaName = tableName == null ? null : tableName.Parent;
             var catalogName = schemaName == null ? null : schemaName.Parent;
             var columnName = name.Name;
 
             if (column == null)
                 return true;
             if (!StringCompare(columnName, column))
                 return false;
 
             if (table == null)
                 return true;
             if (tableName == null)
                 return false;
 
             string tname = tableName.Name;
             if (tname != null && !StringCompare(tname, table))
                 return false;
 
             if (schema == null)
                 return true;
 
             string sname = schemaName != null ? schemaName.Name : null;
             if (sname != null && !StringCompare(sname, schema))
                 return false;
 
             string cname = catalogName != null ? catalogName.Name : null;
             if (cname != null && !StringCompare(cname, catalog))
                 return false;
 
             return true;
         }

bool Deveel.Data.Sql.Query.FromTableSubQuerySource.MatchesReference	(	string	catalog,
		string	schema,
		string	table
	)

inline

Checks if the table matches the given catalog, schema and table.

Parameters

catalog	The catalog name used for the matching.
schema	The schema name used for the matching.
table	The table name used for the maching.

If any arguments are null then it is not included in the match.

Used for 'Part.*' type glob searches.

Returns: Returns true if this source matches the given catalog, schema and table, otherwise false.

Implements Deveel.Data.Sql.Query.IFromTableSource.

Definition at line 39 of file FromTableSubQuerySource.cs.

                                                                                   {
             if (schema == null && table == null)
                 return true;
 
             if (AliasName != null) {
                 string ts = AliasName.Parent.Name;
                 string tt = AliasName.Name;
                 if (schema == null)
                     return StringCompare(tt, table);
                 if (StringCompare(tt, table) && StringCompare(ts, schema))
                     return true;
             }
 
             // No way to determine if there is a match
             return false;
         }

ObjectName Deveel.Data.Sql.Query.FromTableSubQuerySource.ResolveColumn	(	string	catalog,
		string	schema,
		string	table,
		string	column
	)

inline

Resolves a variable within the current source.

Parameters

catalog
schema
table
column

This method does not have to check whether the parameters reference more than one column. If more than one column is referenced, the actual column returned is implementation specific.

Returns: Returns a ObjectName that is a fully resolved form of the given column in the current table set.

Implements Deveel.Data.Sql.Query.IFromTableSource.

Definition at line 141 of file FromTableSubQuerySource.cs.

                                                                                                     {
             EnsureColumnNames();
 
             var result = columnNames.FirstOrDefault(v => Matches(v, catalog, schema, table, column));
             if (result == null)
                 throw new InvalidOperationException("Couldn't resolve to a column.");
 
             return result;
         }

int Deveel.Data.Sql.Query.FromTableSubQuerySource.ResolveColumnCount	(	string	catalog,
		string	schema,
		string	table,
		string	column
	)

inline

Returns the number of instances we can resolve the given catalog, schema, table and column name to a column or columns within the current source.

Parameters

catalog
schema
table
column

Note that if catalog, schema, table or column is null then it means it doesn't matter.

Note that parameters of null, null, null, null, null, null, null, not null, null, null, not null, not null, null, not null, not null, not null, and not null, not null, not null, not null are only accepted.

For example, say we need to resolve the column 'id' the arguments are null, null, null, "id". This may resolve to multiple columns if there is a mixture of tables with "id" as a column.

Returns

Implements Deveel.Data.Sql.Query.IFromTableSource.

Definition at line 128 of file FromTableSubQuerySource.cs.

                                                                                                   {
             EnsureColumnNames();
 
             if (String.IsNullOrEmpty(catalog) && 
                 String.IsNullOrEmpty(schema) && 
                 String.IsNullOrEmpty(table) && 
                 String.IsNullOrEmpty(column))
                 return columnNames.Length;
 
             return columnNames.Count(v => Matches(v, catalog, schema, table, column));
 
         }

bool Deveel.Data.Sql.Query.FromTableSubQuerySource.StringCompare	(	string	str1,
		string	str2
	)

inlineprivate

Definition at line 89 of file FromTableSubQuerySource.cs.

                                                              {
             var comparison = IgnoreCase ? StringComparison.OrdinalIgnoreCase : StringComparison.Ordinal;
             return String.Equals(str1, str2, comparison);
         }

Member Data Documentation

ObjectName [] Deveel.Data.Sql.Query.FromTableSubQuerySource.columnNames

private

Definition at line 28 of file FromTableSubQuerySource.cs.

Property Documentation

ObjectName Deveel.Data.Sql.Query.FromTableSubQuerySource.AliasName

getprivate set

Definition at line 60 of file FromTableSubQuerySource.cs.

ObjectName [] Deveel.Data.Sql.Query.FromTableSubQuerySource.ColumnNames

get

Definition at line 66 of file FromTableSubQuerySource.cs.

bool Deveel.Data.Sql.Query.FromTableSubQuerySource.IgnoreCase

getprivate set

Definition at line 62 of file FromTableSubQuerySource.cs.

SqlQueryExpression Deveel.Data.Sql.Query.FromTableSubQuerySource.QueryExpression

getprivate set

Definition at line 56 of file FromTableSubQuerySource.cs.

QueryExpressionFrom Deveel.Data.Sql.Query.FromTableSubQuerySource.QueryFrom

getprivate set

Definition at line 58 of file FromTableSubQuerySource.cs.

string Deveel.Data.Sql.Query.FromTableSubQuerySource.UniqueName

getprivate set

Definition at line 64 of file FromTableSubQuerySource.cs.

The documentation for this class was generated from the following file:

/var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Sql.Query/FromTableSubQuerySource.cs

Public Member Functions

Package Functions

Properties

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation