Dynamic table generation for JSON schema using Angular JS

1. Here is sample schema, which will be used to generate table header.

 {
    "$schema" : "http://json-schema.org/draft-04/schema#",
    "type" : "array",
    "items" : {
        "type" : "object",
        "properties" : {
            "id" : {
                "type" : "integer",
                "title" : "Record ID"
            },
            "rowType" : {
                "type" : "string"
            },
            "recordName" : {
                "type" : "string",
                "title" : "Record Name"
            },
            "createdBy" : {
                "type" : "string",
                "title" : "Created By"
            },
            "creationDate" : {
                "type" : "string",
                "title" : "Creation Date"
            },
            "lastUpdatedBy" : {
                "type" : "string",
                "title" : "Last Updated By"
            }
        }
    }
}

2. Create a REST service to populate data into table. This is sample for GET method response.

 {  
   "list" : [  
     {  
       "createdBy" : "rash",  
       "creationDate" : "2015-09-15",  
       "id" : 1000010412,  
       "lastUpdatedBy" : "rash",  
       "recordName" : "Adithya",  
       "rowType" : "rashmi's object"  
     },  
     {  
       "createdBy" : "rash",  
       "creationDate" : "2015-09-15",  
       "id" : 1000010413,  
       "lastUpdatedBy" : "rash",  
       "recordName" : "Padmaja",  
       "rowType" : "rashmi's object"  
     },  
     {  
       "createdBy" : "rash",  
       "creationDate" : "2015-09-15",  
       "id" : 1000010414,  
       "lastUpdatedBy" : "rash",  
       "recordName" : "ashwani",  
       "rowType" : "rashmi's object"  
     }  
   ]  
 }  

3. Create a html page with text boxes, buttons and table. Page will look like this:

4. Table generation code (Inside html file):

1:  <table style="border: 1px solid black; margin: 0px auto;">  
2:            <thead>  
3:              <tr>  
4:                <th style="border: 1px solid black; width: 100%; height: 100%"  
5:                  data-ng-repeat="v1 in tableColumns">  
6:                  <span data-ng-if="response[v1].title!=null">{{ response[v1].title}}</span>  
7:                  <span data-ng-if="response[v1].title==null">{{ v1}}</span>  
8:                </th>  
9:              </tr>  
10:            </thead>  
11:            <tbody>  
12:              <tr data-ng-repeat="dataVal in data">  
13:                <td style=" border: 1px solid black;" data-ng-repeat="v2 in tableColumns">  
14:                  <span>{{dataVal[v2]}}</span>  
15:                </td>  
16:              </tr>  
17:            </tbody>  
18:          </table>  

• Line 5: Repeating on table columns.
• Line 6: If title is present in schema then display title otherwise display key value.
• Line 12 to 14: Populating table data based on service output.

5. Table generation code  (Inside controller file):

1:  app.controller("schemaParseController", function ($scope, $http) {  
2:    $scope.schemaUrl = "http://sttool32.idc.oracle.com/WebServices/MCS/MCS%20usecase%203/recordSchema.json";  
3:    $scope.serviceUrl = "http://127.0.0.1:7101/REST_AllOperations-Project1-context-root/resources/project1";  
4:    $scope.invokeSchema = function () {  
5:      $http.get($scope.schemaUrl).success(function (output) {  
6:        $scope.response = output.properties;  
7:        if ($scope.response == null) {  
8:          $scope.response = output.items.properties;  
9:        }  
10:        $scope.fillTableColumns();  
11:      });  
12:    }  
13:    $scope.invokeService = function () {  
14:      $http.get($scope.serviceUrl).success(function (service) {  
15:        $scope.data = service.list;  
16:      });  
17:    }  
18:    $scope.fillTableColumns = function () {  
19:      $scope.tableColumns = [];  
20:      for (var i in $scope.response) {  
21:        $scope.tableColumns.push(i);  
22:      }  
23:    }  
24:  });  

6. At run time:

• Specify schema url and click on Generate table button.
• Inside controller Line 5 (invoke schema()) is getting called, It requests for schema file over HTTP. Line 10 fillTableColumns function is executed to store key value of schema inside table columns array.

Generate Table Header

• Specify service url and click on invoke service button.
• Inside controller Line 13 is executed, It sends GET request to service. 

Populated Table

Display TOOLTIP in angular js on mouseover

Define module and controller for Angular JS application. Controller class contains business logic behind the application. Create a html page and bind it  to controller using data-ng-controller directive.

