pgdml.py Part 5

pgdml_.py

def select_photos():

    # Wildcards:
    # percent sign % for 0 or more characters
    # underscore _ for exactly 1 character
    select_dict = {"where_like": '%Oslo%'}

    try:

        conn = pgconnection.get_connection("codeinpython")
        cursor = conn.cursor()

        # To make LIKE case insensitive use ILIKE
        cursor.execute("SELECT galleryid, title, description, photographer, datetaken FROM photos WHERE description LIKE %(where_like)s;", select_dict)

        # get a list of tuples containing the data
        data = cursor.fetchall()

        cursor.close()
        conn.close()

        for row in data:

            print(row)

    except psycopg2.Error as e:

        print(type(e))

        print(e)


def select_galleriesphotos():

    try:

        conn = pgconnection.get_connection("codeinpython")
        cursor = conn.cursor()

        cursor.execute("SELECT galleryname, gallerydescription, phototitle, photodescription FROM galleriesphotos")

        # get a list of tuples containing the data
        data = cursor.fetchall()

        cursor.close()
        conn.close()

        for row in data:

            print(row)

    except psycopg2.Error as e:

        print(type(e))

        print(e)