Examples of JSONStringer


Examples of org.json.JSONStringer

    return x.toString();
  }

  public static String getJsonForUnitTest6() {
    JSONStringer x = new JSONStringer();
    Random rand = new Random(0);
    try {
      JSONWriter top = x.array();
      for (int i = 1; i <= 1; i++) {
        JSONWriter o = top.object();

        JSONWriter c = o.key("c").array();
        for (int ci = 1; ci <= 1; ci++) {
          JSONWriter co = c.object();
          // co.key("c.1").value("c.1_" + ci);
          if (rand.nextBoolean()) {
            // Need the call to rand to make the test come out
            // right.
          }

          if (rand.nextBoolean()) {
            JSONWriter c3a = co.key("c.3").array();
            for (int c3i = 1; c3i <= 2; c3i++) {
              JSONWriter c3o = c3a.object();
              if (rand.nextBoolean()) {
                co.key("c.3.1").value(
                    "c.3.1_" + c3i + "+" + ci + "+" + i);
              }
              if (rand.nextBoolean()) {
                JSONWriter c34o = co.key("c.3.4").object();
                c34o.key("c.3.4.1").value("c.3.4.1_X");
                c34o.endObject();
              }
              c3o.endObject();
            }

            c3a.endArray();
          }

          co.endObject();
        }
        c.endArray();

        JSONWriter e = o.key("e").array();
        for (int ei = 1; ei <= 3; ei++) {
          e.object().key("e.1").value("e.1_" + ei).endObject();
        }
        e.endArray();

        o.endObject();
      }
      top.endArray();
    } catch (JSONException e) {
      e.printStackTrace();
      return null;
    }

    return x.toString();
  }
View Full Code Here

