Posted on

Jenkins & SVN

My concern is always how to keep code safe!!!

When I deploy my code to production environment, I would like to have a rollback scenario just in case something goes wrong..

I follow the below steps to have the last copy of my release safe since I have CI/CD running in Jenkins to deploy new versions of my application.

  • deploy the new version to your production environment
  • create a new revision of your recently deployed release
  • update release notes

next time you deploy, you always have the revision as it is on production in your subversion.

cd 01.src/OSB
svn upgrade

svn_log=svn log -r r${SVN_REVISION_1}

rel_nr='{ “rel_nr”: “‘”${newRelease}”‘”,’

rel_name='”rel_name”: “‘”${ReleaseType}”‘”,’
rel_desc='”rel_desc”: “‘”$svn_log”‘”, ‘
rel_fix='”rel_fix”: “‘”${STD_NUMMER}”‘”,’
rel_a='”rel_a”: “ja”, ‘
rel_svn_nr=’ “rel_svn_nr”: “‘”${projectChoosen}”‘:'”${SVN_REVISION_1}”‘”}’

message=”$rel_nr$rel_name$rel_desc$rel_desc2$rel_desc3$rel_fix$rel_a$rel_svn_nr”

I update my release notes with a REST call in APEX application automatically

curl -X POST -i -H “Content-type: application/json” http://localhost:8080/ords/releasenotes/releasenote/api/v01/releaseprod -d “$message”

Posted on

ORDS a world of APEX and Database API

On 25 march 2019 I gave a presentation on APEX world 2019. the subject of the presentation was the same as the title of this post. I will put some of the used code here for the who want to check it afterwards.

  • you can find the presentation here.

The used code for the demo:

After you unable the schema for using ORDS. In SQLDeveloper you go REST Data Services and create your first module

  1. Name: OverSystem
  2. URI: /ordersystem/api/v01/
  3. Pattern: orders

use this query as GET method

select p.product_id,
p.product_name,
p.product_description,
p.category,
decode(p.product_avail, ‘Y’,’Yes’,’N’,’No’) product_avail,
p.list_price,
(select sum(quantity) from demo_order_items where product_id = p.product_id) units,
(select sum(quantity * p.list_price) from demo_order_items where product_id = p.product_id) sales,
(select count(o.customer_id) from demo_orders o, demo_order_items t where o.order_id = t.order_id and t.product_id = p.product_id group by p.product_id) customers,
(select max(o.order_timestamp) od from demo_orders o, demo_order_items i where o.order_id = i.order_id and i.product_id = p.product_id) last_date_sold,
p.product_id img,
tags
from demo_product_info p

Save and the go to any test client to test your new create API. the URL is http://<host>:<port/ords/<yourshema>/ordersystem/api/v01/orders

for the sake of the demo I create an APEX app in another environment.

  • create a web service call in the shared components of the created app with the details as in the below image.

(C) Application 126 Shared Components Show All Web Service References MyOrders Edit REST web Reference RES REST Web Reference Name URL Proxy Override Basic Authentication HTTP Method Output Format Response XPath Response Namespace New Record Delimiter Parameter Delimiter REST Input Parameters Input Type No input parameters defined for this service HITP Request Headers http://1 72.18.0.1:32713/0rds/apexw0rld/0rdersystem/api/v01 lord Yes GET JSON in Name Value Pairs Name x Content-Type

  • Create a process to be executed after header.
    • type: web service call
    • Store Result In “Collection”
    • collection name : ARTICLE_MANAGEMENT
  • create a report with and use the SQL Query like below

Code Editor - SQL Query 1 2 3 4 5 6 7 8 9 10 11 12 13 select jt.product_id, jt.product_name, jt.product_description, from apex _ collections, j son _ table (c tobØØ1, '$. items columns ( product_id varchar2 path '$. product_id' , product _ name varchar2 path '$. product _ name' , j t. category, jt. list _ price product _ description varchar2 path $.product_description' , category varchar2 path '$. category' , list_price varchar2 path '$. list _ price' ) as jt where collection name 'ARTICLE MANAGEMENT' ;

Run your page and you have an application using REST API.

Your done. if you have any question, please drop me a message.