Igor Biryukov briu
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE tmp4(tmp_id integer); | |
| insert into tmp4 (tmp_id) values (1), (2), (null); | |
| select count(tmp_id <> 1) from tmp4; | |
| select count(*) from tmp4 where tmp_id <> 1; |
briu
/ sletat_req.xml
Created
June 29, 2017 09:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="urn:SletatRu:Contracts:Soap11Gate:v1" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="urn:SletatRu:DataTypes:AuthData:v1" xmlns:ins1="urn:SletatRu:DataTypes:XmlActualPriceData:v1" xmlns:ins2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ins3="urn:SletatRu:DataTypes:XmlOilTax:v1" xmlns:ins4="urn:SletatRu:DataTypes:XmlResourceData:v1" xmlns:ins5="urn:SletatRu:DataTypes:XmlResource:v1" xmlns:ins6="urn:SletatRu:DataTypes:XmlActualTourInfo:v1" xmlns:ins7="urn:SletatRu:DataTypes:XmlVisa:v1" xmlns:ins8="urn:SletatRu:DataTypes:VisaSurchargeExtendInfo:v1" xmlns:ins9="urn:SletatRu:DataTypes:CityCollection:v1" xmlns:ins10="urn:SletatRu:DataTypes:NamedDbObject:v1" xmlns:ins11="urn:SletatRu:DataTypes:DbObject:v1" xmlns:ins12="urn:SletatRu:DataTypes:CountryCollection:v1" xmlns:ins13="urn:SletatRu:DataTypes:Country:v |
briu
/ sletat.xml
Created
June 27, 2017 18:59
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="urn:SletatRu:Contracts:Soap11Gate:v1" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="urn:SletatRu:DataTypes:AuthData:v1" xmlns:ins1="urn:SletatRu:DataTypes:XmlActualPriceData:v1" xmlns:ins2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ins3="urn:SletatRu:DataTypes:XmlOilTax:v1" xmlns:ins4="urn:SletatRu:DataTypes:XmlResourceData:v1" xmlns:ins5="urn:SletatRu:DataTypes:XmlResource:v1" xmlns:ins6="urn:SletatRu:DataTypes:XmlActualTourInfo:v1" xmlns:ins7="urn:SletatRu:DataTypes:XmlVisa:v1" xmlns:ins8="urn:SletatRu:DataTypes:VisaSurchargeExtendInfo:v1" xmlns:ins9="urn:SletatRu:DataTypes:CityCollection:v1" xmlns:ins10="urn:SletatRu:DataTypes:NamedDbObject:v1" xmlns:ins11="urn:SletatRu:DataTypes:DbObject:v1" xmlns:ins12="urn:SletatRu:DataTypes:CountryCollection:v1" xmlns:ins13="urn:SletatRu:DataTypes:Country:v1" xmlns:ins14="urn:SletatRu:DataTypes: |
briu
/ questions.txt
Created
May 6, 2017 08:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ruby | |
| first_hash = {b: 2, c: 3} | |
| second_hash = first_hash | |
| second_hash[:b] = 5 | |
| first_hash[:b] |
briu
/ oil_duties.xml
Created
April 13, 2017 16:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| D, [2017-04-13T17:30:17.735708 #2334] DEBUG -- : HTTPI GET request to module.sletat.ru (net_http) | |
| D, [2017-04-13T17:30:17.753112 #2334] DEBUG -- : HTTPI GET request to module.sletat.ru (net_http) | |
| D, [2017-04-13T17:30:17.763008 #2334] DEBUG -- : HTTPI GET request to module.sletat.ru (net_http) | |
| I, [2017-04-13T17:30:20.526091 #2334] INFO -- : SOAP request: http://module.sletat.ru/XmlGate.svc | |
| I, [2017-04-13T17:30:20.526361 #2334] INFO -- : SOAPAction: "urn:SletatRu:Contracts:Soap11Gate:v1/Soap11Gate/ActualizePrice", Content-Type: text/xml;charset=UTF-8, Content-Length: 3069 | |
| D, [2017-04-13T17:30:20.526837 #2334] DEBUG -- : <?xml version="1.0" encoding="UTF-8"?> | |
| <SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="urn:SletatRu:Contracts:Soap11Gate:v1" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="urn:SletatRu:DataTypes:AuthData:v1" xmlns:ins1="urn:SletatRu:DataTypes:XmlActualPriceData:v1" xmlns:ins2="http://schema |
briu
/ level_actualizations_resp.rb
Created
April 13, 2017 15:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"success"=>true, | |
| "actualized"=>true, | |
| "price"=>38947, | |
| "transfer"=>true, | |
| "medical_insurance"=>true, | |
| "extras"=>[], | |
| "visa_price"=>0, | |
| "flights"=> | |
| [{"to"=> | |
| {"flight_no"=>"NN 5723", |
briu
/ actualizations_many.xml
Created
April 13, 2017 14:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| I, [2017-04-13T17:30:23.632335 #2334] INFO -- : SOAP response (status 200) | |
| D, [2017-04-13T17:30:23.633887 #2334] DEBUG -- : <?xml version="1.0"?> | |
| <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> | |
| <s:Body> | |
| <ActualizePriceResponse xmlns="urn:SletatRu:Contracts:Soap11Gate:v1"> | |
| <ActualizePriceResult xmlns:a="urn:SletatRu:DataTypes:XmlActualPriceData:v1" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> | |
| <a:ErrorMessage i:nil="true"/> | |
| <a:IsError>false</a:IsError> | |
| <a:IsFound>true</a:IsFound> | |
| <a:NextPossibleCommands xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true"/> |
briu
/ actulizations_oil_taxes.xml
Created
April 13, 2017 14:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| D, [2017-04-13T17:30:20.955321 #2334] DEBUG -- : HTTPI POST request to module.sletat.ru (net_http) | |
| I, [2017-04-13T17:30:21.119143 #2334] INFO -- : SOAP request: http://module.sletat.ru/XmlGate.svc | |
| I, [2017-04-13T17:30:21.119222 #2334] INFO -- : SOAPAction: "urn:SletatRu:Contracts:Soap11Gate:v1/Soap11Gate/ActualizePrice", Content-Type: text/xml;charset=UTF-8, Content-Length: 3069 | |
| D, [2017-04-13T17:30:21.119824 #2334] DEBUG -- : <?xml version="1.0" encoding="UTF-8"?> | |
| <SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="urn:SletatRu:Contracts:Soap11Gate:v1" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="urn:SletatRu:DataTypes:AuthData:v1" xmlns:ins1="urn:SletatRu:DataTypes:XmlActualPriceData:v1" xmlns:ins2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ins3="urn:SletatRu:DataTypes:XmlOilTax:v1" xmlns:ins4="urn:SletatRu:DataTypes:XmlResourceData:v1" xmlns:ins5="urn:SletatRu:DataTypes:XmlResourc |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <SOAP-ENV:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="urn:SletatRu:Contracts:Soap11Gate:v1" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins0="urn:SletatRu:DataTypes:AuthData:v1" xmlns:ins1="urn:SletatRu:DataTypes:XmlActualPriceData:v1" xmlns:ins2="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns:ins3="urn:SletatRu:DataTypes:XmlOilTax:v1" xmlns:ins4="urn:SletatRu:DataTypes:XmlResourceData:v1" xmlns:ins5="urn:SletatRu:DataTypes:XmlResource:v1" xmlns:ins6="urn:SletatRu:DataTypes:XmlActualTourInfo:v1" xmlns:ins7="urn:SletatRu:DataTypes:XmlVisa:v1" xmlns:ins8="urn:SletatRu:DataTypes:VisaSurchargeExtendInfo:v1" xmlns:ins9="urn:SletatRu:DataTypes:CityCollection:v1" xmlns:ins10="urn:SletatRu:DataTypes:NamedDbObject:v1" xmlns:ins11="urn:SletatRu:DataTypes:DbObject:v1" xmlns:ins12="urn:SletatRu:DataTypes:CountryCollection:v1" xmlns:ins13="urn:SletatRu:DataTypes:Country:v |
briu
/ postgresql_pages.sql
Last active
March 30, 2017 08:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create table t(id serial, s text); | |
| create index t_s on t(s); | |
| insert into t(s) values('AAA'); | |
| create view t_v as | |
| select '(0, '||lp||')' as ctid, | |
| case lp_flags | |
| when 0 then 'unused' |