27 Chapter 27: Database/API Versioning & Migration

emmanuel18909890 · July 28, 2022, 10:37am

Hello Everyone,

I have an issue with the database versioning. I followed the tutorial but at the end I have "{“error”:true,“reason”:“server: column "twitterURL" of relation "users" does not exist (checkInsertTargets)”} " and when I run the finished tutorial, it did the same. Someone can help me ?

Thanks u very much,
Emmanuel

0xtim · July 28, 2022, 11:02am

Did you add the migration to add the new column?

github.com

raywenderlich/vpr-materials/blob/editions/3.0/27-database-api-versioning/projects/final/TILApp/Sources/App/configure.swift#L73


      
          app.migrations.add(CreateAcronym())
          app.migrations.add(CreateCategory())
          app.migrations.add(CreateAcronymCategoryPivot())
          app.migrations.add(CreateToken())
          switch app.environment {
          case .development, .testing:
            app.migrations.add(CreateAdminUser())
          default:
            break
          }
          app.migrations.add(AddTwitterURLToUser())
          app.migrations.add(MakeCategoriesUnique())
          
          
app.logger.logLevel = .debug
          
          
try app.autoMigrate().wait()
          
          
app.views.use(.leaf)
          
          
// register routes
          try routes(app)

You also need to make sure you’ve run the migrations