Adding Associations to Schemas

Programming Ecto — Pragmatic Programmers (32 / 122)

👈 Inserting and Deleting with Schemas | TOC | Working with Associations i n Queries 👉

Databases are about tables, and the relationships between them. Consider the data model we’ve been working with throughout this book. Artists have many albums, and albums have many tracks as well as many genres. Let’s drill down to one specific relationship first, the one between artists and albums.

In this section, we’ll look at the different types of associations that Ecto supports, and how we can add them to our schemas. We’ll then look at how to modify our queries to work with associations, and how they can help us insert new records with ease.

To get our first taste of associations, let’s create a schema for our albums table. Based on what we learned in the last section, we know that it will start with something like this:

Related posts:

A form of peer review in which code is incrementally inspected with an eye toward architectural concerns as the code is developed. Code review is a fantastic practice that every team should do…

Carmen Knight is a 20- year-old college student at Alabama State University. She is a junior at ASU, involved in modeling at fashion events at the university, and part of the student group, Elite…

This is a gig you booked 2 years ago. It’s a band you’ve wanted to see for 15 years, and the only reason you’re getting the chance to see them now is because they came out of “retirement” to do one…