Importing Data With Migrations

I'm not a huge fan of migrations as I like having control of my SQL bits, however they can be extremely useful for small operations like data imports.
To create my Courses resource and import the data in, I had to use the following migration:

<span class="hljs-keyword">class</span> <span class="hljs-title class_">AddCoursesAndLessonsToSpina</span> &lt; <span class="hljs-title class_ inherited__">ActiveRecord::Migration</span>[<span class="hljs-number">7.1</span>]
  <span class="hljs-keyword">def</span> <span class="hljs-title function_">up</span>
    res = <span class="hljs-title class_">Spina</span><span class="hljs-symbol">:</span><span class="hljs-symbol">:Resource</span>.create!(<span class="hljs-symbol">id:</span> <span class="hljs-number">1</span>, <span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;courses&quot;</span>, <span class="hljs-symbol">label:</span> <span class="hljs-string">&quot;Courses&quot;</span>)
    courses = <span class="hljs-title class_">Course</span>.all
    courses.each <span class="hljs-keyword">do</span> |<span class="hljs-params">course</span>|
      page = <span class="hljs-title class_">Spina</span><span class="hljs-symbol">:</span><span class="hljs-symbol">:Page</span>.create!(
        <span class="hljs-symbol">title:</span> course.name, 
        <span class="hljs-symbol">slug:</span> course.sku,
        <span class="hljs-symbol">resource_id:</span> <span class="hljs-number">1</span>,
        <span class="hljs-symbol">view_template:</span> <span class="hljs-string">&quot;course&quot;</span>,
        <span class="hljs-symbol">json_attributes:</span>{
          <span class="hljs-symbol">en_content:</span> [
            {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;slug&quot;</span>, <span class="hljs-symbol">content:</span> course.sku, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Line&quot;</span>},
            {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;body&quot;</span>, <span class="hljs-symbol">content:</span> course.description, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Text&quot;</span>},
            {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;summary&quot;</span>, <span class="hljs-symbol">content:</span> course.summary, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Line&quot;</span>},
          ]
        }
      )
      course.lessons.each <span class="hljs-keyword">do</span> |<span class="hljs-params">lesson</span>|
        <span class="hljs-title class_">Spina</span><span class="hljs-symbol">:</span><span class="hljs-symbol">:Page</span>.create!(
          <span class="hljs-symbol">title:</span> lesson.title, 
          <span class="hljs-symbol">slug:</span> lesson.slug,
          <span class="hljs-symbol">ancestry:</span> page.id,
          <span class="hljs-symbol">resource_id:</span> <span class="hljs-number">1</span>,
          <span class="hljs-symbol">view_template:</span> <span class="hljs-string">&quot;lesson&quot;</span>,
          <span class="hljs-symbol">json_attributes:</span>{
            <span class="hljs-symbol">en_content:</span> [
              {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;slug&quot;</span>, <span class="hljs-symbol">content:</span> lesson.slug, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Line&quot;</span>},
              {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;vimeo&quot;</span>, <span class="hljs-symbol">content:</span> lesson.vimeo_id, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Line&quot;</span>},
              {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;summary&quot;</span>, <span class="hljs-symbol">content:</span> lesson.summary, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Line&quot;</span>},
              {<span class="hljs-symbol">name:</span> <span class="hljs-string">&quot;body&quot;</span>, <span class="hljs-symbol">content:</span> lesson.description, <span class="hljs-symbol">type:</span> <span class="hljs-string">&quot;Spina::Parts::Text&quot;</span>},
            ]
          }
        )
      <span class="hljs-keyword">end</span>
    <span class="hljs-keyword">end</span>
  <span class="hljs-keyword">end</span>

  <span class="hljs-keyword">def</span> <span class="hljs-title function_">down</span> 
    <span class="hljs-title class_">Spina</span><span class="hljs-symbol">:</span><span class="hljs-symbol">:Page</span>.where(<span class="hljs-symbol">resource_id:</span> <span class="hljs-number">1</span>).destroy_all
    <span class="hljs-title class_">Spina</span><span class="hljs-symbol">:</span><span class="hljs-symbol">:Resource</span>.where(<span class="hljs-symbol">id:</span> <span class="hljs-number">1</span>).destroy_all
  <span class="hljs-keyword">end</span>
<span class="hljs-keyword">end</span>