Connect to Database and Fetch Metadata APIs

[shreyashshetty18]

Description

Implement API endpoints for connecting to the database via chat_id and fetching metadata such as tables and columns, plus data records.

Tasks

• Implement API to connect to the database using chat_id.
• Implement API to fetch all tables in the connected database.
• Implement API to fetch records of each table.
• API endpoints:
  • connect/str:chat_id/ → ConnectDatabaseAPIView
  • fetch-tables/str:chat_id/ → ShowTablesAPIView
  • fetch-table-records/str:chat_id/ → FetchTablesDataAPIView

Acceptance Criteria

• APIs successfully connect and interact with the database using chat_id.
• APIs reliably return tables and table records.
• Proper error handling for connection failures or no data available.