#   Copyright 2021 Modelyst LLC
#
#   Licensed under the Apache License, Version 2.0 (the "License");
#   you may not use this file except in compliance with the License.
#   You may obtain a copy of the License at
#
#       http://www.apache.org/licenses/LICENSE-2.0
#
#   Unless required by applicable law or agreed to in writing, software
#   distributed under the License is distributed on an "AS IS" BASIS,
#   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#   See the License for the specific language governing permissions and
#   limitations under the License.

from datetime import datetime
from typing import Optional

from sqlmodel import Field, Session, SQLModel, create_engine, func, select


class Item(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    created: datetime
    deleted: bool = False
    category: str
    version: float = 1
    data: str


# Create and save records to show that the query itself is working.
item_1 = Item(created=datetime.now(), category="category_1", data="❤️ I love SQLModel.")
item_2 = Item(
    created=datetime.now(),
    category="category_1",
    data="❤️ I love FastAPI.",
    deleted=True,
)
item_3 = Item(
    created=datetime.now(),
    category="category_2",
    data="🥰 I appreciate your work on all of it!",
)

engine = create_engine("sqlite://")

SQLModel.metadata.create_all(engine)

with Session(engine) as session:
    session.add(item_1)
    session.add(item_2)
    session.add(item_3)
    session.commit()

    # This "statement" is where the issue presents itself in PyCharm
    statement = (
        select(
            Item.category,
            func.count(Item.id).label("my_count"),
            func.total(Item.deleted).label("delete_count"),
            func.min(Item.created).label("oldest_timestamp"),
            func.max(Item.created).label("newest_timestamp"),
            func.group_concat(Item.version).label("version_list"),
        )
        .distinct()
        .group_by(Item.category)
    )
    category_metadata = session.exec(statement)
    for result in category_metadata:
        print(dict(result))

sqlmodel.func.min sqlmodel.SQLModel.metadata.create_all sqlmodel.func.total datetime.datetime.now sqlmodel.func.group_concat sqlmodel.Session sqlmodel.Field sqlmodel.func.count sqlmodel.func.max sqlmodel.create_engine
[((1345, 1371), 'sqlmodel.create_engine', 'create_engine', (['"""sqlite://"""'], {}), "('sqlite://')\n", (1358, 1371), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1373, 1409), 'sqlmodel.SQLModel.metadata.create_all', 'SQLModel.metadata.create_all', (['engine'], {}), '(engine)\n', (1401, 1409), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((791, 828), 'sqlmodel.Field', 'Field', ([], {'default': 'None', 'primary_key': '(True)'}), '(default=None, primary_key=True)\n', (796, 828), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1416, 1431), 'sqlmodel.Session', 'Session', (['engine'], {}), '(engine)\n', (1423, 1431), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1024, 1038), 'datetime.datetime.now', 'datetime.now', ([], {}), '()\n', (1036, 1038), False, 'from datetime import datetime\n'), ((1118, 1132), 'datetime.datetime.now', 'datetime.now', ([], {}), '()\n', (1130, 1132), False, 'from datetime import datetime\n'), ((1239, 1253), 'datetime.datetime.now', 'datetime.now', ([], {}), '()\n', (1251, 1253), False, 'from datetime import datetime\n'), ((1680, 1699), 'sqlmodel.func.count', 'func.count', (['Item.id'], {}), '(Item.id)\n', (1690, 1699), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1731, 1755), 'sqlmodel.func.total', 'func.total', (['Item.deleted'], {}), '(Item.deleted)\n', (1741, 1755), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1791, 1813), 'sqlmodel.func.min', 'func.min', (['Item.created'], {}), '(Item.created)\n', (1799, 1813), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1853, 1875), 'sqlmodel.func.max', 'func.max', (['Item.created'], {}), '(Item.created)\n', (1861, 1875), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n'), ((1915, 1946), 'sqlmodel.func.group_concat', 'func.group_concat', (['Item.version'], {}), '(Item.version)\n', (1932, 1946), False, 'from sqlmodel import Field, Session, SQLModel, create_engine, func, select\n')]