All Questions
Tagged with mysql python-3.x
27 questions
5
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
93
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
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
4
votes
2
answers
302
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,511
4
votes
1
answer
190
views
Calculating the Percentage of a Pair Occurring Across a Lot of Lists
I'm looking for a way to speed this code up. It took about 4.5 hours to run on ~20k decks. I'm open to restructuring my SQL query, but feel adjusting the python would be more effective. The goal of ...
- 83
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
1
answer
48
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 ...
- 880
4
votes
1
answer
533
views
Crossword using tkinter without classes and objects
For my Python project, I wanted to make a crossword game GUI with SQL connectivity to display high scores. I tried to learn tkinter, but the only difficulty was ...
- 41
2
votes
0
answers
72
views
PySide2 Row and Column Creator
In short, I need help simplifying and optimizing this code because now that I have switched to a tree widget from 2 list widgets, loading the tables has increased by roughly 3-4 seconds (used to be ...
- 21
2
votes
1
answer
9k
views
Python Tkinter login GUI with database
I created a simple login program that works how I wanted them to work. I separated the GUI and database codes into two different python files. I named the files as login.py and dbaseManip.py. The ...
- 43
5
votes
1
answer
153
views
Lastest version of my Blackjack game
This is the latest version of my Blackjack game that uses a MySQL database to store user info. I did everything I was recommended in my previous post, added a ranking system and also fixed a bug where ...
- 489
3
votes
1
answer
192
views
Blackjack game with database - follow-up
This is a follow-up to my ex-posted Blackjack game that uses a MySQL database to store the accounts and user's money. I tried splitting display_info() a bit, I also ...
- 489
4
votes
1
answer
564
views
Blackjack game with database
This is the latest version of my Blackjack game and I did a quite big update to it. Now you can make an account that is saved in the MySQL database and you can bet money that are also saved in the ...
- 489
4
votes
1
answer
295
views
Registration and login script
This is a registration and login script I have made in Python 3. It uses a MySQL database. In the future I might use it with my Blackjack game and add a row called ...
- 489
1
vote
1
answer
1k
views
Using encryption/hashing to create a secure login
I am creating a login for an encrypted chat application which retrieves login information from a MySQL database. I have got to the point where I feel pretty confident that (to the best of my knowledge)...
- 13