| # This is not used unless SQLALCHEMY_BINDS is not present | |
| SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://{username}:{password}@{hostname}/{database}?charset=utf8' | |
| SQLALCHEMY_BINDS = { | |
| 'master': 'mysql+pymysql://{username}:{password}@{hostname}/{database}?charset=utf8', | |
| 'slave': 'mysql+pymysql://{username}:{password}@{hostname}/{database}?charset=utf8' | |
| } |
| # Tab completion for scp/sftp/ssh based on ~/.ssh/config | |
| complete -o default -o nospace -W "$(/usr/bin/ruby -ne 'puts $_.split(/[\s,]+/)[1..-1].reject { |h| h.match /\*|\?/ } if $_.match /^\s*Host[s]*\s+/' < ~/.ssh/config)" scp sftp ssh 2>/dev/null |
| from flask import Flask, redirect, url_for, session, request | |
| from flask_oauth import OAuth | |
| SECRET_KEY = 'development key' | |
| DEBUG = True | |
| GITHUB_CLIENT_ID = '<Client-ID>' | |
| GITHUB_CLIENT_SECRET = '<Client-Secret>' | |
Eric Bidelman has documented some of the common workflows possible with headless Chrome over in https://developers.google.com/web/updates/2017/04/headless-chrome.
If you're looking at this in 2016 and beyond, I strongly recommend investigating real headless Chrome: https://chromium.googlesource.com/chromium/src/+/lkgr/headless/README.md
Windows and Mac users might find using Justin Ribeiro's Docker setup useful here while full support for these platforms is being worked out.
| from datetime import datetime, date | |
| from sqlalchemy.orm.query import Query | |
| def render_query(statement, bind=None): | |
| """ | |
| Generate an SQL expression string with bound parameters rendered inline | |
| for the given SQLAlchemy statement. | |
| WARNING: This method of escaping is insecure, incomplete, and for debugging | |
| purposes only. Executing SQL statements with inline-rendered user values is |
| from flask import Flask, render_template_string, request | |
| class CustomFlask(Flask): | |
| jinja_options = Flask.jinja_options.copy() | |
| jinja_options.update(dict( | |
| block_start_string='<%', | |
| block_end_string='%>', | |
| variable_start_string='%%', | |
| variable_end_string='%%', | |
| comment_start_string='<#', |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| #!/bin/bash | |
| # | |
| # PostgreSQL Backup Script Ver 1.0 | |
| # http://autopgsqlbackup.frozenpc.net | |
| # Copyright (c) 2005 Aaron Axelsen <axelseaa@amadmax.com> | |
| # | |
| # This script is based of the AutoMySQLBackup Script Ver 2.2 | |
| # It can be found at http://sourceforge.net/projects/automysqlbackup/ | |
| # | |
| # The PostgreSQL changes are based on a patch agaisnt AutoMySQLBackup 1.9 |
| // swap the keybindings for paste and paste_and_indent | |
| { "keys": ["super+v"], "command": "paste_and_indent" }, | |
| { "keys": ["super+shift+v"], "command": "paste" } |
