利用 AWS Price List API 生成中国区的 EC2 价格表

$ python setup.py biuld
$ python setup.py install

import awscnpricing#接下来设置环境变量：
#AWSPRICING_USE_CACHE设置为1，使用Cache文件
os.environ['AWSPRICING_USE_CACHE'] = "1"#Cache文件的位置：
os.environ['AWSPRICING_CACHE_PATH'] = "/tmp/awscnpricing"#Cache文件的有效期：24小时
os.environ['AWSPRICING_CACHE_MINUTES'] = "1440"

#设置需要得到的价格表信息：
offering_class = 'standard' 
此处设置为standard，得到的是标准Reserved Instance的价格，如果设置成convertible，则可以得到可变RI的价格。
#设置输出文件名：
output = 'cn_ec2_standard_price.xlsx' 

ec2_offer_code = 'AmazonEC2'
ec2_offer = awscnpricing.offer(ec2_offer_code)
ec2_file_path = os.getenv('AWSPRICING_CACHE_PATH')
ec2_file_name = 'offer_{}_current'.format(ec2_offer_code)
ec2_cache_file = os.path.join(ec2_file_path, ec2_file_name)
if os.path.exists(ec2_cache_file):
    with open(ec2_cache_file, 'r') as load_f:
        ec2offer = json.load(load_f)
else:
    offers = requests.get(
        'https://pricing.cn-north-1.amazonaws.com.cn/offers/v1.0/cn/index.json'
    )
    ec2_offer_path = offers.json()['offers']['AmazonEC2']['currentVersionUrl']
    ec2offer = requests.get(
        'https://pricing.cn-north-1.amazonaws.com.cn%s' % ec2_offer_path
    ).json() 

PerchaseOption = ['All Upfront', 'Partial Upfront', 'No Upfront']
LeaseContractLength = ['1yr', '3yr'] 
for sku, data in ec2offer['products'].items():
    if data['productFamily'] != 'Compute Instance':
        # skip anything that's not an EC2 Instance
        continue
    ec2_type = data['attributes']['instanceType']

    ec2_os = data['attributes']['operatingSystem']

    site = data['attributes']['location']
    ec2_region = ""
    if site == "China (Beijing)":
        ec2_region = "cn-north-1"
    if site == "China (Ningxia)":
        ec2_region = "cn-northwest-1" 

for yr in LeaseContractLength:
for p_option in PerchaseOption:
try:
a_price = ec2_offer.reserved_upfront(
ec2_type,
operating_system=ec2_os,
lease_contract_length=yr,
tenancy=data['attributes']['tenancy'],
license_model=data['attributes']['licenseModel'],
preinstalled_software=data['attributes']['preInstalledSw'],
offering_class=offering_class,
purchase_option=p_option,
region=ec2_region,
capacity_status=data['attributes']['capacitystatus']
) except:
a_price = "0"
try:
o_price = ec2_offer.ondemand_hourly(
ec2_type,
operating_system=ec2_os,
tenancy=data['attributes']['tenancy'],
preinstalled_software=data['attributes']['preInstalledSw'],
license_model=data['attributes']['licenseModel'],
region=ec2_region,
capacity_status=data['attributes']['capacitystatus']
)
except:
o_price = "0"