CRUD Generator Extension for VS Code

This VS Code extension allows you to generate CRUD (Create, Read, Update, Delete) operations for SQL tables directly from your SQL scripts.

Features

• Generate CRUD Operations: Quickly generate CRUD operations for your SQL tables based on a specific syntax.
• Dynamic CRUD Generation: Automatically generates package specifications and bodies in PL/SQL for Oracle databases.

Requirements

• Visual Studio Code
• Oracle SQL Developer or similar SQL database tool (for database connection)

Installation

1. Install the extension from the VS Code Marketplace or by downloading the .vsix file.
2. Open VS Code.
3. Navigate to Extensions (Ctrl+Shift+X or Cmd+Shift+X on macOS).
4. Click on the ... menu and choose Install from VSIX....
5. Select the downloaded .vsix file and install the extension.

Usage

Step-by-Step Guide

1. Define Your Table Schema: Write your table schema in a specific format within your SQL file. Use the following syntax:

   table_name("your_table_name");
   table_attr("column1_name").primarykey;
   table_attr("column2_name");
   ...