// This is the first method called. Parse the configuration file, populate the environment values and create the connection to the db
func init() {
flag.Parse()
args := flag.Args()
envVar := os.Getenv("CONF_FILE")
var file string
if len(args) == 1 {
file = args[0]
} else if envVar != "" {
file = envVar
} else {
panic(fmt.Sprintln("Configuration file is required.\nUse: CONF_FILE environment variable or cli args"))
}
var err error
if err = initConfiguration(file); err != nil {
panic(fmt.Sprintf("[!] %v\n", err))
}
var connectionString string
if connectionString, err = Configuration.ConnectionString(); err != nil {
panic(err.Error())
}
if db, err = igor.Connect(connectionString); err != nil {
panic(fmt.Sprintf("Got error when connect database: '%v'\n", err))
}
logger := log.New(os.Stdout, "query-logger: ", log.LUTC)
Db().Log(logger)
}
func init() {
if db, e = igor.Connect("user=donotexists dbname=wat sslmode=error"); e == nil {
panic(fmt.Sprintf("Connect with a wrong connection string shoudl fail, but succeeded"))
}
if db, e = igor.Connect("user=igor dbname=igor sslmode=disable"); e != nil {
panic(e.Error())
}
// Exec raw query to create tables and test transactions (and Exec)
tx := db.Begin()
e = tx.Exec("DROP TABLE IF EXISTS users CASCADE")
if e != nil {
panic(e.Error())
}
e = tx.Exec(`CREATE TABLE users (
counter bigserial NOT NULL PRIMARY KEY,
last timestamp without time zone DEFAULT timezone('utc'::text, now()) NOT NULL,
notify_story jsonb DEFAULT '{}'::jsonb NOT NULL,
private boolean DEFAULT false NOT NULL,
lang character varying(2) DEFAULT 'en'::character varying NOT NULL,
username character varying(90) NOT NULL,
password character varying(60) NOT NULL,
name character varying(60) NOT NULL,
surname character varying(60) NOT NULL,
email character varying(350) NOT NULL,
gender boolean NOT NULL,
birth_date date NOT NULL,
board_lang character varying(2) DEFAULT 'en'::character varying NOT NULL,
timezone character varying(35) DEFAULT 'UTC'::character varying NOT NULL,
viewonline boolean DEFAULT true NOT NULL,
remote_addr inet DEFAULT '127.0.0.1'::inet NOT NULL,
http_user_agent text DEFAULT ''::text NOT NULL,
registration_time timestamp(0) with time zone DEFAULT now() NOT NULL
)`)
if e != nil {
panic(e.Error())
}
e = tx.Exec("DROP TABLE IF EXISTS profiles CASCADE")
if e != nil {
panic(e.Error())
}
e = tx.Exec(`CREATE TABLE profiles (
counter bigserial NOT NULL PRIMARY KEY,
website character varying(350) DEFAULT ''::character varying NOT NULL,
quotes text DEFAULT ''::text NOT NULL,
biography text DEFAULT ''::text NOT NULL,
github character varying(350) DEFAULT ''::character varying NOT NULL,
skype character varying(350) DEFAULT ''::character varying NOT NULL,
jabber character varying(350) DEFAULT ''::character varying NOT NULL,
yahoo character varying(350) DEFAULT ''::character varying NOT NULL,
userscript character varying(128) DEFAULT ''::character varying NOT NULL,
template smallint DEFAULT 0 NOT NULL,
dateformat character varying(25) DEFAULT 'd/m/Y, H:i'::character varying NOT NULL,
facebook character varying(350) DEFAULT ''::character varying NOT NULL,
twitter character varying(350) DEFAULT ''::character varying NOT NULL,
steam character varying(350) DEFAULT ''::character varying NOT NULL,
push boolean DEFAULT false NOT NULL,
pushregtime timestamp without time zone DEFAULT timezone('utc'::text, now()) NOT NULL,
mobile_template smallint DEFAULT 1 NOT NULL,
closed boolean DEFAULT false NOT NULL,
template_variables jsonb DEFAULT '{}'::jsonb NOT NULL
)`)
if e != nil {
panic(e.Error())
}
e = tx.Exec("ALTER TABLE profiles ADD CONSTRAINT profiles_users_fk FOREIGN KEY(counter) references users(counter) ON DELETE CASCADE")
if e != nil {
panic(e.Error())
}
if e = tx.Commit(); e != nil {
panic(e.Error())
}
}