summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjeffreytse <jeffreytse.mail@gmail.com>2021-08-09 23:35:26 +0800
committerjeffreytse <jeffreytse.mail@gmail.com>2021-08-09 23:35:26 +0800
commitf06b7b0e62d5cb6c9fe2dacf4a0f59cfedf3dd5e (patch)
treeed15b1463cebd15f3beaf981ace24f0368fbc1f2
parentad541c4306e2ca8691e5b04a11d421435af703a8 (diff)
feat: update another-test-markdown.md
-rw-r--r--_posts/2016-01-01-another-test-markdown.md13
1 files changed, 13 insertions, 0 deletions
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 |
|-------------------------|-------------------|--------|-------|------------------------|-------|------|----------------------|-----------|