C# Class Deveel.Data.Sql.Tables.TableQueryExtensions

Provides a set of extension methods to ITable and IMutableTable objects.
Afficher le fichier Open project: deveel/deveeldb

Méthodes publiques

Méthode Description
AllRowsMatchColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool
AnyRowMatchesColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool
Composite ( this table, ITable other, CompositeFunction function, bool all ) : ITable
DistinctBy ( this table, ObjectName columnNames ) : ITable
DistinctBy ( this table, int columns ) : ITable
EmptySelect ( this table ) : ITable
Execept ( this table, ITable other, bool all ) : ITable
ExhaustiveSelect ( this table, IRequest context, SqlExpression expression ) : ITable
Exists ( this table, int columnOffset, Field value ) : bool
Exists ( this table, int columnOffset1, Field value1, int columnOffset2, Field value2 ) : bool
FindKeys ( this table, int columnOffsets, Field keyValue ) : IEnumerable
GetColumn ( this table, int columnOffset ) : Column
GetColumn ( this table, string columnName ) : Column
GetFirstValue ( this table, int columnOffset ) : Field
GetFirstValue ( this table, string columnName ) : Field
GetFirstValues ( this table, int columnOffsets ) : Field[]
GetLastValue ( this table, int columnOffset ) : Field
GetLastValue ( this table, string columnName ) : Field
GetLastValues ( this table, int columnOffsets ) : Field[]
GetRow ( this table, int rowNumber ) : Deveel.Data.Sql.Tables.Row
GetSingleValue ( this table, int columnOffset ) : Field
GetSingleValue ( this table, string columnName ) : Field
GetSingleValues ( this table, int columnOffsets ) : Field[]
GetValue ( this table, int rowIndex, ObjectName columnName ) : Field
GetValue ( this table, int rowIndex, string columnName ) : Field
IndexOfColumn ( this table, ObjectName columnName ) : int
IndexOfColumn ( this table, string columnName ) : int
Intersect ( this table, ITable other, bool all ) : ITable
Join ( this table, IRequest context, ITable other, ObjectName columnName, SqlExpressionType operatorType, SqlExpression expression ) : ITable
Join ( this table, ITable otherTable, bool quick ) : ITable
NaturalJoin ( this table, ITable otherTable ) : ITable
NotIn ( this table, ITable otherTable, int tableColumns, int otherColumns ) : ITable
OrderBy ( this table, ObjectName columnName, bool ascending ) : ITable
OrderBy ( this table, int columns ) : ITable
OrderBy ( this table, int columnIndex, bool ascending ) : ITable
OrderBy ( this table, string columnName, bool ascending ) : ITable
OrderRowsByColumns ( this table, int columns ) : IEnumerable
OuterJoin ( this table, ITable rightTable ) : ITable
Search ( this table, int column, string pattern ) : IEnumerable
Search ( this table, int column, string pattern, char escapeChar ) : IEnumerable
SelecRowsLess ( this table, int columnOffset, Field value ) : IEnumerable
SelecRowsLess ( this table, int columnOffset, System.Objects value ) : IEnumerable
Select ( this table, IRequest context, SqlExpression expression ) : ITable
SelectAll ( this table, int columnOffset ) : ITable
SelectAllRows ( this table ) : IEnumerable
SelectAllRows ( this table, int columnOffset ) : IEnumerable
SelectAnyAllNonCorrelated ( this table, ObjectName leftColumns, SqlExpressionType op, bool all, ITable rightTable ) : ITable
SelectEqual ( this table, int columnIndex, Field value ) : ITable
SelectEqual ( this table, string columnName, Field value ) : ITable
SelectFirst ( this table, int columnOffset ) : IEnumerable
SelectFromPattern ( this table, int column, SqlExpressionType op, Field ob ) : IEnumerable
SelectLast ( this table, int columnOffset ) : IEnumerable
SelectNotEqual ( this table, int columnOffset, Field value ) : IEnumerable
SelectNotEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable
SelectRange ( this thisTable, ObjectName columnName, IndexRange ranges ) : ITable
SelectRows ( this table, IVariableResolver resolver, IRequest context, SqlBinaryExpression expression ) : IEnumerable
SelectRows ( this table, int columnOffsets, SqlExpressionType op, Field values ) : IEnumerable
SelectRowsBetween ( this table, int column, Field minCell, Field maxCell ) : IEnumerable
SelectRowsEqual ( this table, int columnIndex, Field value ) : IEnumerable
SelectRowsEqual ( this table, int columnIndex1, Field value1, int columnIndex2, Field value2 ) : IEnumerable
SelectRowsEqual ( this table, string columnName, Field value ) : IEnumerable
SelectRowsGreater ( this table, int columnOffset, Field value ) : IEnumerable
SelectRowsGreater ( this table, int columnOffset, System.Objects value ) : IEnumerable
SelectRowsGreaterOrEqual ( this table, int columnOffset, Field value ) : IEnumerable
SelectRowsGreaterOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable
SelectRowsIn ( this table, ITable other, int column1, int column2 ) : IEnumerable

