Skip to content

Instantly share code, notes, and snippets.

@joscdk
Last active April 15, 2022 08:33
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joscdk/c4b89add26509c6dfabf84974e62543d to your computer and use it in GitHub Desktop.
Save joscdk/c4b89add26509c6dfabf84974e62543d to your computer and use it in GitHub Desktop.
#!/usr/bin/swift sh
import PostgreSQL // https://github.com/vapor/postgresql.git ~> 1.0.0
let group = MultiThreadedEventLoopGroup(numberOfThreads: 1)
struct VersionMetadata: Codable {
var version: String
}
let client = try PostgreSQLConnection.connect(hostname: "localhost", port: 5432, on: group).wait()
_ = try client.authenticate(username: "vapor", database: "test", password: "password").wait()
client.logger = DatabaseLogger(database: .psql, handler: PrintLogHandler())
let results = try client.select().column(.function("version", [])).all(decoding: VersionMetadata.self).wait()
print(results[0].version)
@mxcl
Copy link

mxcl commented Jan 15, 2019

Could be:

import PostgreSQL  // @vapor ~> 1.0

But either works fine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment