quiver

# API https://dev.soracom.io/jp/docs/api/#!/Stats/get_stats_air_subscriber
"""
AWS Lambda function to retrieve traffic data from SORACOM and store them to Elasticsearch
"""

import datetime
import json
import requests

SORACOM_EMAIL="dummy@example.com"

quiver

Sometimes you want to retrieve EC2 insntances' region information.

You can query that information through instance metadata(169.254.169.254).

$ curl --silent http://169.254.169.254/latest/dynamic/instance-identity/document
{
  "privateIp" : "172.31.2.15",
  "instanceId" : "i-12341ee8",
  "billingProducts" : null,
 "instanceType" : "t2.small",

quiver

/*
 * http://www.graphviz.org/
 * $ dot -Tpng test.dot  -o test.png
 * rollback can be disabled
 */
digraph create_stack {
  CreateStack_API [shape=box];
  DeleteStack_API[shape=box];
  CREATE_COMPLETE [style=filled,color=blue]; // OK
  CREATE_FAILED [style=filled,color=red]; // NG

quiver

{
  "version": 2,
  "waiters": {
    "DataSourceAvailable": {
      "delay": 30,
      "operation": "GetDataSource",
      "maxAttempts": 60,
      "acceptors": [
        {
          "expected": "COMPLETED",

quiver

escape ^Z^\

vbell off

# don't show startup messages
startup_message off

# detach on hangup - if my dial-up session fails, screen will simply
# detach and let me re re-attach later.
autodetach on

quiver

copy users    from '/tmp/s3/allusers_pipe.txt'  with null as '' delimiter '|';
copy venue    from '/tmp/s3/venue_pipe.txt'                     delimiter '|';
copy category from '/tmp/s3/category_pipe.txt'  with null as '' delimiter '|';
copy date     from '/tmp/s3/date2008_pipe.txt'  with null as '' delimiter '|';
copy event    from '/tmp/s3/allevents_pipe.txt' with null as '' delimiter '|';
copy listing  from '/tmp/s3/listings_pipe.txt'  with null as '' delimiter '|';
copy sales    from '/tmp/s3/sales_tab.txt'      with null as '' delimiter '\t';

quiver

copy users    from '/tmp/s3/allusers_pipe.txt'  with null as '' delimiter '|';
copy venue    from '/tmp/s3/venue_pipe.txt'                     delimiter '|';
copy category from '/tmp/s3/category_pipe.txt'  with null as '' delimiter '|';
copy date     from '/tmp/s3/date2008_pipe.txt'  with null as '' delimiter '|';
copy event    from '/tmp/s3/allevents_pipe.txt' with null as '' delimiter '|';
copy listing  from '/tmp/s3/listings_pipe.txt'  with null as '' delimiter '|';
copy sales    from '/tmp/s3/sales_tab.txt'      with null as '' delimiter '\t';

quiver

create table users(
	userid integer not null,
	username char(8),
	firstname varchar(30),
	lastname varchar(30),
	city varchar(30),
	state char(2),
	email varchar(100),
	phone char(14),
	likesports boolean,

quiver

CREATE EXTENSION cstore_fdw;

CREATE SERVER cstore_server FOREIGN DATA WRAPPER cstore_fdw;

create foreign table users(
	userid integer not null,
	username char(8),
	firstname varchar(30),
	lastname varchar(30),
	city varchar(30),

quiver

# vim: set fileencoding=utf8
# http://docs.aws.amazon.com/AWSSimpleQueueService/latest/SQSDeveloperGuide/SQSDeadLetterQueue.html
# http://aws.typepad.com/aws/2014/01/amazon-sqs-new-dead-letter-queue.html

import json
import boto
from pprint import pprint

conn = boto.connect_sqs()
q1  = conn.create_queue('test_q1')