Skip to content

Latest commit

 

History

History
56 lines (45 loc) · 3.22 KB

README.md

File metadata and controls

56 lines (45 loc) · 3.22 KB
Raw

AppSmith

C# MS-SQL Database table modeler.

SQLView

See Wiki Index for more on Install and UI details. App using TreeView Control that Reads/Saves as a Table/Dictionary via MessagePack to and from a file.

This app is a port of DBWorkshop a code generator that connects to a MSSql DB and generates code from objects found.

  • Difference being this app does not connect to any database.
  • Stores the model as a file in the file system using asm extension.

Tree is a model of a Server, Can have many APIs and DBs.

  • New Set OpenApiJsonUrl to a web services OpenApi URL and then right click the server and click Import API to download the file and import it into the model.
  • Design Tables, Stored Procedues, Api(namespace), Controllers and Classes headers with right click in tree and Add menu item.
  • So far code parsing of SQL Tables and SQL Stored Procs into the tree model from pastable Input tab.
    • Stored Procs Once defigned, generates a regular CSharp Repo Class methods.
  • As Far as Generation,
    • On Sql Table side,
      • Standard Add Update stored procedure generation,
      • foreach Cursor procedure generator.
    • On CSharp Sql side,
      • Entity Class for table
      • Repository Class output, Standard Dapper wrappers for
        • Get All
        • Get Single by Id
        • Update via AddUpdate stored proc call
        • Delete row call
      • FileTable Class generator in CSharp to showcase FileTable package.
      • Standard Add Update stored procedure for user defigned modeled stored procedures.
    • On Api side, Use tree to design c# output generation
      • Right click on tree and Add Menu will reveal what types are available at the current level of the tree.
      • Generates Controller Classes output
      • Design Generate Classes in general.
      • Design Properties, Methods, Method Parameters.
      • Interface generation for all classes, controllers.
  • Code generation from the tree on the api side works for designing Api. The Constructor and Di needs work in code gen part.

Anyway it's a starter UML designer. Full source included. Clone a copy and modify to your own style add tabs, code is extendable.

  • Project target Framework net48 showcases the following components
    • Visual Studio Standard Tree View control, splitter, and tab controls.
  • Package FCTB version 2.16.24 - For the syntax highlighting text editors.
  • package MessagePack version 2.5.140 - For the high-performance object serialization
  • package PropertyGridEx version 1.0.0 - Property editor to modify the data.
  • package Microsoft OpenApi version 1.6.4 - for Deserializing the spec.

PetController

Building and running the code yourself is the best way to ensure it works as intended. Downloading Visual Studio Community edition is a free and easy way to achieve this

Cheers