create a database

folktales.create_database(filepath = "database.db")

access a database

database = folktales.access_database(filepath = "database.db")

insert a dictionary into a database table

folktales.insert_dictionary_into_database_table(
    dictionary      = {
                      "a": 1,
                      "b": 2
                      },
    table_name      = "data",
    filepath        = "database.db"
)

state dictionaries

A template state dictionary can be created in the following way:

folktales.template_state_dictionary()

This returns a dictionary that features a UUID4 identifier (uuid.uuid4()) and a datetime (datetime.datetime.utcnow()).

A state dictionary can be created at the same time as updating it with an existing dictionary in the following way:

folktales.state_dictionary(
    entries = {
              "state_ID"             : "84f80687-cdd7-48f9-b21c-3d75fd759604",
              "price_recommendation" : 5007.24
              }
)

insert a state dictionary into a database table

folktales.insert_state_dictionary_into_database_table(
    entries    = {
                 "state_ID"             : "84f80687-cdd7-48f9-b21c-3d75fd759604",
                 "price_recommendation" : 5007.24
                 },
    table_name = "do_stocks",
    filepath   = "database.db"
)

access a database table as a pandas DataFrame

df = folktales.DataFrame_of_database_table(
    filepath   = "database.db",
    table_name = "do_stocks"
)