3fe43d1fc0
Fix quantity ordered scope for SQLite: use pathname column instead of recursive CTE
...
SQLite's Arel visitor wraps CTE branches in extra parentheses, making
the UNION ALL inside recursive CTEs invalid. Also SQLite lacks LPAD()
and CAST(... AS BINARY). Fix by using the existing pathname column for
ordering on SQLite, which already encodes the hierarchical path.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com >
2026-03-10 18:41:03 +00:00
bd1a664caa
Measurement form based on select-styled <details>
2026-01-31 17:22:09 +01:00
e12369cea1
Measurements#new form improvements
2025-05-13 22:30:58 +02:00
ef3484dfdf
Update Measurements#new form pathnames on actions
2025-05-07 00:24:05 +02:00
e8a0768d97
Update Quantity.depth using WITH + UPDATE ALL
2025-04-25 14:25:13 +02:00
d1593df0e0
Use callbacks instead of attribute methods to update cached values
2025-04-24 18:59:36 +02:00
fe66522c21
Cached attribute definition (attr_cached)
2025-04-19 20:29:29 +02:00
1cddc794d2
Cleanup Quantity :pathname related code
2025-03-23 13:11:14 +01:00
3b30e58ff3
Persist Quantity :pathname
2025-03-23 12:56:57 +01:00
8401424efa
Partial refresh of Measurements#new form
2025-02-18 18:27:47 +01:00
c48bf290fd
Implement Measurements#new
2025-02-18 11:25:32 +01:00
6300273186
Cleanup
2025-01-16 21:37:58 +01:00
7962cdf169
Simplify object and association checks
...
* check for <object> instead of <object>.nil?
* check for <association>_id? instead of <association>.nil? (avoids
record loading)
2025-01-16 20:42:18 +01:00
c908063212
Persist Quantity :depth instead of computing it on the fly
2025-01-16 17:14:52 +01:00
30686dd1fc
Cleanup of hierarchy related methods
2025-01-16 03:24:43 +01:00
2c0ae1530a
Turn #ancestors into #with_ancestors scope
2025-01-14 23:27:32 +01:00
27038a74d0
Return Quantity progenies as a result of partial ordering
...
Separate scope only provided some optimisation by reducing the count of
records :numbered and should be unnecessary in future once numbering
can be merged with ordering into one recursive query
2025-01-14 23:25:26 +01:00
8524beefdc
Allow to drag all Quantities
2025-01-14 15:03:25 +01:00
644d1f4b9a
Add Quantity #reparent action
2025-01-14 15:02:38 +01:00
4b453c1a82
Add :progenies as a scope to list ordered descendants of Quantity
2025-01-14 01:01:06 +01:00
0652d4a89b
Disallow self- and descendant-reference for base/parent
2025-01-12 19:15:43 +01:00
17b4e4f8a7
Don't duplicate ancestors search in #successive
2025-01-12 18:11:37 +01:00
421515e5ce
ancestors() sets depth for self, instead of returning new instance
2025-01-12 18:09:34 +01:00
d5e7ccacf5
Add Quantity #edit and #update
2025-01-11 22:51:49 +01:00
b6acb30785
Make Quantity name unique among siblings
...
Remove Quantity domain - will be replaced by configurable per-domain
root Quantity, limiting selection to descendants only
2025-01-11 21:50:36 +01:00
57f10c94a4
Add Quantity #new, #create, #destroy actions
2025-01-11 17:01:34 +01:00
1e7ef75e8b
Include self and ancestors in result
2025-01-09 15:59:18 +01:00
c7f16514d2
Re-format query
2025-01-09 15:58:21 +01:00
9461c1f979
Update #successive for unlimited depth hierarchy
2025-01-08 14:29:49 +01:00
fa7918f0e3
Set row indentation based on depth
2025-01-08 13:55:40 +01:00
0d8e7c6c0e
Unlimited depth hierarchy ordering
2025-01-08 02:18:38 +01:00
aa862f0e90
Quantities index WIP
2025-01-05 20:47:49 +01:00
