ysdede

Linux shell:
```bash
sudo -u postgres psql -c "CREATE DATABASE optuna_db;"
sudo -u postgres psql -c "CREATE USER optuna_user WITH PASSWORD 'password';"
sudo -u postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE optuna_db to optuna_user;"
```

Window:
```cmd
psql -U postgres -W -c "CREATE DATABASE optuna_db;"

ysdede

import contextlib
import json
import signal
import sys
from subprocess import PIPE, Popen, call
import click

import jessetk2.utils as utils
from optuna import samplers
import optuna

ysdede

git clone https://github.com/odoo/odoo.git

 psql -U postgres -W -c "CREATE DATABASE odoo_db1;"
 psql -U postgres -W -c "CREATE USER odoo_user1;"
 psql -U postgres -W -c "GRANT ALL PRIVILEGES ON DATABASE odoo_db1 to odoo_user1;"
 
 pip install setuptools wheel
 pip install -r https://raw.githubusercontent.com/odoo/odoo/15.0/requirements.txt
 
 

ysdede

#!/bin/bash
### BEGIN INIT INFO
# Provides:          influxd
# Required-Start:    $all
# Required-Stop:     $remote_fs $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start the InfluxDB process
### END INIT INFO

ysdede

wget -qO- https://repos.influxdata.com/influxdb.key | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/influxdb.gpg > /dev/null
export DISTRIB_ID=$(lsb_release -si); export DISTRIB_CODENAME=$(lsb_release -sc)
echo "deb [signed-by=/etc/apt/trusted.gpg.d/influxdb.gpg] https://repos.influxdata.com/${DISTRIB_ID,,} ${DISTRIB_CODENAME} stable" | sudo tee /etc/apt/sources.list.d/influxdb.list > /dev/null

sudo apt-get update && sudo apt-get install influxdb2

sudo chmod +x /etc/init.d/influxdb
sudo chown root:root /etc/init.d/influxdb
sudo update-rc.d influxdb defaults
sudo update-rc.d influxdb enable

ysdede

sudo apt-get install apt-transport-https ca-certificates dirmngr
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv E0C56BD4

echo "deb https://repo.clickhouse.com/deb/stable/ main/" | sudo tee \
    /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update

sudo apt-get install -y clickhouse-server clickhouse-client

sudo service clickhouse-server start

ysdede

sudo apt-get install -y apt-transport-https
sudo apt-get install -y software-properties-common wget
wget -q -O - https://packages.grafana.com/gpg.key | sudo apt-key add -
# Add this repository for stable releases:

echo "deb https://packages.grafana.com/oss/deb stable main" | sudo tee -a /etc/apt/sources.list.d/grafana.list
# Add this repository if you want beta releases:

echo "deb https://packages.grafana.com/oss/deb beta main" | sudo tee -a /etc/apt/sources.list.d/grafana.list
# After you add the repository:

ysdede

import json
import signal
import sys
from subprocess import PIPE, Popen, call

import jessetk.utils as utils
import optuna

# Multi-objective NSGAII hyperparameters optimization with Optuna
# Wraps Jesse ai's backtest function as an objective function

ysdede

import optuna
import statistics
import json

# This code snippet filters Optuna trials based on performance metrics and standard deviation
# and generates a results.csv file containing all results
# and a SEQ.py file containing all hyperparameters

study = optuna.create_study(study_name="Band5min-LongOnly", directions=["maximize", "maximize"],
                                storage="postgresql://optuna_user:optuna_password@localhost/optuna_db_3", load_if_exists=True)

ysdede

#!/bin/bash
sudo apt install -y lsb-core libllvm6.0 libpq5 pgdg-keyring wget --allow-unauthenticated

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update
sudo apt-get -y install postgresql-14