Function New

internal/db/db.go:38–53

New opens (or creates) the SQLite database and runs migrations.

()

// New opens (or creates) the SQLite database and runs migrations.
func New() (*DB, error) {
	p, err := config.DBPath()
	if err != nil {
		return nil, err
	}
	conn, err := sql.Open("sqlite", p)
	if err != nil {
		return nil, fmt.Errorf("failed to open database: %w", err)
	}
	d := &DB{conn: conn}
	if err := d.initTables(); err != nil {
		conn.Close()
		return nil, err
	}
	return d, nil
}

// Close closes the database connection.
func (d *DB) Close() error {