[BANanoVuetifyAD3] [RFI]: Creating CRUD WebApps

[Mashiane]

Hi there: REQUEST FOR INPUT

In 2021, I released an ebook about Creating CRUD based WebApps ebook. This was for those in a hurry. I am also finding myself in a hurry lately, thus addressing this again.

I am currently updating how that tool created apps, more especially with the outlook of BVAD3 going forward. So we are basically looking at a complete over-haul of the whole process, with a focus on better and more informative b4x code.

I have attached a small project here with 2 pages on what has been done so far. This is implementing everything on lessons learned, ease of use and the overall functionality of creating CRUD web apps with BVAD3.

Whilst not complete, this is what I kindly request you to do.

1. Get BVAD3 and this project, skim through the code.
2. Run this project
3. Now go back and relook at the "input", i.e. the code that generates the app.

What I'd like to establish about the attached source code for bva3code is

1. Do you understand the code and comments?
2. Is it easy to follow or you think it's a steep learning curve.
3. What can be enhanced or changed on the code to make it better.
4. Any other thing you can think of???

Please note.

The CRUD functionality of this app itself is not complete, only the skeleton has been done. The approach followed is the use of the BANanoDataSource (remember, with the data-source you can connect to any back-end you need as the code is 99.9% compatible accross the board).

This back-end compatibility and how the data-source was successfully used in thos use cases was discussed in this Medium Article, I created the same Vuetify WebApp 14 times

PS: The has been feedback already in some of the issues on this code. If you want you can comment here, or telegram or DM.

I humbly thank you.

Mashy

 

[Mashiane]

So I have added more code to this project from the source code generator Sithaso Incwadi yamaBali (StoryBook)....

Reproduction..

1. Get BVAD3 BLibrary
2. Unzip and import the bvad3invoicer.sql scripts.
3. Update the mysqlconfig.php file after unzipping b4xcode.zip

PS: The code to export to PDF, CSV, Excel has not been concluded yet.

 

[Magma]

Hi there...

well I am trying to get that work... but... No Data to Display in Categories...

I think is configuration problem...

well my edited mysqlconfig.php

<?php
const DB_HOST = 'localhost';
const DB_NAME = 'bvad3invoicer';
const DB_USER = 'root';
const DB_PASS = '';
?>

Where i can put different port?... I have 3307 not 3306?

Also is there something that i must change in code to look only for mysql database (to target to it only) ???
anything in config.properties ???

Thanks in advance!

 

[Mashiane]

in Categories...

I remember, I created the categories page but not the table in the db, so for now only the "taxes" file is relevant.

Anyway when the app starts it should load the Taxes screen as others are still work in progress.

Thank you so much!

 

[Magma]

Where i can put different port?... I have 3307 not 3306?

Also is there something that i must change in code to look only for mysql database (to target to it only) ???
anything in config.properties ???

 

[Mashiane]

Also is there something that i must change in code to look only for mysql database (to target to it only) ???

No, the app itself is already built to use mysql as a back-end, so there is nothing to change except your login details for mysql on the config.file.

anything in config.properties ???

If you are using laragon, the app is set up to start https://localhost.

 

[Mashiane]

I have 3307 not 3306?

const DB_HOST = 'localhost';

I think 'localhost:3307' have not tested that though..

 

[Magma]

already tried that... but the same...


ps: I have already a later mysql instance running at 3306 for my program testing... i don't want to mess it...

 

[Mashiane]

I understand, Im also testing how to do that on my side, just a second..

 

[Mashiane]

Ok, just tested, found something on stack overflow, one has to use the IP address

const DB_HOST = '127.0.0.1:3307';

Tested and its working..

I also think for the sake of completeness, I will also just use this approach if the specified port is not 3306.