Skip to content

Instantly share code, notes, and snippets.

View shingara's full-sized avatar

Cyril Mougel shingara

  • regate.io
  • Pau ( France )
View GitHub Profile
2015-01-01 00:00:00 +0000 2015-02-01 00:00:00 +0000 2015-03-01 00:00:00 +0000 2015-04-01 00:00:00 +0000 2015-05-01 00:00:00 +0000
customer 29945 30753 59602 21938 0
new_customer 28634 29409 56428 20182 0
repeat_customer 1311 1344 3174 1756 0
---
[dev]
localhost ansible_connection=local
#!/bin/bash
sudo apt-get install -y software-properties-common
sudo apt-add-repository ppa:ansible/ansible
sudo apt-get update
sudo apt-get install -y ansible
sudo ansible-galaxy install --force shingara.base
sudo ansible-galaxy install --force shingara.shingara-common
sudo ansible-galaxy install --force shingara.ruby
---
- name: Install fig
sudo: true
sudo_user: root
shell: "curl -L https://github.com/docker/fig/releases/download/1.0.1/fig-`uname -s`-`uname -m` > /usr/local/bin/fig; chmod +x /usr/local/bin/fig"
- name: install package needed by gems
sudo: true
sudo_user: root
apt: name={{item}} state=latest
---
- hosts: dev
sudo: true
roles:
- shingara.base
- shingara.ruby
- angstwad.docker_ubuntu
- hosts: dev
sudo_user: vagrant
FROM ruby:2.1
RUN apt-get update -qq && apt-get install -y build-essential libpq-dev libxslt-dev libxml2-dev nodejs postgresql-client npm nodejs-legacy
RUN mkdir /comparsport
WORKDIR /comparsport
ADD Gemfile /comparsport/Gemfile
ADD Gemfile.lock /comparsport/Gemfile.lock
RUN bundle install
## Install javascript dependencies
require 'decorators/application_decorator'
class IndexApiDecorator < ApplicationDecorator
def meta
{
:count => count,
:name => name
}
end
comparsports_development=# explain SELECT "products".* FROM "products" INNER JOIN "merchant_products" ON "merchant_products"."product_id" = "products"."id" INNER JOIN "merchant_products_option_values" ON "merchant_products_option_values"."merchant_product_id" = "merchant_products"."id" INNER JOIN "option_values" ON "option_values"."id" = "merchant_products_option_values"."option_value_id" WHERE "products"."active" = 't' AND "products"."brand_id" = 1943 AND (price_min >= 0) ORDER BY products.merchant_product_active_count desc LIMIT 20 OFFSET 0;
Limit (cost=34508.48..34508.53 rows=20 width=510)
-> Sort (cost=34508.48..34522.45 rows=5586 width=510)
Sort Key: products.merchant_product_active_count
-> Hash Join (cost=16341.25..34359.84 rows=5586 width=510)
Hash Cond: (merchant_products_option_values.option_value_id = option_values.id)
-> Hash Join (cost=14902.40..31919.25 rows=5586 width=514)
Hash Cond: (merchant_products_option_values
shingara@flibustier: ~/prog/daxium/pictbase-web/vagrant features/new_theming ⚡
$ ssh [email protected] printenv [10:19:52]
USER=pictbase_dev
LOGNAME=pictbase_dev
HOME=/home/pictbase_dev
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
MAIL=/var/mail/pictbase_dev
SHELL=/bin/zsh
SSH_CLIENT=192.168.111.1 64116 22
SSH_CONNECTION=192.168.111.1 64116 192.168.111.222 22