Frontend implementation for URI Mathesar type

[kgodey]

Requirements

Users should be able to:

• view data in columns that have the Mathesar URI custom type
• see validation errors if the data they enter is not a valid URI
• change data type to and from the URI DB type
• view, set, and change data type options related to URI data type
• group data by URI-specific grouping options
• filter data by URI-specific filtering options

Update:

• Grouping will be handled in Frontend implementation for type specific grouping options #1073
• Filtering will be handled in Frontend implementation for type specific filtering options #1072

DB Type Mapping

All columns of this type map to MATHESAR_TYPES.URI. Please note that we should make sure it's available before showing it as an available type.

Implementation

Design

• The Global Data Types spec has the latest version of the UX.
• The URL Data Types spec has an older version of the UX but more information on user scenarios.

Backend

• /api/v0/tables/ lists the name and DB type of each columns
• /api/v0/tables/<id/columns/ lists column information in more detail
• /api/v0/databases/<id>/types/ maps Mathesar types to DB types and provides a list of filtering and grouping options per-type.
  • These should be used to populate the filter and grouping options dynamically.
  • This should also be used to determine the availability of the URI type on a given database. It is a custom type so it's not available on all databases.
• Updates to column types and type options should happen via PATCH requests to /api/v0/tables/<id>/columns/<id>/. These updates include
  • Changes to the data type (type)

Additional Context

• Design for URI data type #236 (design)
• Mapping DB data types to Mathesar data types #269 (concept of Mathesar types)
• Implement showing and changing a column's type #498 (conversation about data types)
• Blocked by backend work:
  • Create URI custom type and handle it in the backend. #412

[kgodey]

Marking this as ready since filtering and grouping have been moved to other issues and remaining backend work is done.

[seancolsen]

I'm closing in favor of the following more specific tickets which should address all the remaining work needed here.

• Make URI cells clickable #1322
• 500s when patching column to a different type #1276
• Frontend implementation for type specific grouping options #1073
• Frontend implementation for type specific filtering options #1072