Create a method to add a new event

[brendanator]

The method should

• accept an input T which contains fields that match the names and values of columns in our table, and a database connection
• write those values to the table
• not return any value
• throw exceptions

The method should live in a new Publisher class

[brendanator]

@sourcery-ai plan

[sourcery-ai-dev[bot]]

Objectives

• Create a new Publisher class to handle database event publishing
• Design a generic method that accepts a type parameter T and database connection for inserting events
• Implement reflection or mapping logic to match object fields to database column names
• Add validation to ensure the input object's fields match the table schema
• Implement SQL statement generation for inserting values into the postevent.<topic> table
• Add proper exception handling and propagation for database operations
• Ensure thread safety for database operations
• Add appropriate logging for operation tracking and debugging

Setup commands

File changes

src/main/java/com/p14n/postevent/Publisher.java

• Create new Publisher class with generic type parameter T
• Add constructor that takes jdbcUrl, username, and password parameters
• Add publish method that accepts a topic string and generic type T object
• Add field mapping logic to extract values from object fields using reflection
• Add SQL generation for INSERT statements based on object fields
• Add proper exception handling and logging using java.util.logging.Logger
• Add connection management using try-with-resources

src/test/java/com/p14n/postevent/PublisherTest.java

• Create test class using embedded Postgres for integration testing
• Add test setup with EmbeddedPostgres and DatabaseSetup
• Add test for successful event publishing with verification
• Add test for handling invalid topic names
• Add test for handling null or invalid input objects
• Add test for handling database connection failures
• Add test for handling field mapping errors

Verify commands

• ./gradlew test - ❌

---

This plan was automatically generated. Please review the plan carefully and make any necessary adjustments.