I would like to keep track of the verification status of my project (verilog/systemverilog) coverage and pass/fail status of tests during the life of the project. Ideally I want to create an SQLITE database to keep track of this since SQLITE is stored in a file which can be archived with the project after tapeout.
I am already writing my own solution which involves parsing the output vsof from a regression and then storing the information I need, however this seems to me to be something which may already be possible and there does seem to be an option in the emanager configuration to use SQL but there is no information in any of the docs which explains its use.
Does anyone have any ideas ?
I would generally advise against parsing the VSOF directly as its format does occasionally change slightly and I have seen users flows break in this circumstances. Usually at the point where the author of the parser script has moved on and nobody knows what it was meant to do... ;-)
You could use the API provided by vManager to load up the VSOF(s) and query the run status (pass/fail/incomplete) and get the associated failure information. I think you'll find this a lot easier than parsing the VSOF anyway, even if the VSOF format remains stable. If you wish, I can give you some help to get started with the vMananger batch API, or you can dive right in yourself, just bring up cdnshelp and search for vm_manager.read_session(), vm_vsof.get_runs(), vm_run.get_status(). These should get you close enough that you'll figure it out easily enough.
As regards the SQL support in vManager, this isn't meant for general consumption; it is a legacy thing which isn't under development.