suchbar 0.5.0

suchbar - enduser-learnable-language for database queries.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75

# SuchBar - Such-Abfragesprache

Eine von Otto-Normal-Anwendern erlernbare Abfragesprache ähnlich einer Internet-Suchmaschine.   

Aus einer Anfrage "`plz=26440-26452 OR (Eisen AND sn!=Hammecke*)`" wird eine SQL Abfrage erstellt:

```sql
SELECT 
    pa.shortname, pa.description, pa.taxnumber, pb.longname, pb.postcode, pb.city, pb.street 
FROM partner_partner pa, partner_branchstore pb 
WHERE pa.id = pb.cmrpartner AND 
  (
    ( pb.postcode>='26440' 
          AND pb.postcode<='26452' 
    ) OR
    ( pa.shortname LIKE '%Eisen%' 
            OR pa.description LIKE '%Eisen%' 
            OR pa.taxnumber LIKE '%Eisen%' 
            OR pb.city LIKE '%Eisen%' 
            OR pb.street LIKE '%Eisen%' 
    ) AND 
    NOT pa.shortname LIKE 'Hammecke%' 
 )
LIMIT 20;
```

| Boolean Operator |Alternative Symbol	 | Description                                                                         |
|:----------------:|:------------------:|:---------------------------------------------------------------------------------------|
|       AND        |         &&         | 	Requires both terms on either side of the Boolean operator to be present for a match. |
|       NOT        |         !	         | Requires that the following term not be present.                                       |
|       OR         |    &vert;&vert;    | 	Requires that either term (or both terms) be present for a match.                     |


## Programmierung: 


### Anmeldung der Felder

Die zur Suche zur Verfügung stehenden Felder werden angemeldet: 
`DbField::new("datenbankfeld", Datentyp, "Berechtigung", &["name", "alternative_name", "abk"]),`   


## Beispiel

```rust 
const SUCHBAR: Suchbar = Suchbar::new(&[
    DbField::new("pa.shortname", TEXT, "STD", &["sname", "sn"]),
    DbField::new("pa.description", TEXT, "STD", &["desc", "d"]),
    DbField::new(
        "pa.taxnumber",
        VARCHAR(15),
        "STD",
        &["ust_id", "tax", "ustid"],
    ),
    DbField::new("pb.city", VARCHAR(35), "STD", &["city"]),
    DbField::new("pb.street", VARCHAR(55), "STD", &["street", "st"]),
    DbField::new("pb.postcode", VARCHAR(5), "STD", &["plz", "zip"]),
]);

fn main() {
    let suche = "plz=26440-26452 OR (Eisen AND sn!=Hammecke*)";
    match SUCHBAR.exec(suche) {
        Err(c) => println!("\n{c}"),
        Ok(sr) => {
        let query = format ! (
        "SELECT pa.shortname, pa.description, pa.taxnumber, \
                pb.longname, pb.postcode AS INTEGER, pb.city, pb.street \
                FROM partner_partner pa, partner_branchstore pb \
                WHERE pa.id = pb.cmrpartner{} LIMIT 20",
        sr.to_sql("AND")
        );
    }
    }
}
```