perf: new column Posting Datetime in SLE to optimize stock ledger related queries by rohitwaghchaure [frappe] PR#39800

From: https://github.com/frappe/erpnext/pull/39800
Date: 2024-02-21 18:39:27+05:30

• Merge pull request #39800 from rohitwaghchaure/persistent-indexing
• chore: remove microsecond from posting_datetime
• test: test cases to test clash timestamp entries
• perf: new column posting datetime in SLE to optimize stock ledger related queries

---

Diagnostics

pre-commit failed for source commit: d80ca523a43e9d1073dc008ead7d140fb0811a89
flake8...................................................................Failed
- hook id: flake8
- exit code: 1

erpnext/stock/doctype/stock_ledger_entry/test_stock_ledger_entry.py:10:1: F401 'frappe.query_builder.functions.CombineDatetime' imported but unused


pre-commit failed for source commit: f04676aaed69d669e43099077c85d93fedbf7e07
flake8...................................................................Failed
- hook id: flake8
- exit code: 1

erpnext/stock/doctype/stock_ledger_entry/test_stock_ledger_entry.py:11:1: F401 'frappe.query_builder.functions.CombineDatetime' imported but unused


pre-commit failed for source commit: a73ba2c0d26b9d27bb5a75bc6c9739e49035f266
flake8...................................................................Failed
- hook id: flake8
- exit code: 1

erpnext/stock/doctype/stock_ledger_entry/test_stock_ledger_entry.py:11:1: F401 'frappe.query_builder.functions.CombineDatetime' imported but unused


pre-commit failed for source commit: 4c061d61fa9a635e8b7dec72a21d67bdbd15c900
flake8...................................................................Failed
- hook id: flake8
- exit code: 1

erpnext/stock/doctype/purchase_receipt/test_purchase_receipt.py:2420:14: F821 undefined name 'item'
erpnext/stock/doctype/purchase_receipt/test_purchase_receipt.py:2432:19: F821 undefined name 'item'
erpnext/stock/doctype/purchase_receipt/test_purchase_receipt.py:2460:14: F821 undefined name 'item'
erpnext/stock/doctype/purchase_receipt/test_purchase_receipt.py:2472:19: F821 undefined name 'item'


Suspicious merge commit detected: 4c061d61fa9a635e8b7dec72a21d67bdbd15c900

---

Checkout instructions

# Checkout locally
git fetch upstream
git switch ft-pr-39800

# Make changes then rebase
git rebase -i upstream/develop --reapply-cherry-picks

# Fix or ignore conflicts
git checkout --theirs .
git rebase --continue

# Force-push changes
git push --force-with-lease