Serverless Daily Task

A Serverless back-end to manage requests on PostgreSQL, including creating a new table and automated backup.

Components and technologies

• IBM Cloud Functions: IBM Cloud Functions is a Function-as-a-Service (FaaS) platform which executes functions in response to incoming events.
• PostgreSQL: Postgres is a powerful, open source object-relational database that is highly customizable.

Deployment

To deploy, you need to install IBM Cloud CLI and IBM Cloud Functions CLI in your local machine. After this step, you need to login in your IBM Cloud account on IBM Cloud CLI (if you haven't already done, run ibmcloud login), follow all steps below.

1. Clone this repository

git clone https://github.com/victorshinya/serverless-dailytask.git
cd serverless-dailytask

2. Open the project in a text editor

Replace on create.js:

• [ Line 2 ] {cert} by your PostgreSQL's certificate.
• [ Line 6 ] {host} by your PostgreSQL's hostname.
• [ Line 7 ] {port} by your PostgreSQL's port.
• [ Line 8 ] {user} by your PostgreSQL's username.
• [ Line 9 ] {password} by your PostgreSQL's password.
• [ Line 10 ] {database} by your PostgreSQL's database name.

Replace on delete.js:

• [ Line 2 ] {cert} by your PostgreSQL's certificate.
• [ Line 6 ] {host} by your PostgreSQL's hostname.
• [ Line 7 ] {port} by your PostgreSQL's port.
• [ Line 8 ] {user} by your PostgreSQL's username.
• [ Line 9 ] {password} by your PostgreSQL's password.
• [ Line 10 ] {database} by your PostgreSQL's database name.

Replace on insert.js:

• [ Line 2 ] {cert} by your PostgreSQL's certificate.
• [ Line 6 ] {host} by your PostgreSQL's hostname.
• [ Line 7 ] {port} by your PostgreSQL's port.
• [ Line 8 ] {user} by your PostgreSQL's username.
• [ Line 9 ] {password} by your PostgreSQL's password.
• [ Line 10 ] {database} by your PostgreSQL's database name.

Replace on select.js:

• [ Line 2 ] {cert} by your PostgreSQL's certificate.
• [ Line 6 ] {host} by your PostgreSQL's hostname.
• [ Line 7 ] {port} by your PostgreSQL's port.
• [ Line 8 ] {user} by your PostgreSQL's username.
• [ Line 9 ] {password} by your PostgreSQL's password.
• [ Line 10 ] {database} by your PostgreSQL's database name.

Replace on update.js:

• [ Line 2 ] {cert} by your PostgreSQL's certificate.
• [ Line 6 ] {host} by your PostgreSQL's hostname.
• [ Line 7 ] {port} by your PostgreSQL's port.
• [ Line 8 ] {user} by your PostgreSQL's username.
• [ Line 9 ] {password} by your PostgreSQL's password.
• [ Line 10 ] {database} by your PostgreSQL's database name.

3. Deploy all functions

Run the following command to deploy both create.js, delete.js, insert.js, select.js, update.js functions. It requires an account on IBM Cloud.

As you are using IBM Cloud Functions, you don't need to install any package or setup a package.json. The platform already has the package installed.

ibmcloud fn deploy --manifest serverless.yml

LICENSE

Copyright 2020 Victor Shinya

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.