flask_sqlalchemy AttributeError:'list'对象没有属性'topic1'

app = Flask(__name__) app.secret_key = "zWG3uzYMMrXp3TDYEZBgG4XAfYU4fd" app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///users.sqlite3' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False db1 = SQLAlchemy(app) migrate = Migrate() migrate.init_app(app, db1) class users(db1.Model): username = db1.Column("name", db1.String(100), primary_key=True) password = db1.Column("password", db1.String(100)) def __init__(self, username, password): self.username = username self.password = password counting = [0] topics_list = ["found_topic1x.topic1", "found_topic1x.topic2", "found_topic1x.topic3", "found_topic1x.topic4", "found_topic1x.topic5", "found_topic1x.topic6", "found_topic1x.topic7", "found_topic1x.topic8", "found_topic1x.topic9", "found_topic1x.topic10", "found_topic1x.topic11", "found_topic1x.topic12", "found_topic1x.topic13", "found_topic1x.topic14", "found_topic1x.topic15", "found_topic1x.topic16", "found_topic1x.topic17" "found_topic1x.topic18", "found_topic1x.topic19", "found_topic1x.topic20", "found_topic1x.topic21", "found_topic1x.topic22", "found_topic1x.topic23", "found_topic1x.topic24", "found_topic1x.topic25", "found_topic1x.topic26", "found_topic1x.topic27", "found_topic1x.topic28", "found_topic1x.topic29", "found_topic1x.topic30", "found_topic1x.topic31"] class topics1(db1.Model): topicsid = db1.Column("ID", db1.Integer, primary_key=True) usernamex = db1.Column("Username", db1.String(100)) topic1 = db1.Column("Topic 1", db1.String(100)) topic2 = db1.Column("Topic 2", db1.String(100)) topic3 = db1.Column("Topic 3", db1.String(100)) topic4 = db1.Column("Topic 4", db1.String(100)) topic5 = db1.Column("Topic 5", db1.String(100)) topic6 = db1.Column("Topic 6", db1.String(100)) topic7 = db1.Column("Topic 7", db1.String(100)) topic8 = db1.Column("Topic 8", db1.String(100)) topic9 = db1.Column("Topic 9", db1.String(100)) topic10 = db1.Column("Topic 10", db1.String(100)) topic11 = db1.Column("Topic 11", db1.String(100)) topic12 = db1.Column("Topic 12", db1.String(100)) topic13 = db1.Column("Topic 13", db1.String(100)) topic14 = db1.Column("Topic 14", db1.String(100)) topic15 = db1.Column("Topic 15", db1.String(100)) topic16 = db1.Column("Topic 16", db1.String(100)) topic17 = db1.Column("Topic 17", db1.String(100)) topic18 = db1.Column("Topic 18", db1.String(100)) topic19 = db1.Column("Topic 19", db1.String(100)) topic20 = db1.Column("Topic 20", db1.String(100)) topic21 = db1.Column("Topic 21", db1.String(100)) topic22 = db1.Column("Topic 22", db1.String(100)) topic23 = db1.Column("Topic 23", db1.String(100)) topic24 = db1.Column("Topic 24", db1.String(100)) topic25 = db1.Column("Topic 25", db1.String(100)) topic26 = db1.Column("Topic 26", db1.String(100)) topic27 = db1.Column("Topic 27", db1.String(100)) topic28 = db1.Column("Topic 28", db1.String(100)) topic29 = db1.Column("Topic 29", db1.String(100)) topic30 = db1.Column("Topic 30", db1.String(100)) topic31 = db1.Column("Topic 31", db1.String(100)) def __init__(self, topicsid, usernamex, topic1, topic2, topic3, topic4, topic5, topic6, topic7, topic8, topic9, topic10, topic11, topic12, topic13, topic14, topic15, topic16, topic17, topic18, topic19, topic20, topic21, topic22, topic23, topic24, topic25, topic26, topic27, topic28, topic29, topic30, topic31): self.topicsid = topicsid self.usernamex = usernamex self.topic1 = topic1 self.topic2 = topic2 self.topic3 = topic3 self.topic4 = topic4 self.topic5 = topic5 self.topic6 = topic6 self.topic7 = topic7 self.topic8 = topic8 self.topic9 = topic9 self.topic10 = topic10 self.topic11 = topic11 self.topic12 = topic12 self.topic13 = topic13 self.topic14 = topic14 self.topic15 = topic15 self.topic16 = topic16 self.topic17 = topic17 self.topic18 = topic18 self.topic19 = topic19 self.topic20 = topic20 self.topic21 = topic21 self.topic22 = topic22 self.topic23 = topic23 self.topic24 = topic24 self.topic25 = topic25 self.topic26 = topic26 self.topic27 = topic27 self.topic28 = topic28 self.topic29 = topic29 self.topic30 = topic30 self.topic31 = topic31 class row0(db1.Model): username0 = db1.Column("username", db1.String(100), primary_key=True) Monday0 = db1.Column("Monday", db1.String(100)) Tuesday0 = db1.Column("Tuesday", db1.String(100)) Wednesday0 = db1.Column("Wednesday", db1.String(100)) Thursday0 = db1.Column("Thursday", db1.String(100)) Friday0 = db1.Column("Friday", db1.String(100)) def __init__(self, username0, Monday0, Tuesday0, Wednesday0, Thursday0, Friday0): self.username0 = username0 self.Monday0 = Monday0 self.Tuesday0 = Tuesday0 self.Wednesday0 = Wednesday0 self.Thursday0 = Thursday0 self.Friday0 = Friday0 class row1(db1.Model): username1 = db1.Column("username", db1.String(100), primary_key=True) Monday1 = db1.Column("Monday", db1.String(100)) Tuesday1 = db1.Column("Tuesday", db1.String(100)) Wednesday1 = db1.Column("Wednesday", db1.String(100)) Thursday1 = db1.Column("Thursday", db1.String(100)) Friday1 = db1.Column("Friday", db1.String(100)) def __init__(self, username1, Monday1, Tuesday1, Wednesday1, Thursday1, Friday1): self.username1 = username1 self.Monday1 = Monday1 self.Tuesday1 = Tuesday1 self.Wednesday1 = Wednesday1 self.Thursday1 = Thursday1 self.Friday1 = Friday1 class row2(db1.Model): username2 = db1.Column("username", db1.String(100), primary_key=True) Monday2 = db1.Column("Monday", db1.String(100)) Tuesday2 = db1.Column("Tuesday", db1.String(100)) Wednesday2 = db1.Column("Wednesday", db1.String(100)) Thursday2 = db1.Column("Thursday", db1.String(100)) Friday2 = db1.Column("Friday", db1.String(100)) def __init__(self, username2, Monday2, Tuesday2, Wednesday2, Thursday2, Friday2): self.username2 = username2 self.Monday2 = Monday2 self.Tuesday2 = Tuesday2 self.Wednesday2 = Wednesday2 self.Thursday2 = Thursday2 self.Friday2 = Friday2 class row3(db1.Model): username3 = db1.Column("username", db1.String(100), primary_key=True) Monday3 = db1.Column("Monday", db1.String(100)) Tuesday3 = db1.Column("Tuesday", db1.String(100)) Wednesday3 = db1.Column("Wednesday", db1.String(100)) Thursday3 = db1.Column("Thursday", db1.String(100)) Friday3 = db1.Column("Friday", db1.String(100)) def __init__(self, username3, Monday3, Tuesday3, Wednesday3, Thursday3, Friday3): self.username3 = username3 self.Monday3 = Monday3 self.Tuesday3 = Tuesday3 self.Wednesday3 = Wednesday3 self.Thursday3 = Thursday3 self.Friday3 = Friday3 class row4(db1.Model): username4 = db1.Column("username", db1.String(100), primary_key=True) Monday4 = db1.Column("Monday", db1.String(100)) Tuesday4 = db1.Column("Tuesday", db1.String(100)) Wednesday4 = db1.Column("Wednesday", db1.String(100)) Thursday4 = db1.Column("Thursday", db1.String(100)) Friday4 = db1.Column("Friday", db1.String(100)) def __init__(self, username4, Monday4, Tuesday4, Wednesday4, Thursday4, Friday4): self.username4 = username4 self.Monday4 = Monday4 self.Tuesday4 = Tuesday4 self.Wednesday4 = Wednesday4 self.Thursday4 = Thursday4 self.Friday4 = Friday4 class row5(db1.Model): username5 = db1.Column("username", db1.String(100), primary_key=True) Monday5 = db1.Column("Monday", db1.String(100)) Tuesday5 = db1.Column("Tuesday", db1.String(100)) Wednesday5 = db1.Column("Wednesday", db1.String(100)) Thursday5 = db1.Column("Thursday", db1.String(100)) Friday5 = db1.Column("Friday", db1.String(100)) def __init__(self, username5, Monday5, Tuesday5, Wednesday5, Thursday5, Friday5): self.username5 = username5 self.Monday5 = Monday5 self.Tuesday5 = Tuesday5 self.Wednesday5 = Wednesday5 self.Thursday5 = Thursday5 self.Friday5 = Friday5 class row6(db1.Model): username6 = db1.Column("username", db1.String(100), primary_key=True) Monday6 = db1.Column("Monday", db1.String(100)) Tuesday6 = db1.Column("Tuesday", db1.String(100)) Wednesday6 = db1.Column("Wednesday", db1.String(100)) Thursday6 = db1.Column("Thursday", db1.String(100)) Friday6 = db1.Column("Friday", db1.String(100)) def __init__(self, username6, Monday6, Tuesday6, Wednesday6, Thursday6, Friday6): self.username6 = username6 self.Monday6 = Monday6 self.Tuesday6 = Tuesday6 self.Wednesday6 = Wednesday6 self.Thursday6 = Thursday6 self.Friday6 = Friday6 class row7(db1.Model): username7 = db1.Column("username", db1.String(100), primary_key=True) Monday7 = db1.Column("Monday", db1.String(100)) Tuesday7 = db1.Column("Tuesday", db1.String(100)) Wednesday7 = db1.Column("Wednesday", db1.String(100)) Thursday7 = db1.Column("Thursday", db1.String(100)) Friday7 = db1.Column("Friday", db1.String(100)) def __init__(self, username7, Monday7, Tuesday7, Wednesday7, Thursday7, Friday7): self.username7 = username7 self.Monday7 = Monday7 self.Tuesday7 = Tuesday7 self.Wednesday7 = Wednesday7 self.Thursday7 = Thursday7 self.Friday7 = Friday7 class row8(db1.Model): username8 = db1.Column("username", db1.String(100), primary_key=True) Monday8 = db1.Column("Monday", db1.String(100)) Tuesday8 = db1.Column("Tuesday", db1.String(100)) Wednesday8 = db1.Column("Wednesday", db1.String(100)) Thursday8 = db1.Column("Thursday", db1.String(100)) Friday8 = db1.Column("Friday", db1.String(100)) def __init__(self, username8, Monday8, Tuesday8, Wednesday8, Thursday8, Friday8): self.username8 = username8 self.Monday8 = Monday8 self.Tuesday8 = Tuesday8 self.Wednesday8 = Wednesday8 self.Thursday8 = Thursday8 self.Friday8 = Friday8 class row9(db1.Model): username9 = db1.Column("username", db1.String(100), primary_key=True) Monday9 = db1.Column("Monday", db1.String(100)) Tuesday9 = db1.Column("Tuesday", db1.String(100)) Wednesday9 = db1.Column("Wednesday", db1.String(100)) Thursday9 = db1.Column("Thursday", db1.String(100)) Friday9 = db1.Column("Friday", db1.String(100)) def __init__(self, username9, Monday9, Tuesday9, Wednesday9, Thursday9, Friday9): self.username9 = username9 self.Monday9 = Monday9 self.Tuesday9 = Tuesday9 self.Wednesday9 = Wednesday9 self.Thursday9 = Thursday9 self.Friday9 = Friday9 class row10(db1.Model): username10 = db1.Column("username", db1.String(100), primary_key=True) Monday10 = db1.Column("Monday", db1.String(100)) Tuesday10 = db1.Column("Tuesday", db1.String(100)) Wednesday10 = db1.Column("Wednesday", db1.String(100)) Thursday10 = db1.Column("Thursday", db1.String(100)) Friday10 = db1.Column("Friday", db1.String(100)) def __init__(self, username10, Monday10, Tuesday10, Wednesday10, Thursday10, Friday10): self.username10 = username10 self.Monday10 = Monday10 self.Tuesday10 = Tuesday10 self.Wednesday10 = Wednesday10 self.Thursday10 = Thursday10 self.Friday10 = Friday10 class row11(db1.Model): username11 = db1.Column("username", db1.String(100), primary_key=True) Monday11 = db1.Column("Monday", db1.String(100)) Tuesday11 = db1.Column("Tuesday", db1.String(100)) Wednesday11 = db1.Column("Wednesday", db1.String(100)) Thursday11 = db1.Column("Thursday", db1.String(100)) Friday11 = db1.Column("Friday", db1.String(100)) def __init__(self, username11, Monday11, Tuesday11, Wednesday11, Thursday11, Friday11): self.username11 = username11 self.Monday11 = Monday11 self.Tuesday11 = Tuesday11 self.Wednesday11 = Wednesday11 self.Thursday11 = Thursday11 self.Friday11 = Friday11 topics_count = [] @app.route("/home") def home(): if "user" in session: user = session["user"] found_topics0 = row0.query.filter_by(username0 = user).all() found_topics1 = row1.query.filter_by(username1 = user).all() found_topics2 = row2.query.filter_by(username2 = user).all() found_topics3 = row3.query.filter_by(username3 = user).all() found_topics4 = row4.query.filter_by(username4 = user).all() found_topics5 = row5.query.filter_by(username5 = user).all() found_topics6 = row6.query.filter_by(username6 = user).all() found_topics7 = row7.query.filter_by(username7 = user).all() found_topics8 = row8.query.filter_by(username8 = user).all() found_topics9 = row9.query.filter_by(username9 = user).all() found_topics10 = row10.query.filter_by(username10 = user).all() found_topics11 = row11.query.filter_by(username11 = user).all() found_topic0 = row0.query.all() found_topic1 = row1.query.all() found_topic2 = row2.query.all() found_topic3 = row3.query.all() found_topic4 = row4.query.all() found_topic5 = row5.query.all() found_topic6 = row6.query.all() found_topic7 = row7.query.all() found_topic8 = row8.query.all() found_topic9 = row9.query.all() found_topic10 = row10.query.all() found_topic11 = row11.query.all() topics = [] for x0 in found_topics0: if x0.Monday0 not in topics and x0.Monday0 != "": topics.append(x0.Monday0) if x0.Tuesday0 not in topics and x0.Tuesday0 != "": topics.append(x0.Tuesday0) if x0.Wednesday0 not in topics and x0.Wednesday0 != "": topics.append(x0.Wednesday0) if x0.Thursday0 not in topics and x0.Thursday0 != "": topics.append(x0.Thursday0) if x0.Friday0 not in topics and x0.Friday0 != "": topics.append(x0.Friday0) for x1 in found_topics1: if x1.Monday1 not in topics and x1.Monday1 != "": topics.append(x1.Monday1) if x1.Tuesday1 not in topics and x1.Tuesday1 != "": topics.append(x1.Tuesday1) if x1.Wednesday1 not in topics and x1.Wednesday1 != "": topics.append(x1.Wednesday1) if x1.Thursday1 not in topics and x1.Thursday1 != "": topics.append(x1.Thursday1) if x1.Friday1 not in topics and x1.Friday1 != "": topics.append(x1.Friday1) for x2 in found_topics2: if x2.Monday2 not in topics and x2.Monday2 != "": topics.append(x2.Monday2) if x2.Tuesday2 not in topics and x2.Tuesday2 != "": topics.append(x2.Tuesday2) if x2.Wednesday2 not in topics and x2.Wednesday2 != "": topics.append(x2.Wednesday2) if x2.Thursday2 not in topics and x2.Thursday2 != "": topics.append(x2.Thursday2) if x2.Friday2 not in topics and x2.Friday2 != "": topics.append(x2.Friday2) for x3 in found_topics3: if x3.Monday3 not in topics and x3.Monday3 != "": topics.append(x3.Monday3) if x3.Tuesday3 not in topics and x3.Monday3 != "": topics.append(x3.Tuesday3) if x3.Wednesday3 not in topics and x3.Wednesday3 != "": topics.append(x3.Wednesday3) if x3.Thursday3 not in topics and x3.Thursday3 != "": topics.append(x3.Thursday3) if x3.Friday3 not in topics and x3.Friday3 != "": topics.append(x3.Friday3) for x4 in found_topics4: if str(x4.Monday4) not in topics and x4.Monday4 != "": topics.append(x4.Monday4) if x4.Tuesday4 not in topics and x4.Tuesday4 != "": topics.append(x4.Tuesday4) if x4.Wednesday4 not in topics and x4.Wednesday4 != "": topics.append(x4.Wednesday4) if x4.Thursday4 not in topics and x4.Thursday4 != "": topics.append(x4.Thursday4) if x4.Friday4 not in topics and x4.Friday4 != "": topics.append(x4.Friday4) for x5 in found_topics5: if x5.Monday5 not in topics and x5.Monday5 != "": topics.append(x5.Monday5) if x5.Tuesday5 not in topics and x5.Tuesday5 != "": topics.append(x5.Tuesday5) if x5.Wednesday5 not in topics and x5.Wednesday5 != "": topics.append(x5.Wednesday5) if x5.Thursday5 not in topics and x5.Thursday5 != "": topics.append(x5.Thursday5) if x5.Friday5 not in topics and x5.Friday5 != "": topics.append(x5.Friday5) for x6 in found_topics6: if x6.Monday6 not in topics and x6.Monday6 != "": topics.append(x6.Monday6) if x6.Tuesday6 not in topics and x6.Tuesday6 != "": topics.append(x6.Tuesday6) if x6.Wednesday6 not in topics and x6.Wednesday6 != "": topics.append(x6.Wednesday6) if x6.Thursday6 not in topics and x6.Thursday6 != "": topics.append(x6.Thursday6) if x6.Friday6 not in topics and x6.Friday6 != "": topics.append(x6.Friday6) for x7 in found_topics7: if x7.Monday7 not in topics and x7.Monday7 != "": topics.append(x7.Monday7) if x7.Tuesday7 not in topics and x7.Tuesday7 != "": topics.append(x7.Tuesday7) if x7.Wednesday7 not in topics and x7.Wednesday7 != "": topics.append(x7.Wednesday7) if x7.Thursday7 not in topics and x7.Thursday7 != "": topics.append(x7.Thursday7) if x7.Friday7 not in topics and x7.Friday7 != "": topics.append(x7.Friday7) for x8 in found_topics8: if x8.Monday8 not in topics and x8.Monday8 != "": topics.append(x8.Monday8) if x8.Tuesday8 not in topics and x8.Tuesday8 != "": topics.append(x8.Tuesday8) if x8.Wednesday8 not in topics and x8.Wednesday8 != "": topics.append(x8.Wednesday8) if x8.Thursday8 not in topics and x8.Thursday8 != "": topics.append(x8.Thursday8) if x8.Friday8 not in topics and x8.Friday8 != "": topics.append(x8.Friday8) for x9 in found_topics9: if x9.Monday9 not in topics and x9.Monday9 != "": topics.append(x9.Monday9) if x9.Tuesday9 not in topics and x9.Tuesday9 != "": topics.append(x9.Tuesday9) if x9.Wednesday9 not in topics and x9.Wednesday9 != "": topics.append(x9.Wednesday9) if x9.Thursday9 not in topics and x9.Thursday9 != "": topics.append(x9.Thursday9) if x9.Friday9 not in topics and x9.Friday9 != "": topics.append(x9.Friday9) for x10 in found_topics10: if x10.Monday10 not in topics and x10.Monday10 != "": topics.append(x10.Monday10) if x10.Tuesday10 not in topics and x10.Tuesday10 != "": topics.append(x10.Tuesday10) if x10.Wednesday10 not in topics and x10.Wednesday10 != "": topics.append(x10.Wednesday10) if x10.Thursday10 not in topics and x10.Thursday10 != "": topics.append(x10.Thursday10) if x10.Friday10 not in topics and x10.Friday10 != "": topics.append(x10.Friday10) for x11 in found_topics11: if x11.Monday11 not in topics and x11.Monday11 != "": topics.append(x11.Monday11) if x11.Tuesday11 not in topics and x11.Tuesday11 != "": topics.append(x11.Tuesday11) if x11.Wednesday11 not in topics and x11.Wednesday11 != "": topics.append(x11.Wednesday11) if x11.Thursday11 not in topics and x11.Thursday11 != "": topics.append(x11.Thursday11) if x11.Friday11 not in topics and x11.Friday11 != "": topics.append(x11.Friday11) top = topics1(counting[-1] + 1, user, "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r","s", "t", "u", "v", "w", "x", "y", "z", "ä", "ö", "ü", "ab", "ac") found_something = topics1.query.filter_by(usernamex = user).all() if found_something: db1.session.add(top) db1.session.commit() counting.append(counting[-1] + 1) found_topic1x = topics1.query.all() for x in range(0, len(topics)): if x == 0: found_something.topic1 = topics[x] if x == 1: found_something.topic2 = topics[x] if x == 2: found_something.topic3 = topics[x] if x == 3: found_something.topic4 = topics[x] if x == 4: found_something.topic5 = topics[x] if x == 5: found_something.topic6 = topics[x] if x == 6: found_something.topic7 = topics[x] if x == 7: found_something.topic8 = topics[x] if x == 8: found_something.topic9 = topics[x] if x == 9: found_something.topic10 = topics[x] if x == 10: found_something.topic11 = topics[x] if x == 11: found_something.topic12 = topics[x] if x == 12: found_something.topic13 = topics[x] if x == 13: found_something.topic14 = topics[x] if x == 14: found_something.topic15 = topics[x] if x == 15: found_something.topic16 = topics[x] if x == 16: found_something.topic17 = topics[x] if x == 17: found_something.topic18 = topics[x] if x == 18: found_something.topic19 = topics[x] if x == 19: found_something.topic20 = topics[x] if x == 20: found_something.topic21 = topics[x] if x == 21: found_something.topic22 = topics[x] if x == 22: found_something.topic23 = topics[x] if x == 23: found_something.topic24 = topics[x] if x == 24: found_something.topic25 = topics[x] if x == 25: found_something.topic26 = topics[x] if x == 26: found_something.topic27 = topics[x] if x == 27: found_something.topic28 = topics[x] if x == 28: found_something.topic29 = topics[x] if x == 29: found_something.topic30 = topics[x] if x == 30: found_something.topic31 = topics[x] db1.session.commit() return render_template("home.html", topics=topics, count=len(topics), found_topic0=found_topic0, found_topic1=found_topic1, found_topic2=found_topic2, found_topic3=found_topic3, found_topic4=found_topic4, found_topic5=found_topic5, found_topic6=found_topic6, found_topic7=found_topic7, found_topic8=found_topic8, found_topic9=found_topic9, found_topic10=found_topic10, found_topic11=found_topic11, user=user, found_topic1x = found_topic1x, topics_list=topics_list) else: flash("Sie müssen sich erst einloggen!") return redirect(url_for("login")) if __name__ == "__main__": db1.create_all() app.run(debug=True, port=5002)

