JSON-java/JSONDateUtils.java at master · agur/JSON-java · GitHub

History

95 lines (85 loc) · 5.22 KB

Raw

package org.json;

import java.text.ParseException;

import java.text.ParsePosition;

import java.text.SimpleDateFormat;

import java.util.Date;

import org.junit.Test;

/**

* Use where a date format is known to have colons the values and lack wrapping double quotes, such as "{date_time:2013-06-15 09:30:09.234}"

* And the value will be correctly wrapped with double quotes.

* Sent as a pull request at: {@link "https://github.com/douglascrockford/JSON-java/pull/103"}

* @author Amir Gur

* @since 9/2/2014

public class JSONDateUtils {

public static String fixJSONTimeFormat(String text, SimpleDateFormat sdf, String[] jsonNames) throws ParseException {

String ret = null;

for(String name : jsonNames) {

ret = fixJSONTimeFormat(ret == null ? text : ret, sdf, name);

}

return ret;

}

public static String fixJSONTimeFormat(String text, SimpleDateFormat sdf, String jsonName) throws ParseException {

int pos = text.indexOf(jsonName);

if(pos < 0) {

throw new ParseException("Can't find json name: " + jsonName, pos);

}

int p = pos + jsonName.length() + 1;

Date date = sdf.parse(text, new ParsePosition(p));

if(date == null) {

throw new IllegalArgumentException("Can't parse date pattern: " + sdf.toPattern() + ", in text: " + text + ", at pos: " + p);

}

String relevantString = text.substring(p);

String prefix = text.substring(0, p);

int relevantEnd = relevantString.indexOf(',');

if(relevantEnd < 0)

relevantEnd = relevantString.indexOf('}');

if(relevantEnd < 0)

throw new ParseException("Can't find end of value: " + jsonName + ", relevantString: " + relevantString, relevantEnd);

String suffix = relevantString.substring(relevantEnd);

return prefix + "\"" + relevantString.substring(0,relevantEnd) + "\"" + suffix;

}

@Test

public void testGetDate() throws ParseException {

testOne("{date_time:2013-06-15 01:30:09.234}", "yyyy-MM-dd HH:mm:ss.SSS", "date_time");

testOne("{date_time:2013-06-15 02:30:09.234, abc:222}", "yyyy-MM-dd HH:mm:ss.SSS", "date_time");

testOne("{date_time:2013-06-15 03:30:09.234-0700}", "yyyy-MM-dd HH:mm:ss.SSSZ", "date_time");

testOne("{date_time:2013-06-15 04:30:09.234-0700, abc:222}", "yyyy-MM-dd HH:mm:ss.SSSZ", "date_time");

testOne("{ab: xyz, date_time:2013-06-15 05:30:09.234-0700}", "yyyy-MM-dd HH:mm:ss.SSSZ", "date_time");

testOne("{date_time:2013-06-15 06:30:09.234-0700, abc:222}", "yyyy-MM-dd HH:mm:ss.SSSZ", "date_time");

testOne("{date_time: 2013-06-15 07:30:09.234-0700, abc:222}", "yyyy-MM-dd HH:mm:ss.SSSZ", "date_time");

try {

testOne("{date_time:\"2013-06-15 08:30:09.234-0700\", abc:222}", "yyyy-MM-dd HH:mm:ss.SSSZ", "date_time");

} catch(IllegalArgumentException e) {

System.out.println("Exception for not legal input is expected here, since value starts with a double quote.");

}

testFew("{date_time:2013-06-15 09:30:09.234-0700, abc:222, date2_time:2013-06-15 09:30:09.234-0700}", "yyyy-MM-dd HH:mm:ss.SSSZ", new String[]{"date_time", "date2_time"});

testFew("{date_time:2013-06-15 10:30:09.234-0700, abc:222, date2_time:2013-06-15 11:30:09.234-0700}", "yyyy-MM-dd HH:mm:ss.SSSZ", new String[]{"date_time", "date2_time"});

testFew("{date_time:2013-06-15 12:30:09.234-0700, abc:222, date_time2:2013-06-15 12:30:09.234-0700}", "yyyy-MM-dd HH:mm:ss.SSSZ", new String[]{"date_time", "date_time2"});

testFew("{date_time:2013-06-15 13:30:09.234-0700, abc:222, date_time2:2013-06-15 14:30:09.234-0700}", "yyyy-MM-dd HH:mm:ss.SSSZ", new String[]{"date_time", "date_time2"});

testOne("{date_time: 2013-06-15 14:30:09.234, abc:222}", "yyyy-MM-dd HH:mm:ss.S", "date_time");

testOne("{date_time: 2013-06-15 15:30:09.23, abc:222}", "yyyy-MM-dd HH:mm:ss.S", "date_time");

testOne("{date_time: 2013-06-15 16:30:09.2, abc:222}", "yyyy-MM-dd HH:mm:ss.S", "date_time");

testOne("{date_time: 2013-06-15 17:30:09.0, abc:222}", "yyyy-MM-dd HH:mm:ss.S", "date_time");

testFew("{creationDate:2014-08-15 19:01:11.588, lastModifiedDate:2014-09-08 14:44:00.006}", "yyyy-MM-dd HH:mm:ss.S", new String[]{"creationDate", "lastModifiedDate"});

}

private void testOne(String jsonStr, String pattern, String jsonName) throws ParseException {

SimpleDateFormat sdf = new SimpleDateFormat(pattern);

String fixed = fixJSONTimeFormat(jsonStr, sdf, jsonName);

JSONObject jsonObject = new JSONObject(fixed);

Object value = jsonObject.get(jsonName);

System.out.println("fixed: " + fixed + ", value: " + value);

}

private void testFew(String jsonStr, String pattern, String[] jsonNames) throws ParseException {

SimpleDateFormat sdf = new SimpleDateFormat(pattern);

String fixed = fixJSONTimeFormat(jsonStr, sdf, jsonNames);

System.out.println("jsonStr: " + jsonStr + ", fixed: " + fixed);

JSONObject jsonObject = new JSONObject(fixed);

for(String jsonName : jsonNames) {

Object value = jsonObject.get(jsonName);

System.out.println("fixed: " + fixed + ", value: " + value);

}

JSON-java/JSONDateUtils.java at master · agur/JSON-java · GitHub

Expand file tree

Breadcrumbs

JSONDateUtils.java

Latest commit

History

Breadcrumbs

JSONDateUtils.java

File metadata and controls