Skip to content

Instantly share code, notes, and snippets.

emerge -cv ruby
Calculating dependencies... done!
dev-lang/ruby-1.8.7_p357 pulled in by:
app-editors/vim-7.3.409
dev-ruby/json-1.5.4-r1
dev-ruby/mysql-ruby-2.8.2
dev-ruby/racc-1.4.6-r1
dev-ruby/rake-0.8.7-r6
dev-ruby/rdoc-3.12
postgres=# explain analyze SELECT 1 FROM words WHERE word LIKE '%xxxprivate.co.za' AND reverse(word) LIKE reverse('xxxprivate.co.za%') limit 1;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..23300.06 rows=1 width=0) (actual time=581.073..581.073 rows=1 loops=1)
-> Seq Scan on words (cost=0.00..23300.06 rows=1 width=0) (actual time=581.070..581.070 rows=1 loops=1)
Filter: ((word ~~ '%xxxprivate.co.za'::text) AND (reverse(word) ~~ '%az.oc.etavirpxxx'::text))
Total runtime: 581.522 ms
(4 rows)
postgres=# explain analyze SELECT 1 FROM words WHERE reverse(word) LIKE reverse('%xxxprivate.co.za') limit 1;
class Filtering
def initialize
@host = "localhost"
@db = "filter"
@user = "filter"
@password = "filter"
@port = 3306
end
def dstdomain(dom)
#db name:msg
#tables client, queue, templates
#I want to store messages queue and when needed to compose msg from templates.
#I have id field in each one of them
#
# in the queue I have template ID and client ID and I want to use one select to get all the data from both tables.
# so what relationship needed? I kind of go confused with belongs_to and has_many.
# thanks.
class Card < ActiveRecord::Base
set_table_name "card"
has_many :messages, :class_name => "MsgQueue"
end
class MsgQueue < ActiveRecord::Base
self.table_name = "msg_queue"
belongs_to :card
belongs_to :templates
end
@elico
elico / gist:6890837
Last active December 25, 2015 00:49
<?xml version="1.0" encoding="utf-8"?>
<!--
phpSysInfo language file Language: Hebrew translated by: Eliezer Croitoru
-->
<tns:translation language="hebrew" charset="utf-8"
xmlns:tns="http://phpsysinfo.sourceforge.net/translation" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://phpsysinfo.sourceforge.net/translation translation.xsd">
<expression id="001" name="title">
<exp>מידע המערכת</exp>
</expression>
@elico
elico / mux_routes.go
Created January 11, 2016 00:51
A trial to use gorilla mux router Walk function
package main
import (
"fmt"
"github.com/gorilla/mux"
"net/http"
)
func signupHandler(w http.ResponseWriter, request *http.Request) {
package main
import (
"crypto/hmac"
"crypto/sha256"
"fmt"
"github.com/elico/mux"
"io/ioutil"
"net"
"net/http"
@elico
elico / reverse-proxy.go
Created June 12, 2016 22:43
A reverse http caching proxy with example of how to override traffic to pass the cache.
package main
import (
"flag"
"github.com/lox/httpcache"
"github.com/lox/httpcache/httplog"
"log"
"net/http"
"net/http/httputil"
"os"
@elico
elico / Dockerfile
Created June 17, 2016 05:42
debian squeeze buildnode
FROM debian:squeeze
ENV DEBIAN_FRONTEND noninteractive
ADD sources.list /etc/apt/sources.list
RUN echo 'Acquire::Check-Valid-Until "false";' >/etc/apt/apt.conf.d/90ignore-release-date && apt-get update \
&& apt-get install -y wget \
&& wget -O - http://packages.vyos.net/vyos-release.gpg | apt-key add - \
&& echo "deb http://archive.debian.org/debian-backports/ squeeze-backports main" > /etc/apt/sources.list.d/bp.list \
&& apt-get update \