Re: What's the easiest way to create a Cloud Funct...

AndyF · 01-09-2024 02:05 AM

I have tied using gcloud CLI for setting up network and am getting lost there. I expect it must be easier than what I am trying right now. How would you create a minimalistic Python function talking to a Postgres database?

AndyF

Ah, nevermind - I've learnt how to use the connector package and it's not that bad

import json
import os

from google.cloud.sql.connector import Connector, IPTypes


def handler(request, **kwargs):
    conn = Connector().connect(
        os.environ['DB_CONNECTION'],
        "pg8000",
        user=os.environ['DB_USER'],
        password=os.environ['DB_PASSWORD'].strip(),
        db=os.environ['DB_DATABASE'],
        ip_type=IPTypes.PUBLIC,
    )
    cur = conn.cursor()
    cur.execute('SELECT tablename FROM pg_catalog.pg_tables')
    rows = cur.fetchall()
    cur.close()
    conn.close()

    return str(len(rows))

kumards

Hi @AndyF , you might find the following documentation useful:

What's the easiest way to create a Cloud Function and PostgreSQL instance?