database

package

v1.0.2 Latest Latest Go to latest Published: Jan 30, 2026 License: MIT Imports: 5 Imported by: 0

Details

This section is empty.

This section is empty.

This section is empty.

type Config struct {
	Host     string
	Port     string
	User     string
	Password string
	DBName   string
	SSLMode  string
}

Config holds database configuration

type PostgresDB struct {
	DB *sql.DB
}

func NewPostgresDB(config Config) (*PostgresDB, error)

NewPostgresDB creates a new PostgreSQL database connection

func (p *PostgresDB) Close() error

Close closes the database connection

func (p *PostgresDB) GetAllCSVData() ([]map[string]interface{}, error)

GetAllCSVData retrieves all CSV data from the database

func (p *PostgresDB) GetCSVDataByID(id int) (map[string]interface{}, error)

GetCSVDataByID retrieves CSV data by ID

func (p *PostgresDB) InitSchema() error

InitSchema creates the necessary tables if they don't exist

func (p *PostgresDB) InsertCSVData(filename string, records []map[string]string) error

InsertCSVData inserts CSV data (as JSON) into the database