Track create-table and drop-table events with Datasette 1.0a8

[simonw]

Refs:

• 50

TODO:

• [x] Run tests on both Datasette versions
• [x] Track create table
• [x] Track drop table
• [x] Tests for all the above that only run on Datasette 1.0a8

[simonw]

I'm going to fire the alter-table event only if the table schema has changed. I won't fire it for create index / drop index.

[simonw]

Should I fire that event for rename table?

Probably yes. The catch is that I need to decide which table I'm going to use as the table attribute - should that be the previous name or the new name?

The before_schema and after_schema things will capture those details.

I'm going to track the new table name as the table in the rename, since that makes it easier to start with that table and figure out its history.

[simonw]

Problem! AlterTableEvent isn't in a release yet - I implemented that after I shipped 1.0a8.

[simonw]

I'll do alter event in a separate issue.