/**
  * 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)) . ')';
 }
Example #2
0
 protected function getKeyToSqlStatement()
 {
     return DatabaseOperation::convertArrayToSqlClauseWhere(self::TABLE_FTA_NAME, array(self::ID_FTA_NAME => $this->id_fta_value));
 }