{% extends "base.html" %} {% block title %} Home {% endblock %} {% block content %} <div class="accordion accordion-flush" id="accordionFlushExample"> {% for x in range(0, count) %} <div class="accordion-item"> <h2 class="accordion-header" id="flush-heading{{x}}"> <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#flush-collapse{{x}}" aria-expanded="false" aria-controls="flush-collapseOne"> <strong>{{topics[x]}}</strong> </button> </h2> <div id="flush-collapse{{x}}" class="accordion-collapse collapse" aria-labelledby="flush-headingOne" data-bs-parent="#accordionFlushExample"> <div class="accordion-body">Gemeinsame Kursteilnehmer: </div> {% endfor %} </div> <p><h1>{{topics}}</h1></p> {% endblock %}

1条回答

网友

1楼 · 发布于 2024-06-26 00:29:10

found_something在使用代码时填充：topics1.query.filter_by(usernamex = user).all()

因此，正如在这里显而易见的，我们发现有些东西是一个列表。现在，要访问列表中的单个对象，必须传递索引

因此，found_something[0].topic1而不是found_something.topic1将为您提供列表中第一个对象的结果

类似地，found_something[1].topic2而不是found_something.topic2将为您提供第二个对象的结果。诸如此类

相关问题更多 >

编程相关推荐

热门问题

热门文章