tomgobravo / tourist-with-flask Goto Github PK

There is a nice list of clubs already maintained in the UK. It'd be nice to have some mechanism that keeps the hockey tourist and the UK site in sync.

https://www.gbuwh.co.uk/index.php?component=findaclub

https://www.google.com/maps/d/u/0/viewer?mid=1mfcfZ4snb0UGuSjvtXx8mG_mSJU

Currently I check the website to see when a new comment is added but this creates a delay and is a bit tedious. I'd like to get an email notifying me when a comment that looks like ham / not-spam is submitted.

Currently the tourist uses a branch of flask_admin which is now pretty old compared to their main and producing warnings such as

site-packages/flask_admin/form/widgets.py:2: DeprecationWarning: '_request_ctx_stack' is deprecated and will be removed in Flask 2.3.
    from flask.globals import _request_ctx_stack

I think the branch was needed to fix the geoa interface:

• flask-admin/flask-admin#2221
• flask-admin/flask-admin#2220

I'll update those PRs and try to get them merged into flask-admin

Add something saying what this is for people who happen to find the site. Some text might make the little map look less odd.

There are some places in the tourist code and dependencies that call flask.flash to add message to be displayed later. These are displayed by flask-admin but not in /tourist so if you sign in, then out, then in again without going to /admin you see old flash messages.

Place

[ Seoul, South Korea ]

Club(s)

