seanbehan

https://www.smashwords.com/books/download/145431/8/latest/0/0/the-secrets-to-ebook-publishing-success.epub
https://www.smashwords.com/books/download/305/8/latest/0/0/smashwords-book-marketing-guide.epub
https://www.smashwords.com/books/download/490949/8/latest/0/0/demon-eyes.epub
https://www.smashwords.com/books/download/502729/8/latest/0/0/a-christmas-gift.epub
https://www.smashwords.com/books/download/512951/8/latest/0/0/mendacium-preview.epub
https://www.smashwords.com/books/download/516986/8/latest/0/0/blood-and-snow-book-81-ashas-kisses.epub
https://www.smashwords.com/books/download/517114/8/latest/0/1/vijay-dinanath-chouhanthe-dark-memoirs-of-an-angry-young-man_80pct_sample.epub
https://www.smashwords.com/books/download/517363/8/latest/0/0/social-media-success-how-to-do-social-media-in-30-minutes-or.epub
https://www.smashwords.com/books/download/517406/8/latest/0/0/poems-and-thoughts.epub
https://www.smashwords.com/books/download/517442/8/latest/0/0/spherical-trigonometry-mathematical-analysis-of-spheri

seanbehan

create temporary table temp (symbol varchar(255), open decimal, high decimal, low decimal, close decimal, volume varchar(255), date date );

create table if not exists stocks (id serial primary key, symbol varchar(255), open decimal, high decimal, low decimal, close decimal, volume varchar(255), date date, created_at timestamp, updated_at timestamp);

copy temp (symbol, date, open, high, low, close, volume) from '/path/to/file.csv' with delimiter ',' csv header;

delete from stocks using temp where stocks.date = temp.date and stocks.symbol = temp.symbol;

insert into stocks (symbol, open, high, low, close, volume, date) select symbol, open, high, low, close, volume, date from temp;

seanbehan

-- cd ~/Library/Application\ Support/Google/Chrome/Default
-- sqlite3 History

.schema urls
.tables

select * from urls where url like "%something%";

seanbehan

import requests
from lxml import html
from os.path import basename

XPATH = dict(
    downloads='//a[contains(@href, "download")]/@href',
    pdfs='//td[contains(text(), "PDF")]/..//a/@href',
    s3url='//meta[contains(@content, "amazon")]/@content',
)

seanbehan

from itsdangerous import URLSafeTimedSerializer

from project import app


def generate_confirmation_token(email):
    serializer = URLSafeTimedSerializer(app.config['SECRET_KEY'])
    return serializer.dumps(email, salt=app.config['SECURITY_PASSWORD_SALT'])

seanbehan

HTML for basic chat app

<div id="chat">
  <div class="msg">
    lorem...
    </div>
  <div class="msg">
    lorem...
  </div>

seanbehan

'''
Run the following commands (bc. gists don't allow directories)

pip install flask django dj-database-url psycopg2

mkdir -p app/migrations
touch app/__init__.py app/migrations/__init__.py
mv models.py app/
python manage.py makemigrations
python manage.py migrate

seanbehan

require 'sidekiq/api'

# 1. Clear retry set

Sidekiq::RetrySet.new.clear

# 2. Clear scheduled jobs 

Sidekiq::ScheduledSet.new.clear

seanbehan

seanbehan

.aaa
.aarp
.abarth
.abb
.abbott
.abbvie
.abc
.able
.abogado
.abudhabi