public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select count(*) as number from public.mt_doc_user as d where d.data ->> 'FirstName' = ?");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[0].Value = _query.FirstName;
}
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_streaming_json_results_customer as d where d.data ->> 'LastName' LIKE ? order by d.data ->> 'LastName'");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[0].Value = EndsWith(_query.LastNamePrefix);
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select d.data from public.mt_doc_user as d where d.data ->> 'UserName' LIKE ?");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[0].Value = ContainsString(_query.Contains);
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var npgsqlParameterArray = builder.AppendWithParameters(SQL);
npgsqlParameterArray[0].Value = _streamId;
npgsqlParameterArray[0].DbType = System.Data.DbType.Guid;
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"select d.data from public.mt_doc_target as d where CAST(d.data -> 'Inner' ->> 'Number' as integer) = ?");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[0].Value = _query.Number;
}
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(@"drop table if exists mt_temp_id_list1;
create temp table mt_temp_id_list1 as (
select id, CAST(d.data ->> 'AssigneeId' as uuid) as id1 from public.mt_doc_issue as d
); select d.data from public.mt_doc_user as d where id in (select id1 from mt_temp_id_list1);
select d.data from public.mt_doc_issue as d where id in (select id from mt_temp_id_list1)");
}
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 order by d.id OFFSET ? LIMIT ?");
parameters[1].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[1].Value = _query.PageSize;
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[0].Value = _query.Start;
}
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);
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(SQL);
parameters[0].Value = Stream.Version;
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Bigint;
parameters[1].Value = Stream.Id;
parameters[1].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Uuid;
parameters[2].Value = Stream.ExpectedVersionOnServer;
parameters[2].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Bigint;
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(@"WITH mt_temp_id_list1CTE as (
select ctid, unnest(CAST(ARRAY(SELECT jsonb_array_elements_text(CAST(d.data ->> 'NumberArray' as jsonb))) as integer[])) as data from public.mt_doc_target as d WHERE (d.data ->> 'Flag' is not null and CAST(d.data ->> 'Flag' as boolean) = True)
)
, mt_temp_id_list2CTE as (
select ctid from mt_temp_id_list1CTE where data = ?
)
select d.data from public.mt_doc_target as d where ctid in (select ctid from mt_temp_id_list2CTE)");
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[0].Value = _query.Number;
}
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_simpleequalsparsertests_querytarget as d where (CAST(d.data ->> 'IntProp' as integer) = ? and d.id = ?) LIMIT ?");
parameters[1].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Uuid;
parameters[1].Value = _query.IdProp;
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[0].Value = _query.IntProp;
parameters[2].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Integer;
parameters[2].Value = _query.IntProp;
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(SQL);
parameters[0].Value = Stream.Id;
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Uuid;
parameters[1].Value = Stream.AggregateTypeName != null ? (object)Stream.AggregateTypeName : System.DBNull.Value;
parameters[1].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[2].Value = Stream.Version;
parameters[2].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Bigint;
parameters[3].Value = Stream.TenantId != null ? (object)Stream.TenantId : System.DBNull.Value;
parameters[3].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
}
public override void ConfigureCommand(Weasel.Postgresql.CommandBuilder builder, Marten.Internal.IMartenSession session)
{
var parameters = builder.AppendWithParameters(SQL);
parameters[0].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Jsonb;
parameters[0].Value = session.Serializer.ToJson(Event.Data);
parameters[1].Value = Event.EventTypeName != null ? (object)Event.EventTypeName : System.DBNull.Value;
parameters[1].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[2].Value = Event.DotNetTypeName != null ? (object)Event.DotNetTypeName : System.DBNull.Value;
parameters[2].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
parameters[3].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Bigint;
parameters[3].Value = Event.Sequence;
parameters[4].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Uuid;
parameters[4].Value = Event.Id;
parameters[5].Value = Stream.Id;
parameters[5].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Uuid;
parameters[6].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Bigint;
parameters[6].Value = Event.Version;
parameters[7].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.TimestampTz;
parameters[7].Value = Event.Timestamp;
parameters[8].Value = Event.TenantId != null ? (object)Event.TenantId : System.DBNull.Value;
parameters[8].NpgsqlDbType = NpgsqlTypes.NpgsqlDbType.Text;
}
