Implement adding a new column

[kgodey]

Problem

Users might want to add a new column to their table. Users would also want to resize the column widths.

Proposed solution

Adding a column

The "Working with Columns" design spec has a solution for adding a new column, which we need to implement on the frontend.

Additional context

• Backend work: Create a Column API #199
• Design issue: Design for editing column properties and table constraints #324
• Design discussion: Working with Columns #436

[pegnott]

Hello! I can help with this.

[kgodey]

Thanks @pegnott! Assigned to you.

[pegnott]

I will be getting started on this tonight or tomorrow and will comment with status updates as they are pertinent. Thanks!

[kgodey]

Sounds good, @pegnott! Please let us know if you have questions along the way.

[pegnott]

Here's what's done so far and where you can check it out:

• ui/src/stores/TableData.ts: added addColumn function
• ui/src/sections/table-view/TableView.svelte: added columnAdd func
• ui/src/sections/table-view/Header.svelte: add UI for basic column creation

My forked branch:
https://github.com/pegnott/mathesar/tree/add_column

Still to do:

• open/close state on add_column dropdown
• add UI for other column values (currently hardcoding type to varchar)
• adjustments to UI for table name restrictions
• style tweaks as needed once all functionality / ui elements are all in place

[kgodey]

Thanks @pegnott! Feel free to open a draft pull request whenever you'd like feedback.

[pegnott]

Am in the final stretch, switching the initial resize implementation to an action. Will have that ready for review later today.

[pegnott]

I have moved the resizable functionality (and because it can do all sorts of moveable things, renamed it to moveable) into common/actions following the popper example.

The pull request asks also for a tableCell component, and that is the next step. Today (through 08/22) I am interrupted by travel, and today I'll be mostly driving. I will be able to work, but be a little slower in response times. I anticipate that I can have a tablecolumn component done by Monday evening. If it's preferred before then, let me know and we can discuss the options.

[kgodey]

@pegnott Thanks for the update! Monday evening is fine.