From f06b7b0e62d5cb6c9fe2dacf4a0f59cfedf3dd5e Mon Sep 17 00:00:00 2001 From: jeffreytse Date: Mon, 9 Aug 2021 23:35:26 +0800 Subject: feat: update another-test-markdown.md --- _posts/2016-01-01-another-test-markdown.md | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to '_posts') diff --git a/_posts/2016-01-01-another-test-markdown.md b/_posts/2016-01-01-another-test-markdown.md index 4c9481d..62db32b 100644 --- a/_posts/2016-01-01-another-test-markdown.md +++ b/_posts/2016-01-01-another-test-markdown.md @@ -103,6 +103,19 @@ void insert(const char* key) { p ":+1:" ``` +``` diff ++ 'user_exists' => 'SELECT EXISTS(SELECT 1 FROM table WHERE username = (:username || \'@sample'))', ++ 'get_users' => 'SELECT split_part(username, \'@\', 1) FROM table WHERE (username ILIKE :search) OR (name ILIKE :search)', ++ 'get_password_hash_for_user' => 'SELECT split_part(password, \'{CRYPT}\', 2) FROM table WHERE username = (:username || \'@sample\')', ++ 'set_password_hash_for_user' => 'UPDATE table SET password = \'{CRYPT}\' || :new_password_hash WHERE username = (:username || \'@sample\')', +``` + +Reload the Nginx: + +``` console +$ sudo nginx -s reload +``` + |: |: :|: $$O_3 + C_2H_2 \rightarrow $$ :|||: $$O_3 + C_2H_4 \rightarrow $$ :|||: :| |: ^^ Method :| ^^ $$\lambda^a$$ | vdW | TS | cycloadd. | vdW | TS | cycloadd. | ^^ MAE | |-------------------------|-------------------|--------|-------|------------------------|-------|------|----------------------|-----------| -- cgit v1.2.3