1. Inside html file create a <div> where you want to display output on mouseover. output is getting displayed based on 'temp' variable value.

 <div data-ng-show="temp">{{TOOLTIP}}</div>  

2. Create two functions inside controller.

• hoverIn function takes a input and set the value of 'temp' to true.
• hoverOut function  set temp variable to false. 

  $scope.hoverIn = function (value) {  
       $scope.temp = true;  
       $scope.TOOLTIP= value;  
      }  
  $scope.hoverOut = function () {  
       $scope.temp = false;  
      }  

3. Populating table header with data-ng-repeat.

• When you hover on particular table header, hoverIn function is getting called with tooltip value.
• When mouse leaves column, hoverOut function is getting executed and it sets temp value to false. so previously displayed tooltip will disappear. 

 
       <table style="border: 1px solid black; margin: 0px auto;">  
           <thead>  
             <tr>  
               <th style="border: 1px solid black" data-ng-repeat="v1 in tableColumns"  
                 ng-mouseover="hoverIn(v1.TOOLTIP)" ng-mouseleave="hoverOut()">  
                 <span>{{v1.title}}</span>
               </th>  
             </tr>  
           </thead>  
         </table>  

Extract latest posts of a Blog (Blogger) using JSOUP API

JSoup is a Java library for working with real-world HTML. It provides a very convenient API for extracting and manipulating data, using the best of DOM, CSS, and jquery-like methods Refer. Using JSoup DOM traversal you can extract data. Manipulation of HTML attributes and elements is very easy through JSoup  library.

In this post, extraction of latest posts through JSoup API will be discussed. 

• Select a blog URL. Here i have selected my own blog url to get my latest posts.

 String rashmiBlog="http://rashmi9425.blogspot.in/";  

• JdoupGet method has been written to extract posts, where i am passing value which is defined for "rashmiBlog". This method is returning a list of posts.

1:    public static List<String> JsoupGet(String rashmiBlog) {  
2:        Document doc = null;            
3:        List<String> list = new ArrayList();  

4:         try {  
5:           doc = Jsoup.connect(rashmiBlog).get();  
6:         } catch (IOException e) {  
7:             e.printStackTrace();  
8:             System.out.println("not able to connect");  
9:             return null;  
10:           }  

11:        //Extract useName  
12:        String userName =doc.getElementsByClass("post-footer").select ("span[itemprop]").first().text();  
13:        list.add(userName);  

14:        //select  "posts" class  
15:        Element posts = doc.getElementsByClass("posts").first();  
16:        ListIterator<Element> link = posts.getElementsByTag("a").listIterator(); 
 
17:        while (link.hasNext()) {  
18:            String href = link.next().getElementsByTag("a").first().attr("href");  
19:            list.add(href);  
20:        }  
21:       
         return list;  
22:   }  

1. In line 5, connecting to blog url and parse it to a DOM. 


2. In line 11, Extracting Username or author of blog.

 <div class="post-footer">   
       <div class="post-footer-line post-footer-line-1">  
            <span class="post-author vcard"> Posted by <span class="fn" itemprop="author" itemscope itemtype="http://schema.org/Person">   
              <meta content="https://plus.google.com/113911429732794531347" itemprop="url"> 
                <a class="g-profile" href="https://plus.google.com/113911429732794531347" rel="author" title="author profile"> 
                  <span itemprop="name">Rashmi Verma</span> </a> </span> </span>   
       </div>   
 </div>  

(1)
This is code snippet of generated document. To get author select class "post-footer" then select tag span which has a attribute 'itemprop'. There are other span tag with itemprop attribute also present so we are selecting first span tag and extracting "text" from it.


3. In line 14, 

    <ul class="posts">   
       <li><a href="http://rashmi9425.blogspot.in/2015/04/programmatically-execution-of-create.html">Programmatically execution of CREATE operation in ...</a>  
       </li>   
       <li>  
         .   
         .  
       </li>  
         .  
         .  
     </ul>  
   

   (2)
   Select element from class 'posts', create a list iterator of latest posts. as you can see in code (2) document snippet, post url is present inside tag '<a>' . In Jsoup its very easy to get a element  using "getElementbyTag"


4. In line 18, Extract the value of  'href' attribute, in code (2) value of attribute is 'http://rashmi9425.blogspot.in/2015/04/programmatically-execution-of-create.html'
   In this scenario only one latest post available.


