* Serving Flask app 'app'

* Debug mode: on

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.

* Running on http://127.0.0.1:5000

Press CTRL+C to quit

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 170, in search

cur.execute(sql,t)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7f882c545070>

127.0.0.1 - - [29/Jan/2023 22:10:03] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo desc

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 170, in search

cur.execute(sql,t)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7f1834719ee0>

127.0.0.1 - - [29/Jan/2023 22:12:16] "POST /search HTTP/1.1" 200 -

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 170, in search

cur.execute(sql,t)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7f1834706d60>

127.0.0.1 - - [29/Jan/2023 22:12:51] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

None

uo============== desc

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

discarding closed connection: <psycopg.Connection [BAD] at 0x7f8ef55aaca0>

127.0.0.1 - - [29/Jan/2023 22:19:28] "GET / HTTP/1.1" 200 -

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 171, in search

cur.execute(sql,t)

NameError: name 't' is not defined

discarding closed connection: <psycopg.Connection [BAD] at 0x7f8ef55bb190>

127.0.0.1 - - [29/Jan/2023 22:19:32] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

current user: None

test user: None

uo============== desc

l========== ['%%', 'desc']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 171, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7fc2880cfb20>

127.0.0.1 - - [29/Jan/2023 22:20:11] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

l========== ['%%', 'desc']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

discarding closed connection: <psycopg.Connection [BAD] at 0x7f28800f2880>

127.0.0.1 - - [29/Jan/2023 22:24:44] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f28800f28b0>

127.0.0.1 - - [29/Jan/2023 22:24:47] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f28801960a0>

127.0.0.1 - - [29/Jan/2023 22:24:49] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f2880196070>

127.0.0.1 - - [29/Jan/2023 22:24:55] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 171, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7fcb6afdb940>

127.0.0.1 - - [29/Jan/2023 22:25:16] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

l========== ['%%', 'desc']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 171, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7fe764592250>

127.0.0.1 - - [29/Jan/2023 22:27:01] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

l========== ['%%', 'desc']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

discarding closed connection: <psycopg.Connection [BAD] at 0x7f99986c4fa0>

127.0.0.1 - - [29/Jan/2023 22:28:23] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f99986b3d60>

127.0.0.1 - - [29/Jan/2023 22:28:25] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f999a78ee50>

127.0.0.1 - - [29/Jan/2023 22:28:26] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f9998672a90>

127.0.0.1 - - [29/Jan/2023 22:29:57] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f9998713070>

127.0.0.1 - - [29/Jan/2023 22:29:59] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f999a78ec40>

127.0.0.1 - - [29/Jan/2023 22:30:00] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f99986c4fa0>

127.0.0.1 - - [29/Jan/2023 22:30:01] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f999a78ee20>

127.0.0.1 - - [29/Jan/2023 22:30:03] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

uo============== asc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

uo============== asc

l========== ['%%']

debug============

uo============== desc

l========== ['%%']

debug============

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 169, in search

l = [username_pattern, uer_order]

NameError: name 'uer_order' is not defined

discarding closed connection: <psycopg.Connection [BAD] at 0x7fe5c5c14970>

127.0.0.1 - - [29/Jan/2023 22:55:55] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 169, in search

l = [username_pattern, uer_order]

NameError: name 'uer_order' is not defined

discarding closed connection: <psycopg.Connection [BAD] at 0x7f440632ddf0>

127.0.0.1 - - [29/Jan/2023 22:56:13] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 171, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...T * FROM login WHERE username LIKE $1 ORDER BY username $2 ;

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7fccf86ca1c0>

127.0.0.1 - - [29/Jan/2023 22:56:46] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

uo============== desc

l========== ['%%', 'desc']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 134-270-053

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 171, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...CT * FROM login WHERE username LIKE $1 ORDER BY username $2;

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7f47c4195970>

127.0.0.1 - - [29/Jan/2023 22:58:07] "POST /search HTTP/1.1" 200 -

* Serving Flask app 'app'

* Debug mode: on

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.

* Running on http://127.0.0.1:5000

