|
from typing import Type |
|
import pandas as pd |
|
import boto3 |
|
import tempfile |
|
import os |
|
|
|
PandasDataFrame = Type[pd.DataFrame] |
|
bucket_name = os.environ['DOCUMENT_REDACTION_BUCKET'] |
|
|
|
try: |
|
session = boto3.Session() |
|
except Exception as e: |
|
print(e) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
def get_assumed_role_info(): |
|
sts = boto3.client('sts', region_name='eu-west-2', endpoint_url='https://sts.eu-west-2.amazonaws.com') |
|
response = sts.get_caller_identity() |
|
|
|
|
|
assumed_role_arn = response['Arn'] |
|
|
|
|
|
assumed_role_name = assumed_role_arn.split('/')[-1] |
|
|
|
return assumed_role_arn, assumed_role_name |
|
|
|
try: |
|
assumed_role_arn, assumed_role_name = get_assumed_role_info() |
|
|
|
print("Assumed Role ARN:", assumed_role_arn) |
|
print("Assumed Role Name:", assumed_role_name) |
|
except Exception as e: |
|
print(e) |
|
|
|
|
|
def download_file_from_s3(bucket_name, key, local_file_path): |
|
|
|
s3 = boto3.client('s3') |
|
s3.download_file(bucket_name, key, local_file_path) |
|
print(f"File downloaded from S3: s3://{bucket_name}/{key} to {local_file_path}") |
|
|
|
|
|
|
|
def download_folder_from_s3(bucket_name, s3_folder, local_folder): |
|
""" |
|
Download all files from an S3 folder to a local folder. |
|
""" |
|
s3 = boto3.client('s3') |
|
|
|
|
|
response = s3.list_objects_v2(Bucket=bucket_name, Prefix=s3_folder) |
|
|
|
|
|
for obj in response.get('Contents', []): |
|
|
|
object_key = obj['Key'] |
|
local_file_path = os.path.join(local_folder, os.path.relpath(object_key, s3_folder)) |
|
|
|
|
|
os.makedirs(os.path.dirname(local_file_path), exist_ok=True) |
|
|
|
|
|
try: |
|
s3.download_file(bucket_name, object_key, local_file_path) |
|
print(f"Downloaded 's3://{bucket_name}/{object_key}' to '{local_file_path}'") |
|
except Exception as e: |
|
print(f"Error downloading 's3://{bucket_name}/{object_key}':", e) |
|
|
|
|
|
def download_files_from_s3(bucket_name, s3_folder, local_folder, filenames): |
|
""" |
|
Download specific files from an S3 folder to a local folder. |
|
""" |
|
s3 = boto3.client('s3') |
|
|
|
print("Trying to download file: ", filenames) |
|
|
|
if filenames == '*': |
|
|
|
print("Trying to download all files in AWS folder: ", s3_folder) |
|
response = s3.list_objects_v2(Bucket=bucket_name, Prefix=s3_folder) |
|
|
|
print("Found files in AWS folder: ", response.get('Contents', [])) |
|
|
|
filenames = [obj['Key'].split('/')[-1] for obj in response.get('Contents', [])] |
|
|
|
print("Found filenames in AWS folder: ", filenames) |
|
|
|
for filename in filenames: |
|
object_key = os.path.join(s3_folder, filename) |
|
local_file_path = os.path.join(local_folder, filename) |
|
|
|
|
|
os.makedirs(os.path.dirname(local_file_path), exist_ok=True) |
|
|
|
|
|
try: |
|
s3.download_file(bucket_name, object_key, local_file_path) |
|
print(f"Downloaded 's3://{bucket_name}/{object_key}' to '{local_file_path}'") |
|
except Exception as e: |
|
print(f"Error downloading 's3://{bucket_name}/{object_key}':", e) |
|
|
|
|
|
|
|
def load_data_from_aws(in_aws_keyword_file, aws_password="", bucket_name=bucket_name): |
|
|
|
temp_dir = tempfile.mkdtemp() |
|
local_address_stub = temp_dir + '/doc-redaction/' |
|
files = [] |
|
|
|
if not 'LAMBETH_BOROUGH_PLAN_PASSWORD' in os.environ: |
|
out_message = "Can't verify password for dataset access. Do you have a valid AWS connection? Data not loaded." |
|
return files, out_message |
|
|
|
if aws_password: |
|
if "Lambeth borough plan" in in_aws_keyword_file and aws_password == os.environ['LAMBETH_BOROUGH_PLAN_PASSWORD']: |
|
|
|
s3_folder_stub = 'example-data/lambeth-borough-plan/latest/' |
|
|
|
local_folder_path = local_address_stub |
|
|
|
|
|
if not os.path.exists(local_folder_path): |
|
print(f"Folder {local_folder_path} does not exist! Making folder.") |
|
|
|
os.mkdir(local_folder_path) |
|
|
|
|
|
if len(os.listdir(local_folder_path)) == 0: |
|
print(f"Folder {local_folder_path} is empty") |
|
|
|
download_files_from_s3(bucket_name, s3_folder_stub, local_folder_path, filenames='*') |
|
|
|
print("AWS data downloaded") |
|
|
|
else: |
|
print(f"Folder {local_folder_path} is not empty") |
|
|
|
|
|
|
|
|
|
files = [os.path.join(local_folder_path, f) for f in os.listdir(local_folder_path) if os.path.isfile(os.path.join(local_folder_path, f))] |
|
|
|
out_message = "Data successfully loaded from AWS" |
|
print(out_message) |
|
|
|
else: |
|
out_message = "Data not loaded from AWS" |
|
print(out_message) |
|
else: |
|
out_message = "No password provided. Please ask the data team for access if you need this." |
|
print(out_message) |
|
|
|
return files, out_message |