Skip to content

Instantly share code, notes, and snippets.

View filipelenfers's full-sized avatar

Filipe Pais Lenfers filipelenfers

View GitHub Profile
1033edge.com
11mail.com
123.com
123box.net
123india.com
123mail.cl
123qwe.co.uk
150ml.com
15meg4free.com
163.com
@filipelenfers
filipelenfers / replacesOnVarchar
Last active August 29, 2015 14:04
Regex detect varchar fields replace bad chars
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
filipelenfers / redisInstall
Last active August 29, 2015 14:16
Install redis on Centos 6
#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
filipelenfers / installJdk
Last active August 29, 2015 14:16
Install oracle jdk 7 on Centos 6
#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
filipelenfers / installJmeter.sh
Last active August 29, 2015 14:16
JMeter Server on CentOS
#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
filipelenfers / redis-server
Created March 11, 2015 18:20 — forked from tahajahangir/redis-server
init.d file for redis-server
#!/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
filipelenfers / rest.scala
Created June 14, 2013 16:05 — forked from stonegao/rest.scala
Rest using Finagle
class Respond extends Service[Request, Response] with Logger {
def apply(request: Request) = {
try {
request.method -> Path(request.path) match {
case GET -> Root / "todos" => Future.value {
val data = Todos.allAsJson
debug("data: %s" format data)
Responses.json(data, acceptsGzip(request))
}
case GET -> Root / "todos" / id => Future.value {
#!/bin/bash
# must run as root!!!
RUBY_VERSION=1.9
RUBY_PATCH=1.9.3-p429
#RUBY_PATCH=1.9.3-p286
#RUBY_PATCH=1.9.3-p194
aptitude install -y build-essential libssl-dev libreadline-dev zlib1g-dev libyaml-dev libffi-dev
libraryDependencies ++= {
Seq("drools-compiler", "drools-core","drools-jsr94", "drools-decisiontables", "knowledge-api")
.map("org.drools" % _ % "5.5.0.Final")
}
@filipelenfers
filipelenfers / ResolversOnBuild.sbt
Created July 23, 2013 12:53
resolvers on build sbt
resolvers ++= Seq("snapshots" at "http://oss.sonatype.org/content/repositories/snapshots",
"staging" at "http://oss.sonatype.org/content/repositories/staging",
"releases" at "http://oss.sonatype.org/content/repositories/releases",
"JBoss Thirdparty Releases" at "https://repository.jboss.org/nexus/content/repositories/thirdparty-releases"
)