I have imported 2 models, I have a mqsql join tabl...
# prisma-whats-newm
Michael
03/19/2017, 9:44 PMI have imported 2 models, I have a mqsql join table as json but I am not exactly sure how to connect the 2 models, especially since Graph.Cool doesn't let you set IDs
n
nilan
03/19/2017, 9:49 PM@Michael create a relation in The Console first. What's the cardinality of both sides of the relation?
m
Michael
03/19/2017, 9:56 PMI created the relation in the console. The cardinality is many-to-many
Michael
03/19/2017, 10:00 PMThe schema has logos and colors. The cardinality is many-to-many. In my MySQL DB I have a logos table, colors table and logoColors table which is the join and it contains an ID, LOGO_ID, COLOR_ID.
n
nilan
03/19/2017, 10:01 PM@Michael cool, now you can use nested mutations to create both sides of the relation at the same time if you want
nilan
03/19/2017, 10:01 PMor you create all nodes of one side and keep a map of old ids from your JSON to new ids From Graphcool. Then when creating the nodes of the other side, you can pass the id to the create mutation
nilan
03/19/2017, 10:02 PMdoes that make sense?
m
Michael
03/19/2017, 10:06 PMI think so. I also think I've just been sitting in front of the computer for too long today. I'll give that a try. Thanks
Michael
03/19/2017, 10:08 PMThat being said, I already imports both the logos and the colors
n
nilan
03/19/2017, 10:10 PMyou can now construct the two maps from old id to new id
nilan
03/19/2017, 10:11 PMand then use the addTo<relationname> mutation to connect the nodes
m
Michael
03/19/2017, 10:13 PMPerfect! Thanks
n
nilan
03/19/2017, 10:14 PM👍
nilan
03/20/2017, 9:00 AMlet me know if that worked out 🙂