public NpgQuery DeleteWhere(string table, IWhereOp whereOp) { var parameters = new List<NpgsqlParameter>(); var text = string.Format("DELETE FROM {0} WHERE {1}", Quote(table), whereOp.Build(parameters)); return new NpgQuery(text, parameters.ToArray()); }
public NpgQuery DeleteWhere(string table, IWhereOp whereOp) { var parameters = new List <NpgsqlParameter>(); var text = string.Format("DELETE FROM {0} WHERE {1}", Quote(table), whereOp.Build(parameters)); return(new NpgQuery(text, parameters.ToArray())); }
public NpgQuery UpdateWhere(string table, IWhereOp whereOp, string[] columns, object[] values) { var setParameters = new NpgsqlParameter[columns.Length]; var set = new string[columns.Length]; for (var i = 0; i < set.Length; i++) { var column = columns[i]; var parameterName = SetParameterNamePrefix + column; set[i] = Quote(column) + " = :" + parameterName; setParameters[i] = new NpgsqlParameter(parameterName, values[i]); } var parameters = new List <NpgsqlParameter>(); var scriptRow = string.Format( "UPDATE {0} SET {1} WHERE {2}", Quote(table), string.Join(", ", set), whereOp.Build(parameters)); parameters.AddRange(setParameters); return(new NpgQuery(scriptRow, parameters.ToArray())); }
public string Select( IList <NpgsqlParameter> parameters, string table, string[] columnsToReturn, IWhereOp whereOp, string[] columnsOfOrder, bool asc, int limit, bool distinct) { var text = new StringBuilder(); text.Append("SELECT "); if (distinct) { text.Append("DISTINCT "); } text.AppendFormat( "{0} FROM {1}", string.Join(", ", columnsToReturn.Select(Quote)), Quote(table)); if (whereOp != null) { text.AppendFormat(" WHERE {0}", whereOp.Build(parameters)); } if (columnsOfOrder != null) { string sortDirection = asc ? " ASC" : " DESC"; text.AppendFormat( " ORDER BY {0}", string.Join(", ", columnsOfOrder.Select(c => Quote(c) + sortDirection))); } if (limit != -1) { text.AppendFormat(" LIMIT {0}", limit); } return(text.ToString()); }
public string Select( IList<NpgsqlParameter> parameters, string table, string[] columnsToReturn, IWhereOp whereOp, string[] columnsOfOrder, bool asc, int limit, bool distinct) { var text = new StringBuilder(); text.Append("SELECT "); if (distinct) { text.Append("DISTINCT "); } text.AppendFormat( "{0} FROM {1}", string.Join(", ", columnsToReturn.Select(Quote)), Quote(table)); if (whereOp != null) { text.AppendFormat(" WHERE {0}", whereOp.Build(parameters)); } if (columnsOfOrder != null) { var sortDirection = asc ? " ASC" : " DESC"; text.AppendFormat( " ORDER BY {0}", string.Join(", ", columnsOfOrder.Select(c => Quote(c) + sortDirection))); } if (limit != -1) { text.AppendFormat(" LIMIT {0}", limit); } return text.ToString(); }
public NpgQuery UpdateWhere(string table, IWhereOp whereOp, string[] columns, object[] values) { var setParameters = new NpgsqlParameter[columns.Length]; var set = new string[columns.Length]; for (var i = 0; i < set.Length; i++) { var column = columns[i]; var parameterName = SetParameterNamePrefix + column; set[i] = Quote(column) + " = :" + parameterName; setParameters[i] = new NpgsqlParameter(parameterName, values[i]); } var parameters = new List<NpgsqlParameter>(); var scriptRow = string.Format( "UPDATE {0} SET {1} WHERE {2}", Quote(table), string.Join(", ", set), whereOp.Build(parameters)); parameters.AddRange(setParameters); return new NpgQuery(scriptRow, parameters.ToArray()); }
public override string Build(IList <NpgsqlParameter> parameters) { return(string.Format("not ({0})", _op.Build(parameters))); }