问题

我有一个图，其中顶点表示城市，还有连接每个城市的边。这些边包含一个名为travelTime的属性，表示从一个城市到另一个城市所需的时间。

SELECT * FROM cypher('Saxeburg', $$
MATCH (v1)-[e]->(v2) RETURN v1.name, e.travelTime, v2.name
$$) as (from_city agtype, travel_time agtype, to_city agtype);

      from_city       | travel_time |       to_city        
----------------------+-------------+----------------------
 "Cavite Island"      | 2.5         | "Intramuros"
 "Cavite Island"      | 3           | "Fort Tilden"
 "St Germain"         | 9           | "Intramuros"
 "St Germain"         | 5.6         | "China Town"
 "Pigalle"            | 6           | "China Town"
 "Pigalle"            | 4           | "Montreal"
 "Pigalle"            | 8.5         | "NYC"
 "Montreal"           | 3           | "Quebec"
 "Fort Tilden"        | 13          | "Brooklyn"
 "Coney Island"       | 1.5         | "Brooklyn"
 "Brooklyn"           | 2.5         | "Uptown"
 "Brooklyn"           | 5           | "The Ruins"
 "Uptown"             | 5           | "Intramuros"
 "Intramuros"         | 11          | "China Town"
 "Intramuros"         | 16.5        | "Bastille"
 "China Town"         | 7.5         | "Divisoria"
 "China Town"         | 4.5         | "Ermita"
 "China Town"         | 12.5        | "NYC"
 "The Ruins"          | 4           | "Card Shark"
 "The Ruins"          | 5.5         | "Phoenix"
 "The Ruins"          | 2.5         | "Red Light"
 "Card Shark"         | 4.5         | "Phoenix"
 "Divisoria"          | 6.5         | "Bastille"
 "Ermita"             | 9           | "Puerto del Postigo"
 "NYC"                | 10.5        | "Puerto del Postigo"
 "NYC"                | 5           | "St Domingo"
 "NYC"                | 2           | "Sta Isabel"
 "Phoenix"            | 3.5         | "Red Light"
 "Phoenix"            | 10          | "Bastille"
 "Bastille"           | 6.5         | "Hotel St Paul"
 "Bastille"           | 6           | "Puerto del Postigo"
 "Puerto del Postigo" | 3           | "Sta Isabel"

我如何可以获取，例如，从Cavite Island到Bastille的总旅行时间以及到达目的地的多条路线？

英文:

I have a graph that has vertices as cities and it also has edges that connect each city. These edges contain a property called travelTime that represents the time to got from one city to another.

SELECT * FROM cypher(&#39;Saxeburg&#39;, $$
MATCH (v1)-[e]-&gt;(v2) RETURN v1.name, e.travelTime, v2.name
$$) as (from_city agtype, travel_time agtype, to_city agtype);

      from_city       | travel_time |       to_city        
