---

import pymysql
from pymysql.cursors import DictCursor


class QwerSql:
    def __init__(self):
        try:
            self.conn = pymysql.connect(
            host='kiribeh6.beget.tech',
            user='kiribeh6_databas',
            password='Vikun548',
            database='kiribeh6_databas',
            cursorclass=DictCursor
            )
            print('Ok')
            self.cursor = self.conn.cursor()
        except Exception as e:
            print('no')
            print(repr(e))

    def auth(self, login, password):
        sql = "SELECT * FROM users WHERE login=%s AND passw=%s"
        self.cursor.execute(sql, (login, password))
        return self.cursor.fetchone()

    def show_meters(self):
        sql = "SELECT * FROM users"
        self.cursor.execute(sql)
        return self.cursor.fetchall()