/** * Retourne la requete SQL à partir d'un crière sur un champs * Attention, ne gère que les tables 'mono-clef' * @param type $paramTableName * @param type $paramFieldName * @param type $paramFieldValue * @return type */ public static function getSqlQueryFromOneField($paramTableName, $paramFieldName, $paramFieldValue) { return 'SELECT ' . $paramTableName . '.* FROM ' . self::convertTableNameToSqlClause($paramTableName) . ' WHERE (' . DatabaseOperation::convertArrayToSqlClauseWhere($paramTableName, array($paramFieldName => $paramFieldValue)) . ')'; }
protected function getKeyToSqlStatement() { return DatabaseOperation::convertArrayToSqlClauseWhere(self::TABLE_FTA_NAME, array(self::ID_FTA_NAME => $this->id_fta_value)); }