{
  "adapter_type": "com.altizon.gateway.script.pull.ScriptAdapter",
  "tag_suffixes": [
    {
      "suffix_id": "round_2",
      "expression_js": "tag_val != null && !isNaN(tag_val) ? +(parseFloat(tag_val)).toFixed(2) : tag_val"
    }
  ],
  "thing_configs": [
    {
      "thing_key": "99t5f84bc4",
      "name": "Extrusion Press OPM 1 ",
      "description": "",
      "bi_directional": false,
      "config_mode": "read_write",
      "send_interval_ms": 5000,
      "scan_interval_ms": 1000,
      "heartbeat_interval_ms": 120000,
      "generate_scan_alerts": true,
      "source_tags": [
        {
          "protocol_connection": {
            "connection_id": "connection_0",
            "read_connect_script_js": " var Driver = Packages.oracle.jdbc.OracleDriver;\n var oracleDriver = new Driver();\n\n//Java.type(\"java.sql.DriverManager\").registerDriver (new oracle.jdbc.OracleDriver());\n//var ds = new oracle.jdbc.driver.OracleDriver();\n//var dbURL = \"jdbc:oracle:thin:opmplc/plcopm@10.190.1.20:1541:PROD1\";\n\n//var  con = ds.getConnection(dbURL);\nvar con=java.sql.DriverManager.getConnection(\"jdbc:oracle:thin:@10.190.1.20:1541:PROD1\",\"opmplc\",\"plcopm\");\nglobal_val['rs'] = false\ncon;",
            "read_scan_script_js": "var cstmt = connection_val.createStatement();\nvar ddate = new Date();\n//var rs = cstmt.executeQuery(\"select * from prod_rkt.OPM_FEED_BACK o where o.CURRENT_DATE='20-03-18' \");\n\nvar feed_back_details = {};\nif (global_val['rs']) {\nglobal_val = cstmt.executeQuery(\"select * from prod_rkt.OPM_FEED_BACK o where o.LOT_TKT_CODE='E190318153'\");\nif(global_val.next()) {\n feed_back_details =\"empty\";\n}\n}\nelse{\n feed_back_details = global_val;\n global_val.close(); \n global_val = cstmt.executeQuery(\"select * from prod_rkt.OPM_FEED_BACK o where o.LOT_TKT_CODE='E190318153'\");\nif(global_val.next()) {\n feed_back_details = global_val;\n}\n}\n\nfeed_back_details;",
            "read_disconnect_script_js": "connection_val.close();",
            "write_script_js": "",
            "java_lib_urls": "file:/C:/Users/hilrkt-iot/Desktop/Altizon/ojdbc6.jar"
          },
          "read_tags": [
            {
              "tag_id": "Start_Time",
              "script_js": "scan_val;"
            },
            {
              "tag_id": "End_Time",
              "script_js": "scan_val"
            },
            {
              "tag_id": "Current_Date",
              "script_js": "scan_val"
            },
            {
              "tag_id": "Lot_Tkt_Code",
              "script_js": "scan_val.getString('LOT_TKT_CODE');"
            },
            {
              "tag_id": "Output_Lot_No",
              "script_js": "scan_val.getString('OUTPUT_LOT_NO');"
            }
          ],
          "write_tags": []
        }
      ],
      "ml_tags": [],
      "derived_tags": [],
      "monitor_tag_ids": [],
      "scan_tag_ids": [],
      "datetime_tag_id": "",
      "metric_mappings": [
        {
          "metric_id": "Start_Time",
          "tag_id": "Start_Time",
          "type": "string"
        },
        {
          "metric_id": "End_Time",
          "tag_id": "End_Time",
          "type": "string"
        },
        {
          "metric_id": "Current_Date",
          "tag_id": "Current_Date",
          "type": "string"
        },
        {
          "metric_id": "Lot_Tkt_Code",
          "tag_id": "Lot_Tkt_Code",
          "type": "string"
        },
        {
          "metric_id": "Output_Lot_No",
          "tag_id": "Output_Lot_No",
          "type": "string"
        }
      ]
    }
  ]
}