package connection

import (
    "os"
    "database/sql"
    _ "github.com/go-sql-driver/mysql"
    Encryption "cf-experian/module_server/handlers/Modules/Encryption"
)



func DBCon() (*sql.DB, error){

    u := Encryption.Get(os.Getenv("USER"))
    d := Encryption.Get(os.Getenv("DB"))
    ho := Encryption.Get(os.Getenv("HOST"))
    p := Encryption.Get(os.Getenv("CRE"))

    conn := u+":"+p+"@tcp("+ho+":3306)/"+d

    db, err := sql.Open("mysql", conn)
    return db, err
}

func DBConE() (*sql.DB, error){

    u := Encryption.Get(os.Getenv("S_USER"))
    d := Encryption.Get(os.Getenv("S_DB"))
    ho := Encryption.Get(os.Getenv("S_HOST"))
    p := Encryption.Get(os.Getenv("S_CRE"))

    conn := u+":"+p+"@tcp("+ho+":3306)/"+d

    db, err := sql.Open("mysql", conn)
    return db, err
}