示例#1
0
if not DRIVE_FOLDER_ID:
    drive = Drive()
    folder = drive.create_folder('price_checker')
    DRIVE_FOLDER_ID = folder['id']

    if not DRIVE_FOLDER_ID:
        print('ERROR: was not possible to create the drive' +
              'folder for price-checker')
        sys.exit()

    configProperties.save_value('DEFAULT', 'drive.folder.id', DRIVE_FOLDER_ID)

for product in configProperties.get_products():
    if not product.spreadsheet_id:
        spreadsheet = drive.create_google_spreadsheet(product.name,
                                                      DRIVE_FOLDER_ID)
        if spreadsheet:
            product.spreadsheet_id = spreadsheet.id
            configProperties.save_value(product.name, 'spreadsheet.id',
                                        spreadsheet.id)

    if product.spreadsheet_id:
        drive_spreadsheet = drive.open_google_spreadsheet(
            product.spreadsheet_id)
        if drive_spreadsheet:
            for site in product.sites_list:
                worksheet = None
                try:
                    worksheet = drive_spreadsheet.worksheet(
                        site.site_type.name)
                except Exception: