curl -fsSL get.docker.com -o get-docker.sh
sh get-docker.sh

sudo systemctl enable docker
sudo systemctl start docker
sudo groupadd docker
sudo usermod -aG docker $USER

sudo curl -L https://github.com/docker/compose/releases/download/1.25.5/docker-compose-`uname -s`-`uname -m` -o /usr/local/bin/docker-compose
sudo chmod +x /usr/local/bin/docker-compose
docker-compose --version

scp Dreamoji-server root@144.202.101.94:~

apt install unzip
unzip Dreamoji-server.zip

cd Dreamoji-server
docker-compose build
docker-compose up app

struct ModifyNameToCategory: Migration {
    func prepare(on database: Database) -> EventLoopFuture<Void> {
        return database.schema(ArticleCategory.schema)
            .unique(on: ArticleCategory.nameKey)
            .update()

    }
    func revert(on database: Database) -> EventLoopFuture<Void> {
       ...
    }
}

[ INFO ] query read _fluent_migrations
[ INFO ] query read _fluent_migrations limits=[count(1)]
[ ERROR ] syntax error at end of input (scanner_yyerror)
[ ERROR ] server: syntax error at end of input (scanner_yyerror)
Fatal error: Error raised at top level: server: syntax error at end of input (scanner_yyerror): file /AppleInternal/BuildRoot/Library/Caches/com.apple.xbs/Sources/swiftlang/swiftlang-1103.8.25.8/swift/stdlib/public/core/ErrorType.swift, line 200

import Foundation
import Fluent
import FluentSQL
import FluentPostgresDriver
struct ModifyNameToCategory: Migration {
    func prepare(on database: Database) -> EventLoopFuture<Void> {
        /*
        //Because the Fluent kit didn't implement this feature, so we need to run the sql raw.
        return database.schema(ArticleCategory.schema)
            .unique(on: ArticleCategory.nameKey)
            .update()
        */
        let psgl = database as! PostgresDatabase
        let sql = "ALTER TABLE \(ArticleCategory.schema) ADD CONSTRAINT name_unique UNIQUE (\(ArticleCategory.nameKey))"
        print(sql)
        return psgl.query(sql)
            .transform(to: ())

    }
    func revert(on database: Database) -> EventLoopFuture<Void> {
        let psgl = database as! PostgresDatabase
        let sql = "ALTER TABLE \(ArticleCategory.schema) DROP CONSTRAINT name_unique"
        print(sql)
        return psgl.query(sql)
            .transform(to: ())
    }
}

export DATABASE_PORT="5433"; export DATABASE_USERNAME="test"; export DATABASE_PASSWORD="test"; export DATABASE_NAME="test"; swift test

name: test
on:
  push:
jobs:
  test:
    container:
      image: vapor/swift:5.2
    services:
      psql:
        image: postgres
        ports:
          - 5432:5432
        env:
          POSTGRES_USER: test
          POSTGRES_DB: test
          POSTGRES_PASSWORD: test
    runs-on: ubuntu-latest 
    
    steps:
      - name: 'Checking out repo'	       
        uses: actions/checkout@v2	
      - name: 'Running Integration Tests'	
				run: swift test --enable-test-discovery --sanitize=thread
        env:
         DATABASE_PORT: 5432
         DATABASE_USERNAME: test
         DATABASE_PASSWORD: test
         DATABASE_NAME: test
         DATABASE_HOST: psql

import Vapor
class CapturingViewRenderer: ViewRenderer {
    var shouldCache = false
    var eventLoop: EventLoop
    init(eventLoop: EventLoop) {
        self.eventLoop = eventLoop
    }
    
    func `for`(_ request: Request) -> ViewRenderer {
        return self
    }

    private(set) var capturedContext: Encodable?
    private(set) var templatePath: String?
    func render<E>(_ name: String, _ context: E) -> EventLoopFuture<View> where E : Encodable {
        self.capturedContext = context
        self.templatePath = name
        let string = "I just want to get the context and the templatePath, I don't care what the view will look like"
        var byteBuffer = ByteBufferAllocator().buffer(capacity: string.count)
        byteBuffer.writeString(string)
        let view = View(data: byteBuffer)
        return eventLoop.future(view)
    }
}

func getArticlesHandler(req: Request) throws -> EventLoopFuture<View> {
        return Article.query(on: req.db).all().flatMap {
            return req.view.render("Home",  HomeContext(articles: $0))
        }
    }

final class ArticleRoutesTests: XCTestCase {
    var app: Application!
    let url = "/articles"
    let articleName = "Swift"
    let articleBody = "This is my first post"
    var capturingViewRender: CapturingViewRenderer!
    
    override func setUpWithError() throws {
        app = Application(.testing)
        try configure(app)
        capturingViewRender = CapturingViewRenderer(eventLoop: app.eventLoopGroup.next())
        app.views.use {_ in self.capturingViewRender }
    }
		...
}

func testGetArticles() throws {
      try Utils.cleanDatabase(db: app.db)
      let article = Article(name: articleName, body: articleBody)
      try article.save(on: app.db).wait()
      try app.test(.GET, url) { res in
          let context = try XCTUnwrap(capturingViewRender.capturedContext as? ArticleController.HomeContext)
          XCTAssert(capturingViewRender.templatePath == "Home", "render to wrong page")
          XCTAssertTrue(context.articles?.count == 1, "GET /articles api failed.")
          XCTAssertTrue(context.articles?.first?.name == articleName, "GET /articles api failed.")
          XCTAssertTrue(context.articles?.first?.body == articleBody, "GET /articles api failed.")
      }
  }

final class Article: Model, Content {
    static var schema: String = "articles"
    static var idKey: FieldKey = .id
    static var nameKey: FieldKey = "name"
    static var slugKey: FieldKey = "slug"
    static var bodyKey: FieldKey = "body"
    static var categoryIDKey: FieldKey = "category_id"
    static var createdKey: FieldKey = "created_at"
    static var updatedKey: FieldKey = "updated_at"
    
    @ID(key: idKey)
    var id: UUID?
    
    @Field(key: nameKey)
    var name: String
    
    @Field(key: slugKey)
    var slug: String?
    
    @Field(key: bodyKey)
    var body: String
   
    @OptionalParent(key: categoryIDKey)
    var category: ArticleCategory?
    
    @Timestamp(key: createdKey, on: .create)
    var createdAt: Date?
    
    @Timestamp(key: updatedKey, on: .update)
    var updatedAt: Date?
    
    init() {
    }
    init(name: String, body:String, categoryID: UUID? = nil) {
        self.name = name
        self.body = body
        self.$category.id = categoryID
        self.slug = "\(Date().formatedString())\(name.split(separator: " ").joined(separator: "-"))"
    }
    
}

struct CreateTile: Migration {
    // Prepares the database for storing Tile models.
    func prepare(on database: Database) -> EventLoopFuture<Void> {
        database.schema("tiles")
            .id()
            .field("x", .int, .required)
            .field("y", .int, .required)
            .field("z", .int, .required)
            .create()
    }

    // Optionally reverts the changes made in the prepare method.
    func revert(on database: Database) -> EventLoopFuture<Void> {
        database.schema("tiles").delete()
    }
}

struct UpdateTile: Migration {
    // Prepares the database for storing Tile models.
    func prepare(on database: Database) -> EventLoopFuture<Void> {
        database.schema("tiles")
            .field("new", .int)
            .update()
    }

    // Optionally reverts the changes made in the prepare method.
    func revert(on database: Database) -> EventLoopFuture<Void> {
        database.schema("tiles").deleteField("new").update()
    }
}

func testDatabaseConfig() throws {
    let app = Application(.testing)
    defer { app.shutdown() }
    try configure(app)
    XCTAssertTrue(Int(Environment.get("DATABASE_PORT") ?? "5432")! == 5433, "DATABASE_PORT is wrong")
    XCTAssertTrue(Environment.get("DATABASE_USERNAME") == "test", "DATABASE_USERNAME is wrong")
    XCTAssertTrue(Environment.get("DATABASE_PASSWORD") == "test", "DATABASE_PASSWORD is wrong")
    XCTAssertTrue(Environment.get("DATABASE_NAME") == "test", "DATABASE_PASSWORD is wrong")
}