Live tracking, flight database and competition framework

Overview

SkyLines

SkyLines is a web platform where pilots can share their flights with others after, or even during flight via live tracking. SkyLines is a sort of social network for pilots including rankings, statistics and other interesting features. Most of all SkyLines is truly open in all regards compared to other similar platforms.

SkyLines has started development in 2012 as a spin-off from the popular XCSoar glide computer. Internally SkyLines is still sharing some code with XCSoar in the algorithmic areas and is providing the base for XCSoar's live tracking functionalities.

SkyLines is far from finished yet, but it has been running in production for quite some time now. You can reach the official server at http://www.skylines.aero.

Build Status: Build Status

Getting the source

The SkyLines source code is managed with git. It can be downloaded with the following command:

$ git clone git://github.com/skylines-project/skylines.git

For more information, please refer to the git documentation.

Installation and Setup

SkyLines is based on Python and depends on the following major components:

The process of installing these components and setting up a server for local development is described in the INSTALL.md file.

Contact and Contributing

You read about news on Facebook and Twitter. If you want to talk to us directly join our Slack community.

Bugs and feature request can be submitted here on GitHub. New ideas can also be discussed in the Wiki first.

Patches should be submitted using the Pull Request system of GitHub because of the integration with TravisCI.

Here are a few guidelines for creating patches:

  • patches should be self-contained
  • patches should be self-documenting
    (add a good description on what is changed, and why you are changing it)
  • write one patch for one change

License

SkyLines - the free internet platform for sharing flights
Copyright (C) 2012-2019  The SkyLines Team (see AUTHORS.md)

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.

You can find the full license text in the LICENSE file.

