# encoding: utf-8
import MySQLdb
import requests
import json

db = MySQLdb.connect(host='localhost',
                     user='root',
                     passwd='',
                     db='ucoffee',
                     charset='utf8',
                     use_unicode=True,
                     port=3306)

db = MySQLdb.connect(host='ucoffee.cpktwzterboq.us-west-2.rds.amazonaws.com',
                     user='ucoffee',
                     passwd='uc0ff332016',
                     db='ucoffee',
                     charset='utf8',
                     use_unicode=True,
                     port=3306)

cur = db.cursor(MySQLdb.cursors.DictCursor)

or_id = 9950

query = "SELECT * from orders where or_id=%s;"%or_id
result = cur.execute(query)

subscription = "569185853B2449BC8E1DB74E0C4A7F6A"

for row in cur.fetchall():
    query = """
        INSERT INTO orders(or_date, or_discount, or_ship, or_invoice_id, or_status, or_subscription_id, or_tracking, or_shipcompany, users_id, ua_id, or_antifraud, or_coupon_name)
        VALUES ("{}", {}, {}, "{}", "{}", "{}", "{}", "{}", "{}", "{}", 0, "{}")
    """.format(row['or_date'], row['or_discount'], row['or_ship'], "", row['or_status'], subscription,
        "", "", row['users_id'], row['ua_id'], row['or_coupon_name'])
    print query

query = "SELECT * from orders_products where or_id=%s;" % or_id
result = cur.execute(query)

for row in cur.fetchall():

# {'op_date': datetime.datetime(2018, 1, 23, 14, 28, 8), 'op_quantity': 1L, 'pr_id': 1051L, 'op_grind_choice': u'capsule', 'or_id': 9888L, 'op_id': 12059L, 'op_custom_image': None, 'op_custom_desc': u'', 'op_custom_template': 0L, 'op_custom_name': u'', 'op_periodicity': 1L, 'op_price': 55.0}

    query = """
        INSERT INTO orders_products(or_id, op_date, op_quantity, pr_id, op_grind_choice, op_custom_image, op_custom_desc, op_custom_template, op_custom_name, op_periodicity, op_price)
        VALUES ("{}", "{}", {}, "{}", "{}", "{}", "{}", "{}", "{}", "{}", "{}")
    """.format(27126, row['op_date'], row['op_quantity'], row['pr_id'], row['op_grind_choice'], row['op_custom_image'],
     row['op_custom_desc'], row['op_custom_template'], row['op_custom_name'], row['op_periodicity'], row['op_price'])
    print query






Spot	ID	Bug	Iugu	Geração 2a (1a da Assinatura)	Pagto 2a (1a da Assinatura)	ID Brain
9888	Marcus de Mattos  (neurocirurgiao@yahoo.com.br)	Não geração de assinatura na Iugu	A138734CE0E3492CB2D020D6F1AE593A	2-mar	2-mar
9907	Felipe Luz  (felipeluz21@hotmail.com)	Não geração de assinatura na Iugu	6EB0EBBCA11644D5AC122544A4059D68	2-mar	2-mar
9950	Alexandre Barbosa (alexandrejb@hotmail.com)	Pagto 1a por Boleto. Não geração de assinatura na Iugu	569185853B2449BC8E1DB74E0C4A7F6A	2-mar	Aguardando cliente
10156	Milton Oliveira  (mlro@globo.com)	Não geração de assinatura na Iugu	CAD68728500842329E2A3E3D0C03FAEA	2-mar	2-mar
10438	Thalana Binotti (thaalana@hotmail.com)	Não geração de assinatura na Iugu	55B19BD45BDB40FC80A23B66664D4748	2-mar	Falha. LR: 51
10547	Fábio Madeira Peres  (fabinhomadeira@gmail.com)	Não geração de assinatura na Iugu	817516FDE24C4EF4B2FE044857939C2C	2-mar	2-mar
10552	Anderson Santos (andersonsc745@hotmail.com)	Não geração de assinatura na Iugu	8B51F4713EE04C30811FD1C23DDD7850	2-mar	2-mar