Maxim Kolesnikov xCASx

## get-icons-for-site-list.py
'''
This programm gets url list from text file and request the pages, finds favicons and save them into current directory
'''
import urllib
from urllib.request import urlopen
from urllib.request import urlretrieve
from bs4 import BeautifulSoup

'''had to add this windows specific block to handle this bug in urllib2:
http://bugs.python.org/issue11220

## Excel duplicate in order rows
// Next formula makes 12 copies in C for each row in A in a determined order

=ИНДЕКС(A:A;ОКРВВЕРХ(ЧСТРОК(C$1:C1)/12;1))

## postrgresql
-- export to csv
Copy (Select * From tablename) To 'C:\\dev\01.csv' With CSV;

-- import from csv
COPY tablename FROM 'C:\data\01.csv' DELIMITER ',' CSV HEADER;

-- Create a Range From 1 to 10
SELECT * FROM GENERATE_SERIES(1, 10)

## regex
Find: ref=\"tns:(.*)\"
Replace: name=\"\1\" type=\"tns:\1\"

## Git ignore SSL check commands
# Turn off global property
git config http.sslVerify false

# Turn off ssl check for current operation
git -c http.sslVerify=false clone https://domain.com/path/to/git

## Maven install DB driver to local repo
mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.4 -Dpackaging=jar -Dfile=ojdbc6.jar -DgeneratePom=true

## Oracle JDK for Ubuntu
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer

#  If you have multiple java installed on your system, you can select with : sudo update-alternatives --config java

## MockitoTemplate
 /**
 * Fixture for test.
 */
private static final class Fixture {
    @Mock
    CustomManager customManager;

    @Mock
    CustomRepository repository;

## git_pull_rebase
# Force all new branches to automatically use rebase
git config --global branch.autosetuprebase always

# This will tell git to always pull with rebase.
git config --global --bool pull.rebase true

# After these two commands ~/.gitconfig will look like this:
[branch]
	autosetuprebase = always
[pull]

## client-config.wsdd
<?xml version="1.0" encoding="UTF-8"?>
<deployment name="defaultClientConfig" xmlns="http://xml.apache.org/axis/wsdd/"
xmlns:java="http://xml.apache.org/axis/wsdd/providers/java">

    <handler name="log" type="java:org.apache.axis.handlers.LogHandler" >
        <parameter name="LogHandler.fileName" value="axis1.log"/>
    </handler>

    <globalConfiguration>
        <requestFlow>
	'''
	This programm gets url list from text file and request the pages, finds favicons and save them into current directory
	'''
	import urllib
	from urllib.request import urlopen
	from urllib.request import urlretrieve
	from bs4 import BeautifulSoup

	'''had to add this windows specific block to handle this bug in urllib2:
	http://bugs.python.org/issue11220
	// Next formula makes 12 copies in C for each row in A in a determined order

	=ИНДЕКС(A:A;ОКРВВЕРХ(ЧСТРОК(C$1:C1)/12;1))
	-- export to csv
	Copy (Select * From tablename) To 'C:\\dev\01.csv' With CSV;

	-- import from csv
	COPY tablename FROM 'C:\data\01.csv' DELIMITER ',' CSV HEADER;

	-- Create a Range From 1 to 10
	SELECT * FROM GENERATE_SERIES(1, 10)
	# Turn off global property
	git config http.sslVerify false

	# Turn off ssl check for current operation
	git -c http.sslVerify=false clone https://domain.com/path/to/git
	sudo add-apt-repository ppa:webupd8team/java
	sudo apt-get update
	sudo apt-get install oracle-java7-installer

	# If you have multiple java installed on your system, you can select with : sudo update-alternatives --config java
	/**
	* Fixture for test.
	*/
	private static final class Fixture {
	@Mock
	CustomManager customManager;

	@Mock
	CustomRepository repository;
	# Force all new branches to automatically use rebase
	git config --global branch.autosetuprebase always

	# This will tell git to always pull with rebase.
	git config --global --bool pull.rebase true

	# After these two commands ~/.gitconfig will look like this:
	[branch]
	autosetuprebase = always
	[pull]
	<?xml version="1.0" encoding="UTF-8"?>
	<deployment name="defaultClientConfig" xmlns="http://xml.apache.org/axis/wsdd/"
	xmlns:java="http://xml.apache.org/axis/wsdd/providers/java">

	<handler name="log" type="java:org.apache.axis.handlers.LogHandler" >
	<parameter name="LogHandler.fileName" value="axis1.log"/>
	</handler>

	<globalConfiguration>
	<requestFlow>