Database update in Cyclist

[Max Schalz]

Dear all,

I have recently started working with Cyclus and Cyclist.

When analyzing some sqlite output files, I noticed that some of them featured indices, views and certain additional tables (eg., QuantityInventoryBase) while others did not.

I have found out that these are added automatically (via the database update pop-up window) when opening them in Cyclist using ./Cyclist.app/Contents/Java/externalApps/cycpost-darwin-amd64.

However, when I execute this application manually in the terminal, it only adds the indices, not the views or tables.

Is there a way to do this without needing to open Cyclist? And moreover, is there some documentation on how these indices and tables are generated?

Regards,

Max

[Paul Wilson]

Hello Max,

Thanks for your email about Cyclus and Cyclist.

For a variety of reasons, we have not been maintaining Cyclist in the last couple of years.  Frankly, I'm surprised you got as far as you did. :)

It sounds as though you don't necessarily want to use Cyclist either for analyzing your data.  Perhaps we can help you get started with some other tools, especially Cymetric, a python based tool for post-processing Cyclus data.

If you can share your aims for what you are trying to do, we might be able to suggest the best approach with more robust tools.

Cheers,

Paul

--
You received this message because you are subscribed to the Google Groups "Cyclus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cyclus-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cyclus-users/cee532ce-803f-4e51-8eb1-4ea49d202a6f%40googlegroups.com.

--
-- ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ --
Paul P.H. Wilson (he/him/his)
Grainger Professor of Nuclear Engineering
Chair, Department of Engineering Physics
Chair, Energy Analysis and Policy Certificate
608-263-0807
paul....@wisc.edu
153 Engineering Research Bldg
1500 Engineering Dr, Madison, WI 53706

Computational Nuclear Engineering Research Group

[Max Schalz]

Hi Paul,

Thanks for the answer.

Yes, you're right about this. I was only using Cyclist to get a glimpse into the software, but did not plan on using it further.

One aim is to get an overview of the time evolution of commodity x in facility y, which was basically encoded in the QuantityInventoryBase table.

To be frank I have not yet understood the advantages of using Cymetric over analyzing the sqlite data directly in Python or any other language and therefore I haven't spent much time on this.

Cheers, Max

Am Donnerstag, 7. November 2019 02:30:13 UTC+1 schrieb paul.wilson:

Hello Max,

Thanks for your email about Cyclus and Cyclist.

For a variety of reasons, we have not been maintaining Cyclist in the last couple of years.  Frankly, I'm surprised you got as far as you did. :)

It sounds as though you don't necessarily want to use Cyclist either for analyzing your data.  Perhaps we can help you get started with some other tools, especially Cymetric, a python based tool for post-processing Cyclus data.

If you can share your aims for what you are trying to do, we might be able to suggest the best approach with more robust tools.

Cheers,

Paul

On 11/4/19 02:58, 'Max Schalz' via Cyclus Users wrote:

Dear all,

I have recently started working with Cyclus and Cyclist.

When analyzing some sqlite output files, I noticed that some of them featured indices, views and certain additional tables (eg., QuantityInventoryBase) while others did not.

I have found out that these are added automatically (via the database update pop-up window) when opening them in Cyclist using ./Cyclist.app/Contents/Java/externalApps/cycpost-darwin-amd64.

However, when I execute this application manually in the terminal, it only adds the indices, not the views or tables.

Is there a way to do this without needing to open Cyclist? And moreover, is there some documentation on how these indices and tables are generated?

Regards,

Max

--
You received this message because you are subscribed to the Google Groups "Cyclus Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to cyclu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/cyclus-users/cee532ce-803f-4e51-8eb1-4ea49d202a6f%40googlegroups.com.

[Baptiste MOUGINOT]

Dear Max,

TBH, Cymetric won't get you information that you wouldn't be able able to get/compute from sqlite queries.

But it might make it simpler, and delivers the data in panda dataframe.

Using Cymetric, you can:

- access the raw data using the metric evaluation (eval("Metrics_1"))

- get some tables that have been combined together: transaction (You can filter those by facilities, commodities and and nuclide when doing the query)

- get some advanced metrics, such as activity, decayheat ...)

- get simple timeseries for transactions, inventories, ... returning a 2 columns table: time vs value.

- get a flow graph of the transaction in your simulation, 

You can see some examples there: https://github.com/bam241/cymetric_play/blob/demo/demo.ipynb

Baptiste

[Max Schalz]

Dear Baptiste,

Alright, that sounds interesting! I will look through the demo and try to use Cymetric on my own results as well.

Thank you very much,

Max