garlic3 / Blog: Recent posts

I tried to find out how to read information from a TreeView that was filled before.
Gambas Version 3.12 + can give an array with keys ..

Add database connection information like datacontext, user@host:database, ..

DataContext-0.2.3.tar.gz
- DataContextTest.sql to make a test database/table
- button to test the connections to database server

CDataContext: getContextSlots from id or all if -1
FMain: change quit menu to quit button

• Fixed crash on invalid datacontext name bug,
• Demo added in included test app.
• Improved feedback in test app.

Counter for the start and close of an application.
Useful to check at user:
- is application used regularly?
- if close counter is much lower than runcounter, application might have crashed a lot.

Also contains reset to zero, or force a certain value.
Values stored in the settings file.

Something I already use for a while,and put in a lib now...

Get all context id's as array.
Remove old index from code (Use context id instead of context index)

Cleanup, use iDataContext in procedure calls, iSelectedContextId internal

Use id instead of index for the contexts in the settings file.
FMain now ready to load config file, and let you do some tests.
Help.txt explains the contexts, datasets, slots, keys etc.
Tab for database settings

3.2.3 Table remark is now saved also at creation of table.
3.2.4 Table remark as comment in created object code

FMain: Table description is visible, and can be added in dd with type=table.

Data context in Settings, create, load, etc

Menu to show About/Help, file menu to clean up data and log files, data directory.

Some improvements like Help, layout, activate hospitalisations.
Uses only the "new in" value of hospitalisations.

Uses only the "new in" value of hospitalisations.
Not tested yet.

0.1.2 was full of errors; use this instead:
1.municipality choice works again on KDE
2.location of files: only download in home directory; immediately put files in data directory to work with afterwards

Use this version instead of 0.1.0 that fixed the changed csv files because it had problems with the location of the files and creation of the list of municipalities.

This is a gambas3 command line app that now can:
1. Download and load data in empty database
2. Download and update data in database, keep old records set "invalid" so you can check the evulution of the numbers of a given day (they tend to change still 2 a 3 days after first appearance).
There is no graphical interface so that you can start the program as a script and let it run daily...
You can then retrieve the data from the database with your own applications...... read more

Covid19DataBE2db 0.1.0 release:
- cases municipalities download csv, filter needed columns and import in empty mariadb table

Note:
Covid19 Data Belgium to db: adapt to new format of csv file for covid 19 cases - municipalities since 22/9/2020.
Therefore version goes from 0.0.4 to 0.1.0.

Suddenly Sciensano changed the format of the data, the csv files for cases has 9 columns instead of 11, and two first columns changed places!

examples of downloading data file of Belgian Covid19 cases (and hospitalisations) and doing some work on them;
- covid19DataBE to download the cases in cvs, split into data columns, filter the data of a choosen city, and optionally show the graph or export to cvs file.
(note: gambas 3.10 is not compatible with the versions that have the graph, you need gambas 3.14 or so)
- covid19DataBE2db CLI to download the data files, split into data colums, and import in your (mariadb) database (in the works), might run as daily script.

Editor is deprecated in gambas since 3.8. Replaced with TextEditor.

DbInfoCode 3.2.1: project, replace qt4 by gb.gui.qt

Normally this tool is meant to create a new settings file that you want to read from the software you are developping.
Now you can also use it to open an existing settings file with an editor as kate (tested) or gedit (not tested).
This way it is just a shortcut to open your hidden gambas3 settings directory ...

3.0.1 Adapted to Gambas 3.x from garlic SimpleCharts.
3.0.2: bugs in chart titles corrected, Charts resize (redraw after doubleclick)

3.1.46: Include tab with text from MForm to copy paste.
MForm contains default colors for edit, help etc
3.1.45: fix syntax $sLastError in MCode