#This Script will use Paginator to print result for each bucket, executed in multiple threads
import boto3
import threading
import os.path

ACCESS_KEY = 'A*****************A'
SECRET_ACCESS_KEY = 'P******************************2'

session = boto3.Session(aws_access_key_id = ACCESS_KEY, aws_secret_access_key = SECRET_ACCESS_KEY)

maxthreads = 5
sema = threading.Semaphore(value=maxthreads)

def list_object(bucket):
    try:
        s3 = session.client('s3')
        flag1 = objcount = 0
        paginator = s3.get_paginator('list_objects')
        page_iterator = paginator.paginate(Bucket= bucket)
        for page in page_iterator:
            if 'Contents' in page:
                for obj in page['Contents']:
                    uniobj = obj['Key'].encode('ascii', 'ignore').decode('ascii')
                    objAcl = s3.get_object_acl(Bucket=bucket, Key=obj['Key'])
                    flag2 = 0
   

Select all Open in new window

#Base Class
class Staff:
    def __init__ (self, pPosition, pName, pPay):
        self._position = pPosition
        self.name = pName
        self.pay = pPay
        print('Creating Staff object')

    def __str__(self):
        return "Position = %s, Name = %s, Pay = %d" %(self._position, self.name, self.pay)

    @property
    def position(self):
        print("Getter Method")
        return self._position

    @position.setter
    def position(self, value):
        if value == 'Manager' or value == 'Basic':
            self._position = value
        else:
            print('Position is invalid.  No changes made.')
    
    def calculatePay(self):
        prompt = '\nEnter number of hours worked for %s: ' %(self.name)
        hours = input(prompt)
        prompt = 'Enter the hourly rate for %s: ' %(self.name)
        hourlyRate = input(prompt)
        self.pay = int(hours)*int(hourlyRate)
        return self.pay

#Derived class
class ManagementStaff(Staff):
    def __init__ (self, pName, pPay, pAllowance, pBonus):
        super().__init__('Manager', pName, pPay)
        self.allowance = pAllowance
        self.bonus = pBonus

    def calculatePay(self):
        basicPay = super().calculatePay()
        self.Pay = basicPay + self.allowance
        return self.pay

    def calculatePerfBonus(self):
        prompt = 'Enter performance grade for %s: ' %(self.name)
        grade = input(prompt)
        if (grade == 'A'):
           

Select all Open in new window

#This Script will use Paginator to print result for each bucket, executed in multiple threads
import boto3
import threading
import os.path

ACCESS_KEY = 'AKIAIXXXXXXXXXXX'
SECRET_ACCESS_KEY = 'XXUPJIsSXXxxXXxxXXo9Fl5TzSxXXxxXX3ly2XXlxjXXxxXX'

session = boto3.Session(aws_access_key_id = ACCESS_KEY, aws_secret_access_key = SECRET_ACCESS_KEY)

maxthreads = 5
sema = threading.Semaphore(value=maxthreads)

def list_object(bucket):
    try:
        s3 = session.client('s3')
        flag1 = objcount = 0
        paginator = s3.get_paginator('list_objects')
        page_iterator = paginator.paginate(Bucket= bucket)
        for page in page_iterator:
            if 'Contents' in page:
                for obj in page['Contents']:
                    uniobj = obj['Key'].encode('ascii', 'ignore').decode('ascii')
                    objAcl = s3.get_object_acl(Bucket=bucket, Key=obj['Key'])
                    flag2 = 0
                   

Select all Open in new window

• adding in an iteration that will iterate strings from user input (I understand how to ask for user input and how to put those items in array or object) but grabbing the contents of the array and storing them in place of store_uin = (instead of CO004 inserting what would be in the array)

• iterating and repeating those select statements for all the contents in the array

• and writing out to new output JSON file instead of overriding one with the file name being export_name from array_date.JSON

import pyodbc
import json
import collections
def selectHRO():
    driver = 'DRIVER={SQL Server};'
    host = 'SERVER=hostname;'
    database = 'DATABASE=dbname;'

    connectionstr = driver+host+database
    conn = pyodbc.connect(connectionstr)
    cursor = conn.cursor()

    cursor.execute("SELECT cust_NO, FNAME, LNAME, store_UIN from Customer where store_UIN = 'CO004'")

    rows = cursor.fetchall()

    objects_list = []
    for row in rows:
        d = collections.OrderedDict()
        d['cust_NO'] = row.cust_NO
        d['FirstName'] = row.FNAME
        d['LastName'] =

Select all Open in new window

import xlsxwriter
import openpyxl

wb = openpyxl.Workbook()
ws = wb.worksheets[0]

workbook = xlsxwriter.Workbook('Maps.xlsx')
worksheet = workbook.add_worksheet('Maps')

images = ['overview.png','Site 1.png','Site 2.png','Site 3.png','Site 4.png','Site 5.png','Site 6.png','Site 7.png','Site 8.png']

for row, image in enumerate(images):

  img = openpyxl.drawing.image.Image(image)
  img.anchor = 'A'+str(row*30+1)

  ws.add_image(img)

  worksheet.insert_image(30*row,1,image)
  

workbook.close()

wb.save('out.xlsx')

wb.close()

Select all Open in new window

wand.exceptions.CoderError: Read error at scanline 3373; got 27894 bytes, expected 30000. `TIFFFillStrip' @ error/tiff.c/TIFFErrors/568

Select all Open in new window

import os
import shutil
import openpyxl

src = "S:\\Compliance Dept\\Vendor Management\\VCM\\VCM Attachments\\"
dst = "S:\\Compliance Dept\\Vendor Management\\VCM\\VCM Attachments\\"
exFile = "C:\\Users\\mfigur\\Desktop\\Attachments.xlsx"

wb = openpyxl.load_workbook(exFile)
sheet = wb.get_sheet_by_name ('Sheet1')
ven = sheet['A']
fil = sheet['B']

for cell in fil:
   folderName = cell.value
    os.path.join(src, folderName)
    shutil.copy()
    print("\nFolder created in: ", os.path.join(src, folderName))

Select all Open in new window

DECLARE @TempTable TABLE (
	Parameter NVARCHAR(30)
	,[ID01|20190720] FLOAT
	,[ID01|20190721] FLOAT
	,[ID01|20190722] FLOAT
	,[ID01|20190723] FLOAT
	)

INSERT INTO @TempTable
VALUES (
	'pH'
	,'5'
	,'6'
	,'6'
	,'5'
	)

INSERT INTO @TempTable
VALUES (
	'Alkalinity'
	,'166'
	,'168'
	,'168'
	,'163'
	)

SELECT *
FROM @TempTable

Select all Open in new window