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 here .
Time left
Opened
Issue Type
Workers Auto Approve
Project Type
Time Commitment
Experience Level
Permissions
Accepted
Reserved For
Python script that updates SQL tables
mainnebula
Python, sql, backend
# Description
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
](https://www.celestrak.com/satcat/search.php)
- [Raw SATCAT Data](https://www.celestrak.com/pub/satcat.txt)
- [SATCAT Format Documentation](https://www.celestrak.com/satcat/satcat-format.php)
https://www.ucsusa.org/nuclear-weapons/space-weapons/satellite-database
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.
## Requirements
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:
Skills
No results found for [[search]] .
Type to search skills..
Bio Required
[[totalcharacter]] / 240
Are you currently looking for work?
[[ option.string ]]
Next
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.
Back
Next
Save
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:
Email
Back
Save
