Skip to main content

Create Micro CRUD services for Oracle Database Cloud using NodeJS

I will try to explain, how you can use NodeJS to create mirco services for the tables in your Oracle Database Cloud or on-premise Database.

Complete Github project : https://github.com/sohamda/LeasifyAPIs
You need to do "npm install" to download the node_modules.

Step by Step guide :

1. NodeJS : either 32 or 64 bit.

If you already have NodeJS installed, please check whether it is 64 or 32. Use below command to figure that out :
C:\>node
> require('os').arch()

If you get : 'ia32' , then it is 32 bit installation.

2. Install oracle-db node module

This was a lengthy and time consuming installation for me, because for Windows, it has a lot of pre-requisites. If you are a Mac user, you are lucky. :)
I followed : https://community.oracle.com/docs/DOC-931127
There is also a detailed one in github : https://github.com/oracle/node-oracledb/blob/master/INSTALL.md

3. Config your DB Cloud

Create a user and couple of tables on which we'll write the Microservices.
I created an user with some basic GRANTS


 



Connected to the DB instance via SQL Developer and created 2 tables :



Now we gonna write some CRUD services on both the tables.

4. Lets explain my NodeJS code

This tutorial from Oracle is excellent for starters : http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/apaas/node-cloud-REST-DB/nodecloud-RESTDB.html#overview
You should go through it once before you try to understand my NodeJS construction.

JS code:
4i. app.js : Creates a NodeJS server and invokes "./routes/index.js" for REST URI "/" and "./routes/users.js" for URI "/users". All our DB cloud api is in "index.js"
4ii. ./routes/index.js : Defines an API catalogue on "/api/catalogue" and micro services on LEASE_HISTORY and USERS table.
4iii. ./routes/users_crud.js : Defines the CRUD methods for USERS table.
4iv. ./routes/lease_crud.js : Defines the CRUD methods for LEASE_HISTORY table.
4v.  ./routes/dbutil.js : Defines common utility methods for DB operations.



Config files:
4i. manifest.json : Defines the Application Container Cloud NodeJS version and command to start this NodeJS applicaiton. You only need this file if you want to deploy this application to Oracle Application Container Cloud, Otherwise not.
4ii. package.json : Defines application name, command and dependencies.

5. Running this locally:

Run it from command line :



Check in Postman :



6. Upload it in Application Container Cloud :

Follow the next blog on this.







Comments

  1. Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles learn Node JS training

    ReplyDelete
  2. I have been following your post for a long time. I always found it very interesting and valuable. keep posting it is really helpful.
    Cloud Migration services

    Aws Cloud Migration services

    Azure Cloud Migration services

    ReplyDelete
  3. I am really impressed with the way of writing of this blog. The author has shared the info in a crisp and short way.

    Best Cloud Migration Tools


    Best Cloud Migration services

    ReplyDelete
  4. I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. All the best.


    python training in bangalore

    python training in hyderabad

    python online training

    python training

    python flask training

    python flask online training

    python training in coimbatore
    python training in chennai

    python course in chennai

    python online training in chennai


    ReplyDelete
  5. Very nice post. Informative article about cloud migration. Helpful to know why cloud migration and cloud computing is important, how it will helps for future need in IT and also giving knowledge about how cloud migration services helps organizations. Thank you for sharing knowledge with us.

    ReplyDelete
  6. The discussion on machine learning algorithms in this article is informative and well-structured.data analyst course in chennai

    ReplyDelete

Post a Comment

Popular posts from this blog

Rich Text Editor - Oracle JET

Oracle JET has a lot of excellent UI components, but according to Murphy's law, client always comes up with something which you don't have at your disposal. So, driven by one of my client's requirements, I created a Rich Text Editor or WYSIWYG editor for Oracle JET. This is based on Quill JS and fully customizable. Github project download: https://github.com/sohamda/JET-Web-Components/tree/master/rich-text-editor I will explain in this blog, on how to integrate it in your own Oracle JET project. 1. Create and initialize your JET application and then put the downloaded web component inside "src\js\jet-composites" folder. 2. Once copied update your viewModel first. Add a snippet for passing the default content to be displayed by the editor after load. 3. Update view to load this editor Above you can see the "toolbar-options" property, that controls which options you should display to user on the editor. Those are basically the forma

Layout Management & CSS Classes with Oracle JET

Oracle JET provides automatic responsive layout using CSS classes. So that, from large screens to small screens the application fits itself the best possible way. JET’s layout management are based on 2 types of CSS classes “Responsive Grid” and “Flex”. Responsive grid classes which deals with size, number of columns and functions of a particular <div>. Naming convention of these classes are oj- size - function - columns sizes can be: sm, md, lg, xl functions can be: hide, only-hide columns can be: any number between 1 to 12.   Just like Bootstrap, JET also divides the width of the available space into 12 columns, so for example, if you want a section of your page should take up atleast 5 columns if you divide the available screen into 12 columns, you need use : oj- size -5. Now comes the size part, you need to define that for each size of the screen, from hand-held mobile devices to large or extra large desktop screens. With combination with theses grid c