Skip to content

readme.md

Latest commit

 

History

History
24 lines (19 loc) · 907 Bytes

readme.md

File metadata and controls

24 lines (19 loc) · 907 Bytes
Raw

LOB2OBJ

Description

This python script pulls lobs out of oracle and puts them into Object Storage S3. If the object already exists it will be overwritten. One metadata tag is added - x-amz-meta-results_frpa_attachment_id: (which represents the primary key in the oracle database)

require libraries

  • python -m pip install boto3
  • python -m pip install oracledb

required parameters to set

set all the parameters for the database connection and the objectstore '''

  • set PYTHON_CONNECTSTRING=the server/servicename>
  • set PYTHON_PASSWORD=the oracle password
  • set PYTHON_USERNAME=the oracle username
  • set OBJ_STOR_ID=the s3 bucket id/username
  • set OBJ_STOR_KEY=the s3 bucket key '''
  • endpoint_url='https://nrs.objectstore.gov.bc.ca:443/' # endpoint for S3 Object Storage -- if this isn't specified it will try and go to Amazon S3
  • bucketname = the bucket name