Comments
  • Airfield names garbled

    Airfield names garbled

    Surprisingly quite a few airfields in the Czech Republic have their names garbled on skylines (e.g. Medlamky instead of Medlanky, Krizantov instead of Krizanov etc.) I found more than 10 typos just within CZ names. I know you import the airfield database from welt2000. I tried contacting them at http://www.segelflug.de/vereine/welt2000/ but they never responded.

    It kind of hurts to see the name of your homebase misspelled all the time :-(

    My question is if any of these would be possible:

    1. Does anyone here know the welt2000 authors and can possibly push my changes through? Even better does anyone here have access and can review and apply my changes? I have a patch ready it just needs to get in.

    2. Would it be possible to fork welt2000 database under skylines-project org on github? If think that having the database on github would be beneficial anyway (more contributions, better transparency of changes, etc.) I need to double check but I think it is OK with their T&C.

    opened by jharting 25
  • Score: Possibility to choose method

    Score: Possibility to choose method

    A default OLC method is used for scoring in SkyLines, I think there should be a user setting to choose among the same rules allowed by XCSoar. I don't think there is a need for 2 options, one for "Flights" page, and one for "show page". What do you think?

    cf. XCSoar source:src/Engine/Contest/Solvers/Contests.cpp _T("OLC Sprint"), _T("OLC FAI"), _T("OLC Classic"), _T("OLC League"), _T("OLC Plus"), _T("XContest"), _T("DHV-XC"), _T("SIS-AT"), _T("FFVV NetCoupe"), _T("DMSt"),

    feature-request 
    opened by Adrien81 14
  • Bump flake8 from 3.3.0 to 3.5.0

    Bump flake8 from 3.3.0 to 3.5.0

    Bumps flake8 from 3.3.0 to 3.5.0.

    Commits
    • 8acf55e Prepare for v3.5.0 release on 2017-10-23
    • 4d0f313 Merge branch 'fix_encoding_test' into 'master'
    • fdcee02 Fix failing encoding test on appveyor
    • 7146aff Merge branch 'catch_decode_error' into 'master'
    • bbe8d6d Catch UnicodeDecodeError while parsing config files
    • 2e12a20 Merge branch 'local-plugins-updates' into 'master'
    • c2218e4 Document using local plugins
    • 222f0a8 Allow our local plugin parsing to accept commas
    • a2c7051 Update release notes to include local plugins
    • 156f903 Update our plugin registration for debugging
    • Additional commits viewable in compare view

    Dependabot compatibility score

    Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.


    Dependabot commands and options

    You can trigger Dependabot actions by commenting on this PR:

    • @dependabot rebase will rebase this PR
    • @dependabot ignore this [minor|major] version will close this PR and stop Dependabot creating any more for this minor/major version (unless you reopen the PR or upgrade to it yourself)
    • @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
    • @dependabot use [this|these] label[s] will set the current labels as the default for future PRs for this repo and language

    Additionally, you can set the following in your Dependabot dashboard:

    • Update frequency (including time of day and day of week)
    • Automerge options (never/patch/minor, and dev/runtime dependencies)
    • Out-of-range updates (receive only lockfile updates, if desired)

    Finally, you can contact us by mentioning @dependabot.

    api internal 
    opened by dependabot-preview[bot] 13
  • Bump aerofiles from 0.1.1 to 0.4.1

    Bump aerofiles from 0.1.1 to 0.4.1

    Bumps aerofiles from 0.1.1 to 0.4.1.

    Release notes

    Sourced from aerofiles's releases.

    aerofiles v0.3

    • OpenAir airspace file reader
    • Fixed encoding issues in SeeYou/XCSoar file writers

    aerofiles v0.2

    • SeeYou CUP file writer
    • XCSoar task file writer
    • Flarm configuration file writer
    Changelog

    Sourced from aerofiles's changelog.

    aerofiles v0.4.1

    • fix extensions in IGC file fix record
    • remove igc line limit

    aerofiles v0.4

    • IGC file reader
    • Expanded SeeYou reader with task reading

    aerofiles v0.3

    • OpenAir airspace file reader
    • Fixed encoding issues in SeeYou/XCSoar file writers

    aerofiles v0.2

    • SeeYou CUP file writer
    • XCSoar task file writer
    • Flarm configuration file writer
    Commits

    Dependabot compatibility score

    Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.


    Dependabot commands and options

    You can trigger Dependabot actions by commenting on this PR:

    • @dependabot rebase will rebase this PR
    • @dependabot ignore this [minor|major] version will close this PR and stop Dependabot creating any more for this minor/major version (unless you reopen the PR or upgrade to it yourself)
    • @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
    • @dependabot use [this|these] label[s] will set the current labels as the default for future PRs for this repo and language

    Additionally, you can set the following in your Dependabot dashboard:

    • Update frequency (including time of day and day of week)
    • Automerge options (never/patch/minor, and dev/runtime dependencies)
    • Out-of-range updates (receive only lockfile updates, if desired)
    • Security updates (receive only security updates, if desired)

    Finally, you can contact us by mentioning @dependabot.

    api internal 
    opened by dependabot-preview[bot] 12
  • unable to build project

    unable to build project

    when running ./manage.py assets build I am running into:

    $ ./manage.py assets build
    Generating bundle: js/ember-app-%(version)s.js
    Traceback (most recent call last):
      File "./manage.py", line 6, in <module>
        manager.run()
      File "/usr/lib/python2.7/site-packages/flask_script/__init__.py", line 423, in run
        result = self.handle(sys.argv[0], sys.argv[1:])
      File "/usr/lib/python2.7/site-packages/flask_script/__init__.py", line 402, in handle
        return handle(app, *positional_args, **kwargs)
      File "/usr/lib/python2.7/site-packages/flask_script/commands.py", line 145, in handle
        return self.run(*args, **kwargs)
      File "/home/jharting/projects/skylines/skylines/commands/assets.py", line 17, in build
        bundle.build()
      File "/usr/lib/python2.7/site-packages/webassets/bundle.py", line 563, in build
        disable_cache=disable_cache))
      File "/usr/lib/python2.7/site-packages/webassets/bundle.py", line 498, in _build
        force, disable_cache=disable_cache, extra_filters=extra_filters)
      File "/usr/lib/python2.7/site-packages/webassets/bundle.py", line 355, in _merge_and_apply
        resolved_contents = self.resolve_contents(env, force=True)
      File "/usr/lib/python2.7/site-packages/webassets/bundle.py", line 148, in resolve_contents
        raise BundleError(e)
    webassets.exceptions.BundleError: 'ember/assets/skylines.js' not found in load path: ['/home/jharting/projects/skylines/skylines/frontend/static']
    

    Happens both when running in my local environment and also in vagrant. Any idea what I am doing wrong?

    opened by jharting 11
  • Tracking: Add OpenGliderNetwork integration

    Tracking: Add OpenGliderNetwork integration

    We could use data from the OpenGliderNetwork to extend the tracking coverage of skylines.

    To enable this feature, a user would enter their FLARM-ID (or ICAO-address, henceforth referred as ogn_address) into skylines. An external daemon (ogn-skylines-gateway) would forward corresponding fix-packets to skylines.

    Architecture

    • skylines
      • [ ] saves mapping ogn_address <--> skylines_tracking_key
      • [ ] serves this mapping for an authenticated service (ogn-skylines-gateway)
    • ogn-skylines-gateway
      • [ ] fetches the mapping from skylines
      • [x] forwards fixes from glidernet to skylines, using the skylines_tracking_key

    Remarks

    • The relation ogn_address(usually a flarm device) <--> skylines_user could be highly volatile (e.g. in glider clubs). solution: Enable optional time-limited relations by adding the timestamps ownership_from and ownership_until to the mapping
    • The ogn-skylines-gateway should be trusted, as it handles foreign tracking_keys.
    • Should the time-delay feature be implemented (at the moment not supported by ogn-skylines-gateway)?

    Help/Tips in the skylines-/user-interface-related tasks would be highly appreciated. What are your thoughts about it?

    feature-request 
    opened by kerel-fs 11
  • 3D rendering

    3D rendering

    3D mode looks like it will be great. On my desktop, Clicking the 3D button does not work.

    It shows the blue flight line, in 3D, with height (can drag view point around), but the background layer just shows black. I've tried with a range of different layers. still just appears black.

    Details: Browsers: Firefox ESR 38.3.0 and Google Chrome Version 45.0.2454.101 (64-bit) OS: 64bit Mageia Linux Network: IPv4 and IPv6 (dual stack) Test URL: https://skylines.aero/flights/55387/

    Note: 3D support in my desktop works fine, I use other 3D apps.

    The web developer console in firefox, shows the following:

    Use of getUserData() or setUserData() is deprecated.  Use WeakMap or element.dataset instead. requestNotifier.js:64:0
    Use of Mutation Events is deprecated. Use MutationObserver instead. itsalltext.js:766:0
    Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help http://xhr.spec.whatwg.org/ skylines-b7fbaf12.js:1:0
    Use of Mutation Events is deprecated. Use MutationObserver instead. itsalltext.js:766:0
    Use of getPreventDefault() is deprecated.  Use defaultPrevented instead. skylines-b7fbaf12.js:1:0
    mutating the [[Prototype]] of an object will cause your code to run very slowly; instead create the object with the correct initial [[Prototype]] value using Object.create Cesium.js:458:16694
    Error: WebGL: A texture is going to be rendered as if it were black, as per the OpenGL ES 2.0.24 spec section 3.8.2, because it is a 2D texture, with a minification filter requiring a mipmap, and is not mipmap complete (as defined in section 3.7.10). Cesium.js:433:10011
    "An error occurred in "": Failed to obtain terrain tile X: 1 Y: 0 Level: 0." Cesium.js:420:26831
    "An error occurred in "": Failed to obtain terrain tile X: 0 Y: 0 Level: 0." Cesium.js:420:26831
    Error: WebGL: A texture is going to be rendered as if it were black, as per the OpenGL ES 2.0.24 spec section 3.8.2, because it is a 2D texture, with a minification filter requiring a mipmap, and is not mipmap complete (as defined in section 3.7.10). Cesium.js:433:10011
    Empty string passed to getElementById(). skylines-b7fbaf12.js:1:0
    Error: WebGL: A texture is going to be rendered as if it were black, as per the OpenGL ES 2.0.24 spec section 3.8.2, because it is a 2D texture, with a minification filter requiring a mipmap, and is not mipmap complete (as defined in section 3.7.10). Cesium.js:433:10011
    
    
    bug frontend beginner-friendly 
    opened by nelg 11
  • French locale is not available

    French locale is not available

    opened by pyrog 10
  • Devenv - Vagrant dev environment provisioned by fabric

    Devenv - Vagrant dev environment provisioned by fabric

    I would propose to replace chef vagrant provisioning with python fabric. To make it even more unified i would suggest to make also new fabfile package module and put all fabric related stuff there. Currently i created "vagrant provision" task in a separate fabric file. What do you think? Cheers

    opened by primozs 10
  • translation errors in Dutch

    translation errors in Dutch

    for example:

    Database Vluchten upload U IGC bestanden en deel ze met U vrienden. We veranderen U bestanden niet, of > belemmeren U niet ze terug te downloaden!

    'U' should be 'uw' or 'jouw'/'je'

    furthermore: Upload (EN) is not Opladen (dutch)

    bug frontend 
    opened by GliderGeek 9
  • Broken URLs in airspace list

    Broken URLs in airspace list

    opened by pyrog 9
  • Add Airport to Airport Database?

    Add Airport to Airport Database?

    One of the more popular sites in Canada is Invermere, BC. When I log flights there, no airport is displayed. Is there a way I could add it to the database?

    https://www.skylines.aero/flights/141932

    opened by ventus99 1
  • docs: Fix a few typos

    docs: Fix a few typos

    There are small typos in:

    • ember/app/sentry.js
    • skylines/api/views/flights.py
    • skylines/model/flight.py

    Fixes:

    • Should read synchronously rather than syncronously.
    • Should read cancellation rather than cancelation.
    • Should read chunk rather than chunck.

    Semi-automated pull request generated by https://github.com/timgates42/meticulous/blob/master/docs/NOTE.md

    opened by timgates42 0
  • [Feature] Add a link to open location in google maps

    [Feature] Add a link to open location in google maps

    Hi, Thanks a lot for your very nice work. For paragliders, tracking is often used to reach the pilot once landed. So on the map, it would be nice to add a link to open pilot location in google maps, next to "Load nearby flights" and "Get location info". Cheers, Pierre

    opened by pierre-fr34 0
  • Update dependency node-sass to v7 [SECURITY]

    Update dependency node-sass to v7 [SECURITY]

    Mend Renovate

    This PR contains the following updates:

    | Package | Change | Age | Adoption | Passing | Confidence | |---|---|---|---|---|---| | node-sass | 5.0.0 -> 7.0.0 | age | adoption | passing | confidence |

    GitHub Vulnerability Alerts

    CVE-2020-24025

    Certificate validation in node-sass 2.0.0 to 6.0.1 is disabled when requesting binaries even if the user is not specifying an alternative download path.


    Release Notes

    sass/node-sass

    v7.0.0

    Compare Source

    Breaking changes
    Features
    Dependencies
    Community
    Misc

    Supported Environments

    | OS | Architecture | Node | | --- | --- | --- | | Windows | x86 & x64 | 12, 14, 16, 17 | | OSX | x64 | 12, 14, 16, 17 | | Linux* | x64 | 12, 14, 16, 17 | | Alpine Linux | x64 | 12, 14, 16, 17 | | FreeBSD | i386 amd64 | 12, 14 |

    *Linux support refers to major distributions like Ubuntu, and Debian

    v6.0.1

    Compare Source

    Dependencies
    Misc

    Supported Environments

    | OS | Architecture | Node | | --- | --- | --- | | Windows | x86 & x64 | 12, 14, 15, 16 | | OSX | x64 | 12, 14, 15, 16 | | Linux* | x64 | 12, 14, 15, 16 | | Alpine Linux | x64 | 12, 14, 15, 16 | | FreeBSD | i386 amd64 | 12, 14, 15 |

    *Linux support refers to major distributions like Ubuntu, and Debian

    v6.0.0

    Compare Source

    Breaking changes
    Features
    • Add support for Node 16
    Community

    Supported Environments

    | OS | Architecture | Node | | --- | --- | --- | | Windows | x86 & x64 | 12, 14, 15, 16 | | OSX | x64 | 12, 14, 15, 16 | | Linux* | x64 | 12, 14, 15, 16 | | Alpine Linux | x64 | 12, 14, 15, 16 | | FreeBSD | i386 amd64 | 12, 14, 15 |

    *Linux support refers to major distributions like Ubuntu, and Debian


    Configuration

    📅 Schedule: Branch creation - "" (UTC), Automerge - At any time (no schedule defined).

    🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

    Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

    🔕 Ignore: Close this PR and you won't be reminded about this update again.


    • [ ] If you want to rebase/retry this PR, check this box

    This PR has been generated by Mend Renovate. View repository job log here.

    opened by renovate[bot] 0
  • DB shuts down for no reason when using docker-compose

    DB shuts down for no reason when using docker-compose

    I have tried to use docker-compose to install skylines and the problem is I see the following error when I'm trying to get flights page:

    Sorry! It looks like there was error while loading this page. The error was automatically reported back to the developers. Please try again later!

    Apparently this is somehow related to db and this is the output I see on terminal:

    api_1       | 172.18.0.1 - - [28/Oct/2021 07:34:16] "GET /flights HTTP/1.1" 200 -
    db_1        | 2021-10-28 07:34:17.385 UTC [221] ERROR:  relation "flights" does not exist at character 46
    db_1        | 2021-10-28 07:34:17.385 UTC [221] STATEMENT:  SELECT max(flights.date_local) AS date 
    db_1        | 	FROM flights JOIN igc_files ON igc_files.id = flights.igc_file_id 
    db_1        | 	WHERE flights.takeoff_time < '2021-10-28T07:34:17.289766'::timestamp AND (flights.privacy_level = 0 OR NULL)
    api_1       | 172.18.0.1 - - [28/Oct/2021 07:34:17] "GET /api/flights/latest?page=1&column=score&order=desc HTTP/1.1" 500 -
    api_1       | Traceback (most recent call last):
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/flask.py", line 90, in sentry_patched_wsgi_app
    api_1       |     environ, start_response
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/wsgi.py", line 131, in __call__
    api_1       |     reraise(*_capture_exception(hub))
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/wsgi.py", line 127, in __call__
    api_1       |     _sentry_start_response, start_response, transaction
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/flask.py", line 89, in <lambda>
    api_1       |     return SentryWsgiMiddleware(lambda *a, **kw: old_app(self, *a, **kw))(
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 2464, in __call__
    api_1       |     return self.wsgi_app(environ, start_response)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/werkzeug/middleware/dispatcher.py", line 66, in __call__
    api_1       |     return app(environ, start_response)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/flask.py", line 90, in sentry_patched_wsgi_app
    api_1       |     environ, start_response
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/wsgi.py", line 101, in __call__
    api_1       |     return self.app(environ, start_response)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sentry_sdk/integrations/flask.py", line 89, in <lambda>
    api_1       |     return SentryWsgiMiddleware(lambda *a, **kw: old_app(self, *a, **kw))(
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 2464, in __call__
    api_1       |     return self.wsgi_app(environ, start_response)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 2450, in wsgi_app
    api_1       |     response = self.handle_exception(e)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 1867, in handle_exception
    api_1       |     reraise(exc_type, exc_value, tb)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 2447, in wsgi_app
    api_1       |     response = self.full_dispatch_request()
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 1952, in full_dispatch_request
    api_1       |     rv = self.handle_user_exception(e)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 1821, in handle_user_exception
    api_1       |     reraise(exc_type, exc_value, tb)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 1950, in full_dispatch_request
    api_1       |     rv = self.dispatch_request()
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/flask/app.py", line 1936, in dispatch_request
    api_1       |     return self.view_functions[rule.endpoint](**req.view_args)
    api_1       |   File "/home/skylines/code/skylines/api/oauth.py", line 98, in decorated
    api_1       |     return f(*args, **kwargs)
    api_1       |   File "/home/skylines/code/skylines/api/views/flights.py", line 222, in latest
    api_1       |     date_ = query.one().date
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3490, in one
    api_1       |     ret = self.one_or_none()
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none
    api_1       |     ret = list(self)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    api_1       |     return self._execute_and_instances(context)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    api_1       |     result = conn.execute(querycontext.statement, self._params)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    api_1       |     return meth(self, multiparams, params)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    api_1       |     return connection._execute_clauseelement(self, multiparams, params)
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement
    api_1       |     distilled_params,
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1317, in _execute_context
    api_1       |     e, statement, parameters, cursor, context
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1511, in _handle_dbapi_exception
    api_1       |     sqlalchemy_exception, with_traceback=exc_info[2], from_=e
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
    api_1       |     cursor, statement, parameters, context
    api_1       |   File "/root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
    api_1       |     cursor.execute(statement, parameters)
    api_1       | ProgrammingError: (psycopg2.errors.UndefinedTable) relation "flights" does not exist
    api_1       | LINE 2: FROM flights JOIN igc_files ON igc_files.id = flights.igc_fi...
    api_1       |              ^
    api_1       | 
    api_1       | [SQL: SELECT max(flights.date_local) AS date 
    api_1       | FROM flights JOIN igc_files ON igc_files.id = flights.igc_file_id 
    api_1       | WHERE flights.takeoff_time < %(takeoff_time_1)s AND (flights.privacy_level = %(privacy_level_1)s OR NULL)]
    api_1       | [parameters: {'privacy_level_1': 0, 'takeoff_time_1': datetime.datetime(2021, 10, 28, 7, 34, 17, 289766)}]
    api_1       | (Background on this error at: http://sqlalche.me/e/13/f405)
    

    So I removed all the containers and volume and network and run docker-compose up command again, and this is the result I got:

    db_1        | The files belonging to this database system will be owned by user "postgres".
    db_1        | This user must also own the server process.
    db_1        | 
    redis_1     | 1:C 28 Oct 2021 07:32:47.491 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
    redis_1     | 1:C 28 Oct 2021 07:32:47.491 # Redis version=6.2.6, bits=64, commit=00000000, modified=0, pid=1, just started
    redis_1     | 1:C 28 Oct 2021 07:32:47.491 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
    db_1        | The database cluster will be initialized with locale "en_US.utf8".
    db_1        | The default database encoding has accordingly been set to "UTF8".
    db_1        | The default text search configuration will be set to "english".
    db_1        | 
    db_1        | Data page checksums are disabled.
    worker_1    | [2021-10-28 07:32:59,009] INFO in app: Running on git revision ce68ee28
    redis_1     | 1:M 28 Oct 2021 07:32:47.492 * monotonic clock: POSIX clock_gettime
    redis_1     | 1:M 28 Oct 2021 07:32:47.493 * Running mode=standalone, port=6379.
    worker_1    | [2021-10-28 07:32:59,057] INFO in app: Running on git revision ce68ee28
    db_1        | 
    db_1        | fixing permissions on existing directory /var/lib/postgresql/data ... ok
    redis_1     | 1:M 28 Oct 2021 07:32:47.493 # Server initialized
    redis_1     | 1:M 28 Oct 2021 07:32:47.493 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
    redis_1     | 1:M 28 Oct 2021 07:32:47.493 * Ready to accept connections
    db_1        | creating subdirectories ... ok
    worker_1    | /root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/celery/platforms.py:812: RuntimeWarning: You are running the worker with superuser privileges, which is
    worker_1    | absolutely not recommended!
    worker_1    | 
    worker_1    | Please specify a different user using the -u option.
    worker_1    | 
    worker_1    | User information: uid=0 euid=0 gid=0 egid=0
    worker_1    | 
    worker_1    |   uid=uid, euid=euid, gid=gid, egid=egid,
    worker_1    | [2021-10-28 07:32:59,119: WARNING/MainProcess] /root/.local/share/virtualenvs/code-t3DK9Vtb/lib/python2.7/site-packages/celery/apps/worker.py:161: CDeprecationWarning: 
    worker_1    | Starting from version 3.2 Celery will refuse to accept pickle by default.
    worker_1    | 
    worker_1    | The pickle serializer is a security concern as it may give attackers
    worker_1    | the ability to execute any command.  It's important to secure
    worker_1    | your broker from unauthorized access when using pickle, so we think
    worker_1    | that enabling pickle should require a deliberate action and not be
    worker_1    | the default choice.
    worker_1    | 
    worker_1    | If you depend on pickle then you should set a setting to disable this
    worker_1    | warning and to be sure that everything will continue working
    worker_1    | when you upgrade to Celery 3.2::
    worker_1    | 
    worker_1    |     CELERY_ACCEPT_CONTENT = ['pickle', 'json', 'msgpack', 'yaml']
    worker_1    | 
    worker_1    | You must only enable the serializers that you will actually use.
    worker_1    | 
    worker_1    | 
    worker_1    |   warnings.warn(CDeprecationWarning(W_PICKLE_DEPRECATED))
    worker_1    | [2021-10-28 07:32:59,583: INFO/MainProcess] Connected to redis://redis:6379/0
    db_1        | selecting default max_connections ... 100
    worker_1    | [2021-10-28 07:32:59,597: INFO/MainProcess] mingle: searching for neighbors
    db_1        | selecting default shared_buffers ... 128MB
    db_1        | selecting default timezone ... Etc/UTC
    db_1        | selecting dynamic shared memory implementation ... posix
    db_1        | creating configuration files ... ok
    db_1        | running bootstrap script ... ok
    db_1        | performing post-bootstrap initialization ... ok
    db_1        | syncing data to disk ... ok
    db_1        | 
    db_1        | Success. You can now start the database server using:
    db_1        | 
    db_1        |     pg_ctl -D /var/lib/postgresql/data -l logfile start
    db_1        | 
    db_1        | 
    db_1        | WARNING: enabling "trust" authentication for local connections
    db_1        | You can change this by editing pg_hba.conf or using the option -A, or
    db_1        | --auth-local and --auth-host, the next time you run initdb.
    db_1        | waiting for server to start....2021-10-28 07:32:59.971 UTC [62] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    db_1        | 2021-10-28 07:33:00.441 UTC [63] LOG:  database system was shut down at 2021-10-28 07:32:53 UTC
    db_1        | 2021-10-28 07:33:00.501 UTC [62] LOG:  database system is ready to accept connections
    db_1        |  done
    db_1        | server started
    worker_1    | [2021-10-28 07:33:00,604: INFO/MainProcess] mingle: all alone
    worker_1    | [2021-10-28 07:33:00,617: WARNING/MainProcess] celery@cf4961e6b0f7 ready.
    db_1        | 
    db_1        | /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/create-databases.sql
    db_1        | CREATE DATABASE
    db_1        | You are now connected to database "skylines" as user "postgres".
    tracking_1  | [2021-10-28 07:33:01,826] INFO in app: Running on git revision ce68ee28
    tracking_1  | Receiving datagrams on :5597
    tracking_1  | [2021-10-28 07:33:01,866] INFO in app: Running on git revision ce68ee28
    api_1       | [2021-10-28 07:33:01,997] INFO in app: Running on git revision ce68ee28
    api_1       | [2021-10-28 07:33:02,028] INFO in app: Running on git revision ce68ee28
    api_1       | [2021-10-28 07:33:02,064] INFO in app: Running on git revision ce68ee28
    api_1       |  * Serving Flask app "skylines.frontend" (lazy loading)
    api_1       |  * Environment: production
    api_1       |    WARNING: This is a development server. Do not use it in a production deployment.
    api_1       |    Use a production WSGI server instead.
    api_1       |  * Debug mode: on
    api_1       |  * Running on http://0.0.0.0:5000/ (Press CTRL+C to quit)
    api_1       |  * Restarting with stat
    db_1        | CREATE EXTENSION
    api_1       | [2021-10-28 07:33:03,141] INFO in app: Running on git revision ce68ee28
    db_1        | CREATE EXTENSION
    api_1       | [2021-10-28 07:33:03,172] INFO in app: Running on git revision ce68ee28
    api_1       | [2021-10-28 07:33:03,211] INFO in app: Running on git revision ce68ee28
    api_1       |  * Debugger is active!
    api_1       |  * Debugger PIN: 273-665-450
    db_1        | CREATE DATABASE
    db_1        | You are now connected to database "skylines_test" as user "postgres".
    db_1        | CREATE EXTENSION
    db_1        | CREATE EXTENSION
    db_1        | 
    db_1        | 
    db_1        | 2021-10-28 07:33:06.592 UTC [62] LOG:  received fast shutdown request
    db_1        | waiting for server to shut down....2021-10-28 07:33:06.682 UTC [62] LOG:  aborting any active transactions
    db_1        | 2021-10-28 07:33:06.684 UTC [62] LOG:  worker process: logical replication launcher (PID 69) exited with exit code 1
    db_1        | 2021-10-28 07:33:06.684 UTC [64] LOG:  shutting down
    db_1        | .2021-10-28 07:33:07.628 UTC [62] LOG:  database system is shut down
    db_1        |  done
    db_1        | server stopped
    db_1        | 
    db_1        | PostgreSQL init process complete; ready for start up.
    db_1        | 
    db_1        | 2021-10-28 07:33:07.756 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
    db_1        | 2021-10-28 07:33:07.756 UTC [1] LOG:  listening on IPv6 address "::", port 5432
    db_1        | 2021-10-28 07:33:07.845 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
    db_1        | 2021-10-28 07:33:08.002 UTC [101] LOG:  database system was shut down at 2021-10-28 07:33:07 UTC
    db_1        | 2021-10-28 07:33:08.094 UTC [1] LOG:  database system is ready to accept connections
    

    What is interesting for me is the part about:

    db_1        | 2021-10-28 07:33:06.592 UTC [62] LOG:  received fast shutdown request
    db_1        | waiting for server to shut down....2021-10-28 07:33:06.682 UTC [62] LOG:  aborting any active transactions
    db_1        | 2021-10-28 07:33:06.684 UTC [62] LOG:  worker process: logical replication launcher (PID 69) exited with exit code 1
    db_1        | 2021-10-28 07:33:06.684 UTC [64] LOG:  shutting down
    db_1        | .2021-10-28 07:33:07.628 UTC [62] LOG:  database system is shut down
    db_1        |  done
    db_1        | server stopped
    

    Unfortunately, I have no idea how containers of this project are organized and I have no idea how to debug this problem. So I'd really appreciate any help.

    opened by farzinghanbari 0
Aerospace utilities: flight conditions package, standard atmosphere model, and more.

Aerospace Utilities About Module that contains commonly-used aerospace utilities for problem solving. Flight Condition: input altitude to compute comm

null 1 Jan 3, 2022
Developing and Comparing Vision-based Algorithms for Vision-based Agile Flight

DodgeDrone: Vision-based Agile Drone Flight (ICRA 2022 Competition) Would you like to push the boundaries of drone navigation? Then participate in the

Robotics and Perception Group 115 Dec 10, 2022
Flight Reservation App With Python

Flight Reservation App With Python

victor-h. 1 Nov 21, 2021
Project for viewing the cheapest flight deals from Netherlands to other countries.

Flight_Deals_AMS Project for viewing the cheapest flight deals from Netherlands to other countries.

null 2 Dec 17, 2022
Developing a python based app prototype with KivyMD framework for a competition :))

Developing a python based app prototype with KivyMD framework for a competition :))

