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'); }