This implements the in command.

SelectRowsLessOrEqual ( this table, int columnOffset, Field value ) : IEnumerable
SelectRowsLessOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable
SelectRowsNotIn ( this table, ITable other, int col1, int col2 ) : IEnumerable

This implements the not in command.

Issue: This will be less efficient than in if table has many rows and other has few rows.

SelectRowsRange ( this table, int column, IndexRange ranges ) : IEnumerable
SimpleJoin ( this thisTable, IRequest context, ITable other, SqlBinaryExpression binary ) : ITable
SimpleSelect ( this table, IRequest context, ObjectName columnName, SqlExpressionType op, SqlExpression exp ) : ITable
Subset ( this table, ObjectName columnNames, ObjectName aliases ) : ITable
ToDictionary ( this table ) : Objects.ISqlObject>.Dictionary
Union ( this thisTable, ITable otherTable ) : ITable

Private Methods

Méthode Description
AsVirtual ( this table, Func selector ) : ITable
MakeObject ( this table, int columnOffset, System.Objects value ) : Field

Method Details

AllRowsMatchColumnValue() public static méthode

public static AllRowsMatchColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool
table this
columnOffset int
op SqlExpressionType
value Field
Résultat bool

AnyRowMatchesColumnValue() public static méthode

public static AnyRowMatchesColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool
table this
columnOffset int
op SqlExpressionType
value Field
Résultat bool

Composite() public static méthode

public static Composite ( this table, ITable other, CompositeFunction function, bool all ) : ITable
table this
other ITable
function CompositeFunction
all bool
Résultat ITable

DistinctBy() public static méthode

public static DistinctBy ( this table, ObjectName columnNames ) : ITable
table this
columnNames ObjectName
Résultat ITable

DistinctBy() public static méthode

public static DistinctBy ( this table, int columns ) : ITable
table this
columns int
Résultat ITable

EmptySelect() public static méthode

public static EmptySelect ( this table ) : ITable
table this
Résultat ITable

Execept() public static méthode

public static Execept ( this table, ITable other, bool all ) : ITable
table this
other ITable
all bool
Résultat ITable

ExhaustiveSelect() public static méthode

public static ExhaustiveSelect ( this table, IRequest context, SqlExpression expression ) : ITable
table this
context IRequest
expression Deveel.Data.Sql.Expressions.SqlExpression
Résultat ITable

Exists() public static méthode

public static Exists ( this table, int columnOffset, Field value ) : bool
table this
columnOffset int
value Field
Résultat bool

Exists() public static méthode

public static Exists ( this table, int columnOffset1, Field value1, int columnOffset2, Field value2 ) : bool
table this
columnOffset1 int
value1 Field
columnOffset2 int
value2 Field
Résultat bool

FindKeys() public static méthode

public static FindKeys ( this table, int columnOffsets, Field keyValue ) : IEnumerable
table this
columnOffsets int
keyValue Field
Résultat IEnumerable

