Kuz Le techkuz

## HW1.sql
3
SELECT COUNT(*)
FROM yellowtripdata
WHERE tpep_pickup_datetime::date = '2021-01-15';

4
SELECT MAX(tip_amount), tpep_pickup_datetime::date
FROM public.yellowtripdata
WHERE EXTRACT(MONTH FROM tpep_pickup_datetime) = 1
GROUP BY tpep_pickup_datetime::date

## partial_example.py
from functools import partial


def test(a, b, c):
    print(a)
    print(b)
    print(c)


foo = partial(test, b=6, c=7)

## ex_exc.py
import sys
import traceback

class TracePrints(object):
  def __init__(self):
    self.stdout = sys.stdout
  def write(self, s):
    self.stdout.write("Writing %r\n" % s)
    traceback.print_stack(file=self.stdout)

## Dockerfile
FROM ubuntu:18.04

RUN apt-get update -y
RUN apt-get install wget -y

RUN wget https://github.com/fullstorydev/grpcurl/releases/download/v1.1.0/grpcurl_1.1.0_linux_x86_64.tar.gz

RUN tar -xvzf grpcurl_1.1.0_linux_x86_64.tar.gz
RUN chmod +x grpcurl
RUN mv grpcurl /usr/local/bin/grpcurl

## readme.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                techkuz
                / readme.md
            
            
              Created
              October 24, 2019 06:13
            
              
                Insert without extra indents vim
              
          
    Esc, :set paste

Paste

Esc, :wq

  
## kafkazookeeper.yaml
version: '2'
services:
  zookeeper:
    image: confluentinc/cp-zookeeper:5.3.1
    environment:
      ZOOKEEPER_CLIENT_PORT: 2181
      ZOOKEEPER_TICK_TIME: 2000
      ZOOKEEPER_SYNC_LIMIT: 2
    ports:
      - 2181:2181

## upd.sql
ALTER TABLE TableName UPDATE ColumnName = ValueOne WHERE AnotherColumn = ValueTwo

## example_req.py
import requests, json


subs_key = API_KEY
uri_base = 'https://api.cognitive.microsoft.com/inkrecognizer/v1.0-preview/recognize'
headers = {'Content-type': 'application/json',
           "Ocp-Apim-Subscription-Key": subs_key}

body = {}

## code.txt
curl https://pyenv.run | bash

## dolya.txt
Количество данных по выборке разделить на количество данных всего
	3
	SELECT COUNT(*)
	FROM yellowtripdata
	WHERE tpep_pickup_datetime::date = '2021-01-15';

	4
	SELECT MAX(tip_amount), tpep_pickup_datetime::date
	FROM public.yellowtripdata
	WHERE EXTRACT(MONTH FROM tpep_pickup_datetime) = 1
	GROUP BY tpep_pickup_datetime::date
	from functools import partial


	def test(a, b, c):
	print(a)
	print(b)
	print(c)


	foo = partial(test, b=6, c=7)
	import sys
	import traceback

	class TracePrints(object):
	def __init__(self):
	self.stdout = sys.stdout
	def write(self, s):
	self.stdout.write("Writing %r\n" % s)
	traceback.print_stack(file=self.stdout)
	FROM ubuntu:18.04

	RUN apt-get update -y
	RUN apt-get install wget -y

	RUN wget https://github.com/fullstorydev/grpcurl/releases/download/v1.1.0/grpcurl_1.1.0_linux_x86_64.tar.gz

	RUN tar -xvzf grpcurl_1.1.0_linux_x86_64.tar.gz
	RUN chmod +x grpcurl
	RUN mv grpcurl /usr/local/bin/grpcurl
	version: '2'
	services:
	zookeeper:
	image: confluentinc/cp-zookeeper:5.3.1
	environment:
	ZOOKEEPER_CLIENT_PORT: 2181
	ZOOKEEPER_TICK_TIME: 2000
	ZOOKEEPER_SYNC_LIMIT: 2
	ports:
	- 2181:2181
	import requests, json


	subs_key = API_KEY
	uri_base = 'https://api.cognitive.microsoft.com/inkrecognizer/v1.0-preview/recognize'
	headers = {'Content-type': 'application/json',
	"Ocp-Apim-Subscription-Key": subs_key}

	body = {}