Home › Archive for Python

Python

Create SQL databases

Posted on by 
#!/usr/bin/env python3
 
 
import mysql.connector
 
weblist = ["ericafox", "ericascott", "ericastevens", "samarafox", "samarastevens", "williamscott", "woodytheduck"]
 
 
mydb = mysql.connector.connect(
  host="localhost",
  user="superuser",
  passwd="superuserpassword"
)
 
mycursor = mydb.cursor()
 
for site in weblist:
    mycursor.execute("CREATE DATABASE " + site)

Python Cloudfront Invalidation Script

Posted on by 
#!/usr/bin/env python3
 
from datetime import tzinfo, timedelta, datetime, date, timezone
import boto3
 
cf = boto3.client('cloudfront')
 
timestamp=str(datetime.timestamp(datetime.today()))
 
distributions=cf.list_distributions()
 
if distributions['DistributionList']['Quantity'] > 0:
  for distribution in distributions['DistributionList']['Items']:
    print("Distribution Id: " + distribution['Id'])
    print("Time: " + timestamp)
    cf.create_invalidation(
        DistributionId=distribution['Id'],
        InvalidationBatch={
            'Paths': {
                'Quantity': 1,
                'Items': [
                    '/*',
                ]
            },
            'CallerReference': timestamp
        }
    )
else:
   print("Error - No CloudFront Distributions Detected.")