sql_query

package

v1.0.2 Latest Latest Go to latest Published: Sep 7, 2018 License: MIT Imports: 5 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

Package: SQLクエリ発行，処理

This section is empty.

This section is empty.

func Has_app_id(app_id string) (bool, error)

app_idがDBに格納されていれば真 * app_id: string 要求されたapp_id

func Insert_status(state string) error

鍵の状態をデータベースに挿入 * state: string(enum("ON","OFF")) 鍵の状態

type Key_info struct {
	Time        string
	State       string
	Key_info_id int
}

func Get_all_statistics() ([]Key_info, error)

統計データ全件抽出

func Get_before_state(fd time.Time) (Key_info, error)

指定した日時の一つ前のデータを抽出 * fd: time.Time 取得する値の指定日時

func Get_latest_state() (Key_info, error)

最新データ一件を抽出

func Get_statistics(fd time.Time, ed time.Time) ([]Key_info, error)

統計データ指定日時から指定日時まで抽出 * fd: time.Time 統計値の取得を開始する指定日時 * ed: time.Time 統計値の取得を終わる指定日時