GetColumn() public static méthode

public static GetColumn ( this table, int columnOffset ) : Column
table this
columnOffset int
Résultat Column

GetColumn() public static méthode

public static GetColumn ( this table, string columnName ) : Column
table this
columnName string
Résultat Column

GetFirstValue() public static méthode

public static GetFirstValue ( this table, int columnOffset ) : Field
table this
columnOffset int
Résultat Field

GetFirstValue() public static méthode

public static GetFirstValue ( this table, string columnName ) : Field
table this
columnName string
Résultat Field

GetFirstValues() public static méthode

public static GetFirstValues ( this table, int columnOffsets ) : Field[]
table this
columnOffsets int
Résultat Field[]

GetLastValue() public static méthode

public static GetLastValue ( this table, int columnOffset ) : Field
table this
columnOffset int
Résultat Field

GetLastValue() public static méthode

public static GetLastValue ( this table, string columnName ) : Field
table this
columnName string
Résultat Field

GetLastValues() public static méthode

public static GetLastValues ( this table, int columnOffsets ) : Field[]
table this
columnOffsets int
Résultat Field[]

GetRow() public static méthode

public static GetRow ( this table, int rowNumber ) : Deveel.Data.Sql.Tables.Row
table this
rowNumber int
Résultat Deveel.Data.Sql.Tables.Row

GetSingleValue() public static méthode

public static GetSingleValue ( this table, int columnOffset ) : Field
table this
columnOffset int
Résultat Field

GetSingleValue() public static méthode

public static GetSingleValue ( this table, string columnName ) : Field
table this
columnName string
Résultat Field

GetSingleValues() public static méthode

public static GetSingleValues ( this table, int columnOffsets ) : Field[]
table this
columnOffsets int
Résultat Field[]

GetValue() public static méthode

public static GetValue ( this table, int rowIndex, ObjectName columnName ) : Field
table this
rowIndex int
columnName ObjectName
Résultat Field

GetValue() public static méthode

public static GetValue ( this table, int rowIndex, string columnName ) : Field
table this
rowIndex int
columnName string
Résultat Field

IndexOfColumn() public static méthode

public static IndexOfColumn ( this table, ObjectName columnName ) : int
table this
columnName ObjectName
Résultat int

IndexOfColumn() public static méthode

public static IndexOfColumn ( this table, string columnName ) : int
table this
columnName string
Résultat int

Intersect() public static méthode

public static Intersect ( this table, ITable other, bool all ) : ITable
table this
other ITable
all bool
Résultat ITable

Join() public static méthode

public static Join ( this table, IRequest context, ITable other, ObjectName columnName, SqlExpressionType operatorType, SqlExpression expression ) : ITable
table this
context IRequest
other ITable
columnName ObjectName
operatorType SqlExpressionType
expression Deveel.Data.Sql.Expressions.SqlExpression
Résultat ITable

Join() public static méthode

public static Join ( this table, ITable otherTable, bool quick ) : ITable
table this
otherTable ITable
quick bool
Résultat ITable

NaturalJoin() public static méthode

public static NaturalJoin ( this table, ITable otherTable ) : ITable
table this
otherTable ITable
Résultat ITable

NotIn() public static méthode

public static NotIn ( this table, ITable otherTable, int tableColumns, int otherColumns ) : ITable
table this
otherTable ITable
tableColumns int
otherColumns int
Résultat ITable

OrderBy() public static méthode

public static OrderBy ( this table, ObjectName columnName, bool ascending ) : ITable
table this
columnName ObjectName
ascending bool
Résultat ITable

OrderBy() public static méthode

public static OrderBy ( this table, int columns ) : ITable
table this
columns int
Résultat ITable

OrderBy() public static méthode

public static OrderBy ( this table, int columnIndex, bool ascending ) : ITable
table this
columnIndex int
ascending bool
Résultat ITable

OrderBy() public static méthode

