[jira] [Commented] (METAMODEL-38) JSON file based DataContext model

[Joao Boto (JIRA)]

    [ 
https://issues.apache.org/jira/browse/METAMODEL-38?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14206593#comment-14206593
 ] 

Joao Boto commented on METAMODEL-38:
------------------------------------

Hi Kasper,

I wrote the code below, following your comment, i get "gender" but i can't get 
"first" and "last" fields..

SimpleTableDef custTable = new SimpleTableDef(
                                "customer",
                                new String[] 
{"name.first","name.last","gender","verified","userimage"}
                                );

SchemaBuilder schema = new SimpleTableDefSchemaBuilder("tester", custTable) ;
                
JsonDataContext dc = new JsonDataContext(new FileResource(new 
File("src/test/resources/datafeed.json")),schema);
                
Table table = dc.getDefaultSchema().getTableByName("customer");
Column firstName = table.getColumnByName("name.first");
Column lastName = table.getColumnByName("name.last");
Column gender = table.getColumnByName("gender");
                
DataSet dataSet = 
dc.query().from(table).select(firstName,lastName,gender).execute();
while (dataSet.next()) {
        String sFirstName = (String) dataSet.getRow().getValue(firstName);
        String sLastName = (String) dataSet.getRow().getValue(lastName);
        String sGender = (String) dataSet.getRow().getValue(gender);
}

can you tell me what I'm doing wrong or indicate which way to go?


thanks

> JSON file based DataContext model
> ---------------------------------
>
>                 Key: METAMODEL-38
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-38
>             Project: Metamodel
>          Issue Type: Improvement
>            Reporter: Joao Boto
>            Assignee: Kasper Sørensen
>             Fix For: 4.2.0-incubating
>
>
> Could we support the json file format..
> Json is not unlike xml which is already supported however is a much condensed 
> form, and it is being used as the preferred method of exchange for many API
> one example:
> {
>     "name":{
>         "first":"Joe", 
>         "last":"Sixpack"
>     }, 
>     "gender":"MALE", 
>     "verified":false, 
>     "userImage":"Rm9vYmFyIQ=="
> }



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)