All Questions
Tagged with sql object-oriented
29 questions
2
votes
1
answer
178
views
Prevent Column Name Collision
I have been working on a series of posts about a library to connect to databases but most of the scenarios I have to resort to some "JOIN" the problem arose when two or more tables had some ...
3
votes
1
answer
152
views
New in PHP OOP and need opinion am I doing it the right way
I am new to using PHP OOP and decided to start learning by converting something I wrote in procedural PHP. So now I need your opinion and recommendations for my first work.
One of the main reasons I ...
2
votes
0
answers
688
views
6
votes
1
answer
319
views
OOP Python Blackjack game with player accounts in PostgreSQL
This is an OOP version of Lastest version of my Blackjack game. Also, it now uses PostgreSQL as database.
...
2
votes
2
answers
89
views
ORM class for Posts
I'm new to PHP OOP and I'm making some tests. I have 2 classes: database and posts and the two interact with each other.
Class Database:
...
6
votes
1
answer
193
views
Polymorphic Data Socket Factory with Query Contingency Protocols in Python
I work on a small data team where we developed this tool when we began experiencing several job failures on our legacy big data systems. We have several data lakes, each with their own API, and until ...
2
votes
0
answers
1k
views
Kotlin DAO with Exposed: How to reduce redundancy in classes?
I'm writing a Kotlin app that uses Exposed (https://github.com/JetBrains/Exposed) as a SQL wrapper to write and read objects from databases. The problem I'm facing is that I end up with 3 classes ...
2
votes
0
answers
84
views
One class for MySQL and MSSQL Queries
EDIT BELOW
I am trying to create resusable classes for MSSQL and MySQL queries (later also Update and Delete queries). I tried it doing the OOP-way. Here is my result:
Einstellungen.vb:
...
4
votes
1
answer
25k
views
Basic object-oriented PHP login, logout, and registration scripts
I am new to OOP in general and have recently started trying to develop object-oriented PHP code instead of relying on a primarily procedural style, as this is a requirement for my studies. One part of ...
1
vote
1
answer
4k
views
PDO Dynamic query builder
I'm trying to improve my php oop programming skills. As an exercise I wrote this class that will generate and execute dynamic sql queries. I've also writed a class to call various sanitization filters ...
4
votes
1
answer
121
views
Class to build and execute dynamic SQL statements
I'm uncertain about proper OOP design since my teachers are explaining OOP very vaguely. Do I need to use the constructor and the mutators like this or am I better off removing the constructor and ...
4
votes
1
answer
311
views
App to manage a football tournament database
My question is all about class design.
I have this app that is connecting to a SQL server, retrieving some tables, the user works on the data, and then it updates the database.
I should say that all ...
1
vote
1
answer
821
views
Data Access Layer (object oriented)
I am using a global class (like a global model) that acts like a sql abstraction layer for my application. I am using it without problems now, but since the application I am creating is getting bigger,...
1
vote
2
answers
3k
views
SQL Query Builder in PHP
I have made a Query Builder, (not the full version of it yet) but I wanna ask if there is someone out there, there can improve this code even more. Will be nice to know so I can code the rest in the ...
4
votes
1
answer
291
views
SQLite database for books
First, my Book object:
...