----------------------+-------------+----------------------
 &quot;Cavite Island&quot;      | 2.5         | &quot;Intramuros&quot;
 &quot;Cavite Island&quot;      | 3           | &quot;Fort Tilden&quot;
 &quot;St Germain&quot;         | 9           | &quot;Intramuros&quot;
 &quot;St Germain&quot;         | 5.6         | &quot;China Town&quot;
 &quot;Pigalle&quot;            | 6           | &quot;China Town&quot;
 &quot;Pigalle&quot;            | 4           | &quot;Montreal&quot;
 &quot;Pigalle&quot;            | 8.5         | &quot;NYC&quot;
 &quot;Montreal&quot;           | 3           | &quot;Quebec&quot;
 &quot;Fort Tilden&quot;        | 13          | &quot;Brooklyn&quot;
 &quot;Coney Island&quot;       | 1.5         | &quot;Brooklyn&quot;
 &quot;Brooklyn&quot;           | 2.5         | &quot;Uptown&quot;
 &quot;Brooklyn&quot;           | 5           | &quot;The Ruins&quot;
 &quot;Uptown&quot;             | 5           | &quot;Intramuros&quot;
 &quot;Intramuros&quot;         | 11          | &quot;China Town&quot;
 &quot;Intramuros&quot;         | 16.5        | &quot;Bastille&quot;
 &quot;China Town&quot;         | 7.5         | &quot;Divisoria&quot;
 &quot;China Town&quot;         | 4.5         | &quot;Ermita&quot;
 &quot;China Town&quot;         | 12.5        | &quot;NYC&quot;
 &quot;The Ruins&quot;          | 4           | &quot;Card Shark&quot;
 &quot;The Ruins&quot;          | 5.5         | &quot;Phoenix&quot;
 &quot;The Ruins&quot;          | 2.5         | &quot;Red Light&quot;
 &quot;Card Shark&quot;         | 4.5         | &quot;Phoenix&quot;
 &quot;Divisoria&quot;          | 6.5         | &quot;Bastille&quot;
 &quot;Ermita&quot;             | 9           | &quot;Puerto del Postigo&quot;
 &quot;NYC&quot;                | 10.5        | &quot;Puerto del Postigo&quot;
 &quot;NYC&quot;                | 5           | &quot;St Domingo&quot;
 &quot;NYC&quot;                | 2           | &quot;Sta Isabel&quot;
 &quot;Phoenix&quot;            | 3.5         | &quot;Red Light&quot;
 &quot;Phoenix&quot;            | 10          | &quot;Bastille&quot;
 &quot;Bastille&quot;           | 6.5         | &quot;Hotel St Paul&quot;
 &quot;Bastille&quot;           | 6           | &quot;Puerto del Postigo&quot;
 &quot;Puerto del Postigo&quot; | 3           | &quot;Sta Isabel&quot;

How could I get, for example, the total travel time from Cavite Island to Bastille and the multiple routes it takes to get to it?

答案1

得分: 1

你可以使用以下查询：

SELECT * FROM cypher('stack75632692',$$
    MATCH path = (a {name: 'Cavite Island'})-[*]->(b {name: 'Bastille'})
    WITH path, relationships(path) AS edges
    UNWIND edges AS edge
    RETURN path, sum(edge.travelTime)
$$) as (path agtype, travelTime agtype);

结果：

