Page Comparison

This article explains how to create a form to insert and or update the data in to the database using a Groovy script.

Before we proceed with the instructions, below are the prerequisite:

...

the Run macro.

Prerequisites

Install the following apps in your Confluence instance:
1. Run Self-Service Reports
2. SQL for Confluence (Pro Edition)
Follow this link to configure the data source profile for SQL for Confluence app.

Instructions

Log into Confluence.
Navigate to the required existing page and click to edit the page or create a new page.

Insert Wiki Markup macro to write the script.and as an example, you can paste the code given below:

Image Added

Code Block

language	groovy
theme	Midnight

{wiki}
{run:titleRun=DATA Display|anchor=result}

        {run}

          {run:id=update|replace=choice:Add::radio::Add::Update,id:1:Id (for update):integer-select:1:1000,type:dog:Select DB:select::MYSQL_new user:MYSQL_new          user:Mysql_confluence:Mysql_confluence,hand1:default:operational_hand_off_status:text,hand2:default:project_status:text,hand3:default:Resource Type:text|titleRun=Add|autoRun=true|anchor=result|focus=choice}
           {anchor:result}

            {hide:showIf=Add:$choice}

            {sql:dataSource=Mysql_confluence|contentPropertyPrefix=sql.}

            INSERT INTO report (Project_status,Resource_type,operational_hand_off_status)VALUES('$hand2','$hand3','$hand1');

            {sql}

            *Row Updated*

            {hide}

            {hide:hideIf=Add:$choice}
            {sql:dataSource=Mysql_confluence|contentPropertyPrefix=sql.}
            UPDATE report set Project_status = '$hand2', Resource_type ='$hand3',operational_hand_off_status = '$hand1' where report_id = $id
            {sql}
            {hide}
        
{run}
        
  {run-now}
            {hide:showIf=1:%property_sql.update_count%}
            *Row Added*
            {hide}

  {run-now}
            ----
            h3. Results
            {sql-query:dataSource=MYSQL_new user}
            select report_id,Project_status,Resource_type,operational_hand_off_status from report
            {sql-query}
       
  
{wiki}

Click Insert, and then Save. The macro is displayed on the page as mentioned belowfollows:
Image RemovedImage Added
Select the choice: field; Add to insert inserts a new record and Update to edit edits the record.
Enter data in the required data fields and click Add to save the data into the database.
Image RemovedImage Added