How to parse a json with date exported by mongoexport in Scala?

Question

Given this code example:

import com.mongodb.util.JSON
import com.mongodb.casbah.Imports._
val json = """{"date" : { "$date" : 1327064009959 }}"""
val doc = JSON.parse(json)

I get this error: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String

What can I do to get this parsed correctly in Scala with Casbah?

The json IS valid. It is the $date which causes problems while parsing in scala — Piotr Zolnierek, Mar 18 '12 at 06:18
Just enclose the seconds in double quotes. `"""{"date" : { "$date" : "1327064009959" }}"""` and file a bug against Casbah that it doesn't support longs. — nicerobot, Mar 18 '12 at 12:05

score 0 · Answer 1 · answered Mar 18 '12 at 10:47

There is a solution, which I don't like too much, thou:

import com.mongodb.util.JSON
import com.mongodb.casbah.Imports._
import scala.util.matching.Regex

val json = """{"date" : { "$date" : 1327064009959 }}"""
val doc = JSON.parse(json)
var regex = new Regex("""\{ "\$date" : (\d+) \}""", "date")
val fixed = regex replaceAllIn (json, m => "\"" + (new DateTime(m.group("date").toLong)) + "\"" )
val doc = JSON.parse(fixed).asInstanceOf[DBObject]

score -1 · Answer 2 · edited Mar 18 '12 at 11:32

-1

Check this typo, this is the valid JSON you should pass

var json = '
    {
        "date": {
            "$date": 1327064009959
        }
    }';

edited Mar 18 '12 at 11:32

om-nom-nom

62,329
13
183
228

answered Mar 18 '12 at 05:57

Sam Arul Raj T

1,752
17
23

Are you sure you are not messing up javascript with scala? Cause I sure it wont even compile in scala, cause ticks are used by characters, not strings: `val ok = 'x'` and this will throw an error: `val notOk = 'notOk'`. Hence your solution is meaningless. – om-nom-nom Mar 18 '12 at 11:30

How to parse a json with date exported by mongoexport in Scala?

2 Answers2