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!
User avatar
furti
Posts: 320
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Postby furti » Thu Jan 31, 2019 5:09 pm

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: 577
Joined: Tue Apr 28, 2015 11:23 pm

Re: SQL Reporting Workbench for FreeCAD

Postby emills2 » Mon Feb 04, 2019 6:58 pm

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: 320
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Postby furti » Tue Feb 05, 2019 7:36 am

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: 577
Joined: Tue Apr 28, 2015 11:23 pm

Re: SQL Reporting Workbench for FreeCAD

Postby emills2 » Fri Feb 08, 2019 10:16 pm

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 853 times
User avatar
furti
Posts: 320
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Postby furti » Thu Feb 14, 2019 4:09 pm

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
Posts: 1690
Joined: Wed May 04, 2016 3:58 pm

Re: SQL Reporting Workbench for FreeCAD

Postby paullee » Fri Feb 15, 2019 1:35 pm

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: 320
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Postby furti » Fri Feb 15, 2019 5:30 pm

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
Posts: 1690
Joined: Wed May 04, 2016 3:58 pm

Re: SQL Reporting Workbench for FreeCAD

Postby paullee » Fri Feb 15, 2019 10:41 pm

I see :)

Downloaded
FreeCAD_0.18.15823_Conda_Py3Qt5_glibc2.12-x86_64.AppImage

and Reporting WB is there, thanks!
wandererfan
Posts: 2982
Joined: Tue Nov 06, 2012 5:42 pm

Re: SQL Reporting Workbench for FreeCAD

Postby wandererfan » Fri Feb 22, 2019 9:44 pm

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 567 times
User avatar
furti
Posts: 320
Joined: Mon Nov 27, 2017 5:27 pm

Re: SQL Reporting Workbench for FreeCAD

Postby furti » Sat Feb 23, 2019 10:23 am

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