TypeError: missing dsn and no parameters when I change my database

0

I'm trying to change a simple chat application to a more complex one by following this tutorial . Now I am deciphering how to change my database. The teacher chose Flask-SQLAlchemy and SQLite but I've already started with PostgreSQL. So I try to modify my application little by little to be able to use it, which seems to be more serious.

However, I tried the simple command > from app.models import User and got a TypeError: missing dsn and no parameters .

(MyFlaskAppEnv) mike@mike-thinks:~/Programing/Rasa/myflaskapp$ python3.6
Python 3.6.5 (default, May  3 2018, 10:08:28) 
[GCC 5.4.0 20160609] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> from app.models import User
/home/mike/.local/lib/python3.6/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.
  """)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/mike/Programing/Rasa/myflaskapp/app.py", line 31, in <module>
    conn = psycopg2.connect(DATABASE_URL)
  File "/home/mike/.local/lib/python3.6/site-packages/psycopg2/__init__.py", line 127, in connect
    raise TypeError('missing dsn and no parameters')
TypeError: missing dsn and no parameters
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 23, 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 "<stdin>", line 1, in <module>
  File "/home/mike/Programing/Rasa/myflaskapp/app.py", line 31, in <module>
    conn = psycopg2.connect(DATABASE_URL)
  File "/home/mike/.local/lib/python3.6/site-packages/psycopg2/__init__.py", line 127, in connect
    raise TypeError('missing dsn and no parameters')
TypeError: missing dsn and no parameters

Should I comment on my old database?

# Online Database
conn = psycopg2.connect(DATABASE_URL)
    
asked by ThePassenger 06.07.2018 в 13:40
source

0 answers