Reading and writing data to database tables

[truongqt]

I would like to share data between actions using database tables. Is that possible? Thanks.

[KyleGabriel]

Can you expand on what you are specifically trying to do? I’m not completely sure I understand the question or purpose.

[truongqt]

Hi Kyle,

There’re many parameters and temporary data that I would like to store in some database tables, and I would like to have control of those tables (add/remove columns, etc). The stored data will be used later either for recovery or executing different logic when the same function runs again.

Thanks for your help.

Great work!!! I really enjoy using Mycodo.

Tuan

[KyleGabriel]

You can store and retrieve basic values for Inputs, Outputs, and Functions. See:

How to create a custom input with calibration using ADS1115 ADC and Gravity analog pH and EC sensors?

Inputs have the following functions available to them: self.set_custom_option(option, value), where option is a string, and value can be any JSON serializable variable type (dict, list, str, bool). self.get_custom_option(option), where option is the string used with set_custom_option(). If there are no values found in the database for the option, None is returned. You can see these functions used in the Anyleaf pH Input. For building the capacity for the Input module to perform calibra…

[truongqt]

I think that would work. Thanks.

Tuan