Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-4491

Add is_primary column to tally_snapshots Table and update JPA Entity

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • swatch-tally
    • None
    • 5
    • False
    • Hide

      None

      Show
      None
    • False
    • subs-swatch-thunder
    • Swatch Thunder Sprint 8

      • Add a new is_primary column to the tally_snapshots database table using liquibase.
      • Set the default value of is_primary to false.
      • Include a rollback script to remove the column if needed.
      • Update the corresponding Java entity to map the new column.
      • Ensure JPA entity changes prevent compile-time and runtime exceptions.
      • Make sure the models used by other components are updated.

      Example:

         <changeSet id="" author="">
          <addColumn tableName="tally_snapshots">
            <column name="is_primary" type="boolean" defaultValueBoolean="false">
              <constraints nullable="false"/>
            </column>
          </addColumn>
          <rollback>
            <dropColumn tableName="tally_snapshots" columnName="is_primary"/>
          </rollback>
        </changeSet>

       

      Acceptance Criteria

      • is_primary column exists in tally_snapshots with default value false.
      • Database migration includes a valid rollback for the column addition.
      • Java/JPA entity is updated to include is_primary mapping.
      • Application builds successfully with no compile-time errors.
      • No runtime exceptions related to the new column during read/write operations in all related components.

              rhn-engineering-wpoteat William Poteat
              karshah@redhat.com Kartik Shah
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: