Hey guys. I'd like to do a "ping" or "connection c...
# orm-helpf
fgreinus
12/19/2018, 1:22 PMHey guys. I'd like to do a "ping" or "connection check" when my express-server starts to check if prisma is available via the generated client. Any ideas on how to do this best? (I mean, i could just fire a random query or sth, but maybe there is a recommended way)
d
dpetrick
12/19/2018, 1:27 PMA highly selective query like getting the first user is probably the best. (similar as you would do it in SQL DBs,
SELECT 1p
Priyank Patel
12/19/2018, 2:35 PMMaybe try doing a GET request to http://localhost:4466/management and validate with a 200 response.
a
albinekb
12/19/2018, 2:55 PMNice thing about getting something from the db is that you will also know that db connection is working
albinekb
12/19/2018, 2:55 PMI'm not sure if /management will give 200 ok if db connection is broken?
p
Priyank Patel
12/19/2018, 3:03 PMYou are right, didn't think about that. Maybe ping the db port OR doing a query would be the next option.
Priyank Patel
12/19/2018, 3:05 PMI am using cloudwatch that notifies me when the prisma docker container throw error regarding the db connection failure.
f
fgreinus
12/19/2018, 3:19 PMThanks, guys! Probably will do a very simple query