#handle database shit
#User: piggqjvl_stephanie
#Database: piggqjvl_newswebsite
import mysql.connector

class DatbaseHandler:
    
    def __init__(self):
        self.connection = None
        self.cursor = None
        
    def connect(self):
        self.connection = mysql.connector.connect(
            host = localhost,
            user = "piggqjvl_stephanie",
            password = "m3y4g5nui1{)wKsS",
            database = "piggqjvl_newswebsite"
        )
        
        self.cursor = self.connection.cursor()
        
    def getCursor(self):
        return self.cursor
        
    def disconnect(self):
        self.cursor.close()
        self.connection.close()
        
    def insertItem(self, item):
        #validate item
        if len(item.getTitle()) > 0 and len(item.getURL()) > 10 and len(item.getDisplayURL()) > 10 and item.getTimestamp > 0:
            sql = "INSERT INTO items (title,url,publication,timestamp) VALUES (%s,%s,%s,%s)"
            values = (item.getTitle(), item.getURL(), item.getDisplayURL(), item.getTimestamp())
            
            self.cursor.exectute(sql,values)