pawl

from sqlalchemy import create_engine, Column, ForeignKey, Integer
from sqlalchemy.orm import relationship, scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('mysql://root@localhost/test?charset=utf8mb4',
                       convert_unicode=True,
                       echo=True)
session = scoped_session(sessionmaker(autocommit=False,
                                      autoflush=False,
                                      bind=engine))

pawl

from sqlalchemy import create_engine, Column, ForeignKey, Integer, TEXT
from sqlalchemy.orm import relationship, scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('mysql://root@localhost/test?charset=utf8mb4',
                       convert_unicode=True,
                       echo=True)
session = scoped_session(sessionmaker(autocommit=False,
                                      autoflush=False,
                                      bind=engine))

pawl

import codecs
import requests
import time

# this could be different, but it works for my application, but the content-type definitely matters
fileHeaders = {
    'Content-Type': 'application/octet-stream;charset=text/html;charset=UTF-8'
}

url = 'www.yourfile.com/your.zip'

pawl

sess = requests.session()

# you may have other get/post requests before you can get to the download page for the file
url = 'https://example.com/report.zip'

# this may be different for you, i just copied this from an existing request (using fiddler)
file_headers = {
    'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
    'Accept-Language': 'en-US,en;q=0.8',
    'User-Agent': 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.0; Trident/5.0)',

pawl

from sqlalchemy import create_engine, Column, ForeignKey, Integer
from sqlalchemy.orm import relationship, scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('mysql://root@localhost/test?charset=utf8mb4',
                       convert_unicode=True)
session = scoped_session(sessionmaker(autocommit=False,
                                      autoflush=False,
                                      bind=engine))
Base = declarative_base()

pawl

from sqlalchemy import create_engine, Column, ForeignKey, Integer
from sqlalchemy.orm import relationship, scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('mysql://root@localhost/test?charset=utf8mb4',
                       convert_unicode=True)
session = scoped_session(sessionmaker(autocommit=False,
                                      autoflush=False,
                                      bind=engine))
Base = declarative_base()

pawl

import cProfile
import pstats
import contextlib
import uuid

from sqlalchemy import create_engine, Column, ForeignKey, Binary
from sqlalchemy.orm import relationship, scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy_utils import UUIDType

pawl

from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker

engine = create_engine('mysql://root@localhost/test')
db_session = scoped_session(sessionmaker(bind=engine))

db_session.execute('''
    INSERT INTO user (first_name, last_name, username, email)
    VALUES ("blah", "blah", "blah", "[email protected]");
''')

pawl

        <Node id="4" name="Front Door Lock" location="" basic="4" generic="64" specific="3" type="Secure Keypad Door Lock" listening="false" frequentListening="true" beaming="true" routing="true" max_baud_rate="40000" version="4" secured="true" query_stage="Complete">
            <Manufacturer id="3b" name="Schlage">
                <Product type="6341" id="5044" name="BE469NXCEN Touchscreen DeadBolt" />
            </Manufacturer>
            <CommandClasses>
                <CommandClass id="32" name="COMMAND_CLASS_BASIC" version="1" request_flags="4" issecured="true" mapping="98">
                    <Instance index="1" />
                </CommandClass>
                <CommandClass id="34" name="COMMAND_CLASS_APPLICATION_STATUS" version="1" request_flags="4" innif="true">
                    <Instance index="1" />

pawl

from jsonschema import validate, Schema

# A sample schema, like what we'd get from json.load()
schema = {
    "type": "object",
    "properties": {
        "price": {"type": "number"},
        "name": {"type": "string"},
    },
}