Python Obstacles | Kapap | Wiki Scraped Content [Column Nulling]

[BrandonKastning]

Solved!

Thank you to ndc85430 who linked me to PyMySQL on my other thread: Krav Maga: https://python-forum.io/thread-35939-pos...#pid151485

It worked great for sending the MariaDB CLI Command directly through Python! SQL Alchemy was not the best solution it proved!

I entered values into row 1, 2 and 3 as Alpha!


whats my screen size

Here is the working Python Script: Kapap

# Finalized on Python-Forum.io
# Disabled American Constitutional Pre-Law Student: BrandonKastning
# Date: 01/02/2021
# Script: kapap_WTPO_AK.py
# Purpose: Building Block for Python 3.9.9 + MariaDB 10.4.22
# Thread URL with Sources of Learning (Cited on Board)
# Thread URL : https://python-forum.io/thread-35958-post-151561.html
# Kapap
# DB: Eggnest
# Table: WTPO_Dirty_Wiki_Counties_AK
# Purpose: Null All Entries (Rows) within a Column using Python rather than MariaDB CLI

import pymysql.cursors

# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='brandon',
                             password='password',
                             database='Eggnest',
                             cursorclass=pymysql.cursors.DictCursor)

with connection:
    with connection.cursor() as cursor:
        sql = "UPDATE WTPO_Dirty_Wiki_Counties_AK SET american_county_name = NULL;"
        cursor.execute(sql)

brandon@FireDragon:~/Python/05_Kapap$ python3 kapap_WTPO_AK.py

Solution Worked:



Thank you everyone for this forum!

Best Regards,

Brandon Kastning