Błąd podczas tworzenia bazy danych

[robin92]

Aplikacja nie jest w stanie stworzyć bazy danych. Otrzymuję błąd:

Traceback (most recent call last):
  File "/usr/lib/python3.3/runpy.py", line 160, in _run_module_as_main
    "__main__", fname, loader, pkg_name)
  File "/usr/lib/python3.3/runpy.py", line 73, in _run_code
    exec(code, run_globals)
  File "./runserver.py", line 2, in <module>
    from flavority import app
  File "./flavority/__init__.py", line 19, in <module>
    flavority.controllers.load_database(app)
  File "./flavority/controllers.py", line 35, in load_database
    a.db.drop_all()
  File "/usr/lib/python3.3/site-packages/flask_sqlalchemy/__init__.py", line 864, in drop_all
    self._execute_for_all_tables(app, bind, 'drop_all')
  File "/usr/lib/python3.3/site-packages/flask_sqlalchemy/__init__.py", line 848, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), tables=tables)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/schema.py", line 3335, in drop_all
    tables=tables)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1516, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1164, in _run_visitor
    **kwargs).traverse_single(element)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/visitors.py", line 119, in traverse_single
    return meth(obj, **kw)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/ddl.py", line 766, in visit_metadata
    for t in reversed(sort_tables(tables))
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/ddl.py", line 857, in sort_tables
    {'foreign_key': visit_foreign_key})
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/visitors.py", line 255, in traverse
    return traverse_using(iterate(obj, opts), obj, visitors)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/visitors.py", line 246, in traverse_using
    meth(target)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/ddl.py", line 848, in visit_foreign_key
    parent_table = fkey.column.table
  File "/usr/lib/python3.3/site-packages/sqlalchemy/util/langhelpers.py", line 689, in __get__
    obj.__dict__[self.__name__] = result = self.fget(obj)
  File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/schema.py", line 1644, in column
    tablekey)
sqlalchemy.exc.NoReferencedTableError: Foreign key associated with column 'Comment.author_id' could not find table 'User' with which to generate a foreign key to target column 'id'

[FilipJany]

Hej :) Dopiero teraz odczytałem maila, nie mam przy sobie kompa i nie umiem nic zrobić :( jak wrócę to lookne na to :) chyba ze już działa?

Pozdro

-----Original Message----- From: Rafal Sent: 2014-03-18 11:14 To: robin92/flavority-api Subject: [flavority-api] Błąd podczas tworzenia bazy danych (#1)

Aplikacja nie jest w stanie stworzyć bazy danych. Otrzymuję błąd: Traceback (most recent call last): File "/usr/lib/python3.3/runpy.py", line 160, in _run_module_as_main "main", fname, loader, pkg_name) File "/usr/lib/python3.3/runpy.py", line 73, in _run_code exec(code, run_globals) File "./runserver.py", line 2, in from flavority import app File "./flavority/init.py", line 19, in flavority.controllers.load_database(app) File "./flavority/controllers.py", line 35, in load_database a.db.drop_all() File "/usr/lib/python3.3/site-packages/flask_sqlalchemy/init.py", line 864, in drop_all self._execute_for_all_tables(app, bind, 'drop_all') File "/usr/lib/python3.3/site-packages/flask_sqlalchemy/init.py", line 848, in _execute_for_all_tables op(bind=self.get_engine(app, bind), tables=tables) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/schema.py", line 3335, in drop_all tables=tables) File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1516, in _run_visitor conn._run_visitor(visitorcallable, element, _kwargs) File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1164, in _run_visitor _kwargs).traverse_single(element) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/visitors.py", line 119, in traverse_single return meth(obj, kw) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/ddl.py", line 766, in visit_metadata for t in reversed(sort_tables(tables)) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/ddl.py", line 857, in sort_tables {'foreign_key': visit_foreign_key}) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/visitors.py", line 255, in traverse return traverse_using(iterate(obj, opts), obj, visitors) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/visitors.py", line 246, in traverse_using meth(target) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/ddl.py", line 848, in visit_foreign_key parent_table = fkey.column.table File "/usr/lib/python3.3/site-packages/sqlalchemy/util/langhelpers.py", line 689, in get obj.dict[self.name**] = result = self.fget(obj) File "/usr/lib/python3.3/site-packages/sqlalchemy/sql/schema.py", line 1644, in column tablekey) sqlalchemy.exc.NoReferencedTableError: Foreign key associated with column 'Comment.author_id' could not find table 'User' with which to generate a foreign key to target column 'id'

— Reply to this email directly or view it on GitHub.

[robin92]

@FilipJany Tak, został zamknięty jak tylko go znalazłem (robin92 closed this in 0a4dcd1 2 hours ago), ale pomyślałem że zrobię przykładowe Issue :-)

[FilipJany]

Ok :) to fajnie :) Pozdro

-----Original Message----- From: Rafal Sent: 2014-03-18 12:58 To: robin92/flavority-api Cc: Filip Jany Subject: Re: [flavority-api] Błąd podczas tworzenia bazy danych (#1)

@FilipJany Tak, został zamknięty jak tylko go znalazłem (robin92 closed this in 0a4dcd1 2 hours ago), ale pomyślałem że zrobię przykładowe Issue :-)

— Reply to this email directly or view it on GitHub.