All Questions
82 questions
6
votes
4
answers
2k
views
Program for an employee database using python
In this program I'm defining functions to perform different tasks on a data record book for employees.
Here is a summary of the code:
Intro() to make the presentation of the home page.
create_record()...
2
votes
1
answer
96
views
delete rows based on references to other tables in a mysql database?
I have a database with the following hierarchy.
A dataset can have multiple scans (foreign key scan.id_dataset -> dataset.id)
A scan can have multiple labels (<...
- 199
2
votes
1
answer
79
views
5
votes
1
answer
3k
views
Student report card management Python program
The program is designed to take data from a MySQL database, using mysql-connector-python, and print it as a table in Python using the texttable module. The program also plots charts based on the data ...
- 151
2
votes
0
answers
215
views
Python script to collect NWS gridpoint forecast data (JSON) and push it into MariaDB
This script is my first-ever attempt at writing anything in python. Though I have an electrical engineering background and therefore got a little programming education in college, it was fairly ...
- 21
5
votes
1
answer
3k
views
Login system using bcrypt and MySQL, to be used for any future projects
Main function will ask what the user wants to do. LoginSystem class will handle the sign up and login process as well with the checking if password is right. passwordHashing will use bcrpyt to salt ...
- 399
1
vote
1
answer
236
views
Web scraping cars
Is there any way to lower the lines of this code and make it better in terms of being more Pythonic? The program collects data from truecar.com and then puts them ...
- 193
2
votes
2
answers
144
views
Inserting data into MySQL
My code currently doesn't insert data into MySQL fast enough. However I don't know how to measure the current speed.
...
4
votes
2
answers
304
views
Creating a database, a table within the database and inserting some values into it in one go
I've written a script which creates a new database, a table within the database, ...
- 2,501
2
votes
1
answer
494
views
Periodic Table and Simulation of Elements
I've been working on my first real "project" and decided to make the periodic table that can simulate each atom after you press on it. I'm unsure if the code is good and can be used on my ...
3
votes
1
answer
347
views
Get future events from Pinnacle API
My program makes API requests to Pinnacle Sports to retrieve future events and saves them to the database.
Questions:
Do I manage the database resources correctly? It takes about 3 seconds to check ...
2
votes
0
answers
87
views
Junior Dev Self-taught Resume Project
I've been learning Python now for 3 months as I find it really interesting to code. I want to be able to apply for junior dev positions and as I have no formal education I thought I'd make a project ...
2
votes
0
answers
78
views
Basic flask template with sessions
This Flask app, which makes use of SQLAlchemy, a MySQL server which is only reachable via SSH and Flask-Login, is the base on which I want to write an application which has login protected pages.
...
- 125
2
votes
2
answers
150
views
Receive data from SQL and CSV and send it to MySQL database using Python
Details:
I have a code, which does the following:
Get data from CSV and insert it into MySQL table
Get data from SQL Server and insert it into MySQL table
Run this code every 240 seconds - to refresh ...
- 235
2
votes
1
answer
57
views
Connecting and getting mysql connection object
I have written this code that connects to a mysql database. The function should be able to be used as a context manager - via with. It is working, but I am not sure ...
- 870