stset

Server setup

BASE

sudo apt update

apt-get curl install

stset

Container list

docker ps

List of container id

docker ps -q

Stop all containers

docker stop $(docker ps -q)

Remove all containers

docker rm $(docker ps -q)

Run dump in docker

stset

<?php
// Used in https://github.com/im4aLL/roolith-event

class Event {
    private static $events = [];

    public static function listen($name, $callback) {
        self::$events[$name][] = $callback;
    }

stset

### KILL
kill -9 $(pgrep -f phpstorm)

### CANHE ENVAROMENT
service docker stop && service nginx start && service postgresql start && service php7.3-fpm start

service nginx stop && service postgresql stop && service php7.3-fpm stop && service docker start 

stset

FULL TEXT SEARCH [LIKE]

  select id, name, surname from user_profiles
  where concat(id, ' ', name, ' ', surname) ILIKE '%mik%'

select
  c.name,
  sum(IF(price >= 1000, 1, 0)) as max,