Press CTRL+C to quit

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

127.0.0.1 - - [30/Jan/2023 06:18:12] "GET /search HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2548, in __call__

return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2528, in wsgi_app

response = self.handle_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2525, in wsgi_app

response = self.full_dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1822, in full_dispatch_request

rv = self.handle_user_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1820, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1796, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

File "/home/shiyanlou/db/app/__init__.py", line 165, in search

username_pattern = "%" + username + "%"

TypeError: can only concatenate str (not "NoneType") to str

127.0.0.1 - - [30/Jan/2023 06:18:12] "GET /search?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:18:12] "GET /search?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:18:12] "GET /search?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:18:12] "GET /search?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:18:13] "GET /search HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2548, in __call__

return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2528, in wsgi_app

response = self.handle_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2525, in wsgi_app

response = self.full_dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1822, in full_dispatch_request

rv = self.handle_user_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1820, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1796, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

File "/home/shiyanlou/db/app/__init__.py", line 165, in search

username_pattern = "%" + username + "%"

TypeError: can only concatenate str (not "NoneType") to str

127.0.0.1 - - [30/Jan/2023 06:18:13] "GET /search?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:18:13] "GET /search?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:18:13] "GET /search?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

un: None

uo============== None

un: None

uo============== None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

127.0.0.1 - - [30/Jan/2023 06:22:33] "GET /search HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2548, in __call__

return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2528, in wsgi_app

response = self.handle_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2525, in wsgi_app

response = self.full_dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1822, in full_dispatch_request

rv = self.handle_user_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1820, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1796, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

File "/home/shiyanlou/db/app/__init__.py", line 163, in search

username_pattern = "%" + username + "%"

TypeError: can only concatenate str (not "NoneType") to str

127.0.0.1 - - [30/Jan/2023 06:22:33] "GET /search?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:33] "GET /search?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:33] "GET /search?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:34] "GET /search HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2548, in __call__

return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2528, in wsgi_app

response = self.handle_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2525, in wsgi_app

response = self.full_dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1822, in full_dispatch_request

rv = self.handle_user_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1820, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1796, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

File "/home/shiyanlou/db/app/__init__.py", line 163, in search

username_pattern = "%" + username + "%"

TypeError: can only concatenate str (not "NoneType") to str

127.0.0.1 - - [30/Jan/2023 06:22:34] "GET /search?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:34] "GET /search?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:34] "GET /search?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:40] "GET /search HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2548, in __call__

return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2528, in wsgi_app

response = self.handle_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2525, in wsgi_app

response = self.full_dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1822, in full_dispatch_request

rv = self.handle_user_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1820, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1796, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

File "/home/shiyanlou/db/app/__init__.py", line 163, in search

username_pattern = "%" + username + "%"

TypeError: can only concatenate str (not "NoneType") to str

127.0.0.1 - - [30/Jan/2023 06:22:40] "GET /search?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:40] "GET /search?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:22:40] "GET /search?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff0e0c32640>

127.0.0.1 - - [30/Jan/2023 06:22:42] "GET / HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff0e0c326d0>

127.0.0.1 - - [30/Jan/2023 06:22:44] "GET / HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff0e0bdd7f0>

127.0.0.1 - - [30/Jan/2023 06:22:45] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff0e0bddac0>

127.0.0.1 - - [30/Jan/2023 06:22:48] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff0e2cfadc0>

127.0.0.1 - - [30/Jan/2023 06:22:48] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff0e2cfab50>

127.0.0.1 - - [30/Jan/2023 06:22:49] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

un: None

un: None

un: None

current user: None

test user: None

current user: None

test user: None

un:

uo==============

l========== ['', '']

debug============

un:

uo============== desc

l========== ['', 'desc']

debug============

un:

uo============== asc

l========== ['', 'asc']

debug============

un:

uo============== desc

l========== ['', 'desc']

debug============

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7f420011d9a0>

127.0.0.1 - - [30/Jan/2023 06:23:57] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f420196bf40>

127.0.0.1 - - [30/Jan/2023 06:23:59] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f420011d070>

