postgresql

To get started

import freeflowuniverse.crystallib.installers.db.postgresql

mut installer:= postgresql.get()!

installer.start()!

example heroscript

!!postgresql.install
    path: ''
    passwd: 'asecret'

use psql

uses our hero configure output and jq command line trick

#export PGPASSWORD=`hero configure -c postgres -i default -s | jq -r '.passwd'`
psql -U 'root' -h localhost

to use in other installer

//e.g. in server configure function

import freeflowuniverse.crystallib.installers.db.postgresql

mut mydbinstaller:=postgresql.get()!
mydbinstaller.start()!

// now create the DB
mydbinstaller.db_create('gitea')!

fn get(args_ ArgsGet) !&Postgresql

fn heroscript_default() !string

fn play(args_ PlayArgs) !

fn switch(name string)

switch instance to be used for postgresql

struct ArgsGet {
pub mut:
	name string
}

///////FACTORY

struct InstallArgs {
pub mut:
	reset bool
}

struct PlayArgs {
pub mut:
	heroscript string // if filled in then plbook will be made out of it
	plbook     ?playbook.PlayBook
	reset      bool
}

struct Postgresql {
pub mut:
	name         string = 'default'
	path         string
	passwd       string
	container_id string
}

fn (mut server Postgresql) check() !

fn (mut server Postgresql) db() !pg.DB

fn (mut server Postgresql) db_create(name_ string) !

fn (mut server Postgresql) db_delete(name_ string) !

fn (mut server Postgresql) db_exists(name_ string) !bool

fn (mut self Postgresql) destroy() !

fn (mut self Postgresql) install(args InstallArgs) !

fn (mut self Postgresql) install_start(args InstallArgs) !

fn (mut server Postgresql) path_config() !pathlib.Path

fn (mut server Postgresql) path_data() !pathlib.Path

fn (mut server Postgresql) path_export() !pathlib.Path

fn (mut self Postgresql) reload() !

load from disk and make sure is properly intialized

fn (mut self Postgresql) restart() !

fn (mut self Postgresql) running() !bool

fn (mut self Postgresql) start() !

fn (mut self Postgresql) stop() !