querious2_sqlite_database.go

package amanar

import (
	"database/sql"
	_ "github.com/mattn/go-sqlite3"
)

func NewQuerious2SQLiteDatabase(filepath string) (*Querious2SQLiteDatabase, error) {
	database := &Querious2SQLiteDatabase{
		Filepath: filepath,
	}

	return database, nil
}

type Querious2SQLiteDatabase struct {
	Filepath string
}

func (qdb *Querious2SQLiteDatabase) UpdateUsername(databaseUuid string, username string) error {
	db, err := sql.Open("sqlite3", qdb.Filepath)

	statement, err := db.Prepare("UPDATE connection_settings SET user=? WHERE uuid=?")

	if err != nil {
		return err
	}

	_, err = statement.Exec(username, databaseUuid)

	defer statement.Close()

	return err
}