Ник В

import xml.etree.cElementTree as ET
from typing import List
from typing import NamedTuple
from typing import Tuple


class User(NamedTuple):
    internal_id: int
    name: str
    age: int
    images: Tuple[str]


XML: str = """
<root>
<user internal-id="1233232323">
  <name>Alex</name>
  <age>23</age>
  <image id="1">http://example.com/images/img1.jpg</image>
  <image id="2">http://example.com/images/img2.jpg</image>
  <image id="3">http://example.com/images/img3.jpg</image>
  <image id="4">http://example.com/images/img4.jpg</image>
  <image id="5">http://example.com/images/img5.jpg</image>
</user>

<user internal-id="24323423423">
  <name>Daniel</name>
  <age>31</age>
  <image id="1">http://example.com/images/img1.jpg</image>
  <image id="2">http://example.com/images/img2.jpg</image>
  <image id="3">http://example.com/images/img3.jpg</image>
  <image id="4">http://example.com/images/img4.jpg</image>
  <image id="5">http://example.com/images/img5.jpg</image>
</user>
</root>
"""

if __name__ == '__main__':
    users: List[User] = []
    root = ET.fromstring(XML)
    for user in root:
        user_data = tuple(tag.text for tag in user)
        users.append(
            User(
                internal_id=user.get('internal-id'),
                name=user_data[0],
                age=user_data[1],
                images=user_data[2:]
            )
        )

if __name__ == '__main__':
    print('Здравствуйте, я робот который определят, какое сейчас время года по числу :)')
    try:
        date = int(input('Введите какое сейчас число: '))
    except ValueError:
        print('Ты ввёл не число. Ты убил меня.')
    else:
        if date <= 2:
            print('Сейчас на улице зима, сиди дома ;)')
        elif date <= 5:
            print('Ой весна иди делай фотки!')
        elif date <= 8:
            print('Везет тебе сейчас у тебя лето, а мне тут людям помогать, но мне даже это нравиться')
        elif date <= 11:
            print('Вот и осень подоспела, идти в школу, а мне тут сидеть')
        else:
            print('Сейчас зима и вроде грустно, но уже скоро 2020 год!')

from sqlite3 import Connection as SqliteConnection
from sqlite3 import Cursor as SqliteCursor

sql = """
pragma foreign_keys = on;
create table if not exists users
(
  id          integer primary key autoincrement,
  internal_id text not null,
  first_name  text not null,
  last_name   text not null,
  username    text not null unique,
  created     date not null default current_date
);
create unique index if not exists users_id_uindex
  on users (id);
create unique index if not exists users_internal_id_uindex
  on users (internal_id);
create index if not exists users_first_name_index
  on users (created);
create index if not exists users_last_name_index
  on users (created);
create unique index if not exists users_username_uindex
  on users (username);
create index if not exists users_created_index
  on users (created);
"""


def check_db(db_connect: SqliteConnection,
             db_cursor: SqliteCursor) -> None:
    db_cursor.executescript(sql)
    db_connect.commit()

from sqlite3 import Connection as SqliteConnection
from sqlite3 import Cursor as SqliteCursor
from typing import List

def insert_user(db_cursor: SqliteCursor,
                db_connect: SqliteConnection,
                internal_id: str, username: str,
                first_name: str, last_name: str) -> None:
    db_cursor.execute("""
            insert into users(internal_id, username, first_name, last_name)
            select :internal_id, :username, :first_name, :last_name
            where not exists(select 1 from users where internal_id = :internal_id and username = :username)
        """, {
        'internal_id': internal_id,
        'username': username,
        'first_name': first_name,
        'last_name': last_name,
    })
    db_connect.commit()

def select_user(db_connect: SqliteConnection,
                username: str) -> List[tuple] or None:
    result = db_connect.execute(
        f"""select *
            from users
            where username = :username""",
        {'username': username},
    ).fetchone()

    return result

from contextlib import closing
import sqlite3

from db.utils import check_db
from db.queries import insert_user

with closing(sqlite3.connect('db_name')) as db_connect:
        with closing(db_connect.cursor()) as db_cursor:
            check_db(db_connect, db_cursor)  # проверяем есть ли таблица в базе, если нет то создаём её
            insert_user(db_cursor, db_connect, 'internal_id', 'username', 'first_name', 'last_name')  # если в базе ещё нет такого юзера с internal_id и username то он создастся

from contextlib import closing
import sqlite3

from db.utils import check_db
from db.queries import select_user


with closing(sqlite3.connect('db_name')) as db_connect:
        with closing(db_connect.cursor()) as db_cursor:
            check_db(db_connect, db_cursor)  # проверяем есть ли таблица в базе, если нет то создаём её
            user = select_user(db_connect, 'username')