T
Size: a a a
T
A
АП
приложение готово и работает. (если ты к этому)
T
A
I
АП
I
I
SELECT point_pass_mea.id,я все написал но не могу как вложить в
(select count(hpm.id) from history_pass_mea as hpm where hpm.id_point_pass = point_pass_mea.id)
FROM point_pass_mea
GROUP BY point_pass_mea.id;
db.session.query(вот это
PointPass.id
)
(select count(hpm.id) from history_pass_mea as hpm where hpm.id_point_pass = point_pass_mea.id)
АП
I
I
I
АП
I
I
t = db.session.query( db.func.count(HistoryPass.id)).filter(HistoryPass.id_point_pass == PointPass.id).subquery()что выводит вот это:
hp = db.session.query( PointPass.id, t)
hp = hp.group_by(PointPass.id)
hp.all()
SELECT point_pass_mea.id AS point_pass_mea_id, anon_1.count_1 AS anon_1_count_1а мне надо получить вот такой запрс:
FROM point_pass_mea, (SELECT count(history_pass_mea.id) AS count_1
FROM history_pass_mea, point_pass_mea
WHERE history_pass_mea.id_point_pass = point_pass_mea.id) AS anon_1 GROUP BY point_pass_mea.id;
SELECT point_pass_mea.id,
(select count(hpm.id) from history_pass_mea as hpm where hpm.id_point_pass = point_pass_mea.id)
FROM point_pass_mea
GROUP BY point_pass_mea.id;
I
t = db.session.query( db.func.count(HistoryPass.id)).filter(HistoryPass.id_point_pass == PointPass.id).subquery()что выводит вот это:
hp = db.session.query( PointPass.id, t)
hp = hp.group_by(PointPass.id)
hp.all()
SELECT point_pass_mea.id AS point_pass_mea_id, anon_1.count_1 AS anon_1_count_1а мне надо получить вот такой запрс:
FROM point_pass_mea, (SELECT count(history_pass_mea.id) AS count_1
FROM history_pass_mea, point_pass_mea
WHERE history_pass_mea.id_point_pass = point_pass_mea.id) AS anon_1 GROUP BY point_pass_mea.id;
SELECT point_pass_mea.id,
(select count(hpm.id) from history_pass_mea as hpm where hpm.id_point_pass = point_pass_mea.id)
FROM point_pass_mea
GROUP BY point_pass_mea.id;
/
class DateForm(FlaskForm):
"""Config for select date form"""
days_range = 5
choices = [(datetime.date.today().strftime('%d/%m/%Y'), datetime.date.today().strftime('%d/%m/%Y'))]
for day in range(1, days_range):
day_tmp = (datetime.datetime.today() - datetime.timedelta(days=int(day))).strftime("%d/%m/%Y")
choices.append((day_tmp, day_tmp))
date = SelectField("Date", choices=choices)
submit = SubmitField()
T