Robert Smith robsmith1776

## gist:1447456649e0f5ad81dd
def ResultIter(cursor, arraysize=1000):
    'An iterator that uses fetchmany to keep memory usage down'
    while True:
        results = cursor.fetchmany(arraysize)
        if not results:
            break
        for result in results:
            yield result

## mssql_to_csv.py
#!/usr/bin/env python
"""
simple mssql -> csv file example using pymssql
@author jack@tinybike.net
"""
import csv
import datetime
import pymssql
from decimal import Decimal

## Pandas_EmailColumn.py
from tqdm import tqdm
from time import sleep
import pandas as pd

mycsv = "C:\\Users\\rob\\Downloads\\contest-standings-17968412\\contest-standings-17968412.csv"
mycsv2 = "C:\\Users\\rob\\Downloads\\contest-standings-17968412\\testEmail.csv"


# items = range(1,100)
#

## App.config
<configuration>

  <system.diagnostics>
    <sources>
      <source name="System.Net.Sockets" tracemode="protocolonly">
        <listeners>
          <add name="System.Net.Sockets" type="System.Diagnostics.TextWriterTraceListener" initializeData="network.log" />
        </listeners>
      </source>
    </sources>

## NewAutPost.cs
public class WebClientEx : WebClient
{
    private CookieContainer _cookieContainer = new CookieContainer();

    protected override WebRequest GetWebRequest(Uri address)
    {
        WebRequest request = base.GetWebRequest(address);
        if (request is HttpWebRequest)
        {
            (request as HttpWebRequest).CookieContainer = _cookieContainer;

## kill_attrs.py
from BeautifulSoup import BeautifulSoup

def _remove_attrs(soup):
    for tag in soup.findAll(True):
        tag.attrs = None
    return soup


def example():
    doc = '<html><head><title>test</title></head><body id="foo" onload="whatever"><p class="whatever">junk</p><div style="background: yellow;" id="foo" class="blah">blah</div></body></html>'

## gist:efac554de78203ed92fc
"""splits a large text file into smaller ones, based on line count

Original is left unmodified.

Resulting text files are stored in the same directory as the original file.

Useful for breaking up text-based logs or blocks of login credentials.

"""

## gist:3fd22d4b2e150634e673
# from urllib.request import urlopen # python 3 syntax

## DefaultDict
class CSOFEmail(object):
    def __init__(self):
        self.mail = imaplib.IMAP4_SSL('outlook.office365.com', port='993')
        self.mail.login('rsmith@freshaddress.com', 'Hardcore8*')
        print("logged in")
        self.folder_info = defaultdict(dict)


    def grab_folder_list(self):
        response, dir_list = self.mail.list(directory='INBOX/CSOF.NET/')

## CTE
WITH Table_name (
	Table
,Columns

	)
AS (
	SELECT Statement
	)
	def ResultIter(cursor, arraysize=1000):
	'An iterator that uses fetchmany to keep memory usage down'
	while True:
	results = cursor.fetchmany(arraysize)
	if not results:
	break
	for result in results:
	yield result
	#!/usr/bin/env python
	"""
	simple mssql -> csv file example using pymssql
	@author jack@tinybike.net
	"""
	import csv
	import datetime
	import pymssql
	from decimal import Decimal
	from tqdm import tqdm
	from time import sleep
	import pandas as pd

	mycsv = "C:\\Users\\rob\\Downloads\\contest-standings-17968412\\contest-standings-17968412.csv"
	mycsv2 = "C:\\Users\\rob\\Downloads\\contest-standings-17968412\\testEmail.csv"


	# items = range(1,100)
	#
	<configuration>

	<system.diagnostics>
	<sources>
	<source name="System.Net.Sockets" tracemode="protocolonly">
	<listeners>
	<add name="System.Net.Sockets" type="System.Diagnostics.TextWriterTraceListener" initializeData="network.log" />
	</listeners>
	</source>
	</sources>
	public class WebClientEx : WebClient
	{
	private CookieContainer _cookieContainer = new CookieContainer();

	protected override WebRequest GetWebRequest(Uri address)
	{
	WebRequest request = base.GetWebRequest(address);
	if (request is HttpWebRequest)
	{
	(request as HttpWebRequest).CookieContainer = _cookieContainer;
	from BeautifulSoup import BeautifulSoup

	def _remove_attrs(soup):
	for tag in soup.findAll(True):
	tag.attrs = None
	return soup


	def example():
	doc = '<html><head><title>test</title></head><body id="foo" onload="whatever"><p class="whatever">junk</p><div style="background: yellow;" id="foo" class="blah">blah</div></body></html>'
	"""splits a large text file into smaller ones, based on line count

	Original is left unmodified.

	Resulting text files are stored in the same directory as the original file.

	Useful for breaking up text-based logs or blocks of login credentials.

	"""
	class CSOFEmail(object):
	def __init__(self):
	self.mail = imaplib.IMAP4_SSL('outlook.office365.com', port='993')
	self.mail.login('rsmith@freshaddress.com', 'Hardcore8*')
	print("logged in")
	self.folder_info = defaultdict(dict)


	def grab_folder_list(self):
	response, dir_list = self.mail.list(directory='INBOX/CSOF.NET/')