integrate heroku deployment

[prisma-labs]

integrate heroku deployment

[jasonkuhrt]

progress

Just need to get the db part working now. Presumably there is a free tier postgres we can wire up here.

[jasonkuhrt]

yep

[janpio]

Possible interesting: There are also addons that enable you to get a free tier MySQL db.

[jasonkuhrt]

Good to know!

[jasonkuhrt]

While I was able to perform a lift migration, with apparent success,

e.g.

❯ DEBUG=* yarn prisma2 lift up
yarn run v1.19.2
$ /Users/jasonkuhrt/projects/foobar/node_modules/.bin/prisma2 lift up
  getos { platform: 'darwin', libssl: undefined } +0ms
  getos { platform: 'darwin', libssl: undefined } +15ms
  ensureDatabaseExists {
  ensureDatabaseExists   status: 'Ok',
  ensureDatabaseExists   message: 'Starting a postgresql pool with 17 connections.\n' +
  ensureDatabaseExists     '[2019-12-05T16:41:39Z INFO  migration_engine] Connection successful'
  ensureDatabaseExists } +0ms
  getos { platform: 'darwin', libssl: undefined } +249ms
  LiftEngine:rpc SENDING RPC CALL {"id":1,"jsonrpc":"2.0","method":"listMigrations","params":{"projectInfo":"","sourceConfig":"datasource db {\n  provider = \"postgresql\"\n  url      = \"postgresql://yjiuwpjsouwrfj:[e-mail]:5432/d8m9sd3pgffegr?sslaccept=accept_invalid_certs\"\n}\n\ngenerator photon {\n  provider = \"photonjs\"\n}\n\nmodel World {\n  id         Int    @id\n  name       String @unique\n  population Float\n}\n"}} +0ms
  LiftEngine:stderr [2019-12-05T16:41:39Z INFO  quaint] Starting a postgresql pool with 17 connections. +0ms
🏋️‍ lift up

All migrations are already applied
✨  Done in 1.16s.

I am unable to get photon to connect:

❯ yarn ts-node prisma/seed
yarn run v1.19.2
$ /Users/jasonkuhrt/projects/foobar/node_modules/.bin/ts-node prisma/seed
(node:72607) UnhandledPromiseRejectionWarning: Error:
Invalid `const result = await photon.worlds.create()` invocation in /Users/jasonkuhrt/projects/foobar/prisma/seed.ts:8:38

   4
   5 main()
   6
   7 async function main() {
→  8   const result = await photon.worlds.create(

Reason: Error occurred during query execution:
ConnectorError(QueryError(Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState("42P01"), message: "relation \"public.World\" does not exist", detail: None, hint: None, position: Some(Original(13)), where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("parse_relation.c"), line: Some(1159), routine: Some("parserOpenTable") }) }

stack backtrace:
   0: backtrace::backtrace::trace
   1: backtrace::capture::Backtrace::new_unresolved
   2: failure::backtrace::internal::InternalBacktrace::new
   3: <failure::backtrace::Backtrace as core::default::Default>::default
   4: quaint::connector::postgres::error::<impl core::convert::From<tokio_postgres::error::Error> for quaint::error::Error>::from
   5: <std::future::GenFuture<T> as core::future::future::Future>::poll
   6: <std::future::GenFuture<T> as core::future::future::Future>::poll
   7: std::future::poll_with_tls_context
   8: <std::future::GenFuture<T> as core::future::future::Future>::poll
   9: query_core::interpreter::query_interpreters::write::execute::{{closure}}
  10: <std::future::GenFuture<T> as core::future::future::Future>::poll
  11: <std::future::GenFuture<T> as core::future::future::Future>::poll
  12: <std::future::GenFuture<T> as core::future::future::Future>::poll
  13: std::future::poll_with_tls_context
  14: <std::future::GenFuture<T> as core::future::future::Future>::poll
  15: <std::future::GenFuture<T> as core::future::future::Future>::poll
  16: <std::future::GenFuture<T> as core::future::future::Future>::poll
  17: hyper::proto::h1::dispatch::Dispatcher<D,Bs,I,T>::poll_catch
  18: <hyper::server::conn::upgrades::UpgradeableConnection<I,S,E> as core::future::future::Future>::poll
  19: <hyper::server::conn::spawn_all::NewSvcTask<I,N,S,E,W> as core::future::future::Future>::poll
  20: <std::panic::AssertUnwindSafe<F> as core::ops::function::FnOnce<()>>::call_once
  21: std::panicking::try::do_call
  22: __rust_maybe_catch_panic
  23: tokio_executor::threadpool::task::Task::run
  24: tokio_executor::threadpool::worker::Worker::run_task
  25: tokio_executor::threadpool::worker::Worker::run
  26: tracing_core::dispatcher::with_default
  27: std::thread::local::LocalKey<T>::with
  28: tokio::runtime::threadpool::builder::Builder::build::{{closure}}
  29: std::thread::local::LocalKey<T>::with
  30: std::sys_common::backtrace::__rust_begin_short_backtrace
  31: std::panicking::try::do_call
  32: __rust_maybe_catch_panic
  33: core::ops::function::FnOnce::call_once{{vtable.shim}}
  34: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once
  35: std::sys::unix::thread::Thread::new::thread_start
  36: _pthread_start
))

    at PhotonFetcher.<anonymous> (/Users/jasonkuhrt/projects/foobar/node_modules/@prisma/photon/index.js:54:27)
    at Generator.throw (<anonymous>)
    at rejected (/Users/jasonkuhrt/projects/foobar/node_modules/@prisma/photon/index.js:6:65)
    at processTicksAndRejections (internal/process/task_queues.js:93:5)
(node:72607) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
(node:72607) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

[jasonkuhrt]

This helped unblock me prisma/prisma#884