Project

General

Profile

Actions

Feature #8963

open

Setting values in a store: flexible way

Added by Carsten Rose over 4 years ago. Updated almost 3 years ago.

Status:
Priorize
Priority:
Normal
Assignee:
Carsten Rose
Target version:
Start date:
29.08.2019
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
Vote:

Description

https://qfq.io/doc/Manual.html#database-index

Mitunter waere es gut wenn man Werte direkt in einen Store schreiben koennte.

Form / FormElement

Idee fuer das Parameter Feld. key1 & key2 sind anschliessend im V-Store.

# Setzen
V:key1=value1
V:key2=value2

# Abruf
sqlAfter = SELECT ... WHERE {{key2:V}}...

Evtl. koennten weitere Stores moeglich sein - aber bringt das einen Vorteil?

Report

Idee 1 fuer Report (aber auch in Queries die in Form/FormElement gefeuert werden):

{{V:key3=value3}}
  • Das wuerde interpretiert werden an allen Stellen an denen Variablen ersetzt werden.
  • Ob das Parser einfach angepasst werden kann ist nicht klar.
  • Problem: erkennt der User das '{{V:key3=value3}}' keinen Wert liefert!

Idee 2: Eine Moeglichkeit waere die FormNotation zu verwenden und dann ein neues Keyword einzufuehren:

# Setzen
10.var = key4=value4, key5='value5'
10.svar = key6=value6, key7='value7'
10.altvar = key8=value8, key9='value9'

  • Das wuerde dann vor allem anderen ausgefuehrt.
  • Es erzeugt keine Ausgabe.

Related issues

Related to QFQ - Feature #8975: Report Notation: 2.0 - `10.sql` wird ersetzt durch `<name>.sql` resp `<name> { ...` - Merge RequestClosedCarsten Rose30.08.2019

Actions
Actions #1

Updated by Carsten Rose over 4 years ago

  • Description updated (diff)
  • Priority changed from Normal to High
Actions #2

Updated by Carsten Rose over 4 years ago

  • Description updated (diff)
Actions #3

Updated by Carsten Rose over 4 years ago

  • Description updated (diff)
Actions #4

Updated by Benjamin Baer over 4 years ago

Idee Benj:

Form.parameter, FormElement.parameter: $key1 = value1 $key2:V = value2 $key3:U = value3 Nicht geplant: $key4:UV = value4 Report: # Variabeln deklarien $key1 = value1 $key2 = {{SELECT name FROM Person WHERE id=1}} $key3:U = userValue1 ... 10 { sql = SELECT id AS _key1 WHERE .... } 20 { sql = SELECT {{key1:RV}} } 30 { sql = SELECT key2 FROM databaseTable /// key2:R = 123 } 40 { sql = SELECT {{key2:RV}} //// Ausgabe: 123 }
Actions #5

Updated by Carsten Rose over 4 years ago

  • Related to Feature #8975: Report Notation: 2.0 - `10.sql` wird ersetzt durch `<name>.sql` resp `<name> { ...` - Merge Request added
Actions #6

Updated by Carsten Rose over 4 years ago

  • Status changed from New to Some day maybe
Actions #7

Updated by Carsten Rose over 4 years ago

  • Status changed from Some day maybe to New
Actions #8

Updated by Carsten Rose about 4 years ago

  • Assignee set to Carsten Rose
Actions #9

Updated by Carsten Rose about 4 years ago

  • Target version changed from 146 to 55
Actions #10

Updated by Carsten Rose about 4 years ago

  • Target version changed from 55 to next7
Actions #11

Updated by Carsten Rose almost 3 years ago

  • Target version changed from next7 to next4
Actions #12

Updated by Carsten Rose almost 3 years ago

  • Target version changed from next4 to next3
Actions #13

Updated by Carsten Rose almost 3 years ago

  • Priority changed from High to Normal
Actions #14

Updated by Carsten Rose almost 3 years ago

  • Status changed from New to Priorize
Actions

Also available in: Atom PDF