No funded issue found.
Check out the
Issue Explorer Be the OSS Funding you wish to see in the world.
Looking to fund some work? You can submit a new Funded Issue
Workers Auto Approve
Python script that updates SQL tables
Python, sql, backend
I want a script written that adds and updates objects to two SQL tables, based on data available from Celestrak.org SATCAT and the Union of Concerned Satellite Database. The datasets are available at the following URLs:
[Celestrak Satellite Catalog
- [Raw SATCAT Data](https://www.celestrak.com/pub/satcat.txt)
- [SATCAT Format Documentation](https://www.celestrak.com/satcat/satcat-format.php)
Following population / update of the celestrak_SATCAT and ucs_SATDB tables, the script should access and parse the updates available from celestrak.com to update the errors in the ucs_SATDB data described in UCS-SD-Discrepancies.txt
The NORAD Catalog Number should be used to relate to the two datasets to each other.
[Draft code](https://github.com/mainnebula/SPACE_TASKS/blob/master/parse_satcat_UCS_for_bounty.py) to parse and insert the data into a SQL table is provided, along with [SQL DUMP](https://github.com/mainnebula/SPACE_TASKS) code for creating the populated tables.
It is assumed that this script will be called daily to update from online sources.
The module must be written in Python >= 3.6
SQL should be compatible with MariaDB >= 10.4
The script should provide console feedback when data source changes are discovered/implemented
Hands-off, automated process - preferably working with the source file data in memory.
## Definition of Done
The module code should be posted to the linked Github issue along with the source data.
Setup your profile
Tell us a little about you:
No results found for
Type to search skills..
Required [[totalcharacter]] / 240
Are you currently looking for work?
[[ option.string ]]
Setup your profile
Our tools are based on the principles of earn (💰), learn (📖), and meet (💬).
Select the ones you are interested in. You can change it later in your settings.
I'm also an organization manager looking for a great community.
Enable your organization profile
Gitcoin products can help grow community around your brand. Create your tribe, events, and incentivize your community with bounties. Announce new and upcoming events using townsquare. Find top-quality hackers and fund them to work with you on a grant.
These are the organizations you own. If you don't see your organization here please be sure that information is public on your GitHub profile. Gitcoin will sync this information for you.
Select the products you are interested in:
Out of the box you will receive Tribes Lite for your organization. Please provide us with a contact email: