oliworx

Let's automate composer updates

Image by Randall Munroe, xkcd.com

---

What are we talking about

• Upgrading PHP packages only using composer
• Packages following semantic versioning only

oliworx

stages:
  - update-dependencies
  - code-style
  - build
  - test
  - deploy

composer-update:
  stage: update-dependencies
  only:

oliworx

SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH ) / 1024 / 1024) AS `Data (MB)`,
  ROUND((INDEX_LENGTH) / 1024 / 1024) AS `Index (MB)`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Total (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "my_db_name"
ORDER BY

oliworx

# rsync-homedir-excludes
#
# A list of files to exclude when backing up *nix home directories using rsync.
#
# Author: Ruben Barkow-Kuder <https://github.com/rubo77/rsync-homedir-excludes>
# Version: 2019-11-30
#
# #Usage:
#    USER=<homedir username here>
#    rsync -aP --exclude-from=rsync-homedir-excludes.txt /home/$USER/ /media/$USER/linuxbackup/home/$USER/

oliworx

alias gco='git checkout'
alias glg='git log'
alias gst='git status'
alias gbr='git branch'
alias grm='git rebase master'
alias gcom='git checkout master'
alias glo="git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit"

alias dco='docker-compose'
alias dphp='docker-compose exec -u www-data app php'

oliworx

{% if post.tags.size > 0 %}
  Tag{% if post.tags.size > 1 %}s{% endif %}:
  {{ post.tags | sort | join: ", " }}
{% endif %}

oliworx

Reset and sync local repository with remote branch

git fetch origin
git reset --hard origin/master
git clean -f -d

Your local branch is now an exact copy (commits and all) of the remote branch.

oliworx

-- source: https://blogs.sap.com/2016/10/27/create-tenant-database-sap-hana-express-sap-hana-academy/
-- create a tenant 
CREATE DATABASE TESTDB SYSTEM USER PASSWORD Initial1; 
-- add the script server service
ALTER DATABASE TESTDB ADD 'scriptserver'

-- or hit two birds with one stone 
CREATE DATABASE TESTDB ADD 'scriptserver' SYSTEM USER PASSWORD Initial1;

-- Tenants by default start automatically, but can be started and stopped manually as well

oliworx

#!/bin/sh
sudo chmod -x /usr/bin/gnome-keyring-daemon

oliworx

CREATE DATABAESE MYNEWDB;

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON MYNEWDB.* TO 'newuser'@'localhost';

FLUSH PRIVILEGES;