From f080854b84d80f6063b4f9392d059a84ec09e66c Mon Sep 17 00:00:00 2001 From: Shav Kinderlehrer Date: Sun, 7 Apr 2024 15:35:46 -0400 Subject: Version 1.0 --- src/post.rs | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/post.rs') diff --git a/src/post.rs b/src/post.rs index b597f99..e19d6ae 100644 --- a/src/post.rs +++ b/src/post.rs @@ -44,8 +44,8 @@ pub async fn create_link( if let Some(index) = id.index { res = sqlx::query( " -INSERT INTO chela.urls (index,id,url) -VALUES ($1,$2,$3) +INSERT INTO chela.urls (index,id,url,custom_id) +VALUES ($1,$2,$3,false) ", ) .bind(index) @@ -56,8 +56,8 @@ VALUES ($1,$2,$3) } else { res = sqlx::query( " -INSERT INTO chela.urls (id,url) -VALUES ($1,$2) +INSERT INTO chela.urls (id,url,custom_id) +VALUES ($1,$2,true) ", ) .bind(id.id.clone()) @@ -102,7 +102,7 @@ VALUES ($1,$2) async fn generate_id(form: CreateForm, state: ServerState) -> eyre::Result { if form.id.is_empty() { let existing_row: Result = - sqlx::query_as("SELECT * FROM chela.urls WHERE url = $1") + sqlx::query_as("SELECT * FROM chela.urls WHERE url = $1 AND custom_id = 'false'") .bind(form.url.as_str()) .fetch_one(&state.db_pool) .await; -- cgit v1.2.3