Adding foreign key to model using chicagoboss?

Question

I am a newbie to erlang and chicago boss. I followed Chicago boss API documentation. I have been working with Python and Django earlier. Now in Chicago boss can we add foreign key in models.

This is my model.

model: anatomy.erl

-module(anatomy, [Id,
                 UID,
                 Name,
                 Property,
                 Ratio::float(),
                 Value::integer(),
                 Pieces::float(),
                 Status]).
-compile(export_all).

There is another model.

model: species.erl

-module(species, [Id,
                 UID,
                 Name,
                 Property,
                 Anatomy,
                 Morphology   
                 Gender]).
-compile(export_all).

I have to add Anatomy as a foreign key in species table.

mongodb is not a relational database. use `belongs_to(species)`. `http://www.chicagoboss.org/api-record.html` — Laxmikant Ratnaparkhi, Jul 08 '14 at 10:00

7i11 · Answer 1 · 2019-02-27T18:12:51.673

model: anatomy.erl

-module(anatomy, [Id,
             UID,
             Name,
             Property,
             Ratio::float(),
             Value::integer(),
             Pieces::float(),
             Status]).
-has({species,many}).
-compile(export_all).

model: species.erl

-module(species, [Id,
             UID,
             Name,
             Property,
             AnatomyId,
             Morphology   
             Gender]).
-belongs_to(anatomy).
-compile(export_all).

score 1 · Answer 2 · answered Aug 12 '14 at 20:40

I'm not entirely sure that I understand your question, so forgive me if this is a waste of your time. But... I think you need to rename the property in the anatomy.erl to AnatomyId and then make use of the -belongs and -has associations:

module(species, [Id,
                 UID,
                 Name,
                 Property,
                 AnatomyId,
                 Morphology   
                 Gender]).
-compile(export_all).
-belongs_to(anatomy).

The -belongs_to(anatomy) will add a function, anatomy() which returns the BossRecord, of type anatomy, with the id = AnatomyId.

This will not create a relation in Mongo, but might give you the behavior you are looking for

Adding foreign key to model using chicagoboss?

2 Answers2