使用flask創(chuàng)建SQLite數(shù)據(jù)庫出現(xiàn)問題:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: novels [SQL: 'SELECT novels.id AS novels_id, novels.book_name AS novels_book_name, novels.book_url AS novels_book_url, novels.book_img AS novels_book_img, novels.author AS novels_author, novels.style AS novels_style, novels.last_update AS novels_last_update, novels.profile AS novels_profile, novels.search_name AS novels_search_name, novels.page AS novels_page \nFROM novels \nWHERE novels.search_name = ? AND novels.page = ?'] [parameters: ('誅仙', 0)]
原來是數(shù)據(jù)庫沒有創(chuàng)建候齿,路徑不對握恳,正確路徑:
SQLALCHEMY_DATABASE_URI = os.environ.get('DEV_DATABASE_URL') or 'sqlite:///' + os.path.join(basedir, 'data-dev.sqlite')
注意尼变,是 SQLALCHEMY_DATABASE_URI啼止,
而我寫成了 SQLALCHEMY_DATABASE_URL,
一字之差姥敛,害死人啊~~~