How do I add logging errors in my lambda function?

Asked Jan 26 '23 at 22:15

Active Jan 27 '23 at 08:30

Viewed 59 times

I added a few, I'm not sure if any more would be useful. Also, is this all I have to do to write a lambda? I was given very little instruction on how to do it. It returns the result from the query like it's supposed to. I don't see anything wrong with it except for adding some logging exceptions?

import logging
import os
import sys
import mariadb as mdb

cnxn = mdb.connect(
user="username",
password="pass",
host="host",
port=port,
database="database"
)

cur=cnxn.cursor()
SQL_QUERY="CALL STORED_PROCEDURE();"
cur.execute(SQL_QUERY)
row=cur.fetchone()

def name_of_handler(event=None, context=None):
    try:
        cur.execute(SQL_QUERY)
        cnxn.commit()
    except mdb.Error as e:
        print(f"Error: {e}")
    except Exception as e:
        logging.exception(e)

    print(row)
    cnxn.close()

name_of_handler()

UPDATE: Nevermind, how do I write a message saying "executed successfully?" I see the records did insert into the database, but there is no confirmation in the python code.

edited Jan 27 '23 at 08:30

ljmc

4,830
2
7
26

asked Jan 26 '23 at 22:15

stackoverflowme

Where in your code do you have a `lambda`? – Matiiss Jan 26 '23 at 22:15
the function is the lambda function. it's the "name_of_handler", which is the lambda handler – stackoverflowme Jan 26 '23 at 22:24
That's not a `lambda`, that's just a regular function. – Matiiss Jan 26 '23 at 22:26
Not a lambda... – Luca Angioloni Jan 26 '23 at 22:28
oh! how do i make it a lambda? – stackoverflowme Jan 26 '23 at 22:37
Why do you want to make it a `lambda`? It's fine as it is – Matiiss Jan 26 '23 at 22:45
because i need to run my lambda function on a scheduler? im not sure if i can do that with a regular function...im using AWS lambda for this. i think i need to read up more on it – stackoverflowme Jan 26 '23 at 22:48
Stored procedures should be executed with cursors callproc() method instead of execute(). – Georg Richter Jan 27 '23 at 04:37
Does this answer your question? [Using python Logging with AWS Lambda](https://stackoverflow.com/questions/37703609/using-python-logging-with-aws-lambda) – ljmc Jan 27 '23 at 08:31

How do I add logging errors in my lambda function?

0 Answers0