CITIES


import mysql.connector

class Rifa:

    def __init__(self) -> None:
        self.cnn = mysql.connector.connect(
            host = 'localhost',
            user = 'root',
            password = '',
            database = 'inacaprifa')

    def __str__(self) -> str:
        datos = self.consulta_numeros()
        aux = ''
        for columna in datos:
            aux += str(columna) + '\n'
        return aux

    def insertar_datos(self, NombreRifa, CantNumeros, ValorNumero, Premio):
        cur = self.cnn.cursor()
        sql = f'''INSERT INTO countries (NombreRifa, CantNumeros, ValorNumero, Premio)
        VALUES ('{NombreRifa}', '{CantNumeros}', '{ValorNumero}', '{Premio}')'''
        cur.execute(sql)
        n = cur.rowcount
        self.cnn.commit()
        cur.close()
        return n

    def consulta_numeros(self):
        cur = self.cnn.cursor()
        cur.execute('SELECT * FROM CantNumeros')
        datos = cur.fetchall()
        cur.close()
        return datos

    def modificar_ciudad(self, id, ISO3, CountryName, capital, currenyCode):
        cur = self.cnn.cursor()
        sql = F'''UPDATE countries SET
        ISO3 = '{ISO3}', CountryName = '{CountryName}', capital = '{capital}', currencyCode = '{currenyCode}'
        WHERE id = '{id}' '''
        cur.execute(sql)
        n = cur.rowcount
        self.cnn.commit()
        cur.close()
        return n

    def eliminar_ciudad(self, id):
        cur = self.cnn.cursor()
        sql = f'DELETE FROM countries WHERE id = {id}'
        cur.execute(sql)
        n = cur.rowcount
        self.cnn.commit()
        cur.close()
        return n

    def buscar_ciudad(self,Id):
        cur = self.cnn.cursor()
        sql = f'SELECT * FROM countries WHERE id = {Id}'
        cur.execute(sql)
        n = cur.fetchome()
        cur.close
        return n