public override string ToSql (Operator op)
{
if (String.IsNullOrEmpty (value)) {
return null;
}
string escaped_value = EscapeString (op, Uri.EscapeUriString (value.ToLower ()));
if (op == StartsWith) {
return "file://" + escaped_value;
}
return escaped_value;
}
private void HandleOperatorChanged (object o, EventArgs args)
{
if (op_chooser.Active < 0 || op_chooser.Active >= operators.Count) {
return;
}
this.op = operators [op_chooser.Active];
if (operator_entries [this.op] != current_value_entry) {
SetValueEntry (operator_entries [this.op]);
}
//value_entry = new QueryValueEntry <field.ValueType> ();
}
public override string ToSql (Operator op)
{
return Convert.ToString (value, System.Globalization.CultureInfo.InvariantCulture);
}
public override string ToSql (Operator op)
{
return String.IsNullOrEmpty (value) ? null : EscapeString (op, StringValue);
}
public override string ToSql (Operator op)
{
return null;
}
public abstract string ToSql(Operator op);
public override string ToSql (Operator op)
{
return DateTimeUtil.FromDateTime (DateTime.Now + TimeSpan.FromSeconds ((double) offset)).ToString (System.Globalization.CultureInfo.InvariantCulture);
}
public override string ToSql (Operator op)
{
if (op == GreaterThan) {
return DateTimeUtil.FromDateTime (value.AddDays (1.0)).ToString (System.Globalization.CultureInfo.InvariantCulture);
} else {
return DateTimeUtil.FromDateTime (value).ToString (System.Globalization.CultureInfo.InvariantCulture);
}
}
public string ToSql (Operator op, QueryValue qv)
{
string value = qv.ToSql (op) ?? String.Empty;
if (op == null) op = qv.OperatorSet.First;
StringBuilder sb = new StringBuilder ();
if (no_custom_format) {
string column_with_key = Column;
if (qv is StringQueryValue && !(column_lowered || qv is ExactStringQueryValue)) {
column_with_key = String.Format ("HYENA_SEARCH_KEY({0})", Column);
}
sb.AppendFormat ("{0} {1}", column_with_key, String.Format (op.SqlFormat, value));
if (op.IsNot) {
return String.Format ("({0} IS NULL OR {1})", Column, sb.ToString ());
} else {
return String.Format ("({0} IS NOT NULL AND {1})", Column, sb.ToString ());
}
} else {
sb.AppendFormat (
Column, String.Format (op.SqlFormat, value),
value, op.IsNot ? "NOT" : null
);
}
return sb.ToString ();
}
public override string ToSql(Operator op)
{
return(DateTimeUtil.FromDateTime(DateTime.Now + TimeSpan.FromSeconds((double)offset)).ToString(System.Globalization.CultureInfo.InvariantCulture));
}
protected static string EscapeString (Operator op, string orig)
{
orig = orig.Replace ("'", "''");
if (op == Contains || op == DoesNotContain ||
op == StartsWith || op == EndsWith) {
return orig.Replace ("\\", "\\\\")
.Replace ("%", "\\%")
.Replace ("_", "\\_");
}
return orig;
}
public override string ToSql (Operator op)
{
return String.IsNullOrEmpty (value) ? null : EscapeString (op, Hyena.StringUtil.SearchKey (value));
}
protected static string EscapeString (Operator op, string orig)
{
orig = orig.Replace ("'", "''");
if (op == Contains || op == DoesNotContain ||
op == StartsWith || op == EndsWith) {
return StringUtil.EscapeLike (orig);
}
return orig;
}