sql.py - master - kkko-ssw/dfdr

sql.py
68 строк2 KB
kkko-ssw
create: sql.py, admin.py
27 май 2026, 03:29
27 май 2026, 03:29cd2cf93
from dotenv import load_dotenv
import pymysql
from pymysql.cursors import DictCursor
import os
load_dotenv()

class DB:
    def __init__(self):
        self.conn = pymysql.connect(
            host=os.getenv('DB_HOST'),
            database=os.getenv('DB_NAME'),
            user=os.getenv('DB_USER'),
            password=os.getenv('DB_PASSWORD'),
            cursorclass=DictCursor
        )

        self.cursor = self.conn.cursor(DictCursor)

    def all_user(self, login, password):
        self.cursor.execute("select * from users where login=%s and password=%s", (login, password))
        info = self.cursor.fetchone()
        return info

    def all_product(self, offset):
        self.cursor.execute("select p.id, p.image, p.name, p.brand, p.category, p.size, p.color, p.price, p.discount, s.quantity from products as p join stock s on s.product_id = p.id Limit 3 offset %s", (offset, ))
        data = self.cursor.fetchall()
        return data

    def extra_opt_admin(self, sort = None, sort_ord='ASC', filter_by=None, search=None):
        query = "select p.image, p.name, p.brand, p.category, p.size, p.color, p.price, p.discount, s.quantity from products as p join stock s on s.product_id = p.id"
        param = []
        where_clauses = []

        if filter_by and filter_by != 'Все типы':
            where_clauses.append('p.category = %s')
            param.append(filter_by)

        if search and search.strip():
            where_clauses.append('p.name LIKE %s')
            param.append(f'%{search}%')

        if where_clauses:
            query += ' WHERE ' + ' AND '.join(where_clauses)

        if sort == 'Цена':
            query += f' ORDER BY p.price {sort_ord}'
        elif sort == 'Название':
            query += f' ORDER BY p.name {sort_ord}'

        self.cursor.execute(query, param)
        return self.cursor.fetchall()

from PyQt6.QtWidgets import *
from PyQt6.QtCore import *
from PyQt6.QtGui import *
import sys
import auth

if __name__ == '__main__':
    app = QApplication(sys.argv)
    window = auth.Auth()
    window.show()
    sys.exit(app.exec())

DB_HOST=localhost
DB_USER=vhrt
DB_PASSWORD=pPU93lT3blHya9ja
DB_NAME=shoe_warehouse