name 'conn' is not defined
Request Method: | GET |
---|---|
Request URL: | http://cosbi6.ee.ncku.edu.tw/YQFC/ |
Django Version: | 1.11 |
Exception Type: | NameError |
Exception Value: | name 'conn' is not defined |
Exception Location: | /home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py in <module>, line 30 |
Python Executable: | /usr/bin/python3 |
Python Version: | 3.4.3 |
Python Path: | ['/home/alphabet7431/Django/alphabet7431_project', '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4', '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/plat-x86_64-linux-gnu', '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/lib-dynload', '/usr/lib/python3.4', '/usr/lib/python3.4/plat-x86_64-linux-gnu', '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages'] |
Server time: | Fri, 29 Mar 2024 01:46:55 +0000 |
/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py
in <module>
from collections import OrderedDict
import pymysql
# dataAll=pd.read_json('/home/alphabet7431/Django/alphabet7431_project/file/Genome_features_Change.json', orient='split') #總表!!
#mysql讀檔程式 :讀總表
try :
conn = pymysql.connect("localhost","alphabet7431","624001479","alphabet7431_database")...
cursor = conn.cursor()
# cursor.execute("SELECT * FROM `qqqa412` WHERE `a`")
cursor.execute("SELECT `Primary SGDID`, `Feature type`, `Feature qualifier`, `Feature name`, `Standard gene name`, `Alias`, `Parent feature name`, `Secondary SGDID`, `Chromosome`, `Start_coordinate`, `Stop_coordinate`, `Strand`, `Genetic position`, `Description`, `Transcriptional plasticity`, `# of mRNA isoforms`, `5'UTR length`, `3'UTR length`, `Transcription level`, `Dataset1 (Csárdi)`, `Dataset2 (Ingolia)`, `Dataset3 (Gerashchenko)`, `Dataset4 (McManus)`, `Dataset5 (Subtelny)`, `mRNA expression level`, `mRNA half-life`, `Transcriptional frequency`, `Protein half-life`, `CDS length`, `Protein length`, `Molecular weight`, `Isoelectric point`, `Aliphatic index`, `Instability index`, `Codon bias`, `Codon adaptation index`, `Frequency of optimal codons`, `Hydropathicity of protein`, `Aromaticity score`, `All Cys residues appear as half cystines`, `No Cys residues appear as half cystines`, `Carbon`, `Hydrogen`, `Nitrogen`, `Oxygen`, `Sulfur`, `A`, `C`, `D`, `E`, `F`, `G`, `H`, `I`, `K`, `L`, `M`, `N`, `P`, `Q`, `R`, `S`, `T`, `V`, `W`, `Y`, `PubMed ID`, `# of publications`, `Phenotype`, `# of mutant phenotypes`, `Regulator`, `# of transcriptional regulators`, `Domains`, `# of protein domains`, `GO Slim term`, `# of GO slim terms`, `GO terms`, `# of GO terms`, `Pathways`, `# of pathways`, `# of PTMs`, `# of fungal homologs`, `# of non-fungal and S. cerevisiae homologs`, `Biogrid Physical`, `BioGRID`, `Biogrid Genetic`, `GI network`, `CC`, `CC network`, `CX`, `CX network`, `DC`, `DC network`, `GN`, `GN network`, `GT`, `GT network`, `HT`, `YeastNet_HT`, `LC`, `YeastNet_LC`, `PG`, `PG network`, `TS`, `TS network`, `Physical Interaction`, `PIA network`, `Genetic Interaction`, `GIA network`, `TF Binding`, `TFBA network`, `TF Regulation`, `TFRA network`, `Expression Profile`, `EPA network`, `Functional Annotation`, `FAA network`, `Literature Evidence`, `LEA network`, `Mutant Phenotype`, `MPA network`, `Dataset1 (Mean molecules per cell)`, `Dataset2 (Median molecules per cell)`, `Dataset3 (LU)`, `Dataset4 (PENG)`, `Dataset5 (KUL)`, `Dataset6 (LAW)`, `Dataset7 (LAHT)`, `Dataset8 (DGD)`, `Dataset9 (LEE2)`, `Dataset10 (THAK)`, `Dataset11 (NAG)`, `Dataset12 (PIC)`, `Dataset13 (WEB)`, `Dataset14 (TKA)`, `Dataset15 (BRE)`, `Dataset16 (DEN)`, `Dataset17 (MAZ)`, `Dataset18 (CHO)`, `Dataset19 (YOF)`, `Dataset20 (NEW)`, `Dataset21 (LEE)`, `Dataset22 (DAV)`, `Dataset23 (GHA)`, `2mM dithiothreitol, 2h`, `1mM H2O2, 1h`, `0.67% yeast nitrogen base without amino acids and without ammoni`, `0.2M hydroxyurea, 160 min`, `200 ng/ml rapamycin, 700 min`, `YPAD + 50 mg/mL ampicillin, 7d`, `0.03% methyl methanesulfonate, 7h`, `0.03% methyl methanesulfonate, 4h`, `0.02% methyl methanesulfonate, 2h`, `0.2M hydroxyurea, 2h`, `0.03% methyl methanesulfonate, 2h` FROM `Genome_features` WHERE 1 ")
GFs = cursor.fetchall()
cursor.execute("SHOW columns FROM Genome_features")
Variable | Value |
---|---|
HttpResponse | <class 'django.http.response.HttpResponse'> |
JsonResponse | <class 'django.http.response.JsonResponse'> |
OrderedDict | <class 'collections.OrderedDict'> |
__builtins__ | {'ArithmeticError': <class 'ArithmeticError'>, 'AssertionError': <class 'AssertionError'>, 'AttributeError': <class 'AttributeError'>, 'BaseException': <class 'BaseException'>, 'BlockingIOError': <class 'BlockingIOError'>, 'BrokenPipeError': <class 'BrokenPipeError'>, 'BufferError': <class 'BufferError'>, 'BytesWarning': <class 'BytesWarning'>, 'ChildProcessError': <class 'ChildProcessError'>, 'ConnectionAbortedError': <class 'ConnectionAbortedError'>, 'ConnectionError': <class 'ConnectionError'>, 'ConnectionRefusedError': <class 'ConnectionRefusedError'>, 'ConnectionResetError': <class 'ConnectionResetError'>, 'DeprecationWarning': <class 'DeprecationWarning'>, 'EOFError': <class 'EOFError'>, 'Ellipsis': Ellipsis, 'EnvironmentError': <class 'OSError'>, 'Exception': <class 'Exception'>, 'False': False, 'FileExistsError': <class 'FileExistsError'>, 'FileNotFoundError': <class 'FileNotFoundError'>, 'FloatingPointError': <class 'FloatingPointError'>, 'FutureWarning': <class 'FutureWarning'>, 'GeneratorExit': <class 'GeneratorExit'>, 'IOError': <class 'OSError'>, 'ImportError': <class 'ImportError'>, 'ImportWarning': <class 'ImportWarning'>, 'IndentationError': <class 'IndentationError'>, 'IndexError': <class 'IndexError'>, 'InterruptedError': <class 'InterruptedError'>, 'IsADirectoryError': <class 'IsADirectoryError'>, 'KeyError': <class 'KeyError'>, 'KeyboardInterrupt': <class 'KeyboardInterrupt'>, 'LookupError': <class 'LookupError'>, 'MemoryError': <class 'MemoryError'>, 'NameError': <class 'NameError'>, 'None': None, 'NotADirectoryError': <class 'NotADirectoryError'>, 'NotImplemented': NotImplemented, 'NotImplementedError': <class 'NotImplementedError'>, 'OSError': <class 'OSError'>, 'OverflowError': <class 'OverflowError'>, 'PendingDeprecationWarning': <class 'PendingDeprecationWarning'>, 'PermissionError': <class 'PermissionError'>, 'ProcessLookupError': <class 'ProcessLookupError'>, 'ReferenceError': <class 'ReferenceError'>, 'ResourceWarning': <class 'ResourceWarning'>, 'RuntimeError': <class 'RuntimeError'>, 'RuntimeWarning': <class 'RuntimeWarning'>, 'StopIteration': <class 'StopIteration'>, 'SyntaxError': <class 'SyntaxError'>, 'SyntaxWarning': <class 'SyntaxWarning'>, 'SystemError': <class 'SystemError'>, 'SystemExit': <class 'SystemExit'>, 'TabError': <class 'TabError'>, 'TimeoutError': <class 'TimeoutError'>, 'True': True, 'TypeError': <class 'TypeError'>, 'UnboundLocalError': <class 'UnboundLocalError'>, 'UnicodeDecodeError': <class 'UnicodeDecodeError'>, 'UnicodeEncodeError': <class 'UnicodeEncodeError'>, 'UnicodeError': <class 'UnicodeError'>, 'UnicodeTranslateError': <class 'UnicodeTranslateError'>, 'UnicodeWarning': <class 'UnicodeWarning'>, 'UserWarning': <class 'UserWarning'>, 'ValueError': <class 'ValueError'>, 'Warning': <class 'Warning'>, 'ZeroDivisionError': <class 'ZeroDivisionError'>, '__build_class__': <built-in function __build_class__>, '__debug__': True, '__doc__': 'Built-in functions, exceptions, and other objects.\n' '\n' "Noteworthy: None is the `nil' object; Ellipsis represents `...' " 'in slices.', '__import__': <built-in function __import__>, '__loader__': <class '_frozen_importlib.BuiltinImporter'>, '__name__': 'builtins', '__package__': '', '__spec__': ModuleSpec(name='builtins', loader=<class '_frozen_importlib.BuiltinImporter'>), 'abs': <built-in function abs>, 'all': <built-in function all>, 'any': <built-in function any>, 'ascii': <built-in function ascii>, 'bin': <built-in function bin>, 'bool': <class 'bool'>, 'bytearray': <class 'bytearray'>, 'bytes': <class 'bytes'>, 'callable': <built-in function callable>, 'chr': <built-in function chr>, 'classmethod': <class 'classmethod'>, 'compile': <built-in function compile>, 'complex': <class 'complex'>, 'copyright': Copyright (c) 2001-2015 Python Software Foundation. All Rights Reserved. Copyright (c) 2000 BeOpen.com. All Rights Reserved. Copyright (c) 1995-2001 Corporation for National Research Initiatives. Al... <trimmed 6386 bytes string> |
__cached__ | '/home/alphabet7431/Django/alphabet7431_project/Q1_app/__pycache__/views.cpython-34.pyc' |
__doc__ | None |
__file__ | '/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py' |
__loader__ | <_frozen_importlib.SourceFileLoader object at 0x7fbd0654eb70> |
__name__ | 'Q1_app.views' |
__package__ | 'Q1_app' |
__spec__ | ModuleSpec(name='Q1_app.views', loader=<_frozen_importlib.SourceFileLoader object at 0x7fbd0654eb70>, origin='/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py') |
csrf_exempt | <function csrf_exempt at 0x7fbd1a600ae8> |
ensure_csrf_cookie | <function make_middleware_decorator.<locals>._make_decorator.<locals>._decorator at 0x7fbd1a600f28> |
json | <module 'json' from '/usr/lib/python3.4/json/__init__.py'> |
np | <module 'numpy' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/numpy/__init__.py'> |
pd | <module 'pandas' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pandas/__init__.py'> |
pymysql | <module 'pymysql' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/__init__.py'> |
render | <function render at 0x7fbd19928950> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/__init__.py
in Connect
def Connect(*args, **kwargs):
"""
Connect to the database; see connections.Connection.__init__() for
more information.
"""
from .connections import Connection
return Connection(*args, **kwargs)...
from . import connections as _orig_conn
if _orig_conn.Connection.__init__.__doc__ is not None:
Connect.__doc__ = _orig_conn.Connection.__init__.__doc__
del _orig_conn
Variable | Value |
---|---|
Connection | <class 'pymysql.connections.Connection'> |
args | ('localhost', 'alphabet7431', '624001479', 'alphabet7431_database') |
kwargs | {} |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/connections.py
in __init__
if program_name:
self._connect_attrs["program_name"] = program_name
if defer_connect:
self._sock = None
else:
self.connect()...
def _create_ssl_ctx(self, sslp):
if isinstance(sslp, ssl.SSLContext):
return sslp
ca = sslp.get('ca')
capath = sslp.get('capath')
Variable | Value |
---|---|
auth_plugin_map | None |
autocommit | False |
binary_prefix | False |
bind_address | None |
charset | '' |
client_flag | 3842573 |
compress | None |
connect_timeout | 10 |
conv | {0: <class 'decimal.Decimal'>, 1: <class 'int'>, 2: <class 'int'>, 3: <class 'int'>, 4: <class 'float'>, 5: <class 'float'>, 7: <function convert_datetime at 0x7fbd06631488>, 8: <class 'int'>, 9: <class 'int'>, 10: <function convert_date at 0x7fbd06631620>, 11: <function convert_timedelta at 0x7fbd06631510>, 12: <function convert_datetime at 0x7fbd06631488>, 13: <class 'int'>, 15: <function through at 0x7fbd066316a8>, 16: <function through at 0x7fbd066316a8>, 246: <class 'decimal.Decimal'>, 249: <function through at 0x7fbd066316a8>, 250: <function through at 0x7fbd066316a8>, 251: <function through at 0x7fbd066316a8>, 252: <function through at 0x7fbd066316a8>, 253: <function through at 0x7fbd066316a8>, 254: <function through at 0x7fbd066316a8>, <class 'decimal.Decimal'>: <function Decimal2Literal at 0x7fbd06631378>, <class 'datetime.datetime'>: <function escape_datetime at 0x7fbd066311e0>, <class 'datetime.timedelta'>: <function escape_timedelta at 0x7fbd066310d0>, <class 'datetime.time'>: <function escape_time at 0x7fbd06631158>, <class 'datetime.date'>: <function escape_date at 0x7fbd06631268>, <class 'str'>: <function escape_unicode at 0x7fbd06ee9ea0>, <class 'tuple'>: <function escape_sequence at 0x7fbd06ee99d8>, <class 'frozenset'>: <function escape_sequence at 0x7fbd06ee99d8>, <class 'set'>: <function escape_sequence at 0x7fbd06ee99d8>, <class 'NoneType'>: <function escape_None at 0x7fbd06631048>, <class 'dict'>: <function escape_dict at 0x7fbd06ee9950>, <class 'list'>: <function escape_sequence at 0x7fbd06ee99d8>, <class 'float'>: <function escape_float at 0x7fbd06ee9c80>, <class 'bytes'>: <function escape_bytes at 0x7fbd06ee9e18>, <class 'int'>: <function escape_int at 0x7fbd06ee9bf8>, <class 'bool'>: <function escape_bool at 0x7fbd06ee9ae8>, <class 'time.struct_time'>: <function escape_struct_time at 0x7fbd066312f0>} |
cursorclass | <class 'pymysql.cursors.Cursor'> |
database | 'alphabet7431_database' |
db | None |
defer_connect | False |
host | 'localhost' |
init_command | None |
local_infile | False |
max_allowed_packet | 16777216 |
named_pipe | None |
passwd | None |
password | '624001479' |
port | 0 |
program_name | None |
read_default_file | None |
read_default_group | None |
read_timeout | None |
self | <pymysql.connections.Connection object at 0x7fbd06537320> |
server_public_key | None |
sql_mode | None |
ssl | None |
unix_socket | None |
use_unicode | True |
user | 'alphabet7431' |
write_timeout | None |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/connections.py
in connect
sock.settimeout(None)
self._sock = sock
self._rfile = _makefile(sock, 'rb')
self._next_seq_id = 0
self._get_server_information()
self._request_authentication()...
if self.sql_mode is not None:
c = self.cursor()
c.execute("SET sql_mode=%s", (self.sql_mode,))
if self.init_command is not None:
Variable | Value |
---|---|
kwargs | {} |
self | <pymysql.connections.Connection object at 0x7fbd06537320> |
sock | <socket.socket [closed] fd=-1, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/connections.py
in _request_authentication
k = k.encode('utf-8')
connect_attrs += struct.pack('B', len(k)) + k
v = v.encode('utf-8')
connect_attrs += struct.pack('B', len(v)) + v
data += struct.pack('B', len(connect_attrs)) + connect_attrs
self.write_packet(data)
auth_packet = self._read_packet()...
# if authentication method isn't accepted the first byte
# will have the octet 254
if auth_packet.is_auth_switch_request():
if DEBUG: print("received auth switch")
# https://dev.mysql.com/doc/internals/en/connection-phase-packets.html#packet-Protocol::AuthSwitchRequest
Variable | Value |
---|---|
authresp | b'Q&\xec\x84\x7f;m\x00y\xe0S\x86\x9f\x06\xb6\x15;\x81\xa6J' |
charset_id | 45 |
connect_attrs | b'\x0f_client_version\x060.10.0\x04_pid\x0539869\x0c_client_name\x07pymysql' |
data | b'\r\xa2:\x00\xff\xff\xff\x00-\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00alphabet7431\x00\x14Q&\xec\x84\x7f;m\x00y\xe0S\x86\x9f\x06\xb6\x15;\x81\xa6Jalphabet7431_database\x00mysql_native_password\x007\x0f_client_version\x060.10.0\x04_pid\x0539869\x0c_client_name\x07pymysql' |
data_init | b'\r\xa2:\x00\xff\xff\xff\x00-\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00' |
k | b'_client_name' |
plugin_name | b'mysql_native_password' |
self | <pymysql.connections.Connection object at 0x7fbd06537320> |
v | b'pymysql' |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/connections.py
in _read_packet
if bytes_to_read < MAX_PACKET_LEN:
break
packet = packet_type(bytes(buff), self.encoding)
if packet.is_error_packet():
if self._result is not None and self._result.unbuffered_active is True:
self._result.unbuffered_active = False
packet.raise_for_error()...
return packet
def _read_bytes(self, num_bytes):
self._sock.settimeout(self._read_timeout)
while True:
try:
Variable | Value |
---|---|
btrh | 0 |
btrl | 49 |
buff | bytearray(b"\xff\x19\x04#42000Unknown database \'alphabet7431_database\'") |
bytes_to_read | 49 |
packet | <pymysql.protocol.MysqlPacket object at 0x7fbd06537278> |
packet_header | b'1\x00\x00\x02' |
packet_number | 2 |
packet_type | <class 'pymysql.protocol.MysqlPacket'> |
recv_data | b"\xff\x19\x04#42000Unknown database 'alphabet7431_database'" |
self | <pymysql.connections.Connection object at 0x7fbd06537320> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/protocol.py
in raise_for_error
self.raise_for_error()
def raise_for_error(self):
self.rewind()
self.advance(1) # field_count == error (we already know that)
errno = self.read_uint16()
if DEBUG: print("errno =", errno)
err.raise_mysql_exception(self._data)...
def dump(self):
dump_packet(self._data)
class FieldDescriptorPacket(MysqlPacket):
Variable | Value |
---|---|
errno | 1049 |
self | <pymysql.protocol.MysqlPacket object at 0x7fbd06537278> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/err.py
in raise_mysql_exception
def raise_mysql_exception(data):
errno = struct.unpack('<h', data[1:3])[0]
errval = data[9:].decode('utf-8', 'replace')
errorclass = error_map.get(errno)
if errorclass is None:
errorclass = InternalError if errno < 1000 else OperationalError
raise errorclass(errno, errval)...
Variable | Value |
---|---|
data | b"\xff\x19\x04#42000Unknown database 'alphabet7431_database'" |
errno | 1049 |
errorclass | <class 'pymysql.err.OperationalError'> |
errval | "Unknown database 'alphabet7431_database'" |
/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py
in <module>
cursor.execute("SHOW columns FROM Genome_features")
GFs_column=[column[0] for column in cursor.fetchall()]
conn.commit()
except :
conn.rollback()...
finally :
conn.close()
dataAll=pd.DataFrame(list(GFs))
Variable | Value |
---|---|
HttpResponse | <class 'django.http.response.HttpResponse'> |
JsonResponse | <class 'django.http.response.JsonResponse'> |
OrderedDict | <class 'collections.OrderedDict'> |
__builtins__ | {'ArithmeticError': <class 'ArithmeticError'>, 'AssertionError': <class 'AssertionError'>, 'AttributeError': <class 'AttributeError'>, 'BaseException': <class 'BaseException'>, 'BlockingIOError': <class 'BlockingIOError'>, 'BrokenPipeError': <class 'BrokenPipeError'>, 'BufferError': <class 'BufferError'>, 'BytesWarning': <class 'BytesWarning'>, 'ChildProcessError': <class 'ChildProcessError'>, 'ConnectionAbortedError': <class 'ConnectionAbortedError'>, 'ConnectionError': <class 'ConnectionError'>, 'ConnectionRefusedError': <class 'ConnectionRefusedError'>, 'ConnectionResetError': <class 'ConnectionResetError'>, 'DeprecationWarning': <class 'DeprecationWarning'>, 'EOFError': <class 'EOFError'>, 'Ellipsis': Ellipsis, 'EnvironmentError': <class 'OSError'>, 'Exception': <class 'Exception'>, 'False': False, 'FileExistsError': <class 'FileExistsError'>, 'FileNotFoundError': <class 'FileNotFoundError'>, 'FloatingPointError': <class 'FloatingPointError'>, 'FutureWarning': <class 'FutureWarning'>, 'GeneratorExit': <class 'GeneratorExit'>, 'IOError': <class 'OSError'>, 'ImportError': <class 'ImportError'>, 'ImportWarning': <class 'ImportWarning'>, 'IndentationError': <class 'IndentationError'>, 'IndexError': <class 'IndexError'>, 'InterruptedError': <class 'InterruptedError'>, 'IsADirectoryError': <class 'IsADirectoryError'>, 'KeyError': <class 'KeyError'>, 'KeyboardInterrupt': <class 'KeyboardInterrupt'>, 'LookupError': <class 'LookupError'>, 'MemoryError': <class 'MemoryError'>, 'NameError': <class 'NameError'>, 'None': None, 'NotADirectoryError': <class 'NotADirectoryError'>, 'NotImplemented': NotImplemented, 'NotImplementedError': <class 'NotImplementedError'>, 'OSError': <class 'OSError'>, 'OverflowError': <class 'OverflowError'>, 'PendingDeprecationWarning': <class 'PendingDeprecationWarning'>, 'PermissionError': <class 'PermissionError'>, 'ProcessLookupError': <class 'ProcessLookupError'>, 'ReferenceError': <class 'ReferenceError'>, 'ResourceWarning': <class 'ResourceWarning'>, 'RuntimeError': <class 'RuntimeError'>, 'RuntimeWarning': <class 'RuntimeWarning'>, 'StopIteration': <class 'StopIteration'>, 'SyntaxError': <class 'SyntaxError'>, 'SyntaxWarning': <class 'SyntaxWarning'>, 'SystemError': <class 'SystemError'>, 'SystemExit': <class 'SystemExit'>, 'TabError': <class 'TabError'>, 'TimeoutError': <class 'TimeoutError'>, 'True': True, 'TypeError': <class 'TypeError'>, 'UnboundLocalError': <class 'UnboundLocalError'>, 'UnicodeDecodeError': <class 'UnicodeDecodeError'>, 'UnicodeEncodeError': <class 'UnicodeEncodeError'>, 'UnicodeError': <class 'UnicodeError'>, 'UnicodeTranslateError': <class 'UnicodeTranslateError'>, 'UnicodeWarning': <class 'UnicodeWarning'>, 'UserWarning': <class 'UserWarning'>, 'ValueError': <class 'ValueError'>, 'Warning': <class 'Warning'>, 'ZeroDivisionError': <class 'ZeroDivisionError'>, '__build_class__': <built-in function __build_class__>, '__debug__': True, '__doc__': 'Built-in functions, exceptions, and other objects.\n' '\n' "Noteworthy: None is the `nil' object; Ellipsis represents `...' " 'in slices.', '__import__': <built-in function __import__>, '__loader__': <class '_frozen_importlib.BuiltinImporter'>, '__name__': 'builtins', '__package__': '', '__spec__': ModuleSpec(name='builtins', loader=<class '_frozen_importlib.BuiltinImporter'>), 'abs': <built-in function abs>, 'all': <built-in function all>, 'any': <built-in function any>, 'ascii': <built-in function ascii>, 'bin': <built-in function bin>, 'bool': <class 'bool'>, 'bytearray': <class 'bytearray'>, 'bytes': <class 'bytes'>, 'callable': <built-in function callable>, 'chr': <built-in function chr>, 'classmethod': <class 'classmethod'>, 'compile': <built-in function compile>, 'complex': <class 'complex'>, 'copyright': Copyright (c) 2001-2015 Python Software Foundation. All Rights Reserved. Copyright (c) 2000 BeOpen.com. All Rights Reserved. Copyright (c) 1995-2001 Corporation for National Research Initiatives. Al... <trimmed 6386 bytes string> |
__cached__ | '/home/alphabet7431/Django/alphabet7431_project/Q1_app/__pycache__/views.cpython-34.pyc' |
__doc__ | None |
__file__ | '/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py' |
__loader__ | <_frozen_importlib.SourceFileLoader object at 0x7fbd0654eb70> |
__name__ | 'Q1_app.views' |
__package__ | 'Q1_app' |
__spec__ | ModuleSpec(name='Q1_app.views', loader=<_frozen_importlib.SourceFileLoader object at 0x7fbd0654eb70>, origin='/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py') |
csrf_exempt | <function csrf_exempt at 0x7fbd1a600ae8> |
ensure_csrf_cookie | <function make_middleware_decorator.<locals>._make_decorator.<locals>._decorator at 0x7fbd1a600f28> |
json | <module 'json' from '/usr/lib/python3.4/json/__init__.py'> |
np | <module 'numpy' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/numpy/__init__.py'> |
pd | <module 'pandas' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pandas/__init__.py'> |
pymysql | <module 'pymysql' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/__init__.py'> |
render | <function render at 0x7fbd19928950> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/core/handlers/exception.py
in inner
This decorator is automatically applied to all middleware to ensure that
no middleware leaks an exception and that the next middleware in the stack
can rely on getting a response instead of an exception.
"""
@wraps(get_response, assigned=available_attrs(get_response))
def inner(request):
try:
response = get_response(request)...
except Exception as exc:
response = response_for_exception(request, exc)
return response
return inner
Variable | Value |
---|---|
exc | NameError("name 'conn' is not defined",) |
get_response | <bound method WSGIHandler._get_response of <django.core.handlers.wsgi.WSGIHandler object at 0x7fbd1b3bb0b8>> |
request | <WSGIRequest: GET '/YQFC/'> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/core/handlers/base.py
in _get_response
if hasattr(request, 'urlconf'):
urlconf = request.urlconf
set_urlconf(urlconf)
resolver = get_resolver(urlconf)
else:
resolver = get_resolver()
resolver_match = resolver.resolve(request.path_info)...
callback, callback_args, callback_kwargs = resolver_match
request.resolver_match = resolver_match
# Apply view middleware
for middleware_method in self._view_middleware:
response = middleware_method(request, callback, callback_args, callback_kwargs)
Variable | Value |
---|---|
request | <WSGIRequest: GET '/YQFC/'> |
resolver | <RegexURLResolver 'alphabet7431_project.urls' (None:None) ^/> |
response | None |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7fbd1b3bb0b8> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/urls/resolvers.py
in resolve
def resolve(self, path):
path = force_text(path) # path may be a reverse_lazy object
tried = []
match = self.regex.search(path)
if match:
new_path = path[match.end():]
for pattern in self.url_patterns:...
try:
sub_match = pattern.resolve(new_path)
except Resolver404 as e:
sub_tried = e.args[0].get('tried')
if sub_tried is not None:
tried.extend([pattern] + t for t in sub_tried)
Variable | Value |
---|---|
match | <_sre.SRE_Match object; span=(0, 1), match='/'> |
new_path | '' |
path | '/' |
self | <RegexURLResolver 'alphabet7431_project.urls' (None:None) ^/> |
tried | [] |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/utils/functional.py
in __get__
self.func = func
self.__doc__ = getattr(func, '__doc__')
self.name = name or func.__name__
def __get__(self, instance, cls=None):
if instance is None:
return self
res = instance.__dict__[self.name] = self.func(instance)...
return res
class Promise(object):
"""
This is just a base class for the proxy class created in
Variable | Value |
---|---|
cls | <class 'django.urls.resolvers.RegexURLResolver'> |
instance | <RegexURLResolver 'alphabet7431_project.urls' (None:None) ^/> |
self | <django.utils.functional.cached_property object at 0x7fbd1aa4b588> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/urls/resolvers.py
in url_patterns
return import_module(self.urlconf_name)
else:
return self.urlconf_name
@cached_property
def url_patterns(self):
# urlconf_module might be a valid set of patterns, so we default to it
patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)...
try:
iter(patterns)
except TypeError:
msg = (
"The included URLconf '{name}' does not appear to have any "
"patterns in it. If you see valid patterns in the file then "
Variable | Value |
---|---|
self | <RegexURLResolver 'alphabet7431_project.urls' (None:None) ^/> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/utils/functional.py
in __get__
self.func = func
self.__doc__ = getattr(func, '__doc__')
self.name = name or func.__name__
def __get__(self, instance, cls=None):
if instance is None:
return self
res = instance.__dict__[self.name] = self.func(instance)...
return res
class Promise(object):
"""
This is just a base class for the proxy class created in
Variable | Value |
---|---|
cls | <class 'django.urls.resolvers.RegexURLResolver'> |
instance | <RegexURLResolver 'alphabet7431_project.urls' (None:None) ^/> |
self | <django.utils.functional.cached_property object at 0x7fbd1aa4b1d0> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/urls/resolvers.py
in urlconf_module
tried.append([pattern])
raise Resolver404({'tried': tried, 'path': new_path})
raise Resolver404({'path': path})
@cached_property
def urlconf_module(self):
if isinstance(self.urlconf_name, six.string_types):
return import_module(self.urlconf_name)...
else:
return self.urlconf_name
@cached_property
def url_patterns(self):
# urlconf_module might be a valid set of patterns, so we default to it
Variable | Value |
---|---|
self | <RegexURLResolver 'alphabet7431_project.urls' (None:None) ^/> |
/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/importlib/__init__.py
in import_module
msg = ("the 'package' argument is required to perform a relative "
"import for {!r}")
raise TypeError(msg.format(name))
for character in name:
if character != '.':
break
level += 1
return _bootstrap._gcd_import(name[level:], package, level)...
_RELOADING = {}
def reload(module):
Variable | Value |
---|---|
level | 0 |
name | 'alphabet7431_project.urls' |
package | None |
/home/alphabet7431/Django/alphabet7431_project/alphabet7431_project/urls.py
in <module>
2. Add a URL to urlpatterns: url(r'^$', Home.as_view(), name='home')
Including another URLconf
1. Import the include() function: from django.conf.urls import url, include
2. Add a URL to urlpatterns: url(r'^blog/', include('blog.urls'))
"""
from django.conf.urls import url
from django.contrib import admin
from Q1_app.views import index...
from Q1_app.views import about
from Q1_app.views import Tool
from Q1_app.views import portfolio
from Q1_app.views import team
from Q1_app.views import download
from Q1_app.views import contact
Variable | Value |
---|---|
__builtins__ | {'ArithmeticError': <class 'ArithmeticError'>, 'AssertionError': <class 'AssertionError'>, 'AttributeError': <class 'AttributeError'>, 'BaseException': <class 'BaseException'>, 'BlockingIOError': <class 'BlockingIOError'>, 'BrokenPipeError': <class 'BrokenPipeError'>, 'BufferError': <class 'BufferError'>, 'BytesWarning': <class 'BytesWarning'>, 'ChildProcessError': <class 'ChildProcessError'>, 'ConnectionAbortedError': <class 'ConnectionAbortedError'>, 'ConnectionError': <class 'ConnectionError'>, 'ConnectionRefusedError': <class 'ConnectionRefusedError'>, 'ConnectionResetError': <class 'ConnectionResetError'>, 'DeprecationWarning': <class 'DeprecationWarning'>, 'EOFError': <class 'EOFError'>, 'Ellipsis': Ellipsis, 'EnvironmentError': <class 'OSError'>, 'Exception': <class 'Exception'>, 'False': False, 'FileExistsError': <class 'FileExistsError'>, 'FileNotFoundError': <class 'FileNotFoundError'>, 'FloatingPointError': <class 'FloatingPointError'>, 'FutureWarning': <class 'FutureWarning'>, 'GeneratorExit': <class 'GeneratorExit'>, 'IOError': <class 'OSError'>, 'ImportError': <class 'ImportError'>, 'ImportWarning': <class 'ImportWarning'>, 'IndentationError': <class 'IndentationError'>, 'IndexError': <class 'IndexError'>, 'InterruptedError': <class 'InterruptedError'>, 'IsADirectoryError': <class 'IsADirectoryError'>, 'KeyError': <class 'KeyError'>, 'KeyboardInterrupt': <class 'KeyboardInterrupt'>, 'LookupError': <class 'LookupError'>, 'MemoryError': <class 'MemoryError'>, 'NameError': <class 'NameError'>, 'None': None, 'NotADirectoryError': <class 'NotADirectoryError'>, 'NotImplemented': NotImplemented, 'NotImplementedError': <class 'NotImplementedError'>, 'OSError': <class 'OSError'>, 'OverflowError': <class 'OverflowError'>, 'PendingDeprecationWarning': <class 'PendingDeprecationWarning'>, 'PermissionError': <class 'PermissionError'>, 'ProcessLookupError': <class 'ProcessLookupError'>, 'ReferenceError': <class 'ReferenceError'>, 'ResourceWarning': <class 'ResourceWarning'>, 'RuntimeError': <class 'RuntimeError'>, 'RuntimeWarning': <class 'RuntimeWarning'>, 'StopIteration': <class 'StopIteration'>, 'SyntaxError': <class 'SyntaxError'>, 'SyntaxWarning': <class 'SyntaxWarning'>, 'SystemError': <class 'SystemError'>, 'SystemExit': <class 'SystemExit'>, 'TabError': <class 'TabError'>, 'TimeoutError': <class 'TimeoutError'>, 'True': True, 'TypeError': <class 'TypeError'>, 'UnboundLocalError': <class 'UnboundLocalError'>, 'UnicodeDecodeError': <class 'UnicodeDecodeError'>, 'UnicodeEncodeError': <class 'UnicodeEncodeError'>, 'UnicodeError': <class 'UnicodeError'>, 'UnicodeTranslateError': <class 'UnicodeTranslateError'>, 'UnicodeWarning': <class 'UnicodeWarning'>, 'UserWarning': <class 'UserWarning'>, 'ValueError': <class 'ValueError'>, 'Warning': <class 'Warning'>, 'ZeroDivisionError': <class 'ZeroDivisionError'>, '__build_class__': <built-in function __build_class__>, '__debug__': True, '__doc__': 'Built-in functions, exceptions, and other objects.\n' '\n' "Noteworthy: None is the `nil' object; Ellipsis represents `...' " 'in slices.', '__import__': <built-in function __import__>, '__loader__': <class '_frozen_importlib.BuiltinImporter'>, '__name__': 'builtins', '__package__': '', '__spec__': ModuleSpec(name='builtins', loader=<class '_frozen_importlib.BuiltinImporter'>), 'abs': <built-in function abs>, 'all': <built-in function all>, 'any': <built-in function any>, 'ascii': <built-in function ascii>, 'bin': <built-in function bin>, 'bool': <class 'bool'>, 'bytearray': <class 'bytearray'>, 'bytes': <class 'bytes'>, 'callable': <built-in function callable>, 'chr': <built-in function chr>, 'classmethod': <class 'classmethod'>, 'compile': <built-in function compile>, 'complex': <class 'complex'>, 'copyright': Copyright (c) 2001-2015 Python Software Foundation. All Rights Reserved. Copyright (c) 2000 BeOpen.com. All Rights Reserved. Copyright (c) 1995-2001 Corporation for National Research Initiatives. Al... <trimmed 6386 bytes string> |
__cached__ | '/home/alphabet7431/Django/alphabet7431_project/alphabet7431_project/__pycache__/urls.cpython-34.pyc' |
__doc__ | ('Bootstrap_project URL Configuration\n' '\n' 'The `urlpatterns` list routes URLs to views. For more information please ' 'see:\n' ' https://docs.djangoproject.com/en/1.11/topics/http/urls/\n' 'Examples:\n' 'Function views\n' ' 1. Add an import: from my_app import views\n' " 2. Add a URL to urlpatterns: url(r'^$', views.home, name='home')\n" 'Class-based views\n' ' 1. Add an import: from other_app.views import Home\n' " 2. Add a URL to urlpatterns: url(r'^$', Home.as_view(), name='home')\n" 'Including another URLconf\n' ' 1. Import the include() function: from django.conf.urls import url, ' 'include\n' " 2. Add a URL to urlpatterns: url(r'^blog/', include('blog.urls'))\n") |
__file__ | '/home/alphabet7431/Django/alphabet7431_project/alphabet7431_project/urls.py' |
__loader__ | <_frozen_importlib.SourceFileLoader object at 0x7fbd0654e898> |
__name__ | 'alphabet7431_project.urls' |
__package__ | 'alphabet7431_project' |
__spec__ | ModuleSpec(name='alphabet7431_project.urls', loader=<_frozen_importlib.SourceFileLoader object at 0x7fbd0654e898>, origin='/home/alphabet7431/Django/alphabet7431_project/alphabet7431_project/urls.py') |
admin | <module 'django.contrib.admin' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/django/contrib/admin/__init__.py'> |
url | <function url at 0x7fbd199a9b70> |
/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py
in <module>
GFs_column=[column[0] for column in cursor.fetchall()]
conn.commit()
except :
conn.rollback()
finally :
conn.close()...
dataAll=pd.DataFrame(list(GFs))
dataAll.columns=GFs_column
#proof
Variable | Value |
---|---|
HttpResponse | <class 'django.http.response.HttpResponse'> |
JsonResponse | <class 'django.http.response.JsonResponse'> |
OrderedDict | <class 'collections.OrderedDict'> |
__builtins__ | {'ArithmeticError': <class 'ArithmeticError'>, 'AssertionError': <class 'AssertionError'>, 'AttributeError': <class 'AttributeError'>, 'BaseException': <class 'BaseException'>, 'BlockingIOError': <class 'BlockingIOError'>, 'BrokenPipeError': <class 'BrokenPipeError'>, 'BufferError': <class 'BufferError'>, 'BytesWarning': <class 'BytesWarning'>, 'ChildProcessError': <class 'ChildProcessError'>, 'ConnectionAbortedError': <class 'ConnectionAbortedError'>, 'ConnectionError': <class 'ConnectionError'>, 'ConnectionRefusedError': <class 'ConnectionRefusedError'>, 'ConnectionResetError': <class 'ConnectionResetError'>, 'DeprecationWarning': <class 'DeprecationWarning'>, 'EOFError': <class 'EOFError'>, 'Ellipsis': Ellipsis, 'EnvironmentError': <class 'OSError'>, 'Exception': <class 'Exception'>, 'False': False, 'FileExistsError': <class 'FileExistsError'>, 'FileNotFoundError': <class 'FileNotFoundError'>, 'FloatingPointError': <class 'FloatingPointError'>, 'FutureWarning': <class 'FutureWarning'>, 'GeneratorExit': <class 'GeneratorExit'>, 'IOError': <class 'OSError'>, 'ImportError': <class 'ImportError'>, 'ImportWarning': <class 'ImportWarning'>, 'IndentationError': <class 'IndentationError'>, 'IndexError': <class 'IndexError'>, 'InterruptedError': <class 'InterruptedError'>, 'IsADirectoryError': <class 'IsADirectoryError'>, 'KeyError': <class 'KeyError'>, 'KeyboardInterrupt': <class 'KeyboardInterrupt'>, 'LookupError': <class 'LookupError'>, 'MemoryError': <class 'MemoryError'>, 'NameError': <class 'NameError'>, 'None': None, 'NotADirectoryError': <class 'NotADirectoryError'>, 'NotImplemented': NotImplemented, 'NotImplementedError': <class 'NotImplementedError'>, 'OSError': <class 'OSError'>, 'OverflowError': <class 'OverflowError'>, 'PendingDeprecationWarning': <class 'PendingDeprecationWarning'>, 'PermissionError': <class 'PermissionError'>, 'ProcessLookupError': <class 'ProcessLookupError'>, 'ReferenceError': <class 'ReferenceError'>, 'ResourceWarning': <class 'ResourceWarning'>, 'RuntimeError': <class 'RuntimeError'>, 'RuntimeWarning': <class 'RuntimeWarning'>, 'StopIteration': <class 'StopIteration'>, 'SyntaxError': <class 'SyntaxError'>, 'SyntaxWarning': <class 'SyntaxWarning'>, 'SystemError': <class 'SystemError'>, 'SystemExit': <class 'SystemExit'>, 'TabError': <class 'TabError'>, 'TimeoutError': <class 'TimeoutError'>, 'True': True, 'TypeError': <class 'TypeError'>, 'UnboundLocalError': <class 'UnboundLocalError'>, 'UnicodeDecodeError': <class 'UnicodeDecodeError'>, 'UnicodeEncodeError': <class 'UnicodeEncodeError'>, 'UnicodeError': <class 'UnicodeError'>, 'UnicodeTranslateError': <class 'UnicodeTranslateError'>, 'UnicodeWarning': <class 'UnicodeWarning'>, 'UserWarning': <class 'UserWarning'>, 'ValueError': <class 'ValueError'>, 'Warning': <class 'Warning'>, 'ZeroDivisionError': <class 'ZeroDivisionError'>, '__build_class__': <built-in function __build_class__>, '__debug__': True, '__doc__': 'Built-in functions, exceptions, and other objects.\n' '\n' "Noteworthy: None is the `nil' object; Ellipsis represents `...' " 'in slices.', '__import__': <built-in function __import__>, '__loader__': <class '_frozen_importlib.BuiltinImporter'>, '__name__': 'builtins', '__package__': '', '__spec__': ModuleSpec(name='builtins', loader=<class '_frozen_importlib.BuiltinImporter'>), 'abs': <built-in function abs>, 'all': <built-in function all>, 'any': <built-in function any>, 'ascii': <built-in function ascii>, 'bin': <built-in function bin>, 'bool': <class 'bool'>, 'bytearray': <class 'bytearray'>, 'bytes': <class 'bytes'>, 'callable': <built-in function callable>, 'chr': <built-in function chr>, 'classmethod': <class 'classmethod'>, 'compile': <built-in function compile>, 'complex': <class 'complex'>, 'copyright': Copyright (c) 2001-2015 Python Software Foundation. All Rights Reserved. Copyright (c) 2000 BeOpen.com. All Rights Reserved. Copyright (c) 1995-2001 Corporation for National Research Initiatives. Al... <trimmed 6386 bytes string> |
__cached__ | '/home/alphabet7431/Django/alphabet7431_project/Q1_app/__pycache__/views.cpython-34.pyc' |
__doc__ | None |
__file__ | '/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py' |
__loader__ | <_frozen_importlib.SourceFileLoader object at 0x7fbd0654eb70> |
__name__ | 'Q1_app.views' |
__package__ | 'Q1_app' |
__spec__ | ModuleSpec(name='Q1_app.views', loader=<_frozen_importlib.SourceFileLoader object at 0x7fbd0654eb70>, origin='/home/alphabet7431/Django/alphabet7431_project/Q1_app/views.py') |
csrf_exempt | <function csrf_exempt at 0x7fbd1a600ae8> |
ensure_csrf_cookie | <function make_middleware_decorator.<locals>._make_decorator.<locals>._decorator at 0x7fbd1a600f28> |
json | <module 'json' from '/usr/lib/python3.4/json/__init__.py'> |
np | <module 'numpy' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/numpy/__init__.py'> |
pd | <module 'pandas' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pandas/__init__.py'> |
pymysql | <module 'pymysql' from '/home/alphabet7431/.virtualenvs/djvenv/lib/python3.4/site-packages/pymysql/__init__.py'> |
render | <function render at 0x7fbd19928950> |
AnonymousUser
No GET data
Variable | Value |
---|
No FILES data
No cookie data
Variable | Value |
---|---|
CONTEXT_DOCUMENT_ROOT | '/var/www/html' |
CONTEXT_PREFIX | '' |
DOCUMENT_ROOT | '/var/www/html' |
GATEWAY_INTERFACE | 'CGI/1.1' |
HTTP_ACCEPT | '*/*' |
HTTP_HOST | 'cosbi6.ee.ncku.edu.tw' |
HTTP_USER_AGENT | 'claudebot' |
PATH_INFO | '/' |
PATH_TRANSLATED | '/var/www/html/index.html' |
QUERY_STRING | '' |
REMOTE_ADDR | '3.227.239.160' |
REMOTE_PORT | '45270' |
REQUEST_METHOD | 'GET' |
REQUEST_SCHEME | 'http' |
REQUEST_URI | '/YQFC/' |
SCRIPT_FILENAME | '/home/alphabet7431/Django/alphabet7431_project/alphabet7431_project/wsgi.py' |
SCRIPT_NAME | '/YQFC' |
SERVER_ADDR | '140.116.214.135' |
SERVER_ADMIN | 'webmaster@localhost' |
SERVER_NAME | 'cosbi6.ee.ncku.edu.tw' |
SERVER_PORT | '80' |
SERVER_PROTOCOL | 'HTTP/1.1' |
SERVER_SIGNATURE | ('<address>Apache/2.4.7 (Ubuntu) Server at cosbi6.ee.ncku.edu.tw Port ' '80</address>\n') |
SERVER_SOFTWARE | 'Apache/2.4.7 (Ubuntu)' |
mod_wsgi.application_group | '' |
mod_wsgi.callable_object | 'application' |
mod_wsgi.enable_sendfile | '0' |
mod_wsgi.handler_script | '' |
mod_wsgi.input_chunked | '0' |
mod_wsgi.listener_host | '' |
mod_wsgi.listener_port | '80' |
mod_wsgi.process_group | 'alphabet7431' |
mod_wsgi.queue_start | '1711676815740227' |
mod_wsgi.request_handler | 'wsgi-script' |
mod_wsgi.script_reloading | '1' |
mod_wsgi.version | (3, 4) |
wsgi.errors | <_io.TextIOWrapper encoding='utf-8'> |
wsgi.file_wrapper | '' |
wsgi.input | <mod_wsgi.Input object at 0x7fbd065018f0> |
wsgi.multiprocess | False |
wsgi.multithread | True |
wsgi.run_once | False |
wsgi.url_scheme | 'http' |
wsgi.version | (1, 0) |
alphabet7431_project.settings
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | {} |
ADMINS | [] |
ALLOWED_HOSTS | ['140.116.214.135', 'cosbi6.ee.ncku.edu.tw'] |
APPEND_SLASH | True |
AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
AUTH_PASSWORD_VALIDATORS | '********************' |
AUTH_USER_MODEL | 'auth.User' |
BASE_DIR | '/home/alphabet7431/Django/alphabet7431_project' |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
CACHE_MIDDLEWARE_SECONDS | 600 |
CSRF_COOKIE_AGE | 31449600 |
CSRF_COOKIE_DOMAIN | None |
CSRF_COOKIE_HTTPONLY | False |
CSRF_COOKIE_NAME | 'csrftoken' |
CSRF_COOKIE_PATH | '/' |
CSRF_COOKIE_SECURE | False |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
CSRF_TRUSTED_ORIGINS | [] |
CSRF_USE_SESSIONS | False |
DATABASES | {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.mysql', 'HOST': 'localhost', 'NAME': 'alphabet7431_database', 'OPTIONS': {'init_command': 'SET ' "sql_mode='STRICT_TRANS_TABLES'"}, 'PASSWORD': '********************', 'PORT': '3306', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'alphabet7431'}} |
DATABASE_ROUTERS | [] |
DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
DATA_UPLOAD_MAX_NUMBER_FIELDS | 1000 |
DATETIME_FORMAT | 'N j, Y, P' |
DATETIME_INPUT_FORMATS | ['%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y'] |
DATE_FORMAT | 'N j, Y' |
DATE_INPUT_FORMATS | ['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y'] |
DEBUG | True |
DEBUG_PROPAGATE_EXCEPTIONS | False |
DECIMAL_SEPARATOR | '.' |
DEFAULT_CHARSET | 'utf-8' |
DEFAULT_CONTENT_TYPE | 'text/html' |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | [] |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
EMAIL_HOST | 'localhost' |
EMAIL_HOST_PASSWORD | '********************' |
EMAIL_HOST_USER | '' |
EMAIL_PORT | 25 |
EMAIL_SSL_CERTFILE | None |
EMAIL_SSL_KEYFILE | '********************' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
EMAIL_TIMEOUT | None |
EMAIL_USE_LOCALTIME | False |
EMAIL_USE_SSL | False |
EMAIL_USE_TLS | False |
FILE_CHARSET | 'utf-8' |
FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
FILE_UPLOAD_PERMISSIONS | None |
FILE_UPLOAD_TEMP_DIR | None |
FIRST_DAY_OF_WEEK | 0 |
FIXTURE_DIRS | [] |
FORCE_SCRIPT_NAME | None |
FORMAT_MODULE_PATH | None |
FORM_RENDERER | 'django.forms.renderers.DjangoTemplates' |
IGNORABLE_404_URLS | [] |
INSTALLED_APPS | ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'Q1_app', 'Q2_app'] |
INTERNAL_IPS | [] |
LANGUAGES | [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('dsb', 'Lower Sorbian'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hsb', 'Upper Sorbian'), ('hu', 'Hungarian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmål'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')] |
LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
LANGUAGE_CODE | 'en-us' |
LANGUAGE_COOKIE_AGE | None |
LANGUAGE_COOKIE_DOMAIN | None |
LANGUAGE_COOKIE_NAME | 'django_language' |
LANGUAGE_COOKIE_PATH | '/' |
LOCALE_PATHS | [] |
LOGGING | {} |
LOGGING_CONFIG | 'logging.config.dictConfig' |
LOGIN_REDIRECT_URL | '/accounts/profile/' |
LOGIN_URL | '/accounts/login/' |
LOGOUT_REDIRECT_URL | None |
MANAGERS | [] |
MEDIA_ROOT | '' |
MEDIA_URL | '' |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
MIDDLEWARE | ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware'] |
MIDDLEWARE_CLASSES | ['django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware'] |
MIGRATION_MODULES | {} |
MONTH_DAY_FORMAT | 'F j' |
NUMBER_GROUPING | 0 |
PASSWORD_HASHERS | '********************' |
PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
PREPEND_WWW | False |
ROOT_URLCONF | 'alphabet7431_project.urls' |
SECRET_KEY | '********************' |
SECURE_BROWSER_XSS_FILTER | False |
SECURE_CONTENT_TYPE_NOSNIFF | False |
SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
SECURE_HSTS_PRELOAD | False |
SECURE_HSTS_SECONDS | 0 |
SECURE_PROXY_SSL_HEADER | None |
SECURE_REDIRECT_EXEMPT | [] |
SECURE_SSL_HOST | None |
SECURE_SSL_REDIRECT | False |
SERVER_EMAIL | 'root@localhost' |
SESSION_CACHE_ALIAS | 'default' |
SESSION_COOKIE_AGE | 1209600 |
SESSION_COOKIE_DOMAIN | None |
SESSION_COOKIE_HTTPONLY | True |
SESSION_COOKIE_NAME | 'sessionid' |
SESSION_COOKIE_PATH | '/' |
SESSION_COOKIE_SECURE | False |
SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
SESSION_FILE_PATH | None |
SESSION_SAVE_EVERY_REQUEST | False |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
SETTINGS_MODULE | 'alphabet7431_project.settings' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
SHORT_DATE_FORMAT | 'm/d/Y' |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SILENCED_SYSTEM_CHECKS | [] |
STATICFILES_DIRS | ['/home/alphabet7431/Django/alphabet7431_project/static'] |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | None |
STATIC_URL | '/alphabet7431_static/' |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/home/alphabet7431/Django/alphabet7431_project/templates'], 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages']}}] |
TEST_NON_SERIALIZED_APPS | [] |
TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
THOUSAND_SEPARATOR | ',' |
TIME_FORMAT | 'P' |
TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
TIME_ZONE | 'UTC' |
USE_ETAGS | False |
USE_I18N | True |
USE_L10N | True |
USE_THOUSAND_SEPARATOR | False |
USE_TZ | True |
USE_X_FORWARDED_HOST | False |
USE_X_FORWARDED_PORT | False |
WSGI_APPLICATION | 'alphabet7431_project.wsgi.application' |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
YEAR_MONTH_FORMAT | 'F Y' |
You're seeing this error because you have DEBUG = True
in your
Django settings file. Change that to False
, and Django will
display a standard page generated by the handler for this status code.