DIO (Do It Once)

DIO is a Visual Studio Code extension scaffold for data-driven automation.

Current capability

• Upload a single .xlsx file using the command:
  • DIO: Upload XLSX
• Stores the last accepted file path in extension workspace state.
• Prompts for one or more project types to generate (currently sqlproj, API sln).
• Prompts for one of the user-available Copilot language models.
• Uses the selected model to parse the workbook into a normalized domain spec.
• Uses deterministic code generation in the extension to scaffold API solutions from the normalized domain spec.
• Uses deterministic code generation in the extension to scaffold SQL projects from the normalized domain spec.
• For sqlproj, creates a project folder named <xlsx_name>_DB in the workspace, writes <xlsx_name>_DB.sqlproj, and writes one SQL file per table under Tables/ with generated keys and relationships included.
• For API sln, creates a solution folder named <xlsx_name>.API in the workspace and writes a Clean Architecture .NET Web API solution where project names follow <solution>.<project> (for example Sales.API.Presentation).
• API solution target framework is configurable via setting dio.apiTargetFramework (default: net10.0).

Future capability (not implemented yet)

• Generate files from uploaded spreadsheet data.

Development

1. Install dependencies:
   • npm install
2. Build:
   • npm run compile
3. Run extension host:
   • Press F5 in VS Code (Run Extension)

Notes

Generated artifacts are intended as an editable scaffold and should be reviewed before use.