1084

Vtl Data Generator has two new features

Comments for “Vtl Data Generator has two new features”
 

Posted by Dom on Tuesday 2nd July 2024 at 18:02 GMT

The Data Generator has just had two new features added to it.

The first is a query builder that lets you create your own queries and test them in situ. If they meet with your expectations you can then go on to save them. For those of you who create numerous sites using the Trongate framework a customised Data Generator could prove to be a useful timesaver.

The second feature arose out of a question from Nico (@Doranov) who enquired if there was a Show Columns feature that might help him create database documentation. I decided to take it a step further and actually create a database Documentation feature that will document your database.

You can see the feature in action here;
https://app.screencast.com/kLHxFcdBx1HAY

I feel that the Generator is now more or less feature complete. There are bits that can be improved I don't doubt.
Level One Member

Dom

User Level: Level One Member

Date Joined: 12/01/2024

Posted by DaFa on Tuesday 2nd July 2024 at 21:43 GMT

Hey Dom,

Brilliant work! I'll try it and give you feedback very soon. Hope the shoulder is getting better so you can convert those silent demos into YT tutorials, maybe even borrow DC's document assistant AI voice :)
Founding Member

DaFa

User Level: Founding Member

Date Joined: 30/11/2018

Posted by Dom on Wednesday 3rd July 2024 at 18:14 GMT

Bumped the version number up to 3.3 with the addition of a create Module facility for when you have created a table.
Level One Member

Dom

User Level: Level One Member

Date Joined: 12/01/2024

Posted by DaFa on Sunday 7th July 2024 at 11:37 GMT

Super cool Dom, I see you used the VS Code module creation format - very nostalgic. I'm sure Jake would be as stoked as I am.

Suggest you also add a link to your GitHub repo near the current version number and also a method to update from within the 'vtlgen' module from GitHub. For me, all I do to update is clone your repo like so:
1. open a terminal inside of VS Code in the `modules` folder
2. rename or remove the old version of `vtlgen`
3. then clone your repo
PS D:\xampp\htdocs\b1\modules> git clone https://github.com/domsinclair/vtlgen.git vtlgen
Cloning into 'vtlgen'...
remote: Enumerating objects: 1056, done.
remote: Counting objects: 100% (1056/1056), done.
remote: Compressing objects: 100% (727/727), done.
Receiving objects: 100% (1056/1056), 7.41 MiB | 3.88 MiB/s, done.sed 0Receiving objects:  98% (1035/1056), 5.80 MiB | 3.79 MiB/s

Resolving deltas: 100% (324/324), done.
I really like the YouTube video you added to `The Trongate Module Market` too - well done! - maybe even embed that into the general doc section.

Cheers,
Si
Founding Member

DaFa

User Level: Founding Member

Date Joined: 30/11/2018

Posted by Dom on Tuesday 9th July 2024 at 08:03 GMT

Great suggestions Simon, thank you. Hopefully they'll be incorporated later on today.

I've been trying to find a way to generate management and create views for generated modules. It's made difficult by dint of the fact that you don't really know what you might potentially be dealing with but I think it's worth pursuing to see if a generally stable generic module creator could be achieved.

Having made the first I'll also try and add some more specific tutorial videos to go with it.

The notion of an update feature is rather cool, especially if it could be linked to a version number. I'll have to look into that. I've plenty of experience doing that with software installation routines, but I haven't applied much thought as to how to do that with modules, however having a simple, but robust system could be really beneficial for all module creators

This comment was edited by Dom on Tuesday 9th July 2024 at 08:08 GMT

Level One Member

Dom

User Level: Level One Member

Date Joined: 12/01/2024

Posted by Dom on Tuesday 9th July 2024 at 18:39 GMT

Simon
You should find that your suggestions have now been incorporated (although currently they are only available via the Github repo).

My aim has been to try and create an update functionality that could be applied to any module.

You'll find the meat and bones of the logic at the top of the private functions region in the controller. I still have some testing to do but in theory when this gets officially released as version 3.4 if you have this current version of 3.3 on your machine it should pick it up.

I have tried to set this up so that there is no need to use the cli, quite deliberately so that it can be added to other modules. I won't insult you by telling you how it works, it should be pretty obvious, but you'll find an addition to the config file and the vtlgen view has a couple of additions around the version text.

Github and YT links also added.
Level One Member

Dom

User Level: Level One Member

Date Joined: 12/01/2024

Posted by DaFa on Friday 12th July 2024 at 10:51 GMT

Cool stuff Dom, I have checked it out and is working as described. I'll take a look at the working and add suggestions once I get some time, which I don't have much of lately. My day job has gotten rather busy, with me managing 5 more employees and admin staff under me and being slammed with 3 more contracts on top of my normal load - where is that load balancer when you need it!! I need a holiday 😵‍💫
Founding Member

DaFa

User Level: Founding Member

Date Joined: 30/11/2018

Posted by Dom on Saturday 13th July 2024 at 14:20 GMT

Hi Simon

Relieved to know it worked!

I think that there is the basis for a form of module updater philosophy there, which with a few 'rules / suggestions' for people to employ would be pretty robust. It probably needs additional refinement for modules where the author expects end users to customise the module, the Data Generator being a case in point. These should probably be designed in such a way that updatable code is actually in separate files (which themselves should probably be separately backed up during the update process).

I think that this also implies the introduction of namespaces to the generator. If nothing else it would act as a proof of concept for what I think would be necessary for Trongate pages.

I've also done a lot more work on module creation. The aim is to get something that resembles a functional working module to be produced. Needless to say it is a tad more complicated to do than say.
Level One Member

Dom

User Level: Level One Member

Date Joined: 12/01/2024

×