import mysql.connector

class DB_conn:
    def __init__(self, host, user, password, database):
        self.mydb = mysql.connector.connect(
            host="127.0.0.1",
            user="basart",
            passwd="megusta",
            database="socialNetwork"
        )
        self.cursor = self.mydb.cursor()
        self.host = host
        self.user = user
        self.password = password
        self.dbname = database

    def get_conn(self):
        if self.mydb:
            print('Connected succesfull')
        return self.mydb

    def select_curs(self, sql):
        self.cursor.execute(sql)
        for x in self.cursor:
            print(x)
        return x

    def insert_curs(self, sql, val):
        self.cursor.execute(sql,val)
        self.mydb.commit()
        self.mydb.rollback()

connect = DB_conn("127.0.0.1", "basart", "megusta", "socialNetwork")
connect.get_conn()