I'm rewriting a ERP system my late father wrote in Delphi (with my help when I was a teenager), to be a modern system in PHP (to be hosted for dirt cheap) with a GraphQL api. As I don't have the manpower to write this API manually, I wrote a JS code to read and parse a MySQL Workbench diagram file, where I define the tables and relationships in the visual editor, and then I parse the XML config file to create the GraphQL Schemas and Resolvers.
This API is already working with queries, filters (conditions for the 'where' clause in sql) and forward and reverse relationships (depending on which table points to the other). This system already create 'create' mutations, but I still have to do 'update's and 'delete's. And the entire frontend still.
Comments
I'm rewriting a ERP system my late father wrote in Delphi (with my help when I was a teenager), to be a modern system in PHP (to be hosted for dirt cheap) with a GraphQL api. As I don't have the manpower to write this API manually, I wrote a JS code to read and parse a MySQL Workbench diagram file, where I define the tables and relationships in the visual editor, and then I parse the XML config file to create the GraphQL Schemas and Resolvers.
This API is already working with queries, filters (conditions for the 'where' clause in sql) and forward and reverse relationships (depending on which table points to the other). This system already create 'create' mutations, but I still have to do 'update's and 'delete's. And the entire frontend still.