filipelenfers

//I like to use oh-my-zsh so I added it as default terminal on vs code

//First define your default distro for wsl
//run this on cmd.exe
//wslconfig /l
//wslconfig /s Ubuntu

//On user Settings add:
{
    "terminal.integrated.shell.windows": "C:\\WINDOWS\\System32\\bash.exe",

filipelenfers

#Login as root
sudo su

#create jdk directory
mkdir /opt/jdk

#uncompress, change to your file name
tar -zxf jdk-8u5-linux-x64.tar.gz -C /opt/jdk

#check if files are there

filipelenfers

#!/bin/sh
#
# redis - this script starts and stops the redis-server daemon
#
# chkconfig:   - 85 15 
# description:  Redis is a persistent key-value database
# processname: redis-server
# config:      /etc/redis/redis.conf
# config:      /etc/sysconfig/redis
# pidfile:     /var/run/redis/redis.pid

filipelenfers

#Download
wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/7u75-b13/jdk-7u75-linux-x64.rpm"
 
#Install
sudo rpm -Uvh jdk-7u75-linux-x64.rpm
#if you already had the openjdk installed before, you need to add the alternatives to this version of java.
 
#Check
#java -version

filipelenfers

#Download
wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/7u75-b13/jdk-7u75-linux-x64.rpm"

#Install
rpm -Uvh jdk-7u75-linux-x64.rpm
#if you already had the openjdk installed before, you need to add the alternatives to this version of java.

#Check
java -version

filipelenfers

#Download and unzip
wget http://download.redis.io/releases/redis-2.8.19.tar.gz
tar xzvf redis-2.8.19.tar.gz

#Deps to compile and test
sudo yum install gcc tcl

#Compile
cd redis-2.8.19
cd deps

filipelenfers

replace in varchars fields
find: ([a-zA-Z0-9_]*)\s*varchar\(\d{2,4}\)
replace: replace(replace(t.$1,'|','-'),'"','¬') $1

date format to YYYY/MM/DD HH:MM:SS
find: ([a-zA-Z0-9_]*)\s+(datetime|timestamp){1}
replace: TO_CHAR(t.$1,'YYYY/MM/DD HH24:MI:SS') $1

clean other types
find: ([a-zA-Z0-9_]*)\s+(integer|bigint){1}

filipelenfers

1033edge.com
11mail.com
123.com
123box.net
123india.com
123mail.cl
123qwe.co.uk
150ml.com
15meg4free.com
163.com

filipelenfers

config.vm.provider :virtualbox do |vb|
  #   # Don't boot with headless mode
  #   vb.gui = true
  #
  #   # Use VBoxManage to customize the VM. For example to change memory:
    vb.customize ["modifyvm", :id, "--memory", "1024"] #memory to 1GB
    vb.customize ["modifyvm", :id, "--cpuexecutioncap", "50"] #limit the use of cpu to 50%
    vb.customize ["modifyvm", :id, "--ioapic", "on"] #needed to use more cpus
    vb.customize ["modifyvm", :id, "--cpus", "2"]  #enable 2 cpus for the vm
  end

filipelenfers

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp
import java.util.Date

import scala.slick.driver.MySQLDriver.simple._
//import scala.slick.driver.H2Driver.simple._
//MultipleDB examples, DAL included: https://github.com/slick/slick-examples/blob/2.0.0-M3/src/main/scala/com/typesafe/slick/examples/lifted/MultiDBExample.scala e https://github.com/slick/slick-examples/blob/2.0.0-M3/src/main/scala/com/typesafe/slick/examples/lifted/MultiDBCakeExample.scala