Skip to content

Instantly share code, notes, and snippets.

def csv_stream
sql = Request.where('created_at < ? AND client_id = ?', Time.now, 42).to_sql
Enumerator.new do |y|
conn = ActiveRecord::Base.connection.raw_connection
conn.copy_data("COPY (#{sql}) TO STDOUT WITH (FORMAT CSV, HEADER TRUE);") do
while (chunk = conn.get_copy_data)
y << chunk
end
end
version: '2.3'
services:
vector:
image: timberio/vector:latest-alpine
restart: unless-stopped
network_mode: host
container_name: vector-agregator
volumes:
- ./vector/vector.toml:/etc/vector/vector.toml:ro
services:
vector:
image: timberio/vector:latest-alpine
restart: unless-stopped
network_mode: host
volumes:
- ./vector/vector.toml:/etc/vector/vector.toml:ro
- /var/run/docker.sock:/var/run/docker.sock
# - /home/rails/project1:/app - если надо забирать логи с древнего проекта без контейнеров
version: "2.3"
services:
x-log: &log
options:
max-size: '50m'
max-file: '3'
driver: json-file
services:
@kinnalru
kinnalru / node-exporter.yaml
Last active December 6, 2021 08:10
node-exporter configuration
version: "2.3"
services:
x-log: &log
options:
max-size: '50m'
max-file: '3'
driver: json-file
services:
{
"$schema": "http://json-schema.org/draft-06/schema#",
"$comment": "Схема данных банка, в котором открыт счет",
"type": "object",
"properties": {
"name": {
"doc_description": "12123123",
"type": "string",
"minLength": 1,
"maxLength": 200,
@kinnalru
kinnalru / docker-compose.yml
Last active March 31, 2021 05:33
Portainer service description
version: "3.7"
x-log: &log
options:
max-size: '50m'
max-file: '3'
labels: com.docker.compose.service
driver: json-file
x-base: &base
@kinnalru
kinnalru / docker-compose.yml
Last active March 3, 2021 07:19
docker-compose.yml
version: "3.7"
x-base: &base
restart: unless-stopped
logging:
options:
max-size: '50m'
max-file: '3'
driver: json-file
@kinnalru
kinnalru / iframe_exmaple.rb
Created February 25, 2021 08:53
Iframe embed example
Lusnoc::Mutex.new('/some/key').synchronize do |mx|
# do some work
mx.renew if mx.need_renew? # manualy renew session if needed
# do other work
mx.renew if mx.need_renew? # manualy renew session if needed
# ...
rescue Lusnoc::ExpiredError => e
# Session was invalidated and mutex was lost!
end
@kinnalru
kinnalru / bench_http.rb
Created February 25, 2021 08:40
Скрипт для бенчмарка кешированных HTTP-соединений в ruby
require 'benchmark'
require 'timeout'
require 'logger'
require 'net/http'
require 'webrick'
require 'terminal-table'
require 'thin'
require 'colorize'
class Base