Angular - Insert Dynamic Form Content to Database in Zeppelin

Question

I am trying to create a simple dynamic form in Apache Zeppelin using Angular interpreter. I want to pass those values which are coming as input from the form in one notebook to a dynamic MySQL insert query in another notebook. Angular code as given below:

<form>
  1) Name: <input type="text" ng-model="firstname">
  </br></br>
  2) Give a rating for pack:
  <input type="radio" ng-model="myVar" value="Good">Good
  <input type="radio" ng-model="myVar" value="Average">Average
  <input type="radio" ng-model="myVar" value="Bad">Bad
  </br></br>
  3) Select a Region:
  <select ng-model="reg">
    <option value="">
    <option value="KNZ">KNZ
    <option value="Gauteng">Gauteng
    <option value="NorthEast">NorthEast
  </select>
</form>

This will create a dynamic form Click to see I want to execute an insert query(MySQL) in the next paragraph accessing the above variables "firstname", "myVar" and "reg" from angular dynamic form.

insert into Table (Firstname,Rating,Region) values ("firstname","myVar","reg")

Can anyone help me?

Saravanan Elumalai · Accepted Answer · 2018-09-11 17:00:42Z

1

You can use ZeppelinContext variables directly in jdbc interpreter by setting zeppelin.jdbc.interpolation property of the jdbc interpreter to 'true'

Example: %jdbc select * from test where country = '{country_code}'

Refer this link for more info

answered Sep 11, 2018 at 17:00

Saravanan Elumalai

3285 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vishnu Mohan Over a year ago

@SaravanElumalai Thank you. The link was really helpful. But my doubt is Dynamic form will be created only once i run the above angular code in a paragraph. In that form i will add the new variables then how the binding of angular variables will happen without executing anything.

Collectives™ on Stack Overflow

Angular - Insert Dynamic Form Content to Database in Zeppelin

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related