Merge branch 'main' into reconnections-2

Send diagnostic summaries synchronously

Return project collaborators and connection IDs in a `RoomGuard`

Update sea-orm to fix bug on failure to commit transactions

Remove project_id foreign key from `room_participants`

Upgrade sea-orm

Remove random pauses to prevent the database from deadlocking

Retry transactions if there's a serialization failure during commit

Remove duplication between `transaction` and `room_transaction`

WIP: Manually rollback transactions to avoid spurious savepoint failure

Remove stale `Error` variant

Merge branch 'main' into reconnections-2

Delete empty rooms

Clear stale data on startup

Move modules into `collab` library as opposed to using the binary

Make all tests pass again after migration to sea-orm

Use i32 to represent Postgres `INTEGER` types in Rust

Finish porting remaining db methods to sea-orm

WIP

Replace i32 with u32 for database columns

Implement `Database::update_project`

Implement `Database::unshare_project`

Implement `Database::project_guest_connection_ids`

Avoid using `col_expr` whenever possible

Get basic calls working again with sea-orm

Implement `Database::create_room`

Go back to a compiling state, panicking on unimplemented db methods

Start using the new sea-orm backed database

Implement signups using sea-orm

Implement invite codes using sea-orm

Implement `db2::Database::fuzzy_search_users`

Implement `db2::Database::remove_contact`

Implement contacts using sea-orm

Implement `db2::Database::get_user_metrics_id`

Implement access tokens using sea-orm

Implement `db2::Database::get_user_by_github_account`

Make some db tests pass against the new sea-orm implementation

WIP: move to a non-generic test database struct

Start on a new `db2` module that uses SeaORM

Start moving towards using sea-query to construct queries

Increase probability of creating new files in randomized test

Capture runnable backtraces only when detecting nondeterminism

Error if project is disconnected after getting completions response

Introduce a new `detect_nondeterminism = true` attribute to `gpui::test`

Remove non-determinism caused by random entropy when reconnecting

:lipstick:

Return error when waiting on a worktree snapshot after disconnecting

Introduce per-room lock acquired before committing a transaction

Error if project is disconnected after getting code actions response

After completing LSP request, return an error if guest is disconnected

Fix integration test incorrectly assuming a certain ordering

Check the correct serialization failure code when retrying transaction

Remove version from `Room`

Don't take an `Arc<Server>` in message handlers

Rename `Store` to `ConnectionPool`

Remove obsolete code from `Store`

WIP: Introduce a `db` field to `Session`

Introduce a new `Session` struct to server message handlers

Revert "Don't replace newer diagnostics with older ones"

Revert "Wait for previous `UpdateFollowers` message ack before sending new ones"

Use int8 for `scan_id` and `inode` in Postgres

:art:

Fix seed script

Fix errors in Postgres schema

Wait for previous `UpdateFollowers` message ack before sending new ones

Remove unwrap from `Server::share_project`

Don't replace newer diagnostics with older ones

Use `Db::get_guest_connection_ids` in other db methods

Fix column name in query

Move unshare_project to db module

Move leave_project from Store to db module

Fix typo in query

WIP: Allow subscribing to remote entity before creating a model

Batch some of the new queries in `Db`

Wait for acknowledgment before sending the next diagnostic summary

Move `Store::start_language_server` to `Db`

Move `Store::update_diagnostic_summary` to `Db`

Send worktree updates after project metadata has been sent

Improve queries for composite primary keys

Cascade deletes when project is deleted

Correctly leave projects when leaving room

Update worktree entry instead of erroring when it already exists

Fix syntax error in schema

Always use the database to retrieve collaborators for a project

Move `Store::update_worktree` to `Db::update_worktree`

Always use strings to represent paths over the wire

Move `Store::join_project` to `Db::join_project`

Start reworking `join_project` to use the database

Determine whether a contact is busy via the database

Finish implementing `Db::update_project`

Add random delay after returning results from the database

Switch to serializable isolation

Skip applying room updates if they're older than the local room state

Wait for acknowledgment before sending the next project update

Automatically decline call when user drops their last connection

Implement `Db::cancel_call`

Fix query errors in `Db::share_project`

Leave room when connection is dropped

WIP

Remove stray log statement