无法在python中创建restaurant.db文件

Z时代
2024-01-10
分类：问答

下面提到的是我在python中创建的数据库配置文件。在执行代码时我没有收到restaurant.db文件（它是在执行时自动创建的）。请检查我的代码。谢谢无法在python中创建restaurant.db文件

import os 
import sys 
from sqlalchemy import Column, ForeignKey, Integer, String 
from sqlalchemy.ext.declarative import declarative_base 
from sqlalchemy.orm import relationship 
from sqlalchemy import create_engine 
Base = declarative_base() 
class Restaurant(Base): 
    __tablename__ = 'restaurant' 
    id = Column(Integer, primary_key=True) 
    name = Column(String(250), nullable=False) 
class MenuItem(Base): 
    __tablename__ = 'menu_item' 
    name = Column(String(80), nullable=False) 
    id = Column(Integer, primary_key=True) 
    description = Column(String(250)) 
    price = Column(String(8)) 
    course = Column(String(250)) 
    restaurant_id = Column(Integer, ForeignKey('restaurant.id')) 
    restaurant = relationship(Restaurant) 
engine = create_engine('sqlite:///restaurantmenu.db') 
Base.metadata.create_all(engine)