Examples of org.json.JSONStringer

  }

  public static Worksheet createJsonWithFunnyCharacters(Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();
      String html = "<ul><li>item 1</li></ul>";
      x.object().key("double quote")
          .value("string with \"double quotes\"")
          .key("single quotes")
          .value("'starts has ' and \"ends\" with '").key("tabs")
          .value("there is a tab between \"x\" and \"y\": x\ty")
          .key("newlines").value("there sho\nuld be a newline")
          .key("HTML").value(html).key("URL").value("http://cnn.com")
          .endObject();

      JsonImport ji = new JsonImport(x.toString(),
          "Funny Characters", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

  public static Worksheet createSampleJsonWithEmptyNestedTable1(
      Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();

      JSONWriter topA = x.array();
      topA.object().key("a").value("a_1").key("b").array()
          //
          .object().key("b.1").value("b.1_1").key("b.2")
          .value("b.2_1").endObject()
          //
          // .object().key("b.1").value("b.1_2").key("b.2")
          // .value("b.2_2").endObject()
          //
          .endArray().endObject();

      topA.object().key("a").value("a_2").endObject();

      topA.endArray();

      JsonImport ji = new JsonImport(x.toString(),
          "Empty Nested Table 1", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

  public static Worksheet createSampleJsonWithEmptyNestedTable2(
      Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();

      JSONWriter topA = x.array();
      topA.object().key("a").value("a_1").key("b").array()
          //
          .object().key("b.1").value("b.1_1").key("b.2")
          .value("b.2_1").endObject()
          //
          .object().key("b.1").value("b.1_2").endObject()
          //
          .endArray().endObject();

      topA.object().key("a").value("a_2").endObject();

      topA.endArray();

      JsonImport ji = new JsonImport(x.toString(),
          "Empty Nested Table 2", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

  public static Worksheet createSampleJsonWithEmptyNestedTable3(
      Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();

      JSONWriter topA = x.array();
      topA.object().key("a").value("a_1").key("b").array()
          //
          .object().key("b.1").value("b.1_1").key("b.2")
          .value("b.2_1").endObject()
          //
          .endArray().endObject();

      topA.object().key("b").array().endArray().endObject();

      topA.endArray();

      JsonImport ji = new JsonImport(x.toString(),
          "Empty Nested Table 3", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

  public static Worksheet createSampleJsonWithEmptyNestedTable4(
      Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();

      JSONWriter topA = x.array();
      topA.object().key("a").value("a_1").key("b").array()
          //
          .object().key("b.1").value("b.1_1").key("b.2")
          .value("b.2_1").endObject()
          //
          .object().key("b.2").value("b.2_2").endObject()
          //
          .object().key("b.1").value("b.1_3").endObject()
          //
          .endArray().endObject();

      topA.object().key("a").value("a_2").endObject();

      topA.endArray();

      JsonImport ji = new JsonImport(x.toString(),
          "Empty Nested Table 4", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

  }

  public static Worksheet createSampleJsonWithNestedTable1(Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();

      JSONWriter topA = x.array();
      topA.object().key("a").value("a/1").key("b")
          .array()
          //
          .object().key("b.1").value("b.1/1,1").key("b.2")
          .value("b.2/1,1").endObject()
          //
          .object().key("b.1").value("b.1/1,2").key("b.2")
          .value("b.2/1,2").endObject()
          //
          .endArray().endObject();

      topA.object().key("a").value("a/2").key("b")
          .array()
          //
          .object().key("b.1").value("b.1/2,1").key("b.2")
          .value("b.2/2,1").endObject()
          //
          .object().key("b.1").value("b.1/2,2").key("b.2")
          .value("b.2/2,2").endObject()
          //
          .endArray().endObject();

      topA.endArray();

      JsonImport ji = new JsonImport(x.toString(),
          "Nested Table 1", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

  public static Worksheet createSampleJsonWithNestedTable2(
      boolean hasTwoRows, Workspace workspace) {
    try {

      JSONStringer x = new JSONStringer();

      JSONWriter topA = x.array();
      topA.object().key("a").value("a/1").key("b").array()
      //
          .object()//
          .key("b.1").value("b.1/1,1")//
          .key("b.2").array()//
          .object()//
          .key("b.2.1").value("b.2.1/1,1,1")//
          .key("b.2.2").value("b.2.2/1,1,1")//
          .endObject()//
          .object()//
          .key("b.2.1").value("b.2.1/1,1,2")//
          .key("b.2.2").value("b.2.2/1,1,2")//
          .endObject()//
          .endArray()//
          .endObject()//
          //
          .object()//
          .key("b.1").value("b.1/1,2")//
          .key("b.2").array()//
          .object()//
          .key("b.2.1").value("b.2.1/1,2,1")//
          .key("b.2.2").value("b.2.2/1,2,1")//
          .endObject()//
          .endArray()//
          .endObject();//
      topA.endArray().endObject();

      if (hasTwoRows) {
        topA.object().key("a").value("a/2").key("b").array()
        //
            .object()//
            .key("b.1").value("b.1/2,1")//
            .key("b.2").array()//
            .object()//
            .key("b.2.1").value("b.2.1/2,1,1")//
            .key("b.2.2").value("b.2.2/2,1,1")//
            .endObject()//
            .endArray()//
            .endObject()//
            //
            .object()//
            .key("b.1").value("b.1/2,2")//
            .key("b.2").array()//
            .object()//
            .key("b.2.1").value("b.2.1/2,2,1")//
            .key("b.2.2").value("b.2.2/2,2,1")//
            .endObject()//
            .endArray()//
            .endObject()//
        //
        ;

        topA.endArray().endObject();
      }

      topA.endArray();

      JsonImport ji = new JsonImport(x.toString(),
          "Nested Table 2", workspace, "UTF-8", -1);
      Worksheet w = ji.generateWorksheet();
      return w;
    } catch (JSONException e) {
      e.printStackTrace();
View Full Code Here

Examples of org.json.JSONStringer

        @Override
        public void generateJson(String prefix, PrintWriter pw,
            VWorkspace vWorkspace) {
          try {
            JSONStringer jsonStr = new JSONStringer();
           
            JSONWriter writer = jsonStr.object();
            writer.key("worksheetId").value(worksheetId);
            writer.key("updateType").value("LiteralNodeUpdate")
            writer.key("node");
           
            writer.object();
View Full Code Here

Examples of org.json.JSONStringer

      AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
     
      ArrayList<ArrayList<String>> data = dbUtil.getDataForLimitedRows(dbType, hostname,
          portnumber, username, password, tableName, dBorSIDName, 10);
     
      JSONStringer jsonStr = new JSONStringer();
      JSONWriter writer = jsonStr.object().key(JsonKeys.commandId.name()).value(commandId)
        .key(GenericJsonKeys.updateType.name()).value("ImportDatabaseTablePreview").key(JsonKeys.tableName.name()).value(tableName);
     
      // Add the headers
      JSONArray arr = new JSONArray(data.get(0));
      writer.key(JsonKeys.headers.name()).value(arr);
     
      // Add the data
      JSONArray dataRows = new JSONArray();
      for(int i = 1; i<data.size(); i++) {
        dataRows.put(data.get(i));
      }
      writer.key(JsonKeys.rows.name()).value(dataRows);
     
      writer.endObject();
      pw.println(jsonStr.toString());
    } catch (SQLException e) {
      e.printStackTrace();
      String message = e.getMessage().replaceAll("\n", "").replaceAll("\"","\\\"");
      ErrorUpdate er = new ErrorUpdate(message);
      er.generateJson(prefix, pw, vWorkspace);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.