Jay Desale 1 Jan 10, 2022
A competition for forecasting electricity demand at the country-level using a standard backtesting framework

A competition for forecasting electricity demand at the country-level using a standard backtesting framework

null 5 Jul 12, 2022
Group P-11's submission for the University of Waterloo's 2021 Engineering Competition (Programming section).

P-11-WEC2021 Group P-11's submission for the University of Waterloo's 2021 Engineering Competition (Programming section). Part I Compute typing time f

TRISTAN PARRY 1 May 14, 2022
Test to grab m3u from YouTube live.

YouTube_to_m3u https://raw.githubusercontent.com/benmoose39/YouTube_to_m3u/main/youtube.m3u Updated m3u links of YouTube live channels, auto-updated e

null 136 Jan 6, 2023
A place where one-off ideas/partial projects can live comfortably

A place to post ideas, partial projects, or anything else that doesn't necessarily warrant its own repo, from my mind to the web.

Carson Scott 2 Feb 25, 2022
A utility control surface for Ableton Live that makes the initialization of a Mixdown quick

Automate Mixdown initialization A script that transfers all the VSTs on your MIDI tracks to a new track so you can freeze your MIDI tracks and then co

Aarnav 0 Feb 23, 2022
This script provides LIVE feedback for On-The-Fly data collection with RELION

