public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select d.id, d.data from public.mt_doc_user as d where d.data ->> 'UserName' = ? LIMIT ?");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[0].Value = _query.UserName;
_hardcoded.Apply(parameters);
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select TRUE as result from public.mt_doc_target as d where d.id = ? LIMIT ?");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Uuid;
parameters[0].Value = _query.IdValue;
_hardcoded.Apply(parameters);
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select TRUE as result from public.mt_doc_user as d where CAST(d.data ->> 'Age' as integer) = ? LIMIT ?");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[0].Value = _query.Age;
_hardcoded.Apply(parameters);
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select d.id, d.data, count(1) OVER() as total_rows from public.mt_doc_target as d where CAST(d.data ->> 'Number' as integer) > ? OFFSET ? LIMIT ?");
parameters[1].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[1].Value = _query.PageNumber;
parameters[2].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[2].Value = _query.PageSize;
_hardcoded.Apply(parameters);
}
