SQL Reporting Workbench for FreeCAD

Info about new community or project announcements, implemented features, classes, modules or APIs. Might get technical!
PLEASE DO NOT POST HELP REQUESTS OR OTHER DISCUSSIONS HERE!
Forum rules
Be nice to others! Respect the FreeCAD code of conduct!
User avatar
furti
Posts: 344
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Post by furti »

Added "CONCAT" function and fixed a bug with unhashable types in Statements with a "GROUP BY" clause. :)


Full list of changes is here https://github.com/furti/FreeCAD-Report ... es/tag/0.4
emills2
Posts: 868
Joined: Tue Apr 28, 2015 11:23 pm

Re: SQL Reporting Workbench for FreeCAD

Post by emills2 »

this is amazing! thank you so much. i can't play with it right this second, but i've been hurting for a basic database, and having it inside FreeCAD will be perfect for me.

have you given any thought to creating basic "TABLE", "VIEW", and "REPORT" python object types? obviously i can add whatever i want to my own python object. i need to go read your docs before i ask too many questions.

my main message here is thank you :)
User avatar
furti
Posts: 344
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Post by furti »

There is a report object available in the workbench. You can add multiple queries to it an it will fill a spreadsheet with the resulting data.

If you need more specialised objects feel free to make a issue (or even a pull request ;) ) in the github repo. Or post your wishes here. :)

Currently I'm thinking of a "visibility" object. You configure it with a "Where" clause and it will display or hide all objects matching. I often need this in my current arch project when displaying only a single building part or the whole building.
emills2
Posts: 868
Joined: Tue Apr 28, 2015 11:23 pm

Re: SQL Reporting Workbench for FreeCAD

Post by emills2 »

i'm with you on the visibilty filter.

i need to assign master / derived / construction / final statuses to points, curves and segments of curves, and surfaces and their segments.

right now i do it by choosing a principal charateristic, and sticking the elements in folders. whenever the principal charateristic doesn't map to a specific task, i do a lot of dancing around from folder to folder.

so i want to 'select' all master elements, make then visible / invisible for editing. at the very end, i want to 'select' all final surface segments, and stitch a shell and make it a solid.

by analogy to Solidworks and Autodesk Inventor, i want one autopopulated folder that shows all solids, one for surfaces, one for curves, one for points, etc.

the relational database model is exactly what is needed!
Silk_model_148_01.png
Silk_model_148_01.png (359.19 KiB) Viewed 2968 times
User avatar
furti
Posts: 344
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Post by furti »

Added Arithmetics and Named columns to the SQL parser :)

Full list of changes can be found here: https://github.com/furti/FreeCAD-Report ... es/tag/0.5
paullee
Veteran
Posts: 5097
Joined: Wed May 04, 2016 3:58 pm

Re: SQL Reporting Workbench for FreeCAD

Post by paullee »

Hi I install in AddManager :)

Start FC and find below message, can't find Reporting WB in the drop-down menu.

Any idea?

Code: Select all

During initialization the error No module named report_utils.resource_utils occurred in /home/paullee/.FreeCAD/Mod/Reporting/InitGui.py
FreeCAD_0.18.15860.glibc2.17-x86_64.AppImage
on
Fedora 29
User avatar
furti
Posts: 344
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Post by furti »

Is this a python 3 build? If not, can you give it a try with a python 3 build?

I only use python 3 so this is not tested with python 2 :)

Hopefully we can drop python 2 support soon :D
paullee
Veteran
Posts: 5097
Joined: Wed May 04, 2016 3:58 pm

Re: SQL Reporting Workbench for FreeCAD

Post by paullee »

I see :)

Downloaded
FreeCAD_0.18.15823_Conda_Py3Qt5_glibc2.12-x86_64.AppImage

and Reporting WB is there, thanks!
User avatar
wandererfan
Veteran
Posts: 6267
Joined: Tue Nov 06, 2012 5:42 pm
Contact:

Re: SQL Reporting Workbench for FreeCAD

Post by wandererfan »

Just fooling around a bit so far. Reports go onto TechDraw pages easily! Well done @furti!
Attachments
ReportOnTDPage.png
ReportOnTDPage.png (202.13 KiB) Viewed 2682 times
User avatar
furti
Posts: 344
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Post by furti »

Nice to see that. So it schould be pretty easy to export and print them next to the model :)
Post Reply