/* guestbook - Standalone guestbook server for static websites
 * Copyright (C) 2025  Vidhu Kant Sharma <vidhukant@vidhukant.com>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */

package db

import (
	"fmt"
	"log"
	"database/sql"

	"github.com/spf13/viper"
	_ "github.com/go-sql-driver/mysql"
)

type GuestbookEntry struct {
	Name       string `json:"name"`
	Website    string `json:"website"`
	Message    string `json:"message"`
	Validation string `json:"validation"`
	Time       string
}

func Connect() *sql.DB {
	conn, err := sql.Open(
		"mysql",
		fmt.Sprintf(
			"%s:%s@%s/%s?%s",
			viper.GetString("database.username"),
			viper.GetString("database.password"),
			viper.GetString("database.location"),
			viper.GetString("database.db_name"),
			viper.GetString("database.params"),
		),
	)
	if err != nil {
		log.Fatal(err)
	}

	return conn
}