127.0.0.1 - - [30/Jan/2023 06:24:00] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f42000a15e0>

127.0.0.1 - - [30/Jan/2023 06:24:00] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f4200050b50>

127.0.0.1 - - [30/Jan/2023 06:24:01] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f4200050e80>

127.0.0.1 - - [30/Jan/2023 06:24:05] "GET / HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f4200050e20>

127.0.0.1 - - [30/Jan/2023 06:24:07] "GET / HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f4200050f40>

127.0.0.1 - - [30/Jan/2023 06:24:09] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

un:

uo============== desc

l========== ['%%', 'desc']

debug============

un:

uo============== asc

l========== ['%%', 'asc']

debug============

un:

uo============== desc

l========== ['%%', 'desc']

debug============

un:

uo============== asc

l========== ['%%', 'asc']

debug============

un:

uo============== desc

l========== ['%%', 'desc']

debug============

current user: None

test user: None

current user: None

test user: None

un:

uo==============

l========== ['%%', '']

debug============

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 176, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7f1548b67df0>

127.0.0.1 - - [30/Jan/2023 06:24:35] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

un:

uo==============

l========== ['%%', '']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7f3961b157c0>

127.0.0.1 - - [30/Jan/2023 06:26:52] "GET / HTTP/1.1" 200 -

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 176, in search

cur.execute(sql,l)

File "/home/shiyanlou/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 723, in execute

raise ex.with_traceback(None)

psycopg.errors.SyntaxError: syntax error at or near "$2"

LINE 1: ...ECT * FROM login WHERE username LIKE $1 ORDER BY username $2

^

discarding closed connection: <psycopg.Connection [BAD] at 0x7f3961b15af0>

127.0.0.1 - - [30/Jan/2023 06:26:54] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

current user: None

test user: None

un:

uo==============

l========== ['%%', '']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7fa918ca29a0>

127.0.0.1 - - [30/Jan/2023 06:29:42] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7fa918c89070>

127.0.0.1 - - [30/Jan/2023 06:29:43] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7fa918c262e0>

127.0.0.1 - - [30/Jan/2023 06:29:44] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7fa918c26d60>

127.0.0.1 - - [30/Jan/2023 06:29:45] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

un:

uo==============

l========== ['%%']

debug============

un:

uo============== desc

l========== ['%%']

debug============

un:

uo============== asc

l========== ['%%']

debug============

un:

uo============== desc

l========== ['%%']

debug============

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7f9594957c70>

127.0.0.1 - - [30/Jan/2023 06:30:44] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f9594919a60>

127.0.0.1 - - [30/Jan/2023 06:30:46] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f9596a34df0>

127.0.0.1 - - [30/Jan/2023 06:30:46] "POST /search HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f9596a34f70>

127.0.0.1 - - [30/Jan/2023 06:30:47] "POST /search HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

un:

uo============== desc

l========== ['%%']

debug============

un:

uo============== asc

l========== ['%%']

debug============

un:

uo============== desc

l========== ['%%']

debug============

un:

uo============== asc

l========== ['%%']

debug============

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 897, in run_command

app = info.load_app()

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 308, in load_app

app = locate_app(import_name, name)

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 218, in locate_app

__import__(module_name)

File "/home/shiyanlou/db/app/__init__.py", line 198, in <module>

def search():

File "/usr/local/lib/python3.8/dist-packages/flask/scaffold.py", line 449, in decorator

self.add_url_rule(rule, endpoint, f, **options)

File "/usr/local/lib/python3.8/dist-packages/flask/scaffold.py", line 50, in wrapper_func

return f(self, *args, **kwargs)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1358, in add_url_rule

