Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· openaiHugging Face Suzhen/CodeChat

Simplify: if failed: cursor.execute('INSERT INTO awssecurityhubcontrols (arn, status,…

  1. User

    Simplify:

                if failed:
                    cursor.execute('INSERT INTO aws_securityhub_controls (arn, status, aws_account_id) \
                                    VALUES (%s, %s, %s) \
                                    ON CONFLICT (arn) \
                                    DO UPDATE SET status = "FAILED"',
                                   (control['StandardsControlArn'], 'FAILED', account))
                    conn.commit()
                else:
                    cursor.execute('INSERT INTO aws_securityhub_controls (arn, status, aws_account_id) \
                                                        VALUES (%s, %s, %s) \
                                                        ON CONFLICT (arn) \
                                                        DO UPDATE SET status = "PASSED"',
                                   (control['StandardsControlArn'], 'PASSED', account))
                    conn.commit()
    
  2. Assistant

    Simplified code:

    status = 'FAILED' if failed else 'PASSED'
    cursor.execute('INSERT INTO aws_securityhub_controls (arn, status, aws_account_id) \
                    VALUES (%s, %s, %s) \
                    ON CONFLICT (arn) \
                    DO UPDATE SET status = %s',
                   (control['StandardsControlArn'], status, account, status))
    conn.commit()
    

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.