Database Column Service Test Interface

This interface tests the DatabaseColumnService which orchestrates the domain actions for database column operations using ColumnDefinition DTOs.

Note: This test interface uses the DatabaseColumnService which coordinates:
• CreateDatabaseColumn action (using ColumnDefinition DTO)
• UpdateDatabaseColumn action (using ColumnDefinition DTO)
• DeleteDatabaseColumn action (using column name)
• ListDatabaseColumns action
Make sure you have RecordTypes created for the tables you want to test with.

Database Connection & Service Info

Sample Service Test

Test the DatabaseColumnService with a sample column creation using ColumnDefinition DTO and the first available RecordType.

Create Database Column

Creates a ColumnDefinition DTO and uses the DatabaseColumnService.createColumn() method.

Table Name (RecordType):

Must match an existing RecordType's recordType field

Column Name:

Will be validated using ColumnNameRule

Column Type:

Nullable:

Default Value:

Update Database Column

Updates an existing column using ColumnDefinition DTO and the DatabaseColumnService.updateColumn() method.

Table Name (RecordType):

Old Column Name:

Must match an existing column name in the table

New Column Name:

New Column Type:

Nullable:

Default Value:

Delete Database Column

Uses the DatabaseColumnService.deleteColumn() method to remove a column from the table.

List Table Columns

Lists all columns in a table using the DatabaseColumnService.listColumns() method.