QSqlRelationalTableModel & advanced relationships

[zuck]

Hi guys!

I need to map database "many-to-many" and "one-to-many" relations into my Qt code. I didn't found an "official" Qt class for this feature so my question is: what's the best approach, in your opinion, for implementing a complete database-relationship support?

My idea is to create two new classes:

1) QSqlAdvancedRelation which inherits from QSqlRelation and maps all three main relation types ("one-to-one", "one-to-many", "many-to-many").

2) QSqlAdvancedRelationalTableModel which inherits from QSqlRelationalTableModel and uses one or more instances of QSqlAdvancedRelation class.

For many-to-many relation, the idea is to use the relation table name as a virtual field name in the original table which value is a list of QModelIndex of the related table and vice versa:

Original table <- Relationship table -> Related table

Original table <- Relationship table -> Related table

To copy to clipboard, switch view to plain text mode 

For one-to-many relation, the approach is simpler: the relation returns the list of QModelIndex of the related model filtered by a where clause.

Original table <- Related table

Original table <- Related table

To copy to clipboard, switch view to plain text mode 

What do you think about this approach?

[Walter]

I have the same problem...

[zuck]

Well, what about to start a collaborative project to implement a better support for database mapping in Qt?

[Walter]

Too late - I've already finalized my own QSqlQuery subclass but in a way that is very specific to my needs.

[zuck]

Ok Could you post any tips about your solution, please?

[Walter]

I've updated my own thread:
http://www.qtcentre.org/forum/f-qt-p...ost112407.html