Hello, we are using SmartGWTEE's SQLDataSource on the server to connect to the DB.
I'll try to explain what we're looking for by describing our data model and our current database-editor, and hopefully you can say how we can achieve the same capabilities using SmartGWT.
We have an hierarchical data model, where we have a base type, and several derived types (for example - base File, and Image,Music,Video derived types with specific fields for each of them).
This bases on a Star-Scheme. For example, an Image record: The File related fields of a record are in the File table. The Image fields are in the Image Table, and the PK is a FK to the rest of the record in the File table.
Our current editor presents the data based on this model, and can represent the entire Image record in one row. When editing a field in the record, it can be mapped to know which table to update. inserts and deletes are the same, based on the order of relations.
We thought the DataSource's "inheritsFrom" was on the way there because it presented the record completely, until:
1. It couldn't update fields at all.
2. If the base type had a binary field, the supporting field (filesize etc) were searched at the derived type's table.
Are we missing a simple solution, or we have to write custom DataSource to perform this logic?
Thank you!
I'll try to explain what we're looking for by describing our data model and our current database-editor, and hopefully you can say how we can achieve the same capabilities using SmartGWT.
We have an hierarchical data model, where we have a base type, and several derived types (for example - base File, and Image,Music,Video derived types with specific fields for each of them).
This bases on a Star-Scheme. For example, an Image record: The File related fields of a record are in the File table. The Image fields are in the Image Table, and the PK is a FK to the rest of the record in the File table.
Our current editor presents the data based on this model, and can represent the entire Image record in one row. When editing a field in the record, it can be mapped to know which table to update. inserts and deletes are the same, based on the order of relations.
We thought the DataSource's "inheritsFrom" was on the way there because it presented the record completely, until:
1. It couldn't update fields at all.
2. If the base type had a binary field, the supporting field (filesize etc) were searched at the derived type's table.
Are we missing a simple solution, or we have to write custom DataSource to perform this logic?
Thank you!
Comment