This SQL query performs an in-depth analysis of shipment data, focusing on delivery times, customer behavior, and carrier performance. The query is structured in three main parts: two Common Table Expressions (CTEs) and a final SELECT statement.
This was inspired by a post by Mehtab Karta.
Sometimes you just want the StrEnums in python to be sorted by their values to avoid duplicates and also to ensure that the code is maintainable.
This test takes the selected files and then runs a test using AST to see if the enum members are sorted by the member values.
If not the test fails.
I hereby claim:
To claim this, I am signing this object:
| @blueprint.route('/login', methods=['GET', 'POST']) | |
| def login(): | |
| """ | |
| If there is no login, redirect the user to the authorization url | |
| """ | |
| oauth_session = get_oauth_session() | |
| next = flask.request.args.get('next') | |
| authorization_url, state = oauth_session.create_authorization_url( | |
| redirect_uri=flask.url_for( | |
| '.authorized', |
| # Fulfil.IO Open Source Projects Individual Contributor License Agreement | |
| Thank you for your interest in contributing to Fulfil.IO Open Source Projects ("We" or "Us"). | |
| This contributor agreement ("Agreement") documents the rights granted by contributors to Us. To make this document effective, please sign it and send it to Us by electronic submission, following the instructions at . This is a legally binding document, so please read it carefully before agreeing to it. The Agreement may cover more than one software project managed by Us. | |
| ## 1. Definitions | |
| "You" means the individual who Submits a Contribution to Us. |
| touch /etc/apt/sources.list.d/pgdg.list | |
| echo "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main" > /etc/apt/sources.list.d/pgdg.list | |
| wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - | |
| apt-get update | |
| apt-get install -y postgresql-10 | |
| # now go to pgtune for config |
| import requests | |
| import pandas as pd | |
| from pandas.io.json import json_normalize | |
| import numpy as np | |
| import os | |
| import json | |
| from google.cloud import storage, bigquery | |
| import datetime | |
| import time | |
| from multiprocessing.pool import ThreadPool |
| from datetime import date | |
| from fulfil_client import Client | |
| fulfil = Client('<subdomain>', '<apikey>') | |
| # Fetch the report instance | |
| # The name can be obtained from the URL | |
| report = fulfil.interactive_report('account.invoice.revenue_by_month.ireport') | |
| # Trigger execution with the fields |
| import os | |
| import csv | |
| import sys | |
| from decimal import Decimal | |
| from fulfil_client import Client | |
| client = Client( | |
| os.environ.get('FULFIL_SUBDOMAIN'), | |
| os.environ.get('FULFIL_API_KEY'), |
| # -*- coding: utf-8 -*- | |
| """ | |
| scale.py | |
| Utilities to fetch weight from weighing scales | |
| :copyright: (c) 2016-2018 by Fulfil.IO Inc. | |
| :license: see LICENSE for details. | |
| """ | |
| from collections import namedtuple |