raise AssertionError(

AssertionError: View function mapping is overwriting an existing endpoint function: search

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 142-687-100

127.0.0.1 - - [30/Jan/2023 06:38:25] "GET /add_users HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 906, in app

raise err from None

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 897, in run_command

app = info.load_app()

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 308, in load_app

app = locate_app(import_name, name)

File "/usr/local/lib/python3.8/dist-packages/flask/cli.py", line 218, in locate_app

__import__(module_name)

File "/home/shiyanlou/db/app/__init__.py", line 198, in <module>

def search():

File "/usr/local/lib/python3.8/dist-packages/flask/scaffold.py", line 449, in decorator

self.add_url_rule(rule, endpoint, f, **options)

File "/usr/local/lib/python3.8/dist-packages/flask/scaffold.py", line 50, in wrapper_func

return f(self, *args, **kwargs)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1358, in add_url_rule

raise AssertionError(

AssertionError: View function mapping is overwriting an existing endpoint function: search

127.0.0.1 - - [30/Jan/2023 06:38:25] "GET /add_users?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:38:25] "GET /add_users?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:38:25] "GET /add_users?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 200 -

127.0.0.1 - - [30/Jan/2023 06:38:25] "GET /add_users?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7f7a896acdc0>

127.0.0.1 - - [30/Jan/2023 06:39:04] "GET /add_users HTTP/1.1" 500 -

Traceback (most recent call last):

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2548, in __call__

return self.wsgi_app(environ, start_response)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2528, in wsgi_app

response = self.handle_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 2525, in wsgi_app

response = self.full_dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1822, in full_dispatch_request

rv = self.handle_user_exception(e)

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1820, in full_dispatch_request

rv = self.dispatch_request()

File "/usr/local/lib/python3.8/dist-packages/flask/app.py", line 1796, in dispatch_request

return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)

File "/home/shiyanlou/db/app/__init__.py", line 217, in add_users

return render_template("show_data.html", l = records, search_user = username, user_order = u2)

NameError: name 'records' is not defined

127.0.0.1 - - [30/Jan/2023 06:39:04] "GET /add_users?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:39:04] "GET /add_users?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1" 304 -

127.0.0.1 - - [30/Jan/2023 06:39:04] "GET /add_users?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1" 304 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

l========== ['kaibdsqvm|', 'owscche{ei']

it is done!

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7f2e4096d4f0>

127.0.0.1 - - [30/Jan/2023 06:39:40] "GET /add_users HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f2e408df520>

127.0.0.1 - - [30/Jan/2023 06:39:45] "GET / HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7f2e408f2a00>

127.0.0.1 - - [30/Jan/2023 06:39:48] "GET / HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

l========== ['yofveomvmw', 'xjgznhmnlc']

current user: None

test user: None

current user: None

test user: None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff3886d4c10>

127.0.0.1 - - [30/Jan/2023 06:40:08] "GET / HTTP/1.1" 200 -

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 208, in add_users

cur.commit()

AttributeError: 'Cursor' object has no attribute 'commit'

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff388f20b20>

127.0.0.1 - - [30/Jan/2023 06:40:15] "GET /add_users HTTP/1.1" 200 -

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff3886d4f40>

127.0.0.1 - - [30/Jan/2023 06:40:25] "GET / HTTP/1.1" 200 -

Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 208, in add_users

cur.commit()

AttributeError: 'Cursor' object has no attribute 'commit'

discarding closed connection: <psycopg.Connection [BAD] at 0x7ff3886587f0>

127.0.0.1 - - [30/Jan/2023 06:40:34] "GET /add_users HTTP/1.1" 200 -

* Detected change in '/home/shiyanlou/db/app/__init__.py', reloading

current user: None

test user: None

l========== ['xolsvxlgxz', '{|kapzvgxu']

None

current user: None

test user: None

l========== ['|lyvhzmdvi', '{kyvhzr{uj']

None

* Restarting with stat

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.

* Debugger is active!

* Debugger PIN: 350-906-571

l========== ['zfcvagixzb', 'jwnxoperqf']

l========== ['cnvcbpdanc', 'k|g|g{lyap']

l========== ['kcoa|y|kbu', 'dter|uysdf']

l========== ['jgjljgrnsk', 'k|o|aexmgv']

l========== ['dtuwpgovn|', '{gaindua{m']

l========== ['tiplg{hxgg', 'xo{chsdiz{']