public static OrderBy ( this table, string columnName, bool ascending ) : ITable
table this
columnName string
ascending bool
Résultat ITable

OrderRowsByColumns() public static méthode

public static OrderRowsByColumns ( this table, int columns ) : IEnumerable
table this
columns int
Résultat IEnumerable

OuterJoin() public static méthode

public static OuterJoin ( this table, ITable rightTable ) : ITable
table this
rightTable ITable
Résultat ITable

Search() public static méthode

public static Search ( this table, int column, string pattern ) : IEnumerable
table this
column int
pattern string
Résultat IEnumerable

Search() public static méthode

public static Search ( this table, int column, string pattern, char escapeChar ) : IEnumerable
table this
column int
pattern string
escapeChar char
Résultat IEnumerable

SelecRowsLess() public static méthode

public static SelecRowsLess ( this table, int columnOffset, Field value ) : IEnumerable
table this
columnOffset int
value Field
Résultat IEnumerable

SelecRowsLess() public static méthode

public static SelecRowsLess ( this table, int columnOffset, System.Objects value ) : IEnumerable
table this
columnOffset int
value System.Objects
Résultat IEnumerable

Select() public static méthode

public static Select ( this table, IRequest context, SqlExpression expression ) : ITable
table this
context IRequest
expression Deveel.Data.Sql.Expressions.SqlExpression
Résultat ITable

SelectAll() public static méthode

public static SelectAll ( this table, int columnOffset ) : ITable
table this
columnOffset int
Résultat ITable

SelectAllRows() public static méthode

public static SelectAllRows ( this table ) : IEnumerable
table this
Résultat IEnumerable

SelectAllRows() public static méthode

public static SelectAllRows ( this table, int columnOffset ) : IEnumerable
table this
columnOffset int
Résultat IEnumerable

SelectAnyAllNonCorrelated() public static méthode

public static SelectAnyAllNonCorrelated ( this table, ObjectName leftColumns, SqlExpressionType op, bool all, ITable rightTable ) : ITable
table this
leftColumns ObjectName
op SqlExpressionType
all bool
rightTable ITable
Résultat ITable

SelectEqual() public static méthode

public static SelectEqual ( this table, int columnIndex, Field value ) : ITable
table this
columnIndex int
value Field
Résultat ITable

SelectEqual() public static méthode

public static SelectEqual ( this table, string columnName, Field value ) : ITable
table this
columnName string
value Field
Résultat ITable

SelectFirst() public static méthode

public static SelectFirst ( this table, int columnOffset ) : IEnumerable
table this
columnOffset int
Résultat IEnumerable

SelectFromPattern() public static méthode

public static SelectFromPattern ( this table, int column, SqlExpressionType op, Field ob ) : IEnumerable
table this
column int
op SqlExpressionType
ob Field
Résultat IEnumerable

SelectLast() public static méthode

public static SelectLast ( this table, int columnOffset ) : IEnumerable
table this
columnOffset int
Résultat IEnumerable

SelectNotEqual() public static méthode

public static SelectNotEqual ( this table, int columnOffset, Field value ) : IEnumerable
table this
columnOffset int
value Field
Résultat IEnumerable

SelectNotEqual() public static méthode

public static SelectNotEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable
table this
columnOffset int
value System.Objects
Résultat IEnumerable

SelectRange() public static méthode

public static SelectRange ( this thisTable, ObjectName columnName, IndexRange ranges ) : ITable
thisTable this
columnName ObjectName
ranges Deveel.Data.Index.IndexRange
Résultat ITable

SelectRows() public static méthode

public static SelectRows ( this table, IVariableResolver resolver, IRequest context, SqlBinaryExpression expression ) : IEnumerable
table this
resolver IVariableResolver
context IRequest
expression Deveel.Data.Sql.Expressions.SqlBinaryExpression
Résultat IEnumerable

SelectRows() public static méthode

public static SelectRows ( this table, int columnOffsets, SqlExpressionType op, Field values ) : IEnumerable
table this
columnOffsets int
op SqlExpressionType
values Field
Résultat IEnumerable

