Chapter 6 Cloud Vapor Deploy Error

wuudles · November 26, 2018, 4:58am

Hi, I am following the guide in chapter 6 and on the very last step when I’m testing out my endpoint
https://chen-wu-look-at-me.vapor.cloud/api/acronyms
I get this error:
{
“reason”: “Model.defaultDatabase is required to use request as DatabaseConnectable.”,
“error”: true
}

Does anyone have any ideas? I just followed the code samples in the chapter.

Thank you

shogunkaramazov · November 26, 2018, 11:40am

@0xtim Can you please help with this when you get a chance? Thank you - much appreciated! :]

0xtim · November 26, 2018, 2:34pm

@wuudles when you added the model to the migration config did you do migrations.add(migration:)? You need to use the migrations.add(model:). Or you forgot to add it to the list of migrations?

wuudles · November 26, 2018, 4:36pm

I’m sorry, i’m not sure i understand. what variable migrations are you referring to? I can post my configure.swift if that helps.

// 1
import FluentPostgreSQL
import Vapor

public func configure(
    _ config: inout Config,
    _ env: inout Environment,
    _ services: inout Services
    ) throws { // 2
    try services.register(FluentPostgreSQLProvider())
    let router = EngineRouter.default()
    try routes(router)
    services.register(router, as: Router.self)
    var middlewares = MiddlewareConfig()
    middlewares.use(ErrorMiddleware.self)
    services.register(middlewares)
    // Configure a database
    
    // 1
    var databases = DatabasesConfig()
    // 2
    let hostname = Environment.get("DATABASE_HOSTNAME")
        ?? "localhost"
    let username = Environment.get("DATABASE_USER") ?? "vapor"
    let databaseName = Environment.get("DATABASE_DB") ?? "vapor"
    let password = Environment.get("DATABASE_PASSWORD")
        ?? "password"
    // 3
    let databaseConfig = PostgreSQLDatabaseConfig(
        hostname: hostname,
        username: username,
        database: databaseName,
        password: password)
// 4
    let database = PostgreSQLDatabase(config: databaseConfig)
    // 5
    databases.add(database: database, as: .psql)
    // 6
    services.register(databases)
}

0xtim · November 26, 2018, 5:02pm

Yeah you’re missing a section! You need something that looks like this:

github.com

raywenderlich/vapor-til/blob/main/Sources/App/configure.swift#L93


      
          /// Copyright (c) 2021 Razeware LLC
          ///
          /// Permission is hereby granted, free of charge, to any person obtaining a copy
          /// of this software and associated documentation files (the "Software"), to deal
          /// in the Software without restriction, including without limitation the rights
          /// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
          /// copies of the Software, and to permit persons to whom the Software is
          /// furnished to do so, subject to the following conditions:
          ///
          /// The above copyright notice and this permission notice shall be included in
          /// all copies or substantial portions of the Software.
          ///
          /// Notwithstanding the foregoing, you may not use, copy, modify, merge, publish,
          /// distribute, sublicense, create a derivative work, and/or sell copies of the
          /// Software in any work that is designed, intended, or marketed for pedagogical or
          /// instructional purposes related to programming, coding, application development,
          /// or information technology.  Permission for such use, copying, modification,
          /// merger, publication, distribution, sublicensing, creation of derivative works,
          /// or sale is expressly withheld.
          ///
          /// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
          /// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
          /// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
          /// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
          /// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
          /// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
          /// THE SOFTWARE.
          
          
import Fluent
          import FluentPostgresDriver
          import Vapor
          import Leaf
          
          
// configures your application
          public func configure(_ app: Application) throws {
            // uncomment to serve files from /Public folder
            app.middleware.use(FileMiddleware(publicDirectory: app.directory.publicDirectory))
            app.middleware.use(app.sessions.middleware)
            
            let databaseName: String
            let databasePort: Int
            if (app.environment == .testing) {
              databaseName = "vapor-test"
              if let testPort = Environment.get("DATABASE_PORT") {
                databasePort = Int(testPort) ?? 5433
              } else {
                databasePort = 5433
              }
            } else {
              databaseName = "vapor_database"
              databasePort = 5432
            }
          
          
  app.databases.use(.postgres(
              hostname: Environment.get("DATABASE_HOST") ?? "localhost",
              port: databasePort,
              username: Environment.get("DATABASE_USERNAME") ?? "vapor_username",
              password: Environment.get("DATABASE_PASSWORD") ?? "vapor_password",
              database: Environment.get("DATABASE_NAME") ?? databaseName
            ), as: .psql)
            
            app.migrations.add(CreateUser())
            app.migrations.add(CreateAcronym())
            app.migrations.add(CreateCategory())
            app.migrations.add(CreateAcronymCategoryPivot())
            app.migrations.add(CreateToken())
            app.migrations.add(CreateAdminUser())
          
          
  app.http.server.configuration.hostname = "0.0.0.0"
            
            app.logger.logLevel = .debug
            
            try app.autoMigrate().wait()
          
          
  app.views.use(.leaf)
            
            // register routes
            try routes(app)
          }

Use migrations.add(model:database:) for actual models and use migrations.add(migration:database:) for migrations that alter databases or seed data etc