/**
* Prepares value for insertion into SQL
* @param string $value
* @param SugarQuery_Builder_Condition $condition
* @return string
*/
protected function prepareValue($value, SugarQuery_Builder_Condition $condition)
{
if ($this->sugar_query->usePreparedStatements && !empty($condition->field->def) && !$value instanceof SugarQuery_Builder_Literal) {
$type = $this->db->getFieldType($condition->field->def);
$this->sugar_query->addData($condition->field->quoteValue($value, $condition->operator, true));
return "?{$type}";
} else {
return $condition->field->quoteValue($value, $condition->operator);
}
}
/**
* Compile this SugarQuery into a standard SQL-92 Query string
* @return string
*/
public function compileSql(SugarQuery $parent = null)
{
$compiler = new SugarQuery_Compiler();
$this->data = $this->dataItems = array();
$sql = $compiler->compile($this, $this->db);
if ($parent) {
$parent->addData($this->data);
}
return $sql;
}