[ Open chat : https://open.kakao.com/o/gUOqiRP (English ok) ]
[ Contact [email protected] for more information ]
[ Every Saturday 09:00~12:00 : subject to change ]

Pool(s)

[ Seongnam Sportscomplex diving pool - a.k.a. Aqualine ]
[ https://goo.gl/maps/Y7UpW3B72rDdXvRg6 ]

Place

[ Korea/Seoul - Korea UWH ]
[ Pool Seongnam ]

Club(s)

[ Korea UWH : Realtime chatroom - https://open.kakao.com/o/gUOqiRP ]

Pool(s)

[1. Aqualine pool (2m Diving pool)] [ link - https://www.google.co.kr/maps/place/%EC%84%B1%EB%82%A8%EC%A2%85%ED%95%A9%EC%8A%A4%ED%8F%AC%EC%B8%A0%EC%84%BC%ED%84%B0+%EC%88%98%EC%98%81%EC%9E%A5+(50m)/@37.4316318,127.1368266,19z/data=!3m1!4b1!4m5!3m4!1s0x357ca8e0a4a87bdf:0xc8e2aca369c35d2a!8m2!3d37.4316307!4d127.1373738?hl=ko ]

I would be interested in becoming an editor of the page.

Place

https://pucku.org/tourist/place/greenbaywisconsin

Club(s)

Contact: Peter Covach at 920-328-5436
Practice: Tuesdays 6:45P-8:30P or as marked on the meetup site.
https://www.meetup.com/green-bay-underwater-hockey/

Pool(s)

The Kroc Community Center
https://www.google.com/maps/place/The+Salvation+Army+Ray+and+Joan+Kroc+Corps+Community+Center/@44.481603,-87.9817462,17z

I built the current site to learn about and take advantage of flask and its many extensions. flask-admin makes editing tables in a database very easy. In hindsight the forms needed to edit tourist pages are fairly simple and a database makes dealing with synchronization and added background processes a little harder.... I'm excited for Kafka-style stream processing and storage. Rewriting is fun but and likely to open the door to new features but much lower priority than getting help editing to update the content.

Place

Country: Denmark
City: Copenhagen

Club(s)

Contact: Mollie Brooks [email protected]
Training: Wednesdays at 20:15 if we can get at least 4 players.

Pool(s)

Available upon request

Place

[ USA Connecticut Cheshire and Stratford ]

Club(s)

[Barnacles

Contact: [email protected]
meetup    https://www.meetup.com/Barnacles-Underwater-Hockey/
facebook  https://www.facebook.com/BarnaclesUnderwaterHockey/

Practice: Sunday 9am-11:15am at the Cheshire Community Pool 520 South Main Street, Cheshire, CT 06410
Practice: Thursday 7:30pm-9pm at the Stratford YMCA, 3045 Main St, Stratford, CT

]

Pool(s)

[ replace Greenwich with Cheshire

Open Cheshire Community Pool 520 S Main St, Cheshire, CT 06410

https://www.google.com/maps/place/Cheshire+Community+Pool/@41.4868228,-72.9011089,15z/data=!4m5!3m4!1s0x0:0x2e6f3489b7e53144!8m2!3d41.4868228!4d-72.9011089

in google maps
]

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[Ireland/Antrim/Belfast]
[Established in 2014 Queens Sinking Sheep Underwater Hockey offers a strong and competitive setting for travelling UWH players. QUB sends teams to the BOA students nationals, take parts in the BOA nationals and several other European tournaments to keep their skills sharp. ]

Club(s)

[Laura, email [email protected], preferably contact us on instagram @qub_uwh
https://www.facebook.com/QUBunderwaterhockey]

Pool(s)

[Practice times: Monday 8pm-9:30pm
Queen's Sport Stranmillis Gardens, Belfast BT9 5EX, UK PEC https://www.google.com/maps/place/Queen's+PEC,+Stranmillis+Gardens,+Belfast+BT9+5EX,+UK/@54.5807975,-5.9317872,17z/data=!3m1!4b1!4m5!3m4!1s0x486108e5f60a7d69:0xdc4a2c99f5b8bf36!8m2!3d54.5807975!4d-5.9295985]

https://www.belgiumuwh.be/clubs-in-belgium/ has a map hosted by infogram, but it uses a separate data source. I'll make something that can replace that map showing clubs in Belgium from the hockey tourist data. I'm imagining something like the map at https://pucku.org/tourist/place/be but the label is the club name and the location is the place/town center.

In the response after clicking "Save" flask-admin adds a flash message saying the record was updated. It'd be really nice for that message to include a link to the page to check how it looks.

Most submitted comments are obviously spam. Try adding a spam score from https://akismet.com/development/ to them so the ham can be more easily found and spam can be more easily deleted.

Investigate feasibility of sync with https://uwhnews.more-sport.com/where-to-flick/

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[Brampton, Ontario, Canada]
[Weekly Pickup Underwater Hockey Tuesday Evenings 9:30-10:30 pm]

Club(s)

[John Florian [email protected] 647-988-7513 https://www.facebook.com/photo/?fbid=10222177623562769&set=p.10222177623562769]

Pool(s)

[Earnscliff Recreation Center, 44 Eastbourne Drive, Brampton Ontario 43.72355185655053, -79.69947978945015 P8F2+86 Brampton, Ontario]

Place

https://pucku.org/tourist/place/bernbern

Club(s)

UWHBern
Website: uwhbern.ch
Training sessions: Tuesday evening

Training session time and places changes with season:
Summer (May-September), in Worb, Tuesday 19:00 - 20:00
Winter (October-April), in Melchenbühl, Tuesday 20:00 - 21:00

Pool(s)

Summer pool:
Worb, Wislepark
46.92614557191153, 7.562530451513532
https://www.google.com/maps/place/Wislepark/@46.9261274,7.5619501,18.5z/data=!4m5!3m4!1s0x478e342d18aaa4c5:0xcb776082e8c58111!8m2!3d46.926118!4d7.562606

Winter pool:
Schwimmbad Melchenbühl
46.93754512318368, 7.495709342344327
https://www.google.com/maps/place/Schwimmbad+Melchenb%C3%BChl/@46.9374755,7.4952507,19z/data=!4m5!3m4!1s0x478e37b3b40ec1dd:0xa3fb57e819a6bba1!8m2!3d46.9375755!4d7.4956418

Once GB import is stable try to make something similar happen for USA UWH.

The country list at https://pucku.org/tourist/ is getting pretty long. This can be fixed entirely in the web browser, no programming needed.

Looks like we have: Americas, Europe, Africa, Middle East, Asia-Pacific (seems to neatly address China/South East Asia/Australia/NZ).
Is Turkey in Europe, Asia or Middle East? IIRC Istanbul is technically split.

Place

https://pucku.org/tourist/place/ch
Country: Switzerland
Region: Fribourg
City: Romont

Club(s)

Information contact : [email protected]
Training sessions : Monday 20:30 - 21:30

Pool(s)

Pool in Épicentre Glâne
46.68695913037666, 6.912205453002633
https://www.google.com/maps/place/Epicentre+Gl%C3%A2ne/@46.6870086,6.9110902,18.5z/data=!4m5!3m4!1s0x478e7ffaac828567:0x2938cf8bf3cd73c8!8m2!3d46.6869876!4d6.9121941

Place

Berlin, Germany

Club(s)

Sporttaucher Berlin
http://berlinuwh.wordpress.com/
https://www.facebook.com/groups/berlinuwh/
[email protected]

Pool(s)

Sport- und Lehrschwimmhalle Schöneberg
Sachsendamm 11, 10829 Berlin

https://www.google.com/maps/place/Sports+and+teaching+swimming+pool+Sch%C3%B6neberg/@52.4762791,13.3541132,17z/data=!3m1!4b1!4m5!3m4!1s0x47a850135bc9a5f9:0x790ada61e0037217!8m2!3d52.4762791!4d13.3563019

Hi Tom,

Just wanting to get access to update some the Aussie/QLD club details.

See you on the bottom,
Steve

Currently there is a status_date attribute in the Place, Club and Pool objects (https://github.com/TomGoBravo/tourist-with-flask/blob/master/tourist/models/sqlalchemy.py) but these are manually maintained. I'm not sure an automatic last_modified_timestamp is quite right either because it'd get triggered for small changes that don't matter. It'd be nice to make updating the status_date easier, then show it in the main UI.

Currently the GBUWH clubs and pools are synced every 10 minutes, but visitors have no way of seeing that this happening. It'd be nice to show the last sync time, where before there was a 'last updated' time that is often many years. Pictures from Phil:

It'd be cool to have a background task that checks all URLs in tourist listings for freshness, extracts a recent post or image to include on our site with the URL.

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[https://pucku.org/tourist/place/chengdu]
[Optional: Information about hockey in this place that is not specific to a club]

Club(s)

[Chengdu Panda renamed as Chengdu Bubble, Contact: 王（WANG）旖（Yee）[email protected], Practice: Tuesday mornings 9:30 - 11:30 AM and Thursday nights 9:30-23:30 PM]

Pool(s)

[at Wenxuan Babu Zaidao Swimming Pool, #89 Huacai Rd, Jinjiang District, Chengdu, Sichuan, China, 610000]

With https://pucku.org/tourist/map one can pan and zoom to find a place, then look for points nearby on the map. It'd be nice to have the option of searching for a place to move the map.... something like https://docs.mapbox.com/mapbox-gl-js/example/mapbox-gl-geocoder/

When viewing the menu it isn't obvious that

WORLD
USA
CALIFORNIA

are nested subcategories of a place hierarchy. I tried putting them in a UL at https://github.com/TomGoBravo/tourist-with-flask/blob/master/tourist/templates/place.html#L7 but they shift too far right and lots of names get truncated. Something like http://odyniec.net/articles/turning-lists-into-trees/ would be nice.

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[ Ireland/Limerick/Limerick City ]
[ Newly founded club, training weekly throughout the winter months. Tourists welcome and newbie sessions every month]

Club(s)

[ Club name: Underwater Hockey Limerick
Contact Information: Chris, email underwaterhockey.limerick@gmail, or reach out on our social media accounts
Facebook: https://www.facebook.com/UWHLimerick
Instagram: https://www.instagram.com/underwaterhockeylimerick/ ]

Pool(s)

[ Practise Location: UL Arena Pool, Castletroy, Limerick.
Post Code: V94 X9VK
Google maps Link: https://goo.gl/maps/Wp1TTSfuQ2K8HpBS8
Practise time: Tuesdays 8pm- 10pm ]

Add a page similar to https://pucku.org/admin/club/?sort=4 that shows clubs with the oldest (or no!) status_date.
This'll make it easier to chip away at updating them.

Currently the map shows only pools, but there are many places and clubs without a pool so they are impossible to find. The fix could involve geojson_children_collection and functions it calls https://github.com/TomGoBravo/tourist-with-flask/blob/master/tourist/models/sqlalchemy.py#L114-L129

Something like
https://evilmartians.com/chronicles/build-images-on-github-actions-with-docker-layer-caching or https://www.skilledcookie.com/2021/04/06/devcontainers-and-continuous-integration/ or https://stackoverflow.com/a/73296056/341400

I'm not sure how the CI action plays with the the codespace action.

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Suzhou

[Link to place at pucku.org or name of relevant country/region/city you'd like to add or update.]
[Optional: Information about hockey in this place that is not specific to a club]

Max Zhang +86-15295618057
Email: [email protected]
Practice on Saturday Morning and Sunday Morning 7:00-9:00

[Information about club(s) to update. Ideally every club is listed with a person's name, email and phone number. Links to websites or groups used by the club are also useful.]

Pool(s)

[Pools are listed with a latitude,longitude pin to the entrance location on a map. Please try to provide it. A link to Google Maps works well.]

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[https://www.facebook.com/HKUWHA/]
[https://www.meetup.com/Hong-Kong-Underwater-Hockey-Association/]

Club(s)

[The Hong Kong Underwater Hockey Association. Contact person: Mr. Henry Chan, Whatsapp: (+852) 9088 7303, email: [email protected]]

*Please note the club originally on your site, under Richard is not longer active. I may pass Richard's contact to you for confirmation if needed.

Pool(s)

[Fridays: Whampoa Pool from 20:15 to 22:15
Tuesdays: Wah Yan Pool from 19:30 to 21:30

Please contact Henry for latest information]

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

https://www.pucku.org/tourist/place/sherbrookequbec

Club(s)

Site update: https://www.facebook.com/hsmSherbrooke (http://www.hsmsherbrooke.org/ no longer valid)
The email [email protected] is no longer valid, we now use the messenger of the facebook page

Pool(s)

Current info is still correct!

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

Belgium, Sint-Pieters-Leeuw/Halle

[Link to place at pucku.org or name of relevant country/region/city you'd like to add or update.]
[Optional: Information about hockey in this place that is not specific to a club]

Club(s)

Zuunse karpers
Steven De Laat
[email protected]
www.zuunsekarpers.be
www.facebook.com/ZuunseKarpers
[Information about club(s) to update. Ideally every club is listed with a person's name, email and phone number. Links to websites or groups used by the club are also useful.]

Pool(s)

pool location:
Wildersportcomplex
Sportlaan 11
1600 Sint-Pieters-Leeuw
50°47'58.8"N 4°17'10.3"E
https://www.google.com/maps/place/50%C2%B047'58.8%22N+4%C2%B017'10.3%22E/@50.7996777,4.2851087,18z/data=!3m1!4b1!4m9!1m2!2m1!1swildersport+sint+pieters+leeuw!3m5!1s0x0:0x0!7e2!8m2!3d50.7996762!4d4.2862032
and a second training location
Nederhem 35, 1500 Halle
50°44'18.6"N 4°14'32.8"E
https://www.google.com/maps/place/50%C2%B044'18.6%22N+4%C2%B014'32.8%22E/@50.7384878,4.2418888,19z/data=!3m1!4b1!4m13!1m6!3m5!1s0x0:0xa8b764c1158cdbe4!2sHallebad+Sportoase!8m2!3d50.7382547!4d4.2427201!3m5!1s0x0:0x0!7e2!8m2!3d50.7384866!4d4.2424364
[Pools are listed with a latitude,longitude pin to the entrance location on a map. Please try to provide it. A link to Google Maps works well.]

Adding the location of a pool is tedious. Many pools are already in OpenStreetMap. I'd like a pipeline that fetches all pools in OSM and lets clubs reference them instead of pools manually added to the UWHT. Places with a club feed be need some kind of exception handling because the club feed and OSM feed are unlikely to match perfectly.

Most of the comments (visible when logged in at https://pucku.org/tourist/comments) are spam. Even though comments are not visible publicly spammers add a few a day and deleting them with the current UI is tedious. Add a UI that makes it easy to delete lots of spam comments.

There are many ways this can be done, though without support from countries this'll need lots of scrapers. Perhaps ML makes writing them easier. This could be done in conjunction with issue 5 and issue 7. Dreaming is easy.
I'd like to get to it, but realistically making a great UI for editors to get humans on the task seems like a better use of time.

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[Link to place at pucku.org or name of relevant country/region/city you'd like to add or update.]
[Optional: Information about hockey in this place that is not specific to a club]

Club(s)

[Information about club(s) to update. Ideally every club is listed with a person's name, email and phone number. Links to websites or groups used by the club are also useful.]

Pool(s)

[Pools are listed with a latitude,longitude pin to the entrance location on a map. Please try to provide it. A link to Google Maps works well.]

Place

[Daejeon, South Korea]

Club(s)

[
UDF Underwater Hockey Club. June Hyuk Lee at [email protected] or +821091213404

http://cafe.naver.com/udfreediving

Wednesday nights @ 6:30PM
]

Pool(s)

[
Youngun international swimming pool,
138 Dongbu-ro, Yongun-dong, Dong-gu, Daejeon, South Korea

https://goo.gl/maps/2CzoPoShJTkWyvoL7
]

Club Puck
San Francisco Bay Area
Club contact- Ben Phipps, [email protected]
Hockey Tu and Thu 8-930pm
Burgess Park Pool- 501 Laurel St, Menlo Park, CA 94025
Park in the parking lot at Laurel St. and Burgess Dr.

Place

https://pucku.org/tourist/place/montrealqubec

Club(s)

CAMO Hockey Sous-Marin

As of 2023

https://www.facebook.com/groups/310207872348080/
Contact: Joseph Ravoahangy at [email protected]
Practices:
Tuesday 20h30-22h30 and Friday 20h00-22h30,

Pool(s)

Piscine Joseph-Charbonneau
https://maps.app.goo.gl/XcvzWM8iyrPSffbLA

Thank you for contributing new information to the Underwater Hockey Tourist
Please replace the items in [....] with the requested information, delete this text and click Submit new issue.
An editor will add your update to the site soon. To learn about editing please see https://github.com/TomGoBravo/tourist-with-flask/wiki/Editor-guide.

Place

[Link to place at pucku.org or name of relevant country/region/city you'd like to add or update.]
[Optional: Information about hockey in this place that is not specific to a club]

Club(s)

[Information about club(s) to update. Ideally every club is listed with a person's name, email and phone number. Links to websites or groups used by the club are also useful.]

Pool(s)

[Pools are listed with a latitude,longitude pin to the entrance location on a map. Please try to provide it. A link to Google Maps works well.]

When editing the content of a page in the admin interface a bare URL (text such as http://..../path) is displayed as a live link in the preview but when the same content appears on a page of the site the URL is shown as plain text (no underline, blue or link). The fix is putting angle brackets around the link (change the text to <http://...../path>). Hint for this found at https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet#links

Fix is making sure preview and site use the same markdown language.