oracle-samples/oracle-functions-samples

Examples demonstrating how to use Oracle Functions

Oracle Functions Samples

This repository provides examples demonstrating how to use Oracle Functions.

Setup

• Quick start

Basic Observability Guidance

• Functions
• Service Connector Hub
• Notifications Service

How To

Description	Python	Java
Hello World	sample	sample
List OCI Compute instances	sample	sample
Control OCI Compute instances (start/stop/status)	sample
List OCI compartments	sample
List objects in OCI Object Storage	sample	sample
Read an object in OCI Object Storage	sample	sample
Create an object in OCI Object Storage	sample	sample
Create a PAR in OCI Object Storage	sample
Copy object from one OCI Object Storage bucket to another	sample
Display an OCI Cloud Event	sample
Invoke another Function using the OCI SDK	sample
Run a SQL statement against Autonomous DB using ORDS	sample
Run a SQL statement against Autonomous DB using DB Client	sample
Publish a notification using ONS	sample
Send an email using Email Delivery Service	sample
Decrypt cipher using Vault keys	sample
Get a secret from Vault	sample
Write IAM policies that enables Functions in a tenancy to access resources in other tenancies		sample
Trace a function with APM and add custom child spans using Zipkin	sample

Functions and API Gateway

Oracle Cloud Functions and OCI API Gateway together enable developers to create serverless APIs and perform function based authorization.

Description	Python	Java
API Gateway Function authorizer for IDCS		sample
Function that returns the API Gateway HTTP request information for testing	sample
Validate an API key	sample
BasicAuth Validation with IDCS		sample

Using Service Connector Hub with Functions

Description	Code
Logging >> Service Connector Hub >> Functions
Move logs from OCI to Datadog using Service Connector Hub, Logging (Source), Functions (Target) and Datadog	sample
Send SMS messages for logs using Service Connector Hub, Logging (Source), Functions (Target) and Syniverse SMS	sample
Streaming >> Service Connector Hub >> Functions
Convert JSON to CSV format using Service Connector Hub, Streams (Source and Target) and Functions (Task)	sample
Convert JSON to Parquet format using Service Connector Hub, Streams (Source and Target) and Functions (Task)	sample

Other Use Cases

Description	Code
Provide the size of an image (Custom Dockerfile, image library)	sample
Automatically load data from Object Storage into Autonomous DataWarehouse	sample
Automatically resize VM on High Memory Alerts (Notifications trigger a function)	sample
Check if a compute instance is tagged correctly on provisioning, if not, stop it	sample
Send SMS messages for monitoring alarms using Monitoring, Notifications Service, Functions and Syniverse SMS	sample
Export a collection of historical metrics from Monitoring Service using the Monitoring Query Language (MQL)	sample

Community-led Examples

Description	Code	Blog
Serverless SaaS Extensions using Oracle Functions, API Gateway and VBCS	repo	blog
Function that demonstrates connectivity between Oracle SaaS applications with OIC	sample

Documentation

You can find the online documentation for Oracle Functions at docs.oracle.com and information about the Fn project at https://fnproject.io/.

Contributing

See CONTRIBUTING

Security

Please consult the security guide for our responsible security vulnerability disclosure process

License

See LICENSE

oracle-functions-samples's Issues

Update cx_Oracle to the latest version - which doesn't need Instant Client.

https://github.com/oracle-samples/oracle-functions-samples/blob/master/samples/oci-adb-client-runsql-python/func.py needs to be updated to the latest cx_Oracle driver, which is now called python-oracledb. This no longer needs Oracle Instant Client. See the release announcement.

OCI Stop Untagged instance pytho

hi,
I followed this tutorial but the instance is not stopping as stated in the tutorial.

https://github.com/oracle/oracle-functions-samples/tree/master/samples/oci-stop-untagged-instance-python

I checked Events (metrics) and I can see the event was detected. I checked the functions (metrics) and I can see the function was triggered.

I created the event rule in a compartment and created the instance in the same compartment.

Thanks

oci-adb-client-runsql-python - Issue

Get the following issue when trying to deploy oci-adb-client-runsql-python sample:

Complete output from command python setup.py egg_info:

        =============================DEBUG ASSISTANCE==========================
        If you are seeing an error here please try the following to
        successfully install cryptography:

        Upgrade to the latest pip and try again. This will fix errors for most
        users. See: https://pip.pypa.io/en/stable/installing/#upgrading-pip
        =============================DEBUG ASSISTANCE==========================

function sample for authorizer for IDCS in python

Hi Team can we create function sample for authorizer but in python format?

Display an OCI Cloud Event - Tutorial not clear

Hello Team,
While following "Display an OCI Cloud Event" tutorial using Oracle functions in below tutorial , its not clear, how to test it.
https://github.com/oracle/oracle-functions-samples/blob/master/oci-event-display-python

Documentation simply refers to logs once Rule is created.

Please clarify, as I am unable to test it.

Thanks,
Pardeep

oci-serviceconnector-streaming-json-to-csv-python not working

The sample is not working.

https://github.com/oracle-samples/oracle-functions-samples)/[samples](https://github.com/oracle-samples/oracle-functions-samples/tree/master/samples)/oci-serviceconnector-streaming-json-to-csv-python/

The input of the service connector looks like this:

"01GBK286021BT0Q4RZJ002PCNH - root - INFO - {'stream': 'mg-input-sc', 'partition': '0', 'key': None, 'value': 'W3sic3RyZWFtIjogIm15bmV3c3RyZWFtIiwicGFydGl0aW9uIjogIjAiLCJ2YWx1ZSI6ICJleUp1WVcxbElqb2lhV2R2Y2lJc0lDSnNiMk5oZEdsdmJpSTZJQ0pFZFdKc2FXNGlmUT09Iiwib2Zmc2V0IjogMCwidGltZXN0YW1wIjogIjIwMTgtMDQtMjZUMDE6MDM6MDYuMDUxWiJ9LHsic3RyZWFtIjogIm15bmV3c3RyZWFtIiwicGFydGl0aW9uIjogIjAiLCJ2YWx1ZSI6ICJleUp1WVcxbElqb2lZbkpwWVc0aUxDSm1hV1ZzWkRFaU9pSjBaWE4wSW4wPSIsIm9mZnNldCI6IDAsInRpbWVzdGFtcCI6ICIyMDE4LTA0LTI2VDAxOjAzOjA2LjA1MVoifV0=', 'offset': 10, 'timestamp': 1661718357219}"

Notice that key is None.

I am not sure why it is written this part of the code but this is causing issue:

        if 'key' in item:
            item['key'] = base64_decode(item['key'])

The same problem happens also with the test.json file that is in the sample directory.
If you remove the lines, it works. I am not sure of the intention of these 2 lines.

oracle function sample in dotnet

Is there any sample code available for function using dotnet.

A key can only consist of ASCII letter, digit or '_' (underscore) characters.

Hello everyone,

Ad func.py
How come you have got for example this:
schema = cfg["db-schema"]?
Given the fact that hyphens are not allowed.

Fn: Error updating function configuration: Service error:InvalidParameter. Invalid config. http status code: 400.

Thanks and Regards,
Vaclav

Project Status

Is this project actively maintained? Or any referral link to alternative sample projects?