NilovAlexander

NilovAlexander / mv_controller_dir_oracle.sql

Created November 22, 2016 13:57

	CREATE MATERIALIZED VIEW mv_controller_dir_oracle AS
	SELECT
	con.gis_id AS PP_ID,
	cmr3.NAME_DIRECTION,
	cmr3.day_timestamp,
	cmr3.plan_time_on,
	cmr3.plan_time_off,
	CASE WHEN length(string_agg(cmr3.periods, ', ' :: TEXT ORDER BY cmr3.start_timestamp)) > 3999
	THEN left(string_agg(cmr3.periods, ', ' :: TEXT ORDER BY cmr3.start_timestamp), 3995) \|\| '...'
	ELSE string_agg(cmr3.periods, ', ' :: TEXT ORDER BY cmr3.start_timestamp) END AS periods,

NilovAlexander / tornado_example.py

Created June 6, 2016 16:10

	# coding: utf-8

	from datetime import datetime

	import tornado.gen

	from handlers.ets_mission import MissionHandler
	from handlers.ets_waybill import WaybillHandler
	from utils.check_date_overlap import (
	check_date_overlap, CHECK_DATE_OVERLAP_ERROR_MESSAGE)

NilovAlexander / query.sql

Last active May 19, 2016 14:18

	SELECT
	company_name,
	(last_name \|\| ' ' \|\| SUBSTRING(first_name, 1, 1) \|\| '.' \|\| SUBSTRING(middle_name, 1, 1) \|\| '.') employee_name,
	to_char(inner_date_create, 'YYYY-DD-MM HH24:MI') date_create,
	sum(inner_assigned) assigned,
	sum(inner_complete) complete,
	sum(inner_fail) fail
	FROM (
	SELECT
	company."NAME" company_name,

NilovAlexander / tornado+asyncio+sqlalchemy+aiopg.py

Last active April 23, 2017 10:12

	# -- coding: utf-8 --
	from random import randint

	import tornado.concurrent
	import tornado.platform.asyncio
	import tornado.web

	from aiopg.sa import create_engine as aiopg_create_engine
	import asyncio