Frontend implementation of Date & Time Mathesar types

[kgodey]

Requirements

Users should be able to:

• view data in columns that have the Date & Time Mathesar typeww
• change data type to and from the associated DB types based on options selected
  • DATE
  • TIME WITH TIME ZONE
  • TIME WITHOUT TIME ZONE
  • TIMESTAMP WITH TIME ZONE
  • TIMESTAMP WITHOUT TIME ZONE
• view, set, and change data type options related to the Date & Time data types
• filter data by Date & Time-specific filtering options
• group data by Date & Time-specific grouping options
• use display options to view data in Date & Time type columns
  • Decide on date/time formatting string syntax #1108
• use a date and time picker while entering new data into columns or filters

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

• The Date UI type maps to the DATE DB type.
• The Time UI type maps to the TIME WITHOUT TIME ZONE DB type by default. "Support Time Zones" should be FALSE.
  • This applies to new columns and converting existing columns to Time
  • Turning on "Support Time Zones" should convert the type to TIME WITH TIME ZONE
  • If the DB type happens to be TIME WITH TIME ZONE, "Support Time Zones" should be checked and turning it off should convert it to TIME WITHOUT TIME ZONE.
• The same logic applies to Date & Time, except that the default is TIMESTAMP WITH TIME ZONE.

Implementation

Design

• The Global Data Types spec has the latest version of the UX for everything except column menus
• The Date and Time Data Type spec has the latest version of the UX for column menus

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.
• 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)
  • Changes to the display options (display_options)

Additional Context

• Design for date & time data types #240 (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:
  • Handle TIMESTAMP data type in the backend #424
  • Handle DATE data type in the backend #425
  • Handle TIME data type in the backend #426
  • Implement display options for date & time types #428
  • Split Date & Time data type into three Mathesar types  #960

[kgodey]

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

Actually, this is still blocked by #960

[kgodey]

Backend work is merged, so removing blocked label.