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; }