README This script provides LIVE feedback for On-The-Fly data collection with RELION (very useful to explore already processed datasets too!) Creating

cryoEM CNIO 6 Jul 14, 2022
Python implementation of an automatic parallel parking system in a virtual environment, including path planning, path tracking, and parallel parking

Automatic Parallel Parking: Path Planning, Path Tracking & Control This repository contains a python implementation of an automatic parallel parking s

null 134 Jan 9, 2023
Tracking development of the Class Schedule Siri Shortcut, an iOS program that checks the type of school day and tells you class scheduling.

Class Schedule Shortcut Tracking development of the Class Schedule Siri Shortcut, an iOS program that checks the type of school day and tells you clas

null 3 Jun 28, 2022
🦠 A simple and fast (< 200ms) API for tracking the global coronavirus (COVID-19, SARS-CoV-2) outbreak.

?? A simple and fast (< 200ms) API for tracking the global coronavirus (COVID-19, SARS-CoV-2) outbreak. It's written in python using the ?? FastAPI framework. Supports multiple sources!

Marius 1.6k Jan 4, 2023
A python package to manage the stored receiver-side Strain Green's Tensor (SGT) database of 3D background models and able to generate Green's function and synthetic waveform

A python package to manage the stored receiver-side Strain Green's Tensor (SGT) database of 3D background models and able to generate Green's function and synthetic waveform

Liang Ding 7 Dec 14, 2022
Tracking stock volatility.

SP500-highlow-tracking Track stock volatility. Being a useful indicator of the stock price volatility, High-Low gap represents the price range of the

Thong Huynh 13 Sep 7, 2022
Time tracking program that will format output to be easily put into Gitlab

time_tracker Time tracking program that will format output to be easily put into Gitlab. Feel free to branch and use it yourself! Getting Started Clon

Jake Strasler 2 Oct 13, 2022
CEI Natural Disaster Tracking Portal

CEI Natural Disaster Tracking Portal (cc) Climatic Eye of ISCI We are an initiative that conducts studies in the field of Space Science, publishes pro

Baris Dincer 7 Dec 24, 2022
Simple project to assist in tracking/logging my working hours

Fill working hours Basic script to assist in the logging/tracking of my working hours How it works Create a file called projects.json in this director

Robin Kennedy-Reid 2 Oct 31, 2022