fix(sqllab): SqlEditorLeftBar listening to database changes

[Antonio-RiveroMartnez]

SUMMARY

We stopped listening to database prop changes at some point to only take into account the initial component render. That however, caused the component to always work with the initial database passed as prop and never take into account new user selections. Which you might evidence for example with empty table dropdown after changing DB.

We're bringing that feature back with this fix. Also we're using the right props in our tests and adding a new one to consider the re-renders with new database.

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

Before:

After:

TESTING INSTRUCTIONS

Go to sql lab and do a query on your default data base
In the same query tab, switch databases
Select your table
Try to select a table

ADDITIONAL INFORMATION

• Has associated issue:
• Required feature flags:
• Changes UI
• Includes DB Migration (follow approval process in SIP-59)
  • Migration is atomic, supports rollback & is backwards-compatible
  • Confirm DB migration upgrade and downgrade tested
  • Runtime estimates and downtime expectations provided
• Introduces new feature or API
• Removes existing feature or API

[sadpandajoe]

🏷️ preset:2022.39