Questions tagged [orm]
Object-relational mapping (ORM) is a technique for mapping object-oriented systems to relational databases.
23 questions
1
vote
3
answers
154
views
Inventory Management System
I'm trying to learn Django by building an inventory management system, here's my final models.py.
I'm looking for feedback!
...
- 325
0
votes
1
answer
134
views
Validating an input in a chatbot
Is this a good approach for validating user input in a chatbot? I am writing an autoposter telegram bot in PHP using the php-telegram-bot library (by Longman). I have a Task class that stores ...
1
vote
0
answers
236
views
write a wrapper for cosmos db calls to use the results as objects in python (technically an ORM)
As part of a larger program, I'm trying to find the cleanest way to architecture my program to query a cosmos db and use its return values (dict objects) as easy to manipulate and maintain objects in ...
- 111
2
votes
1
answer
84
views
Object relational mapper - optimize in memory data representation and code improvements
An Object-relational mapper built using php.
This was done for educational purposes, and curious to know what kind of improvement has to be done to use in production.
Please refer to the complete ...
- 39
0
votes
1
answer
203
views
django multiple if else refactor
I have a function with multiple if else statements that I'm trying to simplify in Django
Is there a pattern or maybe a better modeling approach that I could use here?
The idea behind is to have a ...
- 123
3
votes
1
answer
113
views
Flask Database Design with ORM
I am designing a Stock Currency application and for that, I created a database.
I searched for my question here first but the answerer told me to ask the same question here.
...
- 141
2
votes
0
answers
2k
views
Providing different __table_args__ to SQLAlchemy mapped class depending on backend DBMS
I need to set different __table_args__ for the mapped class depending on the backend DBMS, e.g. mssql and ...
- 21
2
votes
1
answer
592
views
Rails model for aggregate data instead of a real table
I have a rails app with a Project model. Each project has usages which is numeric data.
I need to get all the usage for each month and year. I also need to get usage for specific months and years ...
- 171
1
vote
0
answers
166
views
Database connector in Python
I've been trying to build an ORM. I started with the connector layer, which is responsible for the database server connections and executes raw SQL as the code below shows.
I have built the ...
- 11
2
votes
0
answers
55
views
Sharing model for different ORM's
I am building a MySQL to Realmdb converter app.
I use Entity Framework to deal with MySQL, so below is the code of one of my model classes. I don't want to have multiple classes representing the same ...
- 121
7
votes
3
answers
3k
views
Unit testing a REST API in Go
I am learning Go by writing a simple CRUD REST API using gotilla/mux and Gorm.
I would like to get some feedback on the application code and on unit tests in particular. Please suggest me what to ...
- 343
4
votes
1
answer
199
views
PHP - Saving inbound email and its attachment
I have the below code, which handles inbound emails in my application, saves the actual email content (text + attachments) to my database, and the saves the actual attachment files on the server.
In ...
- 287
3
votes
0
answers
10k
views
Mapping Entities to DTOs in TypeScript
In a recent project my backend architecture consists of
Repositories (talking to database)
Services (handling business logic)
<...
- 131
3
votes
0
answers
737
views
GUI to control a NZXT cooling and lighting system
I am working since a couple of weeks on my first Python application and I would love to have a review of the code I wrote so far.
The app has the purpose of controlling the cooling and lighting of an ...
- 131
2
votes
1
answer
70
views
Displaying a user profile based on a mock ORM
Overview
We are learning PHP OOP and decided to create a simple app with 3 database tables, one a basic users table, the other two containing information about the users' favorite food and favorite ...
- 181
2
votes
1
answer
806
views
Password field based on peewee ORM framework
I implemented a password field based on the peewee framework to handle passwords of accounts in web applications for Python 3.4.
My goals were
Secure hashing.
No plain password leakage.
Easy ...
- 6,211
0
votes
1
answer
54
views
Is using beforeFind() event in background to dynamic update SQL queries a good practice? [closed]
I have a Projects table, which I need to ORDER BY code column. But problem is ...
user34182
3
votes
0
answers
379
views
Flask-SQLAlchemy model structure
I'm seeking a review of my Flask-SQLAlchemy model structure, particularly adherence to DB best practices, such as avoiding duplication, etc.
The models represent the relations between Departments, ...
- 31
5
votes
0
answers
2k
views
Implementing an enum field for peewee.Model
I implemented an enum field class EnumField inheriting from peewee.CharField.
The reason that I use a character-based field is ...
- 6,211
3
votes
0
answers
942
views
Implementing a JSON-serializable ORM model
I implemented a library which, amongst other things, implements a JSON-serializable ORM model based on the peewee framework.
Here's the relevant excerpt:
...
- 6,211
7
votes
2
answers
11k
views
Building a simple ORM in PHP
I have been curious about how ORMs really work under the hood so I decided to do something simple in PHP.
So I basically built two Interfaces: DatabaseInterface and the ORMMapper interface and two ...
- 71
5
votes
3
answers
3k
views
A demonstrational example of a Data mapper ORM
I want to create an educational example of a Data mapper type ORM. You know, it is always interesting to know how the stuff works, but when you take a fully functional software package, it's just ...
- 8,823
4
votes
1
answer
5k
views