• Here is the code to print list, first value inside list is author name and after that all latest posts.
  

       List<String> url = JsoupGet(rashmiBlog);  
       int i = 0;  
       System.out.println("Author:::" + url.get(i)+"\n");  
       i++;  
       System.out.println("Latest Posts");  
       while (url.size() != i) {  
         System.out.println(url.get(i)+"\n");  
         i++;  
       }  
  

• Output on console.
  

   Author:::Rashmi Verma  
  
   Latest Posts  
   http://rashmi9425.blogspot.in/2015/04/programmatically-execution-of-create.html  
  

Limitation: This code is only specific to Blogger URL. other blogs may have different code line. 

Programmatically execution of CREATE operation in ADF

Think of this scenario,  while executing create opetation through web page, you have to D&D Create, commit operation and attributes as a form. when you click on create button and enter values. after that click on Commit operation. Same thing we have to replicate through programmatically.

Before writting code for executing operation some points keep in mind::
1. Attribute Binding should be present onto page.
2. If binding is not present then add attributes onto page.
3. D&D Create and Commit operation onto page or add through bindings.

• Get current binding entry and extract operational binding for CREATE operation.

  BindingContainer DcCon = BindingContext.getCurrent().getCurrentBindingsEntry();  
      OperationBinding oper = DcCon.getOperationBinding("Create");  
              Object p1 = oper.execute();  

• Get attribute bindings for 'Usrname', 'Asin', 'Shelf' and 'Comments' attributes.

 AttributeBinding userName = (AttributeBinding) DcCon.getControlBinding("Usrname");  
       userName.setInputValue("rashmi");  
 AttributeBinding asinVal = (AttributeBinding) DcCon.getControlBinding("Asin");  
       asinVal.setInputValue("112456");  
 AttributeBinding shelfVal = (AttributeBinding) DcCon.getControlBinding("Shelf");  
       shelfVal.setInputValue("To Be Read");  
 AttributeBinding comments = (AttributeBinding) DcCon.getControlBinding("Comments");  
       comments.setInputValue("I am newly inserted");  

• Get operation binding for Commit operation and execute it.

  OperationBinding oper1 = DcCon.getOperationBinding("Commit");  
                oper1.execute();  

        

Native Inner Query join in EJB

EJB stands for Enterprise JavaBeans. There are two types of query one is Native Query and other is Named Query.

Named query means Java Persistence query language(JPQA). In Native query SQL is used to express database queries. An SQL INNER JOIN return all rows from multiple tables based on a common field between them. As a IDE Jdeveloper has been used for creating this application.(Download Application)

Steps::

1. Create a Custom Application and Generate Entities from tables for Person, Country, State and City tables (From HR schema)


2. Generate a new Session Bean with default options.


3. Create a java class which will be used for mapping native query result. Generate accessors for it (such as i have created PersonDetail class). This class should implements Serializable interface.


4. Create a method inside session bean.



   @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)  
   public List<PersonDetail> getInnerJoin() {  
        Query query = em.createNativeQuery("SELECT Person.id,Person.name,Country.name,State.name,City.name from Person INNER JOIN Country ON Person.COUNTRY_ID = Country.ID INNER JOIN State ON Person.STATE_ID = State.ID INNER JOIN City ON Person.CITY_ID = City.ID order by Person.id");  
        List<Person> list = query.getResultList();  
        Iterator person = list.iterator();  
        List<PersonDetail> personIterator = new ArrayList();  
        while (person.hasNext()) {  
              Object col[] = (Object[]) person.next();  
              PersonDetail test1 = new PersonDetail();  
               test1.setPersonId(new Integer(col[0].toString()));  
               test1.setPersonName(col[1].toString());  
               test1.setCountryName(col[2].toString());  
               test1.setStateName(col[3].toString());  
               test1.setCityName(col[4].toString());  
            personIterator.add(test1);  
          }  
     return (personIterator);  
   }  



5. Add this method into Session EJB, Local and Remote java file.
   List<PersonDetail> getInnerJoin();


6. Right click on SessionEJBBean, 


•  Select "Session Bean Client.."
•  Choose client type as "Java Client", finish it.


7. Add this code inside Session EJB Client



  for (PersonDetail person : (List<PersonDetail>) sessionEJB.getInnerJoin())  
            {  
                System.out.println(".................................................");  
                System.out.println("Person Id = "+person.getPersonId());  
                System.out.println("Person Name = "+person.getPersonName());  
                System.out.println("Country Name = "+person.getCountryName());  
                System.out.println("State Name = "+person.getStateName());  
                System.out.println("City Name = "+person.getCityName());  
                System.out.println(".................................................");  
            }  



