diff options
Diffstat (limited to 'tools/mpd-stats/internal/scrobbler/db.go')
-rw-r--r-- | tools/mpd-stats/internal/scrobbler/db.go | 55 |
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 -} |