DataStorageMariaDB {shiny.telemetry}R Documentation

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

Inherited methods

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)

[Package shiny.telemetry version 0.3.0 Index]