AI-Written Python: When an Empty Batch Passes Every Check
Python’s all() returns true on an empty batch. Learn how to distinguish ‘nothing to check’ from ‘ready’ in an AI-written workflow.
Tag: Practical AI
AI-Written SQL: Why Two Orders Can Share a Running Total
Tied timestamps can give two orders the same running total. Test whether your report needs a total through each timestamp or a separate step after each order.
AI-Written Python: A Default List Can Remember the Previous Call
A default list can retain items across Python function calls. Test consecutive jobs, create fresh containers deliberately and agree what happens to supplied lists.
AI-Written SQL: A WHERE Filter Can Undo Your LEFT JOIN
A LEFT JOIN can retain unmatched customers, then a WHERE filter can remove them. Three tested queries show why customers with pending orders need their own review case.
AI-Written Python: A Boolean Can Pass an Integer Check
Python can accept True in an integer check. Define what a quantity field permits, test nearby invalid values and preserve the distinction between decoding and validation.
AI CSV Imports: An Invisible Signature Can Change a Column Name
A CSV column can look correct while Python reads a hidden character into its name. A tested UTF-8 example shows how to inspect the headings and handle an optional BOM without blanket text cleaning.
AI-Written Python: The Text “False” Can Still Switch a Flag On
A text flag can say false while Python treats it as true. Follow a catalogue import to see how explicit rules and rejection tests keep AI-written scripts aligned with the intended selection.
AI-Written Python: A Copied List Can Still Share Records
A new list can still share product dictionaries and nested tags with its source. Tested Python examples show how to check whether a working copy is independent.
AI-Written Python: Remove the Exact Prefix, Preserve the Reference
Python’s strip methods remove sets of characters, which can damage references. Define exact prefix or suffix removal and test the values that expose the difference.
AI-Written Python: Check Both Lists Before Pairing Records
Python’s zip() can quietly omit unmatched entries. Use explicit length checks, then verify that each value belongs to the right record.