Отправка значений списков в почтовом запросе из HTML/JS на серверную часть (python) ⇐ Python

[Anonymous]

Английский не мой родной язык, так что простите за ошибки в грамматике
Я впервые работаю с JS, я начну с показа таблиц в базе данных, а затем объясню проблему, так что, надеюсь, кто-нибудь сможет помочь я.
У меня есть эти таблицы:

Код: Выделить всё

"# Children model
class Child(db.Model):
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(150), nullable=False)
surname = db.Column(db.String(150), nullable=False)
gender = db.Column(db.String(10), nullable=False)
father_name = db.Column(db.String(150), nullable=True)
mother_name = db.Column(db.String(150), nullable=True)
contact_phone_number = db.Column(db.String(20), nullable=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

Код: Выделить всё

# Session Details model
class SessionDetail(db.Model):
id = db.Column(db.Integer, primary_key=True)
child_id = db.Column(db.Integer, db.ForeignKey('child.id'), nullable=False)
therapy_type = db.Column(db.String(150), nullable=False)
session_date = db.Column(db.String(20), nullable=False)
progress_update = db.Column(db.Text, nullable=True)
activities_performed = db.Column(db.Text, nullable=True)
notes_comments = db.Column(db.Text, nullable=True)
progress_rating = db.Column(db.Integer, nullable=True)
goals = db.relationship('Goal', backref='session', lazy=True)

Код: Выделить всё

# Goal model
class Goal(db.Model):
id = db.Column(db.Integer, primary_key=True)
session_id = db.Column(db.Integer, db.ForeignKey('session_detail.id'), nullable=False)
description = db.Column(db.Text, nullable=False)
rating = db.Column(db.Integer, nullable=False)"

"
у каждого ребенка есть таблица сеансов, и для каждого сеанса я могу добавить одну или несколько целей/рейтинга (для каждой цели).
"
у каждого ребенка есть таблица сеансов, и для каждого сеанса я могу добавить одну или несколько целей/рейтинга (для каждой цели).
"
у каждого ребенка есть таблица сеансов, и для каждого сеанса я могу добавить одну или несколько целей/рейтинга (для каждой цели).
"
strong>
это мой код, который обрабатывает добавление/обновление строки в таблице сеанса:

Код: Выделить всё

@app.route('/child//sessions', methods=['GET', 'POST'])
def child_sessions(child_id):
child = Child.query.get(child_id)
if not child:
logging.error(f"Child with ID {child_id} not found.")
return 'Child not found', 404

debug_info = None
if request.method == 'POST':
try:
if 'add_session' in request.form:
response = add_session(child_id)
elif 'update_session' in request.form:
response = update_session(request.form['session_id'])
elif 'delete_session' in request.form:
response = delete_session(request.form['session_id'])
else:
response = None

if response:
return response

except Exception as e:
logging.error(f"Error processing session: {e}")
return f"Error: {e}", 500

sessions = SessionDetail.query.filter_by(child_id=child_id).all()
return render_template('sessions.html', child=child, sessions=sessions, debug_info=debug_info)

def add_session(child_id):
try:
logging.debug(f"Full form data: {request.form}")
therapy_type = request.form['therapy_type']
session_date = request.form['session_date']
if not session_date:
raise ValueError("Session date is required.")
progress_update = request.form['progress_update']
activities_performed = request.form.get('activities_performed')
notes_comments = request.form.get('notes_comments')

progress_ratings = request.form.getlist('progress_rating_new[]')
setting_goals = request.form.getlist('setting_goals_new[]')

logging.debug(f"Progress ratings: {progress_ratings}")
logging.debug(f"Setting goals: {setting_goals}")

logging.info(f"Adding session:  therapy_type={therapy_type}, session_date={session_date}, "
f"progress_update={progress_update}, activities_performed={activities_performed}, "
f"notes_comments={notes_comments}, progress_rating={progress_ratings}")

new_session = SessionDetail(
child_id=child_id, therapy_type=therapy_type, session_date=session_date,
progress_update=progress_update,
activities_performed=activities_performed, notes_comments=notes_comments,
progress_rating=int(progress_ratings[0]))

db.session.add(new_session)
db.session.flush()  # Flush to get the new session ID

for goal, rating in zip(setting_goals, progress_ratings):
logging.info(f"Adding goal: {goal} with rating: {rating}")
new_goal = Goal(session_id=new_session.id, description=goal, rating=int(rating))
db.session.add(new_goal)

db.session.commit()
except KeyError as e:
logging.error(f"Missing form field: {e}")
return f'Error adding session: Missing form field {e}', 400
except ValueError as e:
logging.error(f"Invalid form data: {e}")
return f'Error adding session: {e}', 400
except Exception as e:
logging.error(f"Error adding session: {e}")
return 'Error adding session', 500

return redirect(url_for('child_sessions', child_id=child_id))

def update_session(session_id):

session_detail = SessionDetail.query.get(session_id)
if not session_detail:
logging.error(f"Session with ID {session_id} not found.")
return 'Session not found', 404

try:
logging.debug(f"Full form data: {request.form}")
therapy_type = request.form['therapy_type']
session_date = request.form['session_date']
progress_update = request.form['progress_update']
activities_performed = request.form.get('activities_performed')
notes_comments = request.form.get('notes_comments')

progress_ratings = request.form.getlist('progress_rating[]')
setting_goals = request.form.getlist('setting_goals[]')

session_detail.therapy_type = therapy_type
session_detail.session_date = session_date
session_detail.progress_update = progress_update
session_detail.activities_performed = activities_performed
session_detail.notes_comments = notes_comments
session_detail.progress_rating = int(progress_ratings[0])

Goal.query.filter_by(session_id=session_id).delete()  # Delete existing goals for the session

for goal, rating in zip(setting_goals, progress_ratings):
logging.info(f"Adding goal: {goal} with rating: {rating}")
new_goal = Goal(session_id=session_id, description=goal, rating=int(rating))
db.session.add(new_goal)

db.session.commit()
except KeyError as e:
logging.error(f"Missing form field: {e}")
return f'Error updating session: Missing form field {e}', 400
except ValueError as e:
logging.error(f"Invalid form data: {e}")
return f'Error updating session: {e}', 400
except Exception as e:
logging.error(f"Error updating session: {e}")
return 'Error updating session', 500

return redirect(url_for('child_sessions', child_id=session_detail.child_id))"

Я проверил JS на выходе, и он получает правильный список, но при нажатии на обновление он удаляет все цели, кроме первой, и отправляет их запрос на публикацию - это только первая цель.
и это мой код session.html (я переместил скрипты и CSS на страницу только для отладки):

Код: Выделить всё

Sessions for {{ child.first_name }} {{ child.surname }}


.profile-container {
margin: 20px;
}
.table-container {
overflow-x: auto;
}
table {
width: 100%;
border-collapse: collapse;
}
th, td {
border: 1px solid black;
padding: 8px;
text-align: left;
}
.goal-container {
margin-top: 10px;
}
.goal-item {
margin-bottom: 10px;
}
.goal-item-buttons {
margin-top: 5px;
}
.add-goal-button {
margin-top: 10px;
}
.back-button-container {
margin-bottom: 20px;
}
.btn-back {
text-decoration: none;
padding: 10px 20px;
background-color: #007bff;
color: white;
border-radius: 5px;
}




Sessions for {{ child.first_name }} {{ child.surname }}



[url={{ url_for(]Back to Children's Progress[/url]




Therapy Type
Session Date
Goals
Progress Update
Activities Performed
Notes/Comments
Actions



{% for session in sessions %}





Therapy 1
Therapy 2
Therapy 3
Therapy 4





{% for goal in session.goals %}

{{ goal.description }}

Choose rating
{% for i in range(1, 11) %}
{{ i }}
{% endfor %}


Remove


{% endfor %}
Add Goal


{{ session.progress_update }}
{{ session.activities_performed }}
{{ session.notes_comments }}

Update
Delete



{% endfor %}




Therapy 1
Therapy 2
Therapy 3
Therapy 4








Choose rating
{% for i in range(1, 11) %}
{{ i }}
{% endfor %}


Remove


Add Goal





Add













document.addEventListener('DOMContentLoaded', function() {
const formInputs = document.querySelectorAll('.login-form input[type="text"], .login-form input[type="password"], .profile-container form input[type="text"], .profile-container form input[type="tel"], .profile-container form select');

formInputs.forEach(input => {
input.addEventListener('focus', function() {
this.style.borderColor = '#007bff';
});

input.addEventListener('blur', function() {
this.style.borderColor = '#ddd';
});
});

const submitButtons = document.querySelectorAll('.login-form input[type="submit"], .profile-container form button[type="submit"]');

submitButtons.forEach(button => {
button.addEventListener('mousedown', function() {
this.style.backgroundColor = '#004080';
});

button.addEventListener('mouseup', function() {
this.style.backgroundColor = '#007bff';
});
});
});

function addGoal(button, goalsName = 'setting_goals[]', ratingsName = 'progress_rating[]') {
const goalContainer = button.closest('.goal-container');
const newGoalItem = document.createElement('div');
newGoalItem.className = 'goal-item';
newGoalItem.innerHTML = `


Choose rating
${[...Array(10).keys()].map(i => `${i+1}`).join('')}


Remove

`;
console.log(`Adding new goal item with names: ${goalsName}, ${ratingsName}`);
goalContainer.insertBefore(newGoalItem, button);
logFormData(goalContainer);
}

function removeGoal(button) {
const goalItem = button.closest('.goal-item');
console.log('Removing goal item');
goalItem.remove();
const goalContainer = button.closest('.goal-container');
logFormData(goalContainer);
}

function logFormData(goalContainer) {
const goalTexts = goalContainer.querySelectorAll('textarea[name="setting_goals[]"], textarea[name="setting_goals_new[]"]');
const ratingSelects = goalContainer.querySelectorAll('select[name="progress_rating[]"], select[name="progress_rating_new[]"]');

const goals = Array.from(goalTexts).map(textarea => textarea.value.trim()).filter(value => value);
const ratings = Array.from(ratingSelects).map(select => select.value).filter(value => value);

console.log('Current Goals:', goals);
console.log('Current Ratings:', ratings);
}

Спасибо
Я пытаюсь отправить два списка из html в запросе на публикацию в backcode, но он отправляет только первое значение в списке и удаление всех остальных

Подробнее здесь: https://stackoverflow.com/questions/787 ... kendpython