Tominov Sergey ikenfin

## TestReader.php
<?php

	require_once('AbstractAdvertisementXMLReader.php');

	class TestReader extends AbstractAdvertisementXMLReader {

		private $num = 0;

		public function parseRow() {

## postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

## gismeteo-city-codes.md

      
              1 file
            
          
              1 fork
            
          
              1 comment
            
          
              5 stars
            
          
                ikenfin
                / gismeteo-city-codes.md
            
            
              Created
              October 27, 2016 07:59
            
              
                Список кодов городов XML API Gismeteo
              
          
Код
Название


27611
Москва


26062
С.-Петербург


29865
Абакан


22550
Архангельск


34880
Астрахань


29838
Барнаул


34214
Белгород


31510
Благовещенск
	<?php

	require_once('AbstractAdvertisementXMLReader.php');

	class TestReader extends AbstractAdvertisementXMLReader {

	private $num = 0;

	public function parseRow() {
	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
Код	Название
27611	Москва
26062	С.-Петербург
29865	Абакан
22550	Архангельск
34880	Астрахань
29838	Барнаул
34214	Белгород
31510	Благовещенск