All Questions
26 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
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
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
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
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
4
votes
1
answer
537
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
73
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
194
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
296
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
1
vote
1
answer
114
views
My Python 3.6 script to detect stamp card redeem fraud and prepare a csv report
I have a requirement to write a Python 3.6 script which should be able to detect following case within a time period and be able to create a text file report that lists the condition violated and ...
- 21