8. First run session EJB bean and after that run Session EJB client.


9. Screen shot of output console

Automatic button click in ADF using Java Script

Some time we want to perform a click operation automatically on page load. Consider a scenario where we want to call managed bean on page load event.
To achieve this::

• Create a jsp or jspx page.
• Drag & Drop button component inside form.

 <af:button text="click" id="b3" binding="#{backingBeanScope.backing_Shelf.b3}"  
          visible="false"  
          actionListener="#{backingBeanScope.backing_Shelf.callRowFinder}"  
      clientComponent="true"/>   

•  On page inside <document > tag you can search for <resource> tag. 
•  First create resource tag, select type="javascript". ( Type defines which type of function you will be keeping inside resource tag, it can be either javascript or css)
• Create a function such as "invokeOnLoad" inside resource tag. To locate button component onto page pass button id inside method (which button you want to click). In my case button id is "b3". 

Method

  <af:resource type="javascript">  
         function invokeOnLoad() {  
             var button = AdfPage.PAGE.findComponentByAbsoluteId('b3');  
             AdfActionEvent.queue(button, true);  
             event.cancel();  
         }  
     </af:resource>  

• Now its time to call  method. To achieve this inside <Document> tag,  client listener tag is present, this tag has load property. It invokes method during document load.

                 <af:clientListener method="invokeOnLoad" type="load"/>

Note::

If you use "AdfActionEvent.queue(button)" instead of "AdfActionEvent.queue(button,true) then   button click will occur infinity times. 

JAX RS to RAML Command Line Interface

The JAX-RS API uses Java programming language annotations to simplify the development of RESTful web services (refer). Java class files contain jax-rs annotation for actions and resources.

Jax-rs make developer to easily develop Rest Service. RAML stands for RESTful API Modeling Language, it encourages user for re-usability, pattern sharing and enable discovery. As you understood Jax-Rs and RAML technologies.  Now its time for conversion from Jax-Rs to RAML.

1. Create a  REST – JAX RS Service for Employee Download service
2. Download  1.0 Final: jsr311-api-1.1.1.jar.
3. Download Command line tool jax-rs-to-raml.jar.
4. Create JAX RSToRAML/service folder, put java files inside this folder. Open command prompt from this folder.
5.   In order to generate your RAML code, you must run it by invoking:: 



        javac [classes]  
         -sourcepath [path-to-your-java-source-code]  
         -classpath [your-classpath]  
         -processorpath [path-to-your-jar]/jax-rs-to-raml.jar  
         -processor com.mulesoft.jaxrs.raml.annotation.model.  
          apt.RAMLAnnotationProcessor  
         -Aramlpath=[path]  
         -implicit:class  


Options::
·       classes: The JAVA classes from which you want to generate a RAML representation.
·       -sourcepath: The folder containing the packages where the classes (and classes' dependencies) are located
·       -classpath: The classpath of the Java project, the classes belong to. 
·       -processorpath: The path to the jar you downloaded (or built).
·       -processor: Indicates the annotation processor. Use:com.mulesoft.jaxrs.raml.annotation.model.apt.RAMLAnnotationProcessor
·       -Aramlpath: The folder which the generated RAML definition will be placed.
·       -imlicit: class specifies that the annotations in the dependent files must also be resolved by the processor.


6. Example::



     javac src/project1/Employee.java src/project1/EmployeeList.java src/project1/EmployeeService.java src/project1/GenericApplication.java   
         -processorpath jax-rs-to-raml.jar   
         -classpath jsr311-api-1.1.1.jar   
         -processor com.mulesoft.jaxrs.raml.annotation.model.apt.RAMLAnnotationProcessor   
         -Aramlpath=RAML   
         -implicit:class  



7. Generated RAML document doesn’t include schema. Steps to make valid RAML document::


•           Convert JSON output into JSON schema (JsonToJsonSchema)               
 JSON Code



                       {  
                           "list" : [  
                                    {  
                                       "id" : 1,  
                                       "name" : "Arnold"  
                                     },  
                                     {  
                                        "id" : 2,  
                                         "name" : "Simon"  
                                       }  
                                  ]  
                          }  



•             Add JSON schema into RAML file.
•        EmployeeService.raml is valid raml document.(RAML Location)