mysql

package

v0.42.0 Latest Latest Go to latest Published: Apr 15, 2024 License: Apache-2.0 Imports: 9 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/edgenesis/shifu

Links

Open Source Insights

Documentation ¶

Constants ¶

View Source

const (
	TIMESTAMP_FORMAT = "2006-01-02 15:04:05"
	MYSQL_URL_FORMAT = "%s:%s@(%s)/%s"
	MYSQL_QUERY      = "Insert Into %s (DeviceName,TelemetryData,TelemetryTimeStamp) Values('%s','%s','%s')"
	MYSQL            = "mysql"
)

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

type DBHelper ¶

type DBHelper struct {
	DB       *sql.DB
	Settings *v1alpha1.SQLConnectionSetting
}

func (*DBHelper) ConnectToDB ¶

func (db *DBHelper) ConnectToDB(ctx context.Context) error

func (*DBHelper) InsertDataToDB ¶

func (db *DBHelper) InsertDataToDB(ctx context.Context, deviceName string, rawData []byte) error

This table stores telemetry data from various devices. CREATE TABLE ${DbTableName} (

    TelemetryID INT AUTO_INCREMENT PRIMARY KEY,
    DeviceName VARCHAR(255),
    TelemetryData TEXT,
    TelemetryTimeStamp TIMESTAMP
)

The table is used to track telemetry information for analysis and monitoring.

func (*DBHelper) SendToDB ¶

func (db *DBHelper) SendToDB(ctx context.Context, deviceName string, rawData []byte) error

Source Files ¶

View all Source files

mysql.go

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL