tree 7f14c84de437e6ed2022eab3f061266b79acd60e
parent d6078aa911a135ab7bfd99c3246c44f992225ce8
author Conor <cpdeethree@users.noreply.github.com> 1655465487 -0500
committer GitHub <noreply@github.com> 1655465487 +0530
gpgsig -----BEGIN PGP SIGNATURE-----
 
 wsBcBAABCAAQBQJirGYPCRBK7hj4Ov3rIwAAMaoIAAmJUZH+xCh1LHvkOwU3vYt4
 iZvxkYuZheTI3nORMDTETEvRJaG9T/BlOjKVZv7WKB6FaKsja7etLV/Xbvt4pi+0
 x2ADj41c1zRYPNwYGDLG/i0KnS0qmVv9qQDs7FvmA/1WJiiBDOI5Y566nlmHws8k
 P7aj7xHx4ERYRSvKKmpUzj268WDjje1boJWtbCZId9pOcq2KXHs3FxGUfzbXVtT3
 JJQ9blnfHzNkpgRSPqi1RzpDHGTsNDkV0jjDrTQDLLhY9HJjodb7FLpk/67Bk6Az
 mqWe1xSYEA7C0NIdNL5Bq+MT8vlxHFtdPrwdhnvzNv67KUQVmahmhzhznCAAhDI=
 =9UO1
 -----END PGP SIGNATURE-----
 

refactor: DB independent quoting and truthy/falsy values (#31358)

* refactor: DB independent quoting and truthy/falsy values

* style: reformat to black spec

* fix: ifnull -> coalesce

* fix: coalesce -> Coalesce

* fix: revert pypika comparison

* refactor: convert queries to QB

* fix: incorrect value types for query

`=` query makes no sense with list of values

* fix: remove warehouse docstatus condition

* fix: keep using base rate as rate

Co-authored-by: Ankush Menat <ankush@frappe.io>