DataStorageMariaDB: Data storage class with MariaDB / MySQL provider

In Appsilon/shiny.stats: 'Shiny' App Usage Telemetry

Data storage class with MariaDB / MySQL provider

Description

Implementation of the DataStorage R6 class to MariaDB backend using a unified API for read/write operations

Super classes

shiny.telemetry::DataStorage -> shiny.telemetry::DataStorageSQLFamily -> DataStorageMariaDB

Methods

Public methods

• DataStorageMariaDB$new()

• DataStorageMariaDB$clone()

Inherited methods

• shiny.telemetry::DataStorage$close()
• shiny.telemetry::DataStorage$insert()
• shiny.telemetry::DataStorage$read_event_data()

---

Method new()

Initialize the data storage class

Usage

DataStorageMariaDB$new(
  username = NULL,
  password = NULL,
  hostname = "127.0.0.1",
  port = 3306,
  dbname = "shiny_telemetry"
)

Arguments

username

string with a MariaDB username.

password

string with the password for the username.

hostname

string with hostname of MariaDB instance.

port

numeric value with the port number of MariaDB instance.

dbname

string with the name of the database in the MariaDB instance.

---

Method clone()

The objects of this class are cloneable with this method.

Usage

DataStorageMariaDB$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.

Examples

## Not run: 
data_storage <- DataStorageMariaDB$new(user = "mariadb", password = "mysecretpassword")

data_storage$insert("example", "test_event", "session1")
data_storage$insert("example", "input", "s1", list(id = "id1"))
data_storage$insert("example", "input", "s1", list(id = "id2", value = 32))

data_storage$insert(
  "example", "test_event_3_days_ago", "session1",
  time = lubridate::as_datetime(lubridate::today() - 3)
)

data_storage$read_event_data()
data_storage$read_event_data(Sys.Date() - 1, Sys.Date() + 1)
data_storage$close()

## End(Not run)

Appsilon/shiny.stats documentation built on Dec. 18, 2024, 6:14 a.m.