伙計們，我正在做一個網站專案。我需要幫助閱讀整個表格并將其顯示在我的網站頁面“index.html”上。
要求：我在本地主機 phpmyadmin 上使用 Flask 的 SQLAlchemy 有一個表 'kolkata'，我在 google 上搜索了太多但找不到解決方案所以我來到這里。所以基本上我的表有 3 列 - sno（自動增量和主鍵）、employee_name 和employee_status。我想在我的應用程式中閱讀整個表格，其 main.py 如下 -
from flask import Flask, render_template, request, session
from flask_sqlalchemy import SQLAlchemy
from flask_mail import Mail
import json
from datetime import datetime
from sqlalchemy import select
import sqlalchemy
with open('config.json', 'r') as c:
params = json.load(c)["params"]
local_server = True
app = Flask(__name__)
app.secret_key = 'super-secret-key'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config.update(
MAIL_SERVER = 'smtp.gmail.com',
MAIL_PORT = '465',
MAIL_USE_SSL = True,
MAIL_USERNAME = params['gmail-user'],
MAIL_PASSWORD= params['gmail-password']
)
mail = Mail(app)
if(local_server):
app.config['SQLALCHEMY_DATABASE_URI'] = params['local_uri']
else:
app.config['SQLALCHEMY_DATABASE_URI'] = params['prod_uri']
db = SQLAlchemy(app)
class data_reader(db.Model):
sno = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30))
@app.route("/", methods=["GET", "POST"])
def home():
if (session['user_pass'] == params['sitehr_password']):
data = db.session.query(data_reader)
print(data)
#here i need to add the code which u will give me
return render_template('index.html', employeedata=data)
if request.method=='POST':
username = request.form.get('uname')
userpass = request.form.get('pass')
usersite = request.form.get('select_site')
if (userpass == params['sitehr_password']):
#set the session variable
session['user'] = username
session['user_pass'] = userpass
session['user_site'] = usersite
return render_template('index.html')
return render_template("login.html")
app.run(debug=True)
我的 index.html 如下 -
<html>
<head>
<title>
Employee Status Manager
</title>
</head>
<body>
<table>
<th>Serial No.</th>
<th>Employee Name</th>
{% for row in employeedata %}
<tr>
<td> {{row.sno}} <td>
<td> {{row.employee_name}} <td>
<tr>
{% endfor %}
</table>
{{employeedata}}
</body>
</html>
我的 config.json 放在這里
{
"params":
{
"sitehr_password": "asdf",
"gmail-user":"[email protected]",
"gmail-password":"******",
"local_uri": "mysql://root:@localhost/employeestatus",
"prod_uri":"mysql://root:@localhost/employeestatus"
}
}
當我運行代碼時，出現這樣的錯誤 - https://i.stack.imgur.com/7Yeop.png
我在終端中的 vscode 錯誤如下-
sqlalchemy.exc.ProgrammingError
sqlalchemy.exc.ProgrammingError: (MySQLdb._exceptions.ProgrammingError) (1146, "Table 'employeestatus.data_reader' doesn't exist")
[SQL: SELECT data_reader.sno AS data_reader_sno, data_reader.name AS data_reader_name
FROM data_reader]
(Background on this error at: https://sqlalche.me/e/14/f405)
我的 phpmyadmin 資料庫的圖片 - https://i.stack.imgur.com/6oxVQ.png
我真的無法理解它的含義以及接下來要做什么，我浪費了 3 個小時的時間，但什么也做不了，現在我完全依賴你們這些人。提前致謝 ！！
uj5u.com熱心網友回復：
你的課data_reader有問題。
class data_reader(db.Model):
sno = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30))
您需要向此類添加表名：
class data_reader(db.Model):
__tablename__ = 'kolkata'
sno = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30))
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/403771.html
標籤：