| traveltime 
|------------
| [{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842626, "label": "HAS_ROUTE", "end_id": 844424930131974, "start_id": 844424930131969, "properties": {"travelTime": 3}}::edge, {"id": 844424930131974, "label": "Metro", "properties": {"name": "Fort Tilden"}}::vertex, {"id": 1125899906842633, "label": "HAS_ROUTE", "end_id": 844424930131979, "start_id": 844424930131974, "properties": {"travelTime": 13}}::edge, {"id": 844424930131979, "label": "Metro", "properties": {"name": "Brooklyn"}}::vertex, {"id": 1125899906842636, "label": "HAS_ROUTE", "end_id": 844424930131986, "start_id": 844424930131979, "properties": {"travelTime": 5}}::edge, {"id": 844424930131986, "label": "Metro", "properties": {"name": "The Ruins"}}::vertex, {"id": 1125899906842643, "label": "HAS_ROUTE", "end_id": 844424930131981, "start_id": 844424930131986, "properties": {"travelTime": 4}}::edge, {"id": 844424930131981, "label": "Metro", "properties": {"name": "Card Shark"}}::vertex, {"id": 1125899906842646, "label": "HAS_ROUTE", "end_id": 844424930131987, "start_id": 844424930131981, "properties": {"travelTime": 4.5}}::edge, {"id": 844424930131987, "label": "Metro", "properties": {"name": "Phoenix"}}::vertex, {"id": 1125899906842653, "label": "HAS_ROUTE", "end_id": 844424930131988, "start_id": 844424930131987, "properties": {"travelTime": 10}}::edge, {"id": 844424930131988, "label": "Metro", "properties": {"name": "Bastille"}}::vertex]::path | 39.5
| [{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842625, "label": "HAS_ROUTE", "end_id": 844424930131975, "start_id": 844424930131969, "properties": {"travelTime": 2.5}}::edge, {"id": 844424930131975, "label": "Metro", "properties": {"name": "Intramuros"}}::vertex, {"id": 1125899906842639, "label": "HAS_ROUTE", "end_id": 844424930131988, "start_id": 844424930131975, "properties": {"travelTime": 16.5}}::edge, {"id": 844424930131988, "label": "Metro", "properties": {"name": "Bastille"}}::vertex]::path | 19.0
| [{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842626, "label": "HAS_ROUTE", "end_id": 844424930131974, "start_id": 844424930131969, "properties": {"travelTime": 3}}::edge, {"id": 844424930131974, "label": "Metro", "properties": {"name": "Fort Tilden"}}::vertex, {"id": 1125899906842633, "label": "HAS_ROUTE", "end_id": 844424930131979, "start_id": 844424930131974, "properties": {"travelTime": 13}}::edge, {"id": 844424930131979, "label": "Metro", "properties": {"name": "Brooklyn"}}::vertex, {"id": 1125899906842635, "label": "HAS_ROUTE", "end_id": 844424930131980, "start_id": 844424930131979, "properties": {"travelTime": 2.5}}::edge, {"id": 844424930131980, "label": "Metro", "properties": {"name": "Uptown"}}::vertex, {"id": 1125899906842637, "label": "HAS_ROUTE", "end_id": 844424930131975, "start_id": 844424930131980, "properties": {"travelTime": 5}}::edge, {"id": 844424930131975, "label": "Metro", "properties": {"name": "Intramuros"}}::vertex, {"id": 1125899906842638, "label": "HAS_ROUTE", "end_id": 844424930131976, "start_id": 844424930131975, "properties": {"travelTime": 11}}::edge, {"id": 844424930131976, "label": "Metro", "properties": {"name": "China Town"}}::vertex, {"id": 1125899906842640, "label": "HAS_ROUTE", "end_id": 844424930131982, "start_id": 844424930131976, "properties": {"travelTime": 7.5}}::edge, {"id": 844424930131982, "label": "Metro", "properties": {"name": "Divisoria"}}::vertex, {"id": 1125899906842647, "label": "HAS_ROUTE", "end_id": 844424930131988, "start_id": 844424930131982, "properties": {"travelTime": 6.5}}::edge, {"id": 844424930131988, "label": "Metro", "properties": {"name": "Bastille"}}::vertex]::path | 48.5
| [{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842625, "label": "HAS_ROUTE", "end_id": 844424930131975, "start

<details>
<summary>英文:</summary>

You can use the following query

SELECT * FROM cypher('stack75632692',$$
MATCH path = (a {name: 'Cavite Island'})-[*]->(b {name: 'Bastille'})
WITH path, relationships(path) AS edges
UNWIND edges AS edge
RETURN path, sum(edge.travelTime)
$$) as (path agtype, travelTime agtype);


Result:

                                                                                                path                                                                                      
| traveltime

--------------+------------
[{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842626, "label": "HAS_ROUTE", "end_id": 844424930131974, "start_id": 8444249301
31969, "properties": {"travelTime": 3}}::edge, {"id": 844424930131974, "label": "Metro", "properties": {"name": "Fort Tilden"}}::vertex, {"id": 1125899906842633, "label": "HAS_ROUTE", "end_i
d": 844424930131979, "start_id": 844424930131974, "properties": {"travelTime": 13}}::edge, {"id": 844424930131979, "label": "Metro", "properties": {"name": "Brooklyn"}}::vertex, {"id": 11258
99906842636, "label": "HAS_ROUTE", "end_id": 844424930131986, "start_id": 844424930131979, "properties": {"travelTime": 5}}::edge, {"id": 844424930131986, "label": "Metro", "properties": {"n
ame": "The Ruins"}}::vertex, {"id": 1125899906842643, "label": "HAS_ROUTE", "end_id": 844424930131981, "start_id": 844424930131986, "properties": {"travelTime": 4}}::edge, {"id": 84442493013
1981, "label": "Metro", "properties": {"name": "Card Shark"}}::vertex, {"id": 1125899906842646, "label": "HAS_ROUTE", "end_id": 844424930131987, "start_id": 844424930131981, "properties": {"
travelTime": 4.5}}::edge, {"id": 844424930131987, "label": "Metro", "properties": {"name": "Phoenix"}}::vertex, {"id": 1125899906842653, "label": "HAS_ROUTE", "end_id": 844424930131988, "sta
rt_id": 844424930131987, "properties": {"travelTime": 10}}::edge, {"id": 844424930131988, "label": "Metro", "properties": {"name": "Bastille"}}::vertex]::path

          | 39.5

          | 19.0

[{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842626, "label": "HAS_ROUTE", "end_id": 844424930131974, "start_id": 8444249301
31969, "properties": {"travelTime": 3}}::edge, {"id": 844424930131974, "label": "Metro", "properties": {"name": "Fort Tilden"}}::vertex, {"id": 1125899906842633, "label": "HAS_ROUTE", "end_i
d": 844424930131979, "start_id": 844424930131974, "properties": {"travelTime": 13}}::edge, {"id": 844424930131979, "label": "Metro", "properties": {"name": "Brooklyn"}}::vertex, {"id": 11258
99906842635, "label": "HAS_ROUTE", "end_id": 844424930131980, "start_id": 844424930131979, "properties": {"travelTime": 2.5}}::edge, {"id": 844424930131980, "label": "Metro", "properties": {
"name": "Uptown"}}::vertex, {"id": 1125899906842637, "label": "HAS_ROUTE", "end_id": 844424930131975, "start_id": 844424930131980, "properties": {"travelTime": 5}}::edge, {"id": 844424930131
975, "label": "Metro", "properties": {"name": "Intramuros"}}::vertex, {"id": 1125899906842638, "label": "HAS_ROUTE", "end_id": 844424930131976, "start_id": 844424930131975, "properties": {"t
ravelTime": 11}}::edge, {"id": 844424930131976, "label": "Metro", "properties": {"name": "China Town"}}::vertex, {"id": 1125899906842640, "label": "HAS_ROUTE", "end_id": 844424930131982, "st
art_id": 844424930131976, "properties": {"travelTime": 7.5}}::edge, {"id": 844424930131982, "label": "Metro", "properties": {"name": "Divisoria"}}::vertex, {"id": 1125899906842647, "label":
"HAS_ROUTE", "end_id": 844424930131988, "start_id": 844424930131982, "properties": {"travelTime": 6.5}}::edge, {"id": 844424930131988, "label": "Metro", "properties": {"name": "Bastille"}}::
vertex]::path | 48.5
[{"id": 844424930131969, "label": "Metro", "properties": {"name": "Cavite Island"}}::vertex, {"id": 1125899906842625, "label": "HAS_ROUTE", "end_id": 844424930131975, "start_id": 8444249301
31969, "properties": {"travelTime": 2.5}}::edge, {"id": 844424930131975, "label": "Metro", "properties": {"name": "Intramuros"}}::vertex, {"id": 1125899906842638, "label": "HAS_ROUTE", "end_
id": 844424930131976, "start_id": 844424930131975, "properties": {"travelTime": 11}}::edge, {"id": 844424930131976, "label": "Metro", "properties": {"name": "China Town"}}::vertex, {"id": 11
25899906842640, "label": "HAS_ROUTE", "end_id": 844424930131982, "start_id": 844424930131976, "properties": {"travelTime": 7.5}}::edge, {"id": 844424930131982, "label": "Metro", "properties"
: {"name": "Divisoria"}}::vertex, {"id": 1125899906842647, "label": "HAS_ROUTE", "end_id": 844424930131988, "start_id": 844424930131982, "properties": {"travelTime": 6.5}}::edge, {"id": 8444
24930131988, "label": "Metro", "properties": {"name": "Bastille"}}::vertex]::path

          | 27.5

          | 36.5

          | 40.0

(6 rows)


***For this to work, please pull the recent commits of age on master branch.***
</details>

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

如何对可变长度的边上的每个属性求和

问题

答案1

OUTER JOIN中SELECT列表中有一个不同列的简短语法

什么是使用Java向另一个PostgreSQL服务器插入超过一百万行数据的有效方法？

PostgreSQL – 如何从嵌套数组构建 WHERE 子句

The specified module could not be found. Postgres 15.2 with timescale 2.10.3.

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论