l========== ['mndjtcbqbz', 'dcid{gmewz']

l========== ['qmlheyrunw', 'f{nqxxsu{l']

l========== ['dyuvyevspn', 'pbk|hb|ycv']

l========== ['xgaizlntlb', 'khpduv||vp']

l========== ['lqpzsrp|nt', 'gmuvtcfuii']

l========== ['lsiab{hsch', '{jgyvafr{v']

l========== ['ztupaytdlb', 'd{wl|ewszz']

l========== ['fteyozgbb{', 'ugmllag{sf']

l========== ['e|{jt{kpbo', 'obmmjmsl{u']

l========== ['jmhiw{nmgb', 'rdbiaswwfa']

l========== ['jbgvb|jhpw', 'd|vootka|q']

l========== ['kniavib|bp', 'kpwitsihcf']

l========== ['cegxtenqxt', 'dvtonwnhbh']

l========== ['ixdsucgygh', 'wqrcr|mrln']

l========== ['liagthkwkt', 'pcrflmuiiv']

l========== ['jbfuylofkv', 'lpgjukfxpn']

l========== ['mxuqh|gkfl', 'hrvorp{a|y']

l========== ['ypgpxg{bir', 'xyxnbqdwxs']

l========== ['sqctpiofjd', 'fc|onzh{dd']

l========== ['kgbngndh{b', '{jmoceonco']

l========== ['jpxjcjmfgf', '|jofi{|fdl']

l========== ['lrqolagzfv', 'zsqtqzahrx']

l========== ['ylpkgjkxgk', 'n{jk{wtxk|']

l========== ['xiy|jxtlut', '{jpzx{nawg']

l========== ['qdjwzauuwa', 'cptsexw{ai']

l========== ['iaybivupkj', 'rsweohacqa']

l========== ['euwptyjsdr', '|xh{uyispv']

l========== ['k{tlibezqv', 'zw{ertnrhw']

l========== ['cwr|xlegmd', 'ewtf{mpxuv']

l========== ['ntvi|qiomj', 'jlfhtpixoz']

l========== ['vuuvcr|{uh', 'zlskslwjwn']

l========== ['ckgzwsltsu', 'psi|tlmqtc']

l========== ['wpngjgvrwu', 'ohrugxtvzg']

l========== ['gjcub{oxek', 'cytnyptnko']

l========== ['sgvdpghszs', 'konzraejpx']

l========== ['theqxt|n{q', 'qnkwkjgixp']

l========== ['sdfejcbpxo', 'qidyutqksp']

l========== ['pvpo|pwjhn', 'rynyax|gdt']

l========== ['hizh|dpbnd', 'j|p{vudxrj']

l========== ['rwezxctqsf', 'yu|matweep']

l========== ['rcaeouc|ze', 'bejyzadsul']

l========== ['vddxmtaext', 'utbzerqali']

l========== ['uytncdvliz', 'zagwycxohv']

l========== ['oyxnklcmj{', 'k{mvmknysx']

l========== ['pmjndaoqds', 'wzvhhhuwdh']

l========== ['mtylcijjsn', 'djlmigtdmh']

l========== ['twda|niubu', 'b{qzse|gbs']

l========== ['saqxagmwif', 'jgt{a|svfw']

l========== ['ilznu{ejyo', 'eece{mfner']

l========== ['mra{nhtmjc', '{thstfg|ua']

l========== ['myrysrfgan', 'ohfirtemib']

l========== ['gunvryhw{r', 'qq{yxzqtci']

l========== ['szfgiukpzr', 'ogqxqcuuyn']

l========== ['cdzegfrh{p', 'vqt{blyqcf']

l========== ['lcj|{ddnm{', 'tproqkfrru']

l========== ['gzblqztaf|', '|uxon|niqv']

l========== ['jnzsarddjr', 'ohsc{csove']

l========== ['aqbxsmtugv', 'grfaxlmlw{']

l========== ['lfxisby|vf', 'ygxprf{lig']

l========== ['mm|{eiitwh', 'vgzyqj{alo']

l========== ['csbgj{rgio', 'rnjntsornv']

l========== ['btwlooc|py', 'obohp{dpyk']

l========== ['sys{gm|fwe', 'puq{qtxqrq']

l========== ['{klrpoxzgg', 'ghar|hyowo']

l========== ['vgdprxez{u', 'lyzerndz|q']

l========== ['jbwyiiztz{', 'elekmdiauc']

l========== ['oc|geyrzma', 'flnf|vw|{x']

l========== ['hqbvpqmui{', 'ifszvgnrkq']

l========== ['qiisotdgdv', 'agkcrujpte']

l========== ['fugrsfom{p', 'fg{kbubuot']

l========== ['ngjckdmheg', 'vrtv{vnoil']

l========== ['boefck|{sx', 'bibrjkseai']

l========== ['piiaeemy|h', '|roohgaqey']

l========== ['kloqfaljra', 'umsekyh{hf']

l========== ['eihdqheyvd', 'ghdyzkeswt']

l========== ['lhpkmwvyzw', 'dazbylv{d{']

l========== ['cokyghifpi', '|wusbswvdf']

l========== ['acdfcphufo', 'tzxbfujooc']

l========== ['uamwcjlfej', 'rlx{kkbvcn']

l========== ['blmycvemxo', 'alhf|beaqu']

l========== ['zmhybutwnd', '|zrwdssz{w']

l========== ['ichvrvqzsj', 'zhhizgatel']

l========== ['vlxsochywv', 'esfff|dshc']

l========== ['exknxksdox', 'kgglbskmko']

l========== ['rqrvikrxj{', 'dcbpmu|iun']

l========== ['pfsi|xdxtk', 'ozzuesaxqa']

l========== ['wbtjuiayju', 'jirihx{qvx']

l========== ['xbrcsdrfx|', 'les|qrbuvd']

l========== ['wwihbbdawm', 'dhclzwpffu']

l========== ['xzrgsijfdu', 'hjfsofrrtq']

l========== ['yb|phug|iu', 'csnsojwjrs']

l========== ['ij{k|{jdu|', 'apqbayxhxp']

l========== ['xigakjibgl', 'opfzzfiohk']

l========== ['guxcamdozu', '{erx{qpxhv']

l========== ['utpxygcylu', 'bmcwswavjr']

l========== ['o|qydsfply', '{lphtgxpaa']

l========== ['vbywtwgd|r', 'kzlwlsildz']

l========== ['ggcuh|tzyb', 'fevjnhblfu']

l========== ['uoylt{dczh', 'kgbji{vtdn']

l========== ['{goufpkucm', 'sl{hnx{v{h']

l========== ['hexhhiymhr', 'cwjjyikky{']

l========== ['rguvry|peb', 'wsfppzwmce']

l========== ['urdueciz|d', '{vgzjbecit']

l========== ['mjqwfbzasz', 'blxjoa{{{e']

l========== ['yvijpqcbvo', 'klpttotrmh']

l========== ['ycxhsvaxss', 'nuolhnpjvs']

l========== ['hpslucfbuu', 'julxoccsxv']

l========== ['jxn{lfxtyi', 'sylmsb{doz']

l========== ['mgwvtgefci', 'vtltltqlve']

l========== ['ps{yivaj{f', 'laipfibota']

l========== ['ulxc{ymiev', 'cutevaxfao']

l========== ['wvcwbfisoy', 'rrrfapxs|t']

l========== ['lcvcfv|qpl', 'krfsmcybqb']

l========== ['f{vecokzjo', 'ignxoxizq|']

l========== ['drltqllaeq', 'bgimcquufi']

l========== ['qvxrinusxv', 'aenyrdw{en']

l========== ['duljtdqcae', 'vj|uiounlp']

l========== ['a{jugixb|j', 'fkcdlcfdar']

l========== ['feobklgpgv', 'z{tc{qxmie']

l========== ['xspnimhawe', 'jdqyts|he{']

l========== ['fozfhnvkxb', 'zcnxo{j{ld']

l========== ['ohdmrupflz', 'the{p{ehah']

l========== ['nrsbumwhhd', 'gdvnfkmkio']

l========== ['kbxibqpxiy', 'ntusirr||t']

l========== ['ddi{weyyhp', 'j{lku{wibq']

l========== ['qlwz|dxzoz', 'prhjjuoal{']

l========== ['ujxz{nucmc', 'axapyxjwvu']

l========== ['{yuadodtny', 'afilzkmqyn']

l========== ['htzvaflyph', 'igjlgfqovo']

l========== ['bm{hthumbb', 'xvcnwgpkmm']

l========== ['sustojteul', 'v{fnqadggg']

l========== ['dgxazuj{nv', 'eavtbdyhlz']

l========== ['iwbwbxmqbi', 'lcaofgijol']

l========== ['{ihyc|lxev', 'onnghqxoia']

l========== ['khfygekjrw', 'nsnhoufbox']

l========== ['pjrvawpkzb', 'm{ajifnkax']

l========== ['vzhlpwntrt', 'rbjkpmnik{']

l========== ['b|hzlbrgle', 'lgygixqtq{']

l========== ['ahiehwpfzq', 'hs{rgxuigi']

l========== ['slzgabdymq', 'fwftroccvo']

l========== ['bcwkerozgg', 'xudhpeueod']

l========== ['utectya{ur', '|eamhuurwb']

l========== ['n|fiwz|qcv', 'zdq|pd|zbs']

l========== ['fsqoxk|fru', 'iimbbvfogq']

l========== ['wzin{zfmze', 'nzoyguzz{o']

l========== ['sac{d|svxt', 'if{igzlvll']

l========== ['gnvpqklwey', 'xoktljqky{']

l========== ['jpi||rretn', 'hmirpllfdc']

l========== ['prmanxzrsm', 'lu|ximofdo']

l========== ['{eoawfavxd', 'fbanwbdwqw']

l========== ['miiuqdxnkl', 'elvcqhgpsw']

l========== ['qkylpccecq', 's|uzsjgttw']

l========== ['f|gy|jfulb', 'dqt{givjcs']

l========== ['gfmnjryqqf', 'tzjinweg|q']

l========== ['qfwsyflxzs', 't{kfmgeveo']

l========== ['wijxsqozyt', 'djjrx{ba|f']

l========== ['vqbryhoerl', 'bjvgnutjyk']

l========== ['zngzbpi{no', 'cugjxidmgx']

l========== ['rv{chhociu', 'gadsdtpkbq']

l========== ['alzzuvhrnc', '|hkeeskqyp']

l========== ['vlkobypqae', 'mvxprqnvvd']

l========== ['tqfmcyzrul', 'rx{awzwcvf']

l========== ['gdopfdztel', 'kqleizuoja']

l========== ['blzpciqnny', 'bvhma{fadg']

l========== ['ynddgwaowa', 'nvvw{aok{l']

l========== ['vexhzzukam', '|dkls|nmrc']

l========== ['unactixcwk', 'ubdhnxppxm']

l========== ['byeyucgrgc', 'sodhzjlquj']

l========== ['wmqiifvdfz', 'xgyczizwve']

l========== ['bhwv|nt{jo', 'exgyybxntl']

l========== ['t|yslaglts', 'fxt{fjjwgp']

l========== ['nluxfbxvjp', 'sgqorusmbe']

l========== ['oqzfzgqdrt', 'binhorbdxq']

l========== ['pmsdyeazkj', 'xugbopc{iv']

l========== ['gdfuwkgqqh', 'v{mn{ywdnt']

l========== ['xhnienlkvx', 'u{|skdn|ks']

l========== ['omtpe{wduv', 'tdxs{ygahm']

l========== ['gzbdkyafw{', 'qkyfpbykoh']

l========== ['fymjmdtyfa', 'qbdb{ucvsi']

l========== ['tgip{lsaqy', 'ifeubpj|cs']

l========== ['xcexjbwbvl', 'dywowetqrv']

l========== ['jzcvnfzzim', 'uwwar{knko']

l========== ['xfuorbxkgr', 'z|drr{|gi|']

l========== ['brcvod|dsf', 'djmigllmsq']

l========== ['jozuourjy{', 'aojsfdld||']

l========== ['ujfxxokyjz', 'ohaekbpuqr']

l========== ['gmbcetmovs', 'mrchbzcqhx']

l========== ['vlhyeullcq', 'jxxdv|zqid']

l========== ['kkgvuzqaxd', '{r|qd|bdlx']

l========== ['ydtbp{g|mv', 'vehlvdjqku']

l========== ['ua{hnrt{tv', 'sybbvti|jt']

l========== ['sdc{|gscxw', 'hiewovbjcr']

l========== ['x|agazqzuv', '|bnrcqzstr']

l========== Traceback (most recent call last):

File "/home/shiyanlou/db/app/__init__.py", line 209, in add_users

cur.commit()

AttributeError: 'Cursor' object has no attribute 'commit'

discarding closed connection: <psycopg.Connection [BAD] at 0x7f504419da60>

127.0.0.1 - - [30/Jan/2023 06:42:00] "GET /add_users HTTP/1.1" 200 -

['ony{gqrlwk', 'qfvogvkrtq']

None

l========== ['rhowmjmaer', 'zr{oxfox{a']

l========== ['amxadqxom|', 'bslesnsvg|']

l========== ['pczserdbtx', 'spqtip|yoo']

l========== ['kjoehqjjck', 'kruchrklmm']

l========== ['nflxvwqphk', 'sfd{fetp|i']

l========== ['e|jhqftfsk', '|qhulpc{kx']

l========== ['atlqf|glpr', 'qitl{d|p{j']

l========== ['xdtpp|gbwe', 'jxctspwoou']

l========== ['|avyrfzgni', 'uro|pyyyhp']

l========== ['yjyvxxbnfn', 'ekjcbzwerc']

l========== ['prfgexvdns', 'm|xzsvczcn']

l========== ['{igymv|sab', 'a{imunbjwq']

l========== ['g|nmantatw', 'ddpcjjzju{']

l========== ['yfmtsnhkzy', 'fxy{jngdby']

l========== ['hkvtzgqvgi', 'lzdiqull{d']

l========== ['txdodhpqtw', 'damyrhltms']

l========== ['akmklkzpyy', 'ubznofyqam']

l========== ['dkqyeaacaa', '{kmfezwiiw']

l========== ['iazvcgxjdy', 'uvvloy|dmz']

l========== ['hkjiqfkkfq', 'crppjcjrwf']

l========== ['hbsklwfm{m', 'ysrrpyvyfd']

l========== ['hgb|od{zd|', 'mv{cwbiulr']

l========== ['vvsiuupo{v', 'shhmrknwwx']

l========== ['ufx{l|hscq', 'awlqytmrkj']

l========== ['jxnxuwpglp', 'jigzdvaaqk']

l========== ['ioripdobfq', 'wzyqppufmx']

l========== ['owhte{ua{b', 'mxa|yzxvzu']

l========== ['inqczbea{x', 'euogxssias']

l========== ['vgvuazhgwo', 'wms{quizzf']

l========== ['|rskrfqyit', 'mpvasxrwgr']

l========== ['xdcaisszih', 'yuwr|yfybl']

l========== ['|ayneqvsfl', 'lcpuzlci{m']

l========== ['zuvdibgptq', 'vruuktaphr']

l========== ['nm|qfeczhe', 'akkr|vhu|u']

l========== ['yobeaxzdbw', 'vpsiowendr']

l========== ['h|nloj|trr', 'p{eemgzoez']

l========== ['ijtli{txlt', 'cvqua|eqlm']

l========== ['dvrx|ihahk', '|okgjvabgd']

l========== ['jdstydxmgi', 'ngszcfwshr']

l========== ['kwysdfkevk', 'bupirzvdpz']

l========== ['qxk{zydzla', 'n|xoizeq|r']

l========== ['gjjpsodwco', 'rhpkasducy']

l========== ['ecxb|{ghwf', 'jecerdirld']