aboutsummaryrefslogtreecommitdiff
path: root/tools/mpd-stats/internal/scrobbler/db.go
diff options
context:
space:
mode:
authorFranck Cuny <franck@fcuny.net>2022-10-24 17:32:17 -0700
committerFranck Cuny <franck@fcuny.net>2022-10-24 17:32:17 -0700
commitfe7dfdd250b701177f051ad6cdc3dc68695cbfc4 (patch)
tree99d7cf0230ad604c256df2225c1d32ef4266d4ec /tools/mpd-stats/internal/scrobbler/db.go
parentfeat(home/packages): install git-broom (diff)
downloadinfra-fe7dfdd250b701177f051ad6cdc3dc68695cbfc4.tar.gz
ref(tools/mpd-stats): delete the project
It's been moved to its own repository at https://github.com/fcuny/mpd-stats Update the list of repositories managed by terraform.
Diffstat (limited to 'tools/mpd-stats/internal/scrobbler/db.go')
-rw-r--r--tools/mpd-stats/internal/scrobbler/db.go55
1 files changed, 0 insertions, 55 deletions
diff --git a/tools/mpd-stats/internal/scrobbler/db.go b/tools/mpd-stats/internal/scrobbler/db.go
deleted file mode 100644
index 5f80aa4..0000000
--- a/tools/mpd-stats/internal/scrobbler/db.go
+++ /dev/null
@@ -1,55 +0,0 @@
-package scrobbler
-
-import (
- "database/sql"
- "fmt"
- "os"
-
- _ "github.com/mattn/go-sqlite3"
-)
-
-func initdb(dbpath string) error {
- if _, err := os.Stat(dbpath); err == nil {
- return fmt.Errorf("%s already exists", dbpath)
- }
-
- db, err := sql.Open("sqlite3", dbpath)
- if err != nil {
- return err
- }
- defer db.Close()
-
- sqlStmt := `create table records (id text primary key,
- title text,
- artist text,
- album text,
- duration int,
- playtime int,
- time timestamp
- );`
-
- _, err = db.Exec(sqlStmt)
- if err != nil {
- return err
- }
-
- return nil
-}
-
-func opendatabase(dbpath string) (*sql.DB, error) {
- var err error
- _, err = os.Stat(dbpath)
-
- if err != nil {
- if err := initdb(dbpath); err != nil {
- return nil, err
- }
- }
-
- db, err := sql.Open("sqlite3", dbpath)
- if err != nil {
- return nil, fmt.Errorf("unable to open database: %s", err)
- }
-
- return db, nil
-}