metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen <i.am.kasper.soren...@gmail.com>
Subject Re: [JSON Connector] Multiple Tables and Joining
Date Thu, 23 Jun 2016 16:29:17 GMT
Hi Vijay,

If you want both returned then you shouldn't query for `accounts[0]` but
just `accounts`. The returned object will be lists if I recall correctly.

Kasper

2016-06-22 10:23 GMT-07:00 Vijay Kumar Jalagari <jalagari@adobe.com>:

> Hi,
>
> I am trying JSON connector and facing issues while defining the multiple
> table based on below JSON.
>
> { "name": "VJ",
>                 "age": 29,
>                 "accounts": [{
>                                 "type": "Saving",
>                                 "name": "HDFC"}, {
>                                 "type": "Current",
>                                 "name": "SBI"}]}
>
> Use case - Wanted to define two table out of above json with following
> fields
>
> *         Employee - name & age
>
> *         Accounts - name & type
>
> So that user can fetch either data of employee or account or both using
> joins. I tried below code but it's not working
>
> SimpleTableDef tableDef = new SimpleTableDef("employee", new String[] {
> "name", "age" });
> SimpleTableDef accountDef = new SimpleTableDef("account", new String[] {
> "accounts.type", "accounts.name" });
> SchemaBuilder schemaBuilder = new SimpleTableDefSchemaBuilder("myschema",
> tableDef, accountDef);
> dataContext = new JsonDataContext(new
> InMemoryResource("x/y",stringToJSON(),new Date().getTime()),schemaBuilder);
>
> Verified the test cases and found the way to create table in combine way
> by using definition[0] but when I say select accounts[0].type from
> employee  it only returns Saving instead of getting both Saving & Current
>
>
> Can anyone please guide me to create multiple tables for above JSON data ?
>
>
>
>
>
>
>
> [0] - SimpleTableDef tableDef = new SimpleTableDef("employee", new
> String[] { "name", "age", "accounts[0]", "accounts[0].type",
> "accounts[0].name" });
>
>
> Regards,
> Vijay Kumar J
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message