gigadot

BEGIN
  FOR c IN (SELECT table_name FROM user_tables)
    LOOP
      EXECUTE IMMEDIATE ('DROP TABLE "' || c.table_name || '" CASCADE CONSTRAINTS');
    END LOOP;
  EXECUTE IMMEDIATE 'PURGE RECYCLEBIN';
  FOR s IN (SELECT sequence_name FROM user_sequences)
    LOOP
      EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);
    END LOOP;

gigadot

SET FOREIGN_KEY_CHECKS = 0;
SET GROUP_CONCAT_MAX_LEN=32768;
SET @tables = NULL;
SELECT GROUP_CONCAT('`', table_name, '`') INTO @tables
  FROM information_schema.tables
  WHERE table_schema = (SELECT DATABASE());
SELECT IFNULL(@tables,'dummy') INTO @tables;

SET @tables = CONCAT('DROP TABLE IF EXISTS ', @tables);
PREPARE stmt FROM @tables;

gigadot

Instruction

1. Download and install python from https://www.python.org/downloads/ (Do not forget to check "Add Python 3.8 to PATH")
2. From https://stackoverflow.com/questions/49740073/installation-of-pipenv-on-windows-fails Update setuptools or pip, just in case.

pip install --upgrade setuptools
pip install --upgrade pip

or on Windows

gigadot

#### mkvmerge -o "video.mkv" "video.mp4" --language 0:eng "english.srt" --default-track 0

#### if video and subtitle have the same name, you can do replace all using:
   Find: (.*)
Replace: mkvmerge -o "$1.mkv" "$1.mp4" --language 0:eng "$1.srt" --default-track 0

#### one-liner code

for f in *.mkv; do v=$(basename $f .mkv); mkvmerge -o "$v-sub.mkv" "$v.mkv" --language 0:eng "$v.srt" --default-track 0; don

gigadot

1. chere - add windows context menu to start bash
2. rsync - popular sync tool
3. bind-utils - dig
4. openssh - openssh server

gigadot

# useUnicode=yes
# characterEncoding=UTF-8
# useSSL=false
spring.datasource.url=jdbc:mysql://localhost:3306/<dbname>?useSSL=false&useUnicode=yes&characterEncoding=UTF-8

gigadot

pom.xml

<dependency>
    <groupId>org.springframework.session</groupId>
    <artifactId>spring-session-data-redis</artifactId>
</dependency>
<dependency>
    <groupId>io.lettuce</groupId>
    <artifactId>lettuce-core</artifactId>

gigadot

#!/bin/bash

# Install zsh
# > sudo apt install zsh
# > chsh -s $(which zsh)
# On cygwin, use cygwin setup to install zsh and install fonts by downloading fonts and manually install on Windows

# Install oh-my-zsh
# > sh -c "$(curl -fsSL https://raw.github.com/robbyrussell/oh-my-zsh/master/tools/install.sh)"

gigadot

#/bin/bash

# Check if bridge-nf-call-iptables is enabled (1 if enabled)
# cat /proc/sys/net/bridge/bridge-nf-call-iptables
# Enable IP Forwarding
# echo 'net.ipv4.ip_forward=1' >> /etc/sysctl.conf
# sysctl --system

CONTAINER_NAME=kube
BRIDGED_NAME=br0