>>> import lxml.html as lh
>>>
>>> raw_html = """<div class="form-item">
... <label for="firstname">Введите фамилию*</label>
... <input type="text" name="firstname" id="firstname" required/>
... </div>
... <div class="form-item">
... <label for="lastname">Введите имя*</label>
... <input type="text" name="lastname" id="lastname" required />
... </div>
... <div class="form-item">
... <label for="patronymic">Введите Отчество</label>
... <input type="text" name="patronymic" id="patronymic"/>
... </div>
... """
>>>
>>> html = lh.fromstring(raw_html)
>>> html.xpath('.//label[@for="firstname"]/text()')[0]
'Введите фамилию*'
await message.photo[-1].download('C:/Antony/py_projects/qr_code_bot/photos/ggg.jpg')
await message.photo[-1].download(destination_file='C:/Antony/py_projects/qr_code_bot/photos/ggg.jpg')
CREATE TABLE artist(
artistid INTEGER PRIMARY KEY,
artistname TEXT
);
CREATE TABLE track(
trackid INTEGER,
trackname TEXT,
trackartist INTEGER REFERENCES artist(artistid) ON UPDATE CASCADE
);
PRAGMA foreign_keys = ON;