Robert Smith robsmith1776

## New gist
Hello Save this to gists

## CTE
WITH Table_name (
	Table
,Columns

	)
AS (
	SELECT Statement
	)

## 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/')

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

## 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.

"""

## 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>'

## 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;

## 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>

## 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)
#

## 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
	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/')
	"""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.

	"""
	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>'
	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;
	<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>
	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)
	#
	#!/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