Skip to content

Instantly share code, notes, and snippets.

View dapi's full-sized avatar
🌴
Open for offers

Danil Pismenny dapi

🌴
Open for offers
View GitHub Profile
@dapi
dapi / 20101219150921_add_typus_attributes_to_users.rb
Created December 19, 2010 18:20
Use Devise authentication for Typus 3.0
class AddTypusAttributesToUsers < ActiveRecord::Migration
def self.up
add_column :users, :role, :string
add_column :users, :status, :boolean, :null=>false, :default=>true
User.find(1).update_attribute(:role,'admin')
end
def self.down
remove_column :users, :role
remove_column :users, :status
@dapi
dapi / mysql2_downcase_adapter.rb
Created July 6, 2011 05:50
mysql2 adapter with downcasing column names
# -*- coding: utf-8 -*-
# Just use 'mysql2_downcase' adapter in database.yml
#
require 'active_record/connection_adapters/mysql2_adapter'
module ActiveRecord
class Base
# Establishes a connection to the database that's used by all Active Record objects.
def self.mysql2_downcase_connection(config)
@dapi
dapi / gist:6a9d61e95019b4f5666a
Created December 4, 2015 05:24
Виджет для upload
<script type="text/javascript">
window.art=window.art||[],art.load=function(t,r){art.appId=t,art.config=r=r||{};var e=r.forceSSL||"https:"===document.location.protocol,a=document.createElement("script");a.type="text/javascript",a.async=!0,a.src="http://cdn.1clickanalytics.ru/widget.js";var n=document.getElementsByTagName("script")[0];n.parentNode.insertBefore(a,n);for(var o=function(t){return function(){art.push([t].concat(Array.prototype.slice.call(arguments,0)))}},c=["clearEventProperties","identify","setEventProperties","track","unsetEventProperty"],s=0;s<c.length;s++)art[c[s]]=o(c[s])},art.load("100003");
</script>
@dapi
dapi / bitrix_authorization.rb
Created January 4, 2012 20:38
1С-Битрикс авторизация на рельсах (ruby on rails)
# Расширение контроллера
#
module Bitrix::Authorization
def current_user
@current_user ||= find_from_cookie
end
def login_user(user)
logout_user if current_user
@current_user = user
@dapi
dapi / list_queries.sql
Created June 7, 2017 11:45
Finding and killing long running queries on PostgreSQL
SELECT pid, now() - query_start as duration, query, state FROM pg_stat_activity WHERE now() - query_start > interval '5 minutes';
;; cancel
SELECT pg_cancel_backend(__pid__);
;; kill stucked
SELECT pg_terminate_backend(__pid__);
# Это такой замысловатый спосбо добавить поддомен в запрос для rspec
#
# Использовать:
#
# RSpec.configure do |config|
# config.include ProcessWithRequestSubdomain, type: :controller
#
module ProcessWithRequestSubdomain
extend ActiveSupport::Concern
@dapi
dapi / invoice.pdf.erb
Created July 26, 2019 15:26
Invoce PDF
<!doctype html>
<html>
<head>
<meta charset='utf-8' />
<style>
body {
font-size: 12px;
}
table {
border-collapse: collapse;
@dapi
dapi / kill_springs.sh
Created August 2, 2019 13:37
Kill hanged ruby spring servers
#!/usr/bin/env
echo "Kill them all!!!"
ps axfww | grep spring | grep "app\|server" | awk '{ print $1 }' | xargs kill -9
@dapi
dapi / SSL_OCSP_Stapling.conf
Last active October 17, 2019 21:50
nginx ssl conf
# Проверка HTTPS на Comodo:
# https://sslanalyzer.comodoca.com/?url=https%3A%2F%2Fkiiiosk.ru
# Проверка на Trusted
# https://www.digicert.com/help/
# source:
# https://support.comodo.com/index.php?/Default/Knowledgebase/Article/View/1091/1/certificate-installation--nginx
ssl_stapling on;
@dapi
dapi / paraquest-arrow-editor.js
Last active October 23, 2019 10:37
Проверять тут - http://sketch.paperjs.org/
var title = new PointText(new Point(200, 10));
title.content="click - установка стрелки, drug - перемещени, shift-drug - вращение"
var debug = new PointText(new Point(200, 50));
var currentArrow;
var raster = new Raster({
source: "https://paraquest.ru/uploads/slide/image/20/2018-11-12_21_10_04-Улет_с_Аламнера3.png",
position: view.center
});