public function testCreateSelectSqlPart()
{
Propel::getServiceContainer()->setAdapter('oracle', new OracleAdapter());
$db = Propel::getServiceContainer()->getAdapter();
$c = new Criteria();
$c->addSelectColumn(BookTableMap::COL_ID);
$c->addAsColumn('book_ID', BookTableMap::COL_ID);
$fromClause = [];
$selectSql = $db->createSelectSqlPart($c, $fromClause);
$this->assertEquals('SELECT book.id, book.id AS book_ID', $selectSql, 'createSelectSqlPart() returns a SQL SELECT clause with both select and as columns');
$this->assertEquals(['book'], $fromClause, 'createSelectSqlPart() adds the tables from the select columns to the from clause');
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ContentI18nTableMap::ID);
$criteria->addSelectColumn(ContentI18nTableMap::LOCALE);
$criteria->addSelectColumn(ContentI18nTableMap::TITLE);
$criteria->addSelectColumn(ContentI18nTableMap::DESCRIPTION);
$criteria->addSelectColumn(ContentI18nTableMap::CHAPO);
$criteria->addSelectColumn(ContentI18nTableMap::POSTSCRIPTUM);
$criteria->addSelectColumn(ContentI18nTableMap::META_TITLE);
$criteria->addSelectColumn(ContentI18nTableMap::META_DESCRIPTION);
$criteria->addSelectColumn(ContentI18nTableMap::META_KEYWORDS);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.LOCALE');
$criteria->addSelectColumn($alias . '.TITLE');
$criteria->addSelectColumn($alias . '.DESCRIPTION');
$criteria->addSelectColumn($alias . '.CHAPO');
$criteria->addSelectColumn($alias . '.POSTSCRIPTUM');
$criteria->addSelectColumn($alias . '.META_TITLE');
$criteria->addSelectColumn($alias . '.META_DESCRIPTION');
$criteria->addSelectColumn($alias . '.META_KEYWORDS');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(DiaporamaVersionTableMap::ID);
$criteria->addSelectColumn(DiaporamaVersionTableMap::SHORTCODE);
$criteria->addSelectColumn(DiaporamaVersionTableMap::CREATED_AT);
$criteria->addSelectColumn(DiaporamaVersionTableMap::UPDATED_AT);
$criteria->addSelectColumn(DiaporamaVersionTableMap::VERSION);
$criteria->addSelectColumn(DiaporamaVersionTableMap::VERSION_CREATED_AT);
$criteria->addSelectColumn(DiaporamaVersionTableMap::VERSION_CREATED_BY);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.SHORTCODE');
$criteria->addSelectColumn($alias . '.CREATED_AT');
$criteria->addSelectColumn($alias . '.UPDATED_AT');
$criteria->addSelectColumn($alias . '.VERSION');
$criteria->addSelectColumn($alias . '.VERSION_CREATED_AT');
$criteria->addSelectColumn($alias . '.VERSION_CREATED_BY');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(JudgeTableMap::COL_ID);
$criteria->addSelectColumn(JudgeTableMap::COL_POSITION);
$criteria->addSelectColumn(JudgeTableMap::COL_STARTGROUP_ID);
$criteria->addSelectColumn(JudgeTableMap::COL_USER_ID);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.position');
$criteria->addSelectColumn($alias . '.startgroup_id');
$criteria->addSelectColumn($alias . '.user_id');
}
}
public function testCreateSelectSqlPartAliasAll()
{
$db = Propel::getServiceContainer()->getAdapter(BookTableMap::DATABASE_NAME);
$c = new Criteria();
$c->addSelectColumn(BookTableMap::COL_ID);
$c->addAsColumn('book_id', BookTableMap::COL_ID);
$fromClause = [];
$selectSql = $db->createSelectSqlPart($c, $fromClause, true);
$this->assertEquals('SELECT book.id AS book_id_1, book.id AS book_id', $selectSql, 'createSelectSqlPart() aliases all columns if passed true as last parameter');
$this->assertEquals([], $fromClause, 'createSelectSqlPart() does not add the tables from an all-aliased list of select columns');
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(LockTableMap::COL_ID);
$criteria->addSelectColumn(LockTableMap::COL_CREATINGDATETIME);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.CREATINGDATETIME');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(EveApiTableMap::COL_ID);
$criteria->addSelectColumn(EveApiTableMap::COL_USERID);
$criteria->addSelectColumn(EveApiTableMap::COL_KEYID);
$criteria->addSelectColumn(EveApiTableMap::COL_VCODE);
$criteria->addSelectColumn(EveApiTableMap::COL_STATUS);
$criteria->addSelectColumn(EveApiTableMap::COL_LASTCOMPUTED);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.userId');
$criteria->addSelectColumn($alias . '.keyId');
$criteria->addSelectColumn($alias . '.vCode');
$criteria->addSelectColumn($alias . '.status');
$criteria->addSelectColumn($alias . '.lastComputed');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(BookTableMap::COL_ID);
$criteria->addSelectColumn(BookTableMap::COL_TITLE);
$criteria->addSelectColumn(BookTableMap::COL_ISBN);
$criteria->addSelectColumn(BookTableMap::COL_PUBLISHER_ID);
$criteria->addSelectColumn(BookTableMap::COL_AUTHOR_ID);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.title');
$criteria->addSelectColumn($alias . '.isbn');
$criteria->addSelectColumn($alias . '.publisher_id');
$criteria->addSelectColumn($alias . '.author_id');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(StructureNodeTableMap::COL_ID);
$criteria->addSelectColumn(StructureNodeTableMap::COL_TYPE);
$criteria->addSelectColumn(StructureNodeTableMap::COL_SKILL_ID);
$criteria->addSelectColumn(StructureNodeTableMap::COL_TITLE);
$criteria->addSelectColumn(StructureNodeTableMap::COL_DESCENDANT_CLASS);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.type');
$criteria->addSelectColumn($alias . '.skill_id');
$criteria->addSelectColumn($alias . '.title');
$criteria->addSelectColumn($alias . '.descendant_class');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(AttributeAvTableMap::ID);
$criteria->addSelectColumn(AttributeAvTableMap::ATTRIBUTE_ID);
$criteria->addSelectColumn(AttributeAvTableMap::POSITION);
$criteria->addSelectColumn(AttributeAvTableMap::CREATED_AT);
$criteria->addSelectColumn(AttributeAvTableMap::UPDATED_AT);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.ATTRIBUTE_ID');
$criteria->addSelectColumn($alias . '.POSITION');
$criteria->addSelectColumn($alias . '.CREATED_AT');
$criteria->addSelectColumn($alias . '.UPDATED_AT');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_ID);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_MIN);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_MAX);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_RANGE);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_MEDIAN);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_AVERAGE);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_VARIANCE);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_STANDARD_DEVIATION);
$criteria->addSelectColumn(PerformanceStatisticTableMap::COL_VARIABILITY_COEFFICIENT);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.min');
$criteria->addSelectColumn($alias . '.max');
$criteria->addSelectColumn($alias . '.range');
$criteria->addSelectColumn($alias . '.median');
$criteria->addSelectColumn($alias . '.average');
$criteria->addSelectColumn($alias . '.variance');
$criteria->addSelectColumn($alias . '.standard_deviation');
$criteria->addSelectColumn($alias . '.variability_coefficient');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(MediafileTableMap::COL_IDMEDIAFILE);
$criteria->addSelectColumn(MediafileTableMap::COL_FILE_LOCATION);
$criteria->addSelectColumn(MediafileTableMap::COL_SIZE);
$criteria->addSelectColumn(MediafileTableMap::COL_TIMESTAMP);
$criteria->addSelectColumn(MediafileTableMap::COL_MIMETYPE);
} else {
$criteria->addSelectColumn($alias . '.idMediaFile');
$criteria->addSelectColumn($alias . '.file_location');
$criteria->addSelectColumn($alias . '.size');
$criteria->addSelectColumn($alias . '.timestamp');
$criteria->addSelectColumn($alias . '.mimetype');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(GameTableMap::COL_ID);
$criteria->addSelectColumn(GameTableMap::COL_MODALITY);
$criteria->addSelectColumn(GameTableMap::COL_RESULT);
$criteria->addSelectColumn(GameTableMap::COL_BET_COST);
$criteria->addSelectColumn(GameTableMap::COL_START);
$criteria->addSelectColumn(GameTableMap::COL_FINISH);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.modality');
$criteria->addSelectColumn($alias . '.result');
$criteria->addSelectColumn($alias . '.bet_cost');
$criteria->addSelectColumn($alias . '.start');
$criteria->addSelectColumn($alias . '.finish');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(TemplateTableMap::ID);
$criteria->addSelectColumn(TemplateTableMap::CREATED_AT);
$criteria->addSelectColumn(TemplateTableMap::UPDATED_AT);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.CREATED_AT');
$criteria->addSelectColumn($alias . '.UPDATED_AT');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ResourceTypeTableMap::COL_RESOURCE_TYPE_ID);
$criteria->addSelectColumn(ResourceTypeTableMap::COL_RESOURCE_TYPE_CODE);
} else {
$criteria->addSelectColumn($alias . '.resource_type_id');
$criteria->addSelectColumn($alias . '.resource_type_code');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ProductSaleElementsProductDocumentTableMap::ID);
$criteria->addSelectColumn(ProductSaleElementsProductDocumentTableMap::PRODUCT_SALE_ELEMENTS_ID);
$criteria->addSelectColumn(ProductSaleElementsProductDocumentTableMap::PRODUCT_DOCUMENT_ID);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.PRODUCT_SALE_ELEMENTS_ID');
$criteria->addSelectColumn($alias . '.PRODUCT_DOCUMENT_ID');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(TransferPaymentConfigTableMap::NAME);
$criteria->addSelectColumn(TransferPaymentConfigTableMap::VALUE);
$criteria->addSelectColumn(TransferPaymentConfigTableMap::PLACEMENT);
} else {
$criteria->addSelectColumn($alias . '.NAME');
$criteria->addSelectColumn($alias . '.VALUE');
$criteria->addSelectColumn($alias . '.PLACEMENT');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(UserDetailTableMap::COL_ID);
$criteria->addSelectColumn(UserDetailTableMap::COL_NAME);
$criteria->addSelectColumn(UserDetailTableMap::COL_ADDRESS);
$criteria->addSelectColumn(UserDetailTableMap::COL_PHONE);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.NAME');
$criteria->addSelectColumn($alias . '.ADDRESS');
$criteria->addSelectColumn($alias . '.PHONE');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ExtensionTableMap::COL_ID);
$criteria->addSelectColumn(ExtensionTableMap::COL_KEY);
$criteria->addSelectColumn(ExtensionTableMap::COL_DATA);
$criteria->addSelectColumn(ExtensionTableMap::COL_PACKAGE_ID);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.key');
$criteria->addSelectColumn($alias . '.data');
$criteria->addSelectColumn($alias . '.package_id');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ApiTableMap::ID);
$criteria->addSelectColumn(ApiTableMap::LABEL);
$criteria->addSelectColumn(ApiTableMap::API_KEY);
$criteria->addSelectColumn(ApiTableMap::PROFILE_ID);
$criteria->addSelectColumn(ApiTableMap::CREATED_AT);
$criteria->addSelectColumn(ApiTableMap::UPDATED_AT);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.LABEL');
$criteria->addSelectColumn($alias . '.API_KEY');
$criteria->addSelectColumn($alias . '.PROFILE_ID');
$criteria->addSelectColumn($alias . '.CREATED_AT');
$criteria->addSelectColumn($alias . '.UPDATED_AT');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(RosterTableMap::COL_CLASSID);
$criteria->addSelectColumn(RosterTableMap::COL_SUBJECT);
$criteria->addSelectColumn(RosterTableMap::COL_CATALOGNUMBER);
$criteria->addSelectColumn(RosterTableMap::COL_SECTION);
$criteria->addSelectColumn(RosterTableMap::COL_INSTRUCTORNETID);
} else {
$criteria->addSelectColumn($alias . '.classID');
$criteria->addSelectColumn($alias . '.subject');
$criteria->addSelectColumn($alias . '.catalogNumber');
$criteria->addSelectColumn($alias . '.section');
$criteria->addSelectColumn($alias . '.instructorNetID');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(VariationTypeI18nTableMap::COL_VARIATION_TYPE_ID);
$criteria->addSelectColumn(VariationTypeI18nTableMap::COL_LOCALE);
$criteria->addSelectColumn(VariationTypeI18nTableMap::COL_VARIATION_TYPE_NAME);
} else {
$criteria->addSelectColumn($alias . '.variation_type_id');
$criteria->addSelectColumn($alias . '.locale');
$criteria->addSelectColumn($alias . '.variation_type_name');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(PublisherTableMap::COL_ID);
$criteria->addSelectColumn(PublisherTableMap::COL_NAME);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.name');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(InseeGeoDepartmentI18nTableMap::ID);
$criteria->addSelectColumn(InseeGeoDepartmentI18nTableMap::LOCALE);
$criteria->addSelectColumn(InseeGeoDepartmentI18nTableMap::NAME);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.LOCALE');
$criteria->addSelectColumn($alias . '.NAME');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(AdministratorTableMap::COL_ID);
$criteria->addSelectColumn(AdministratorTableMap::COL_NAME);
$criteria->addSelectColumn(AdministratorTableMap::COL_USERNAME);
$criteria->addSelectColumn(AdministratorTableMap::COL_PASSWORD);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.name');
$criteria->addSelectColumn($alias . '.username');
$criteria->addSelectColumn($alias . '.password');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ProductDelayTableMap::ID);
$criteria->addSelectColumn(ProductDelayTableMap::PRODUCT_ID);
$criteria->addSelectColumn(ProductDelayTableMap::DELIVERY_DELAY_MIN);
$criteria->addSelectColumn(ProductDelayTableMap::DELIVERY_DELAY_MAX);
$criteria->addSelectColumn(ProductDelayTableMap::RESTOCK_DELAY_MIN);
$criteria->addSelectColumn(ProductDelayTableMap::RESTOCK_DELAY_MAX);
$criteria->addSelectColumn(ProductDelayTableMap::DELIVERY_DATE_START);
$criteria->addSelectColumn(ProductDelayTableMap::DELIVERY_TYPE);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.PRODUCT_ID');
$criteria->addSelectColumn($alias . '.DELIVERY_DELAY_MIN');
$criteria->addSelectColumn($alias . '.DELIVERY_DELAY_MAX');
$criteria->addSelectColumn($alias . '.RESTOCK_DELAY_MIN');
$criteria->addSelectColumn($alias . '.RESTOCK_DELAY_MAX');
$criteria->addSelectColumn($alias . '.DELIVERY_DATE_START');
$criteria->addSelectColumn($alias . '.DELIVERY_TYPE');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(RightsTableMap::COL_ID);
$criteria->addSelectColumn(RightsTableMap::COL__GROUP);
$criteria->addSelectColumn(RightsTableMap::COL___CONFIG__);
$criteria->addSelectColumn(RightsTableMap::COL___SPLIT__);
$criteria->addSelectColumn(RightsTableMap::COL___PARENTNODE__);
$criteria->addSelectColumn(RightsTableMap::COL___SORT__);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '._group');
$criteria->addSelectColumn($alias . '.__config__');
$criteria->addSelectColumn($alias . '.__split__');
$criteria->addSelectColumn($alias . '.__parentnode__');
$criteria->addSelectColumn($alias . '.__sort__');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ArticleTableMap::COL_ID);
$criteria->addSelectColumn(ArticleTableMap::COL_TITLE);
$criteria->addSelectColumn(ArticleTableMap::COL_CONTENT);
$criteria->addSelectColumn(ArticleTableMap::COL_DESCRIPTION);
$criteria->addSelectColumn(ArticleTableMap::COL_UPDATED_AT);
$criteria->addSelectColumn(ArticleTableMap::COL_CREATED_AT);
} else {
$criteria->addSelectColumn($alias . '.id');
$criteria->addSelectColumn($alias . '.title');
$criteria->addSelectColumn($alias . '.content');
$criteria->addSelectColumn($alias . '.description');
$criteria->addSelectColumn($alias . '.updated_at');
$criteria->addSelectColumn($alias . '.created_at');
}
}
/**
* Add all the columns needed to create a new object.
*
* Note: any columns that were marked with lazyLoad="true" in the
* XML schema will not be added to the select list and only loaded
* on demand.
*
* @param Criteria $criteria object containing the columns to add.
* @param string $alias optional table alias
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function addSelectColumns(Criteria $criteria, $alias = null)
{
if (null === $alias) {
$criteria->addSelectColumn(ModuleImageTableMap::ID);
$criteria->addSelectColumn(ModuleImageTableMap::MODULE_ID);
$criteria->addSelectColumn(ModuleImageTableMap::FILE);
$criteria->addSelectColumn(ModuleImageTableMap::VISIBLE);
$criteria->addSelectColumn(ModuleImageTableMap::POSITION);
$criteria->addSelectColumn(ModuleImageTableMap::CREATED_AT);
$criteria->addSelectColumn(ModuleImageTableMap::UPDATED_AT);
} else {
$criteria->addSelectColumn($alias . '.ID');
$criteria->addSelectColumn($alias . '.MODULE_ID');
$criteria->addSelectColumn($alias . '.FILE');
$criteria->addSelectColumn($alias . '.VISIBLE');
$criteria->addSelectColumn($alias . '.POSITION');
$criteria->addSelectColumn($alias . '.CREATED_AT');
$criteria->addSelectColumn($alias . '.UPDATED_AT');
}
}
public function testCommentDoSelect()
{
$c = new Criteria();
$c->setComment('Foo');
$c->addSelectColumn(BookTableMap::COL_ID);
$expected = $this->getSql('SELECT /* Foo */ book.ID FROM `book`');
$params = array();
$this->assertEquals($expected, $c->createSelectSQL($params), 'Criteria::setComment() adds a comment to select queries');
}
