Add SQL template for Python v2

[lucyzhang929]

Add template here: https://github.com/Azure/azure-functions-templates/tree/dev/Functions.Templates/Templates-v2

[LouisDeconinck]

Is it possible to add multiple rows to the database in one go?

[lucyzhang929]

Yes, in Python you can use SqlRowList to add multiple rows. See this sample:

azure-functions-sql-extension/samples/samples-python/AddProductsArray/__init__.py

Line 16 in 3a59712

rows = func.SqlRowList(map(lambda r: func.SqlRow.from_dict(r), body))

[lucyzhang929]

@LouisDeconinck, this seems like a functions error, not specific to SQL Bindings. Could you file an issue in the Azure Functions Host repository?

[LouisDeconinck]

@lucyzhang929 I'm running into another issue. Getting the following error:
Database on server is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '{C16638E0-26B4-4AB7-B831-19F334051195}'.

Is there anyway how I can detect that the database will not be available and retry writing another time?

I have the following code, but this doesn't work as I believe that the .set() happens asynchronously after the function has already ended.

        max_retries = 10
        retries = 0

        while retries < max_retries:
            try:
                r.set(rows_sql)
                
                total_time = time.time() - start_time

                logging.info(f"End of scraping. Scraped {len(rows)} groups in {total_time}.")
                break

            except Exception as e:
                logging.error(f"An error occurred: {str(e)}")
                retries += 1
                if retries < max_retries:
                    logging.info(f"Retrying after 30 seconds... (retry {retries}/{max_retries})")
                    time.sleep(30)
                else:
                    logging.error(f"An error occurred: {str(e)}")

[lucyzhang929]

@LouisDeconinck Can you create a separate issue for your question please? https://github.com/Azure/azure-functions-sql-extension/issues/new/choose Thank you!