Skip to content

Instantly share code, notes, and snippets.

Evgeniy OZ e-oz

Block or report user

Report or block e-oz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View q.sql
SELECT u.email, if(t1.email is null,0,1) is_t1, if(t2.email is null,0,1) is_t2,
th.email_from_name as channel,
lg.primary_location_id, lg.id as group_id,
-- t1 - sent emails
t1.facility_name as t1_facility_name,
t1.fname as t1_fname, t1.lname as t1_lname,
CONCAT_WS(', ', NULLIF(trim(t1.address),''), NULLIF(trim(t1.address2),'')) as t1_address,
CONCAT_WS(', ', NULLIF(trim(t1.city),''), NULLIF(trim(t1.state),''), NULLIF(trim(t1.zip),'')) as t1_city_state_zip,
CONCAT_WS(' ', cm.fname, cm.lname) as cm_name,
-- t2 - sent letters
View users.sql
SELECT distinct(u.email)
FROM user u
LEFT JOIN (select distinct(lower(email)) as email from email_campaign WHERE campaign_data_id = 14 AND
sent_date IS NOT NULL AND is_sent_successfully = 1 AND is_unsubscribed = 0) ec ON ec.email = u.email
LEFT JOIN tmp_anndsc_letter1 t1 ON t1.email = u.email
LEFT JOIN tmp_anndsc_letter2 t2 ON t2.email = u.email
WHERE LENGTH(u.email)>5 and (ec.email IS NOT NULL OR t1.email IS NOT NULL or t2.email IS NOT NULL)
AND u.id NOT IN (select user_id from file where type_id = 12 and internal_kind_id = 3)
View adobe.html
<!DOCTYPE html><html lang="en" class="wf-adobeclean-n4-active wf-adobeclean-n7-active wf-adobeclean-i4-active wf-adobeclean-i7-active wf-adobeclean-n3-active wf-sourcecodepro-n7-active wf-sourcecodepro-n4-active wf-active"><head class="at-element-marker" style="visibility:visible;"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta name="keywords" content="a, and, cancel, cancel_order, do, easy"><title>how to cancel monthly subscription to photoshop... |Adobe Community</title><meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://forums.adobe.com/8.0.3.6eafe9c/styles/jive-base.css" type="text/css" media="all"><link rel="stylesheet" href="https://forums.adobe.com/8.0.3.6eafe9c/styles/jive.css" type="text/css" media="all"><link rel="stylesheet" href="https://forums.adobe.com/8.0.3.6eafe9c/styles/jive-visor.css" type="text/css" media="all"><link rel="stylesheet" type="text/css" href="https://forums.adobe.com/plugins/machine-translation/r
@e-oz
e-oz / rustup.sh
Created Dec 25, 2016
Rust installation old way - sudo curl -sSf https://static.rust-lang.org/rustup.sh | sh -s -- --channel=beta
View rustup.sh
#!/bin/sh
# Copyright 2015 The Rust Project Developers. See the COPYRIGHT
# file at the top-level directory of this distribution and at
# http://rust-lang.org/COPYRIGHT.
#
# Licensed under the Apache License, Version 2.0 <LICENSE-APACHE or
# http://www.apache.org/licenses/LICENSE-2.0> or the MIT license
# <LICENSE-MIT or http://opensource.org/licenses/MIT>, at your
# option. This file may not be copied, modified, or distributed
# except according to those terms.
View .gitignore_global
# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so
# Packages #
View Deploying a Rust App to Google App Engine.mhtml
From: <Saved by Blink>
Subject: Deploying a Rust App to Google App Engine
Date: Sun, 2 Apr 2016 14:43:06 -0000
MIME-Version: 1.0
Content-Type: multipart/related;
type="text/html";
boundary="----MultipartBoundary--JS6VqEA1CaoIbspHBB61qNgbfVtHBPM813M6vK79n8----"
------MultipartBoundary--JS6VqEA1CaoIbspHBB61qNgbfVtHBPM813M6vK79n8----
Content-Type: text/html
@e-oz
e-oz / node-and-npm-in-30-seconds.sh
Last active Jul 11, 2016 — forked from isaacs/node-and-npm-in-30-seconds.sh
Use one of these techniques to install node and npm without having to sudo. Discussed in more detail at http://joyeur.com/2010/12/10/installing-node-and-npm/ Note: npm >=0.3 is *safer* when using sudo.
View node-and-npm-in-30-seconds.sh
echo 'export PATH=$HOME/local/bin:$PATH' >> ~/.bash_profile
. ~/.bash_profile
mkdir ~/local
mkdir ~/node-latest-install
cd ~/node-latest-install
curl http://nodejs.org/dist/node-latest.tar.gz | tar xz --strip-components=1
./configure --prefix=~/local
make install # ok, fine, this step probably takes more than 30 seconds...
curl https://www.npmjs.com/install.sh | sh
@e-oz
e-oz / deployment.sh
Created Jan 31, 2016
Rust code deployment
View deployment.sh
cargo build --release
sudo killall my_server $RESULT &> /dev/null || true
nohup target/release/my_server > nohup.out 2>&1 &
exit;
@e-oz
e-oz / nginx.conf
Created Jan 30, 2016
nginx proxy for Rust web server
View nginx.conf
server {
listen 80;
server_name api.server.domain;
keepalive_timeout 65;
location / {
proxy_set_header X-Forwarded-For $remote_addr;
proxy_pass http://localhost:3000;
proxy_temp_path /home/ec2-user/proxy_tmp;
}
}
View redis.init.d
#!/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/6379.conf
# config: /etc/sysconfig/redis
# pidfile: /var/run/redis_6379.pid
You can’t perform that action at this time.