· 6 years ago · Jun 25, 2019, 07:44 AM
1$ flask db init
2
3$ flask db migrate
4
5psycopg2.errors.UndefinedColumn: column "username" does not exist
6
7root@cb14962d3dff:/home/site/wwwroot# flask db init
8Usage: flask [OPTIONS] COMMAND [ARGS]...
9Try "flask --help" for help.
10
11Error: No such command "db".
12
13class Config(object):
14 # ...
15 SECRET_KEY = os.environ.get('SECRET_KEY') or os.urandom(12)
16 USERNAME = os.environ.get('DB_USERNAME')
17 PASSWORD = os.environ.get('DB_PASSWORD')
18 URL = os.environ.get('DB_URL')
19 if USERNAME:
20 SQLALCHEMY_DATABASE_URI = 'postgresql+psycopg2://' + USERNAME + ':' + PASSWORD + '@' + URL + ':5432/postgres'
21 else:
22 SQLALCHEMY_DATABASE_URI = 'sqlite:///' + os.path.join(basedir, 'app.db')
23 SQLALCHEMY_TRACK_MODIFICATIONS = False
24
25server = Flask(__name__)
26server.config.from_object(Config)
27
28db = SQLAlchemy(server)
29migrate = Migrate(server, db)