zimmicz

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.4
-- Dumped by pg_dump version 9.5.4
DROP SCHEMA IF EXISTS test;
CREATE SCHEMA test;
SET statement_timeout = 0;
SET lock_timeout = 0;

zimmicz

const express = require("express")
const app = express()
const { Pool } = require("pg")
const SphericalMercator = require("sphericalmercator")
const pool = new Pool({
    host: "localhost",
    port: 15432,
    user: "postgres",
    database: "postgres"
})

zimmicz

# -*- coding: utf-8 -*-
#!/usr/bin/env python

import requests
from bs4 import BeautifulSoup

URL = "https://www.postgresql.org/docs/VERSION/static/sql-commands.html"
VERSIONS = ["10.0", "9.6", "9.5", "9.4", "9.3", "9.2", "9.1", "9.0", "8.4", "8.3", "8.2", "8.1", "8.0", "7.4", "7.3", "7.2", "7.1", "7.0"]
CAPS = {}

zimmicz

#!/usr/bin/env python
# -*- coding: utf-8 -*- #
from __future__ import unicode_literals

# This file is only used if you use `make publish` or
# explicitly specify it as your config file.

import os
import sys
sys.path.append(os.curdir)

zimmicz

class ConstructionObjectDetailUpdateController {
  constructor(
    SeriesService,
    ModalService,
    ChecklistService,
    Restangular,
  ) {
    this.seriesService = SeriesService;
    this.modalService = ModalService;
    this.checklistService = ChecklistService;

zimmicz

https://www.zimmi.cz/posts/feed.xml

zimmicz

{
  "header": "1. den: Sučany – Malý Kriváň – Chata Pod Chlebom",
  "perex": [
    "Víkend po Silvestru mívá skoro každý volno, ale často se nikam nejede. Proto je to ideální příležitost vyrazit na hory. Chtěli jsme za sněhem, ne moc daleko a trochu netradičně. Volba padla na dvoudenní přechod hřebene Malé Fatry s nástupem z jihu od <a data-url='data/stories/story-20180106-fatra/sucany.json'>Sučan</a> a sestupem ze <a data-url='data/stories/story-20180106-fatra/stoh.json'>Stohu</a> do <a data-url='data/stories/story-20180106-fatra/kralovany.json'>Kraľovan</a>. Obě obce leží v údolí Váhu a spojuje je přímé vlakové spojení.",
    "Vyjíždíme brzo ráno z Brna, necháváme auto v <a data-url='data/stories/story-20180106-fatra/sucany.json'>Sučanech</a> na návsi a v deset ráno vycházíme. Na druhý den se vrátíme z <a data-url='data/stories/story-20180106-fatra/kralovany.json'>Kraľovan</a> vlakem."
  ],
  "sections": [
    {
      "header": "Na Malý Kriváň",
      "bbox": [[0,0], [10,10]],

zimmicz

[{
  "type": "Feature",
  "geometry": {
    "type": "Point",
    "coordinates": [15.2713086,47.6182603]
  },
  "properties": {
    "id": 1,
    "name": "Frühstückspension Seeberghof"
  }

zimmicz

WITH data AS (
    SELECT
        product.id,
        i.year_month,
        date_part('year', i.year_month) as year,
        date_part('month', i.year_month) as month,
        ( random()*100 )::integer as value
    FROM generate_series('2018-01-01'::date, '2018-12-01'::date, '1 month') as i(year_month)
    CROSS JOIN generate_series(1,1,1) product(id)
),

zimmicz

{
	"scenes": [{
		"sphere": {
			"type": "SEGMENT",
			"context": {
				"photoFullUrl": "https://multiscenecloud02.blob.core.windows.net/multiscenecloud-data-02/sus_pce_pasport/spheremap/29/@PHOTO_NAME@_2048@[email protected]",
				"photoPreviewUrl": "https://multiscenecloud02.blob.core.windows.net/multiscenecloud-data-02/sus_pce_pasport/spheremap/29/@PHOTO_NAME@_0128@[email protected]",
				"profile": {
					"type": "LADYBUG",
					"params": {