Jukebox/jukebox-software
10
0
Fork 0
Code Issues 3 Pull Requests Packages Projects Releases 2 Wiki Activity

[Task]: Setup database interaction module #3

New Issue
Closed
opened 2024-01-09 20:11:30 +00:00 by cptlobster · 1 comment
cptlobster commented 2024-01-09 20:11:30 +00:00
Member
Copy Link
Copy Source

Task description

setup a module that can interact with a database (Postgres likely, might need to retool for other DBs if necessary.

Functionality

  • Connect to a database and execute SQL queries
  • Setup Python interface (maybe as a class?) with following functionality
    • Initialize a fresh database
    • Read all rows from a database that match specific parameters
    • Write new rows to a database
  • Make it incredibly fault tolerant
    • If a column does not exist, add it and continue
    • If empty results, just return that and move on
    • If database error, return an empty set and move on

Assign to Project

  • I have assigned to the project
### Task description setup a module that can interact with a database (Postgres likely, might need to retool for other DBs if necessary. ### Functionality - [x] Connect to a database and execute SQL queries - [ ] Setup Python interface (maybe as a class?) with following functionality - [ ] Initialize a fresh database - [ ] Read all rows from a database that match specific parameters - [x] Write new rows to a database - [ ] Make it incredibly fault tolerant - [x] If a column does not exist, add it and continue - [ ] If empty results, just return that and move on - [x] If database error, return an empty set and move on ### Assign to Project - [x] I have assigned to the project
cptlobster self-assigned this 2024-01-09 20:11:30 +00:00
cptlobster added this to the Jukebox project 2024-01-09 20:11:30 +00:00
cptlobster added the Kind/Feature
Priority
High
 labels 2024-01-09 20:12:17 +00:00
cptlobster added reference dthomas-db 2024-01-09 20:39:38 +00:00
cptlobster commented 2024-01-14 20:27:24 +00:00
Author
Member
Copy Link
Copy Source

so far the internal functionality for executing SQL queries is implemented. I don't have error handling fully implemented yet so it just returns an empty list for now and print the error.

Also got read mostly implemented, I haven't added functionality to deal with new rows yet.

so far the internal functionality for executing SQL queries is implemented. I don't have error handling fully implemented yet so it just returns an empty list for now and print the error. Also got read *mostly* implemented, I haven't added functionality to deal with new rows yet.
Sign in to join this conversation.
dthomas-db
Branches Tags
Labels
Clear labels
Kind/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
Priority
Critical
The priority is critical
Priority
High
The priority is high
Priority
Low
The priority is low
Priority
Medium
The priority is medium
Reviewed
Confirmed
Issue has been confirmed
Reviewed
Duplicate
This issue or pull request already exists
Reviewed
Invalid
Invalid issue
Reviewed
Won't Fix
This issue won't be fixed
Status
Abandoned
Somebody has started to work on this but abandoned work
Status
Blocked
Something is blocking this issue or pull request
Status
Need More Info
Feedback is required to reproduce issue or to continue work
No labels Kind/Feature
Priority
High
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Jukebox
In Progress
Assignees
Clear assignees
adeck (Cole Deck) blis cptlobster (Camryn Thomas) eli fannieyu (Fannie Yu) lucas mikefisher natorion1 nhussein scarlett (scarlett kadan)
No Assignees cptlobster
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Jukebox/jukebox-software#3