MBroker
 Указатель Классы Пространства имен Файлы Функции Переменные Определения типов Перечисления Элементы перечислений Свойства
Открытые члены | Открытые атрибуты | Полный список членов класса
Класс MBrokerTest.BuildSqlPgTest

Открытые члены

 BuildSqlPgTest ()
 
void SelectQueryTest ()
 SELECT * FROM Подробнее...
 
void LimitQueryTest ()
 SELECT * FROM ... limit 1 Подробнее...
 
void FilterAndQueryTest ()
 SELECT * FROM ... WHERE ... AND ... Подробнее...
 
void FilterOrQueryTest ()
 SELECT * FROM ... WHERE ... OR .... Подробнее...
 
void FieldsQueryTest ()
 SELECT ... ... ... FROM ... Подробнее...
 
void GroupByQueryTest ()
 SELECT ... ... FROM ... GROUP BY ... Подробнее...
 
void GroupByNumpartQueryTest ()
 
void FieldAgregatQueryTest ()
 SELECT ID_BASE, COUNT(id) as NCOUNT FROM V_AUTO Подробнее...
 
void FieldAgregatDistinctQueryTest ()
 SELECT ID_BASE, COUNT(DISTINCT id) as NCOUNT FROM V_AUTO Подробнее...
 
void OrderQueryDescTest ()
 SELECT ... FROM ... ORDER BY ... DESC Подробнее...
 
void OrderQueryAscTest ()
 SELECT ... FROM ... ORDER BY ... ASC Подробнее...
 
void EqQueryTest ()
 id= Подробнее...
 
void NeqQueryTest ()
 
void GtQueryTest ()
 id> Подробнее...
 
void LtQueryTest ()
 
void GteQueryTest ()
 id>= Подробнее...
 
void LteQueryTest ()
 
void AnyQueryTest ()
 id = ANY Подробнее...
 
void NinQueryTest ()
 id <> ALL Подробнее...
 
void InpQueryTest ()
 = ANY (mbroker.getpresetvalues() Подробнее...
 
void NinpQueryTest ()
 
void LikeQueryTest ()
 id ILIKE Подробнее...
 
void NlikeQueryTest ()
 id NOT ILIKE Подробнее...
 
void IndexNeqQuery ()
 
void SubconditionQueryTest ()
 id IS NOT NULL AND (c_name IS NULL OR c_name=0) Подробнее...
 
void OrderMasQueryTest ()
 /// Запрос представления с использованием массива order Подробнее...
 

Открытые атрибуты

readonly WorkerBroker Broker
 

Конструктор(ы)

MBrokerTest.BuildSqlPgTest.BuildSqlPgTest ( )

Методы

void MBrokerTest.BuildSqlPgTest.AnyQueryTest ( )

id = ANY

void MBrokerTest.BuildSqlPgTest.EqQueryTest ( )

id=

void MBrokerTest.BuildSqlPgTest.FieldAgregatDistinctQueryTest ( )

SELECT ID_BASE, COUNT(DISTINCT id) as NCOUNT FROM V_AUTO

void MBrokerTest.BuildSqlPgTest.FieldAgregatQueryTest ( )

SELECT ID_BASE, COUNT(id) as NCOUNT FROM V_AUTO

void MBrokerTest.BuildSqlPgTest.FieldsQueryTest ( )

SELECT ... ... ... FROM ...

void MBrokerTest.BuildSqlPgTest.FilterAndQueryTest ( )

SELECT * FROM ... WHERE ... AND ...

void MBrokerTest.BuildSqlPgTest.FilterOrQueryTest ( )

SELECT * FROM ... WHERE ... OR ....

void MBrokerTest.BuildSqlPgTest.GroupByNumpartQueryTest ( )
void MBrokerTest.BuildSqlPgTest.GroupByQueryTest ( )

SELECT ... ... FROM ... GROUP BY ...

void MBrokerTest.BuildSqlPgTest.GteQueryTest ( )

id>=

void MBrokerTest.BuildSqlPgTest.GtQueryTest ( )

id>

void MBrokerTest.BuildSqlPgTest.IndexNeqQuery ( )

id<>

void MBrokerTest.BuildSqlPgTest.InpQueryTest ( )

= ANY (mbroker.getpresetvalues()

void MBrokerTest.BuildSqlPgTest.LikeQueryTest ( )

id ILIKE

void MBrokerTest.BuildSqlPgTest.LimitQueryTest ( )

SELECT * FROM ... limit 1

void MBrokerTest.BuildSqlPgTest.LteQueryTest ( )

id<=

void MBrokerTest.BuildSqlPgTest.LtQueryTest ( )

id<

void MBrokerTest.BuildSqlPgTest.NeqQueryTest ( )

id<>

void MBrokerTest.BuildSqlPgTest.NinpQueryTest ( )

<> ALL (mbroker.getpresetvalues()

void MBrokerTest.BuildSqlPgTest.NinQueryTest ( )

id <> ALL

void MBrokerTest.BuildSqlPgTest.NlikeQueryTest ( )

id NOT ILIKE

void MBrokerTest.BuildSqlPgTest.OrderMasQueryTest ( )

/// Запрос представления с использованием массива order

void MBrokerTest.BuildSqlPgTest.OrderQueryAscTest ( )

SELECT ... FROM ... ORDER BY ... ASC

void MBrokerTest.BuildSqlPgTest.OrderQueryDescTest ( )

SELECT ... FROM ... ORDER BY ... DESC

void MBrokerTest.BuildSqlPgTest.SelectQueryTest ( )

SELECT * FROM

void MBrokerTest.BuildSqlPgTest.SubconditionQueryTest ( )

id IS NOT NULL AND (c_name IS NULL OR c_name=0)

Данные класса

readonly WorkerBroker MBrokerTest.BuildSqlPgTest.Broker

Объявления и описания членов класса находятся в файле: