อยู่ดีก็ไม่สามารถเชื่อมต่อกับ database ได้ครับ ทั้ง ลองใช้ code พื้นฐานๆอย่างการเช็น version แล้ว
โค้ด: เลือกทั้งหมด
# -*- coding:utf-8 -*
import psycopg2 as p
con = p.connect(
host='127.0.0.1',
database='ben01',
user='postgres',
password='postgres'
)
cur = con.cursor ()
cur.execute ( "SELECT version()" )
total = cur.fetchall ()
print(total)
database ก็ปรกติครับ
- SQL - Database-1.png (34.1 KiB) Viewed 2681 times
อันนี้ error ครับ
Traceback (most recent call last):
File "/home/com003/Desktop/Ben/mini_project/mini_pro.py", line 2, in <module>
import psycopg2 as p
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 67, in <module>
from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ModuleNotFoundError: No module named 'psycopg2._psycopg'
Error in sys.excepthook:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/apport_python_hook.py", line 63, in apport_excepthook
from apport.fileutils import likely_packaged, get_recent_crashes
File "/usr/lib/python3/dist-packages/apport/__init__.py", line 5, in <module>
from apport.report import Report
File "/usr/lib/python3/dist-packages/apport/report.py", line 30, in <module>
import apport.fileutils
File "/usr/lib/python3/dist-packages/apport/fileutils.py", line 23, in <module>
from apport.packaging_impl import impl as packaging
File "/usr/lib/python3/dist-packages/apport/packaging_impl.py", line 20, in <module>
import apt
File "/usr/lib/python3/dist-packages/apt/__init__.py", line 23, in <module>
import apt_pkg
ModuleNotFoundError: No module named 'apt_pkg'
Original exception was:
Traceback (most recent call last):
File "/home/com003/Desktop/Ben/mini_project/mini_pro.py", line 2, in <module>
import psycopg2 as p
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 67, in <module>
from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ModuleNotFoundError: No module named 'psycopg2._psycopg'
อยู่ดีก็ไม่สามารถเชื่อมต่อกับ database ได้ครับ ทั้ง ลองใช้ code พื้นฐานๆอย่างการเช็น version แล้ว
[code]# -*- coding:utf-8 -*
import psycopg2 as p
con = p.connect(
host='127.0.0.1',
database='ben01',
user='postgres',
password='postgres'
)
cur = con.cursor ()
cur.execute ( "SELECT version()" )
total = cur.fetchall ()
print(total)[/code]
database ก็ปรกติครับ
[attachment=0]SQL - Database-1.png[/attachment]
อันนี้ error ครับ
Traceback (most recent call last):
File "/home/com003/Desktop/Ben/mini_project/mini_pro.py", line 2, in <module>
import psycopg2 as p
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 67, in <module>
from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ModuleNotFoundError: No module named 'psycopg2._psycopg'
Error in sys.excepthook:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/apport_python_hook.py", line 63, in apport_excepthook
from apport.fileutils import likely_packaged, get_recent_crashes
File "/usr/lib/python3/dist-packages/apport/__init__.py", line 5, in <module>
from apport.report import Report
File "/usr/lib/python3/dist-packages/apport/report.py", line 30, in <module>
import apport.fileutils
File "/usr/lib/python3/dist-packages/apport/fileutils.py", line 23, in <module>
from apport.packaging_impl import impl as packaging
File "/usr/lib/python3/dist-packages/apport/packaging_impl.py", line 20, in <module>
import apt
File "/usr/lib/python3/dist-packages/apt/__init__.py", line 23, in <module>
import apt_pkg
ModuleNotFoundError: No module named 'apt_pkg'
Original exception was:
Traceback (most recent call last):
File "/home/com003/Desktop/Ben/mini_project/mini_pro.py", line 2, in <module>
import psycopg2 as p
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 67, in <module>
from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ModuleNotFoundError: No module named 'psycopg2._psycopg'