Igor Hatarist hatarist

## aiohttp_flood.py
#!/usr/bin/env python3
import asyncio
import aiohttp
import ujson


async def get(semaphore, session, url):
    async with semaphore as sem:
        return await session.get(url)

## ilovepusheen.py
from telegram import TelegramApi
from flask import Flask, request, jsonify

import settings


tg = TelegramApi(settings.API_TOKEN)
app = Flask(__name__)

tg.set_webhook(url=settings.BASE_URL + settings.WEBHOOK_URL)

## fucking_sanic.py
from sanic.exceptions import RequestTimeout
from sanic.server import HttpProtocol


class NoTimeoutHttpProtocol(HttpProtocol):
    """
    Doesn't complain about request timeouts to the logger.

    Usage:
        app = Sanic()

## clickhouse_join_date_range.sql
  :) CREATE TABLE ranges (id UInt64, date_start Date, date_end Date) ENGINE = TinyLog;

  :) INSERT INTO ranges SELECT rowNumberInAllBlocks() AS id, least(dates[1], dates[2]) AS date_start, greatest(dates[1], dates[2]) AS date_end FROM (SELECT arrayJoin(arrayMap(d -> [today() - d - rand64(d) % 10, yesterday() - d - rand(d) % 10], range(10))) AS dates);

  :) CREATE TABLE dates (id UInt64, date Date) ENGINE = TinyLog;

  :) INSERT INTO dates SELECT rowNumberInAllBlocks() AS id, date FROM (SELECT arrayJoin(arrayMap(d -> today() - rand64(d) % 10, range(10))) AS date);


## clickhouse-curl-examples.md

      
              1 file
            
          
              1 fork
            
          
              1 comment
            
          
              6 stars
            
          
                hatarist
                / clickhouse-curl-examples.md
            
            
              Last active
              February 15, 2023 01:09
            
          
    создаем таблицу
❯ curl -d "" "http://127.0.0.1:8123/?query=CREATE+TABLE+test+(x+UInt32,+y+String,+z+String)+ENGINE+=+TinyLog;"

смотрим формат входящих данных для VALUES
❯ cat example.values
(1, 'foo', 'bar'),
(2, 'foo', 'baz'),

(3, 'fxx', 'bxx')

  
## flask-login-navbar-example.html
{# include this template right at the beginning of the <body> tag in your base.html #}

<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">

        {# +- title, login_required, urls #}
        {# +-- url, login_required, title #}
        {% set elements = [
          ("Index", True, [
            (url_for('webui.index'), True, "Index")

## slack.fullname-with-username.user.js
// ==UserScript==
// @name         Slack: Full Name (@username)
// @namespace    http://hatari.st/
// @version      0.1
// @description  nuff said
// @author       igor@hatari.st
// @match        https://*.slack.com/messages/*
// ==/UserScript==

(function() {

## goatse.go
package main
import "fmt"

func main() {
    hellotxt := `
    * * * * * * * * * * * * * * * * * * * * * * * * *
    * goatse / hello.jpg world                      *
    *                                               *
    * /     \             \            /    \       *
    *|       |             \          |      |      *

## config.fish
# ~/.config/fish/config.fish:

# Shell integration breaks utilites like scp or rsync because of the excessive output.
# We will load it only if the shell is actually interactive.
if status --is-interactive
  . $HOME/.iterm2_shell_integration.fish
end

## ensure_csrf_cookie_mixin.py
from django.utils.decorators import method_decorator
from django.views.decorators.csrf import ensure_csrf_cookie


class EnsureCsrfCookieMixin(object):
    """
    Ensures that the CSRF cookie will be passed to the client.
    NOTE:
        This should be the left-most mixin of a view.
    """
	#!/usr/bin/env python3
	import asyncio
	import aiohttp
	import ujson


	async def get(semaphore, session, url):
	async with semaphore as sem:
	return await session.get(url)
	from telegram import TelegramApi
	from flask import Flask, request, jsonify

	import settings


	tg = TelegramApi(settings.API_TOKEN)
	app = Flask(__name__)

	tg.set_webhook(url=settings.BASE_URL + settings.WEBHOOK_URL)
	from sanic.exceptions import RequestTimeout
	from sanic.server import HttpProtocol


	class NoTimeoutHttpProtocol(HttpProtocol):
	"""
	Doesn't complain about request timeouts to the logger.

	Usage:
	app = Sanic()
	:) CREATE TABLE ranges (id UInt64, date_start Date, date_end Date) ENGINE = TinyLog;

	:) INSERT INTO ranges SELECT rowNumberInAllBlocks() AS id, least(dates[1], dates[2]) AS date_start, greatest(dates[1], dates[2]) AS date_end FROM (SELECT arrayJoin(arrayMap(d -> [today() - d - rand64(d) % 10, yesterday() - d - rand(d) % 10], range(10))) AS dates);

	:) CREATE TABLE dates (id UInt64, date Date) ENGINE = TinyLog;

	:) INSERT INTO dates SELECT rowNumberInAllBlocks() AS id, date FROM (SELECT arrayJoin(arrayMap(d -> today() - rand64(d) % 10, range(10))) AS date);
	{# include this template right at the beginning of the <body> tag in your base.html #}

	<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
	<ul class="nav navbar-nav">

	{# +- title, login_required, urls #}
	{# +-- url, login_required, title #}
	{% set elements = [
	("Index", True, [
	(url_for('webui.index'), True, "Index")
	// ==UserScript==
	// @name Slack: Full Name (@username)
	// @namespace http://hatari.st/
	// @version 0.1
	// @description nuff said
	// @author igor@hatari.st
	// @match https://.slack.com/messages/
	// ==/UserScript==

	(function() {
	package main
	import "fmt"

	func main() {
	hellotxt := `
	* * * * * * * * * * * * * * * * * * * * * * * * *
	* goatse / hello.jpg world *
	* *
	* / \ \ / \ *
	\| \| \ \| \|
	# ~/.config/fish/config.fish:

	# Shell integration breaks utilites like scp or rsync because of the excessive output.
	# We will load it only if the shell is actually interactive.
	if status --is-interactive
	. $HOME/.iterm2_shell_integration.fish
	end
	from django.utils.decorators import method_decorator
	from django.views.decorators.csrf import ensure_csrf_cookie


	class EnsureCsrfCookieMixin(object):
	"""
	Ensures that the CSRF cookie will be passed to the client.
	NOTE:
	This should be the left-most mixin of a view.
	"""