C# (CSharp) SynchronizedStorageSession.PostgreSqlSession Exemples

Exemple #1

        public async Task <TSagaData> Get <TSagaData>(Guid sagaId, SynchronizedStorageSession session, ContextBag context) where TSagaData : IContainSagaData
        {
            var sql = @"
SELECT 
    data
FROM 
    sagas
WHERE 
    id = @Id
            ";

            var storageSession = session.PostgreSqlSession();

            using (var command = new NpgsqlCommand(sql, storageSession.Connection, storageSession.Transaction))
            {
                command.Parameters.AddWithValue("Id", sagaId);

                using (var reader = await command.ExecuteReaderAsync(CommandBehavior.SingleRow))
                {
                    if (!await reader.ReadAsync())
                    {
                        return(default(TSagaData));
                    }

                    var json = reader.GetString(0);

                    TSagaData sagaData = JsonConvert.DeserializeObject <TSagaData>(json);
                    return(sagaData);
                }
            }
        }

Exemple #2

        public async Task Save(IContainSagaData sagaData, SagaCorrelationProperty correlationProperty, SynchronizedStorageSession session,
                               ContextBag context)
        {
            string sql            = @"
INSERT INTO sagas (
    id, 
    originator, 
    originalmessageid, 
    data
) 
VALUES (
    @Id, 
    @Originator, 
    @OriginalMessageId, 
    @Data
)
";
            var    storageSession = session.PostgreSqlSession();

            using (var command = new NpgsqlCommand(sql, storageSession.Connection, storageSession.Transaction))
            {
                command.Parameters.AddWithValue("Id", sagaData.Id);
                command.Parameters.AddWithValue("Originator", sagaData.Originator);
                command.Parameters.AddWithValue("OriginalMessageId", sagaData.OriginalMessageId);

                var json = JsonConvert.SerializeObject(sagaData);
                command.Parameters.AddWithValue("Data", NpgsqlDbType.Jsonb, json);

                await command.ExecuteNonQueryAsync();
            }
        }

Exemple #3

        public async Task <TSagaData> Get <TSagaData>(string propertyName, object propertyValue, SynchronizedStorageSession session, ContextBag context) where TSagaData : IContainSagaData
        {
            //TODO: INDEX
            string select = "SELECT id, originator, originalmessageid, data FROM sagas WHERE data ->> @propertyName = @propertyValue";

            var storageSession = session.PostgreSqlSession();

            using (var command = new NpgsqlCommand(select, storageSession.Connection, storageSession.Transaction))
            {
                command.Parameters.AddWithValue("propertyName", propertyName);
                command.Parameters.AddWithValue("propertyValue", propertyValue);

                using (var reader = await command.ExecuteReaderAsync(CommandBehavior.SingleRow))
                {
                    if (!await reader.ReadAsync())
                    {
                        return(default(TSagaData));
                    }

                    var json = reader.GetString(3);

                    TSagaData sagaData = JsonConvert.DeserializeObject <TSagaData>(json);
                    return(sagaData);
                }
            }
        }

Exemple #4

        public async Task Complete(IContainSagaData sagaData, SynchronizedStorageSession session, ContextBag context)
        {
            string sql            = @"
DELETE FROM 
    sagas
WHERE
    id = @Id
";
            var    storageSession = session.PostgreSqlSession();

            using (var command = new NpgsqlCommand(sql, storageSession.Connection, storageSession.Transaction))
            {
                command.Parameters.AddWithValue("Id", sagaData.Id);

                await command.ExecuteNonQueryAsync();
            }
        }

Exemple #5

        //Todo: Move to another feature. Will keep it here for now
        public static void Initialize(SynchronizedStorageSession session)
        {
            var storageSession = session.PostgreSqlSession();

            //Todo: Extend the SQL
            string createTableSql = @"CREATE TABLE  IF NOT EXISTS sagas (
	id UUID,
    originator TEXT,
	originalmessageid TEXT,
	data JSONB,
	PRIMARY KEY(id)
)";

            using (var command = new NpgsqlCommand(createTableSql, storageSession.Connection, storageSession.Transaction))
            {
                command.ExecuteNonQuery();
            }
        }

Exemple #6

        public async Task Update(IContainSagaData sagaData, SynchronizedStorageSession session, ContextBag context)
        {
            string sql            = @"
UPDATE sagas SET
    originator = @Originator, 
    originalmessageid = @OriginalMessageId, 
    data = @Data
WHERE
    id = @Id
";
            var    storageSession = session.PostgreSqlSession();

            using (var command = new NpgsqlCommand(sql, storageSession.Connection, storageSession.Transaction))
            {
                command.Parameters.AddWithValue("Id", sagaData.Id);
                command.Parameters.AddWithValue("Originator", sagaData.Originator);
                command.Parameters.AddWithValue("OriginalMessageId", sagaData.OriginalMessageId);

                var json = JsonConvert.SerializeObject(sagaData);
                command.Parameters.AddWithValue("Data", NpgsqlDbType.Jsonb, json);

                await command.ExecuteNonQueryAsync();
            }
        }