def insertDatabaseTable():
"""This function creates a Table that will hold the media in the database."""
try:
    with dbConnection.cursor() as cursor:
        # Create a new record
        sql = ("CREATE TABLE `media` (`id` int(11) NOT NULL AUTO_INCREMENT,\n"
               "            `name` varchar(255) COLLATE utf8_bin NOT NULL,\n"
               "            `platform` varchar(255) COLLATE utf8_bin NOT NULL,\n"
               "            `dateAdded` date NOT NULL,\n"
               "            `type` varchar(255),\n"
               "            PRIMARY KEY (`id`)\n"
               "            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin\n"
               "            AUTO_INCREMENT=1 ;")
        cursor.execute(sql)

    # connection is not autocommit by default. So you must commit to save
    # your changes.
    dbConnection.commit()
except:
    print("Couldn't connect to database to create the table.")

def enterMusic(tpe):
    name = input('Name of the music: ')
    platform = input('Platform of the music: ')
    a = mediatypes.music.Music(name, platform, tpe, dateAdded())
    music = {a: tpe}
    media.append(music)
    enterMediaToDB(a, tpe)


def enterMediaToDB(mediaObj, tpe):
    if dbConnection:
        try:
            with dbConnection.cursor() as cursor:
                sql = 'insert into media (name, platform, dateAdded, type) values ("{}", "{}", "{}", "{}");'.format(mediaObj.name, mediaObj.platform, mediaObj.dateAdded, tpe)
                print(sql)
                cursor.execute(sql)
            dbConnection.commit()
        except:
            print("Couldn't write to database.")
        try:
            # Execute SQL
            print("Execute")
        except:
            print("Cannot write to database.")
            return

/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pymysql/cursors.py:329: Warning: (1292, "Incorrect date value: '2019/04/29:12:28:18' for column 'dateAdded' at row 1")
self._do_get_result()