All Questions
26 questions
2
votes
2
answers
157
views
SQLite querybuilder class in python
Motivated by the first commentor's suggestion on my MSAccess question:
Python SQL insert to MSAccess with VBScript
I am moving to use SQLite databases for a python application and I created this query ...
- 103
4
votes
1
answer
113
views
Python SQL insert to MSAccess with VBScript
I have a business use case that required running SQL insert queries to a local MSAccess database with a Python script. The actual script does many other things and the SQL function is just one of them,...
- 103
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
1
answer
72
views
Functional Python Script to write a large amount of CSVs to database
I just finished up this script that crawls hundreds of local git repos for csv files and then stores them into a database. I've tried to follow a "functional" paradigm for this script but am kind of ...
- 235
4
votes
1
answer
575
views
Script to push data from one database via api to another
I'm still a beginner so any pointers to make this code more professional/production ready are appreciated. The tokens and database connections have been anonymized.
The script is working, its goal is ...
- 95
5
votes
1
answer
153
views
Excel to SQL server
I am self-taught when it comes to coding. I want to improve, so please give me advice if I have some bad habits or if there is in general a better way of doing this.
The idea of this code is to look ...
- 153
5
votes
2
answers
99
views
Add as newest ID to SQLite Database
At our company we use an SQLite Database to manage our Drawing IDs (CAD Drawings). The code is written in Python and I need to update it. I think the code I have has some problems, but I am quite ...
- 357
2
votes
1
answer
90
views
Remapping property IDs when inserting CSV data to a database table
My code is functioning the way I'm expecting, with the if. However, it is not pythonic to me, and that bugs me.
The multiple if in the code below are supposed to ...
- 622
3
votes
1
answer
217
views
SQL queries in a dataframe
I want to get table names and column names from queries in a dataframe. The dataframe is like this:
...
- 185
4
votes
1
answer
72
views
JSON from SQL Server: Reduce lists of single dicts to list of values
SQL Server 2016 introduced some JSON features, but they're far from robust. As far as I can tell, there's no way yet to output a simple array; everything must be in ...
- 143
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
0
answers
44
views
spark takes long time for checking an array of items present in another array
I am new to spark. I have two dataframes df1 and df2. df1 has three rows. df2 has more than few million rows. I want to check whether all items in df2 are in transaction of df1, if so sum up the costs....
- 131
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