summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDennis Kobert <dennis@kobert.dev>2020-03-03 19:42:49 +0100
committerDennis Kobert <dennis@kobert.dev>2020-03-03 19:42:49 +0100
commit3aac0b0f8bac1e6e5819446befb47db965955721 (patch)
tree3a543218125bff315809a5b40792d33dae0d508a
parente4ce9a3ced88745116fe85e1a3093f1536df2ad9 (diff)
Fix error in database creation
-rw-r--r--src/database.rs6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/database.rs b/src/database.rs
index d3e5e03..2970011 100644
--- a/src/database.rs
+++ b/src/database.rs
@@ -4,7 +4,7 @@ use std::sync::{Arc, Mutex};
lazy_static! {
static ref CLIENT: Arc<Mutex<Client>> = Arc::new(Mutex::new(
- Client::connect("host=track_db user=postgres password=example", NoTls)
+ Client::connect("host=localhost user=postgres password=example", NoTls)
.expect("failed to connect to database")
));
}
@@ -34,10 +34,10 @@ pub fn initialize_db() -> Result<(), Error> {
CREATE OR REPLACE VIEW user_track AS (
SELECT *, "count" / (
SELECT SUM("count")
- FROM user_track ut
+ FROM user_track_raw AS ut
WHERE ut.user_id = user_id
)::decimal AS score
- FROM user_track
+ FROM user_track_raw
);
"#,
)?;