SelectRowsBetween() public static méthode

public static SelectRowsBetween ( this table, int column, Field minCell, Field maxCell ) : IEnumerable
table this
column int
minCell Field
maxCell Field
Résultat IEnumerable

SelectRowsEqual() public static méthode

public static SelectRowsEqual ( this table, int columnIndex, Field value ) : IEnumerable
table this
columnIndex int
value Field
Résultat IEnumerable

SelectRowsEqual() public static méthode

public static SelectRowsEqual ( this table, int columnIndex1, Field value1, int columnIndex2, Field value2 ) : IEnumerable
table this
columnIndex1 int
value1 Field
columnIndex2 int
value2 Field
Résultat IEnumerable

SelectRowsEqual() public static méthode

public static SelectRowsEqual ( this table, string columnName, Field value ) : IEnumerable
table this
columnName string
value Field
Résultat IEnumerable

SelectRowsGreater() public static méthode

public static SelectRowsGreater ( this table, int columnOffset, Field value ) : IEnumerable
table this
columnOffset int
value Field
Résultat IEnumerable

SelectRowsGreater() public static méthode

public static SelectRowsGreater ( this table, int columnOffset, System.Objects value ) : IEnumerable
table this
columnOffset int
value System.Objects
Résultat IEnumerable

SelectRowsGreaterOrEqual() public static méthode

public static SelectRowsGreaterOrEqual ( this table, int columnOffset, Field value ) : IEnumerable
table this
columnOffset int
value Field
Résultat IEnumerable

SelectRowsGreaterOrEqual() public static méthode

public static SelectRowsGreaterOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable
table this
columnOffset int
value System.Objects
Résultat IEnumerable

SelectRowsIn() public static méthode

This implements the in command.
public static SelectRowsIn ( this table, ITable other, int column1, int column2 ) : IEnumerable
table this
other ITable
column1 int
column2 int
Résultat IEnumerable

SelectRowsLessOrEqual() public static méthode

public static SelectRowsLessOrEqual ( this table, int columnOffset, Field value ) : IEnumerable
table this
columnOffset int
value Field
Résultat IEnumerable

SelectRowsLessOrEqual() public static méthode

public static SelectRowsLessOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable
table this
columnOffset int
value System.Objects
Résultat IEnumerable

SelectRowsNotIn() public static méthode

This implements the not in command.
Issue: This will be less efficient than in if table has many rows and other has few rows.
public static SelectRowsNotIn ( this table, ITable other, int col1, int col2 ) : IEnumerable
table this
other ITable
col1 int
col2 int
Résultat IEnumerable

SelectRowsRange() public static méthode

public static SelectRowsRange ( this table, int column, IndexRange ranges ) : IEnumerable
table this
column int
ranges Deveel.Data.Index.IndexRange
Résultat IEnumerable

SimpleJoin() public static méthode

public static SimpleJoin ( this thisTable, IRequest context, ITable other, SqlBinaryExpression binary ) : ITable
thisTable this
context IRequest
other ITable
binary Deveel.Data.Sql.Expressions.SqlBinaryExpression
Résultat ITable

SimpleSelect() public static méthode

public static SimpleSelect ( this table, IRequest context, ObjectName columnName, SqlExpressionType op, SqlExpression exp ) : ITable
table this
context IRequest
columnName ObjectName
op SqlExpressionType
exp Deveel.Data.Sql.Expressions.SqlExpression
Résultat ITable

Subset() public static méthode

public static Subset ( this table, ObjectName columnNames, ObjectName aliases ) : ITable
table this
columnNames ObjectName
aliases ObjectName
Résultat ITable

ToDictionary() public static méthode

public static ToDictionary ( this table ) : Objects.ISqlObject>.Dictionary
table this
Résultat Objects.ISqlObject>.Dictionary

Union() public static méthode

public static Union ( this thisTable, ITable otherTable ) : ITable
thisTable this
otherTable ITable
Résultat ITable