Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
|
start:neo4j:lv_parsing [2018/11/14 09:18] domenge |
start:neo4j:lv_parsing [2018/11/14 09:56] (Version actuelle) domenge [Requèsta per sortir los mots voids (stopwords) de la tièra] |
||
|---|---|---|---|
| Ligne 12: | Ligne 12: | ||
| ON MATCH SET r.count = r.count + 1; | ON MATCH SET r.count = r.count + 1; | ||
| </code> | </code> | ||
| - | ===== Requèsta per sortir los mots voids de la tièra ===== | + | ===== Requèsta per sortir los mots voids (stopwords) de la tièra ===== |
| <code sql> | <code sql> | ||
| MATCH (p)-[:HAS_CATEGORY]-> (:Category{name:'lo temps que passa'}) WITH split(tolower(p.name), " ") AS words WITH [w IN words WHERE NOT w IN ["de","a","lo","la","un","una"]] AS text RETURN text; | MATCH (p)-[:HAS_CATEGORY]-> (:Category{name:'lo temps que passa'}) WITH split(tolower(p.name), " ") AS words WITH [w IN words WHERE NOT w IN ["de","a","lo","la","un","una"]] AS text RETURN text; | ||
| - | </code> | + | |
| - | <code> | + | |
| MATCH (s:Stopword) return COLLECT(s.word) | MATCH (s:Stopword) return COLLECT(s.word) | ||
| - | </code> | + | |
| - | <code sql> | + | |
| MATCH (s:Stopword) WITH COLLECT(s.word) AS stopwords RETURN stopwords | MATCH (s:Stopword) WITH COLLECT(s.word) AS stopwords RETURN stopwords | ||
| </code> | </code> | ||
| Ligne 40: | Ligne 38: | ||
| ON MATCH SET r.count = r.count + 1; | ON MATCH SET r.count = r.count + 1; | ||
| </code> | </code> | ||
| + | ===== L'escript entièr ===== | ||
| <file sql> | <file sql> | ||
| /** | /** | ||
