From 97598e7edfcdc97e665453d6f5cda316bd51291b Mon Sep 17 00:00:00 2001 From: Kjetil Orbekk Date: Sat, 8 Oct 2022 08:26:57 -0400 Subject: Add initial postgresql database setup --- server/.env | 3 ++- server/Cargo.toml | 1 + server/migrations/20221008120534_init.down.sql | 2 ++ server/migrations/20221008120534_init.up.sql | 8 ++++++++ 4 files changed, 13 insertions(+), 1 deletion(-) create mode 100644 server/migrations/20221008120534_init.down.sql create mode 100644 server/migrations/20221008120534_init.up.sql (limited to 'server') diff --git a/server/.env b/server/.env index fe7eb8f..61c7e89 100644 --- a/server/.env +++ b/server/.env @@ -4,4 +4,5 @@ RUST_BACKTRACE=1 OPENID_ISSUER_URL=https://auth.orbekk.com/realms/test OPENID_CLIENT_ID=test-client OPENID_CLIENT_SECRET=EbIMIpGnYPrG1GBl6eZtVM5zIhiuu5p1 -APP_URL=https://bridge.orbekk.com \ No newline at end of file +APP_URL=https://bridge.orbekk.com +DATABASE_URL=postgres://bridge_nightly:bridge_nightly@dragon.nyc.orbekk.com/bridge_nightly \ No newline at end of file diff --git a/server/Cargo.toml b/server/Cargo.toml index 92e4730..e7824a2 100644 --- a/server/Cargo.toml +++ b/server/Cargo.toml @@ -21,3 +21,4 @@ uuid = { version = "1.1.2", features = ["serde", "fast-rng", "v4"] } tower-cookies = "0.7.0" tower = { version = "0.4.13", features = ["full"] } urlencoding = "2.1.2" +sqlx = { version = "0.6", features = [ "runtime-tokio-native-tls" , "postgres" ] } \ No newline at end of file diff --git a/server/migrations/20221008120534_init.down.sql b/server/migrations/20221008120534_init.down.sql new file mode 100644 index 0000000..3b80b80 --- /dev/null +++ b/server/migrations/20221008120534_init.down.sql @@ -0,0 +1,2 @@ +-- Add down migration script here +drop table if exists users; diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql new file mode 100644 index 0000000..bcd9c2c --- /dev/null +++ b/server/migrations/20221008120534_init.up.sql @@ -0,0 +1,8 @@ +-- Add up migration script here +create table users ( + id uuid primary key, + username varchar(32) not null, + access_token varchar(2048) not null, + access_token_expiration timestamp with time zone not null, + refresh_token varchar(512) not null +); -- cgit v1.2.3