Questions tagged [orm]

Object-relational mapping (ORM) serves as an efficient approach to connect object-oriented systems with relational databases. Incorporate specific tags like [java], [sql], or [python] to denote the programming language, while mentioning relevant database systems such as [postgreSQL]. Additionally, utilize tags like [django] for content management systems, [flask], [spring], and [laravel] for frameworks, and [android] or [node.js] for application environments. These tags aid in easy discovery and attract interested viewers.

Guide to conducting Drizzle Migrations in SQLite with Docker for a live database on a Virtual Private Server with Next.js

Planning to conduct a Drizzle Migration on Production through a VPS. Facing limitations with executing two commands pnpm db:migrate:prod and pnpm start simultaneously in a Dockerfile. Dockerfile # Seeking guidance on running `db:migrate:prod`. CMD [" ...

Tips for managing @ManyToMany relationships in TypeORM

In this scenario, there are two distinct entities known as Article and Classification, linked together by a relationship of @ManyToMany. The main inquiry here is: How can one persist this relationship effectively? The provided code snippets showcase the ...

javascript node.js orm nestjs typeorm

What exactly does the Doctrine query builder serve to accomplish?

What are the benefits of using Doctrine to construct queries like this: <?php // $qb instanceof QueryBuilder $qb->select('u') ->from('User u') ->where('u.id = :identifier') ->orderBy('u.name ASC& ...

php orm doctrine query-builder

One-To-Many relationship facing issues with Django foreign key integration

Can someone help me with a query that fetches an artist's information and all of their pieces when the artist ID is searched? Essentially, I need a join query between Artist and ArtistPiece. #models.py class Artist(models.Model): name = models.CharFie ...

python django orm

Filter Laravel Eloquent relationship based on the latest pivot record

I have a scenario with 3 tables: user, role, and the pivot table named user_role. The user and role tables have a many-to-many relationship. In addition, every assignment (role to user) in the user_role table includes a timestamp, allowing me to determine ...

php mysql laravel orm eloquent

Leveraging ORM for a multilingual platform

My request for recommendations revolves around using ORM instead of MySQL with PHP. I have been a CodeIgniter user, but now I am looking to switch to FUEL (http://fuelphp.com), which offers its own ORM solution. The challenge I face is that a significant ...

php orm localization

Is there a way for me to change related_name in inherited or child objects?

Consider the given models: class Module(models.Model): pass class Content(models.Model): module = models.ForeignKey(Module, related_name='contents') class Blog(Module): pass class Post(Content): pass I am looking to retrieve al ...

python django orm

Filtering relations in TypeORM can be achieved by using various query criteria

Hello, I have a couple of questions regarding TypeORM in TypeScript. Using Find() Only: I have two tables in my database - Users and Sessions. I am interested in retrieving a specific User along with all their Sessions where the sessions_deleted_at column ...

node.js typescript express orm typeorm

Is the security of Redbean ORM reliable in PHP?

I'm considering using RedBean as my ORM-mapper. Currently, I have my own implementation, but it's becoming less effective and efficient as the project grows in size and complexity. However, there is one question that remains unanswered: How secure is Re ...

php mysql security orm redbean

Using a primary key in a relational database is crucial when utilizing an ORM tool such as Sequelize

As of now, I am involved in a nodejs project that involves utilizing Sequelize ORM to communicate with a Postgres database. When working with ORM like sequelize, should I utilize custom fields as primary keys in the database tables or stick with autogenera ...

node.js postgresql database-design orm sequelize.js

Is it necessary for me to specify models in sequelizejs?

After spending some time experimenting with expressjs, I am now looking to connect to a mysql database. I typically use MySQL Workbench to create my database tables because of the ForeignKeys feature it offers. I haven't yet discovered how to replicat ...

mysql node.js express orm sequelize.js

Prisma financial deal

I am attempting to upsert data and then iterate through an array to upsert values from another table. model ProductVariant { id Int @id @default(autoincrement()) name String @db.VarChar(50) photos ...

node.js next.js orm prisma

Issue encountered during deployment on Google App Engine

I've been encountering an issue while trying to deploy my Node.js application with MySQL Backend to Google App Engine. I am utilizing Sequelize ORM and have both the Cloud SQL Instance and App Engine within the same project. However, upon attempting t ...

node.js google-app-engine orm google-cloud-platform sequelize.js

Performing a single query in Django to join model attributes using select_related

Seeking an ideal solution to retrieve attributes on a join model with a single query. The models relationships are as follows: class Player(models.Model): first_name = models.CharField(max_length=30) last_name = models.CharField(max_length=30) ...

python django orm django-select-related

Strategies for effectively choosing this specific entity from the repository

Is it possible to choose the right entity when crafting a repository method using typeorm? I'm facing an issue where I need to select the password property specifically from the Admin entity, however, the "this" keyword selects the Repository instead of t ...

typescript orm nestjs typeorm bcrypt

Using LARAVEL to connect to mariaDB and SQL Server databases with DBF tables

I have just discovered a method to connect FoxPro tables with MariaDB Server by utilizing ENGINE=CONNECT. By using MySQL WorkBench, I am able to perform insertions, updates, and deletions on existing DBF tables. After following the instructions in the tu ...

php laravel orm mariadb dbf

Is there a Node ORM that supports application-side joins?

Initially, I experimented with Loopback and found it to be a useful tool. However, one limitation I encountered is that it does not support relationships across multiple REST data services. Instead, Loopback makes a call to the initial data service and pas ...

node.js amazon-web-services orm microservices loopback

Filtering nested relations in Laravel

Is there a way to filter query results by translation relation (specifically the name column)? $item = Cart::select('product_id','quantity') ->with(['product.translation:product_id,name','product.manufacturer:id,name&a ...

php laravel eloquent orm

Is it possible to track down the usage of the var_dump function?

Recently, I started experimenting with Laravel 4 and came across an issue while using the ORM to create a new user account. After executing the code, the following output was displayed on the page: array(1) { [0]=> object(stdClass)#103 (1) { ...

php orm laravel eloquent

Relationship mapping for a singular inheritance entity using a one-to-many association

I am encountering an issue with the single table inheritance mapping for Doctrine ORM, also known as STI. It appears that having a one-to-many association from the STI entity to another entity is not possible. I have two entities named Customer and Suppl ...

php symfony orm doctrine sti

Sequelize Error: The WHERE parameter for 'email' is throwing an error due to an invalid value of 'undefined'

Currently, as part of my Node.js application, I am using Sequelize to develop a user registration feature. However, I seem to be facing an issue when attempting to verify the existence of a user based on their email address. The error that keeps popping up ...

javascript express orm sequelize.js

Synchronizing with Sequelize ORM is not possible using the sync() method

In the excerpt above, the file uses db as a variable from db.js, which is responsible for connecting to the database. The connection works without issues. const Sequelize = require("sequelize") const db = require("../database/db.js") module.exports = db. ...

node.js express orm synchronization sequelize.js

Configuring TypeORM in a Next.js project

I've been trying to set up typeorm (postgresql) for Next JS for a few days now without success. Most guides out there focus on using prisma with Next JS. Here are the steps I followed: I installed pg, reflect-metadata, @types/react, @types/node, typeorm ...

orm next.js typeorm

Comparing Doctrine's Data Insertion Methods: Repository vs Entity

I have come to realize the distinction between a Doctrine repository and a Doctrine entity. While attempting to carry out basic CRUD operations on a table, I mistakenly injected a default Doctrine repository into my controller without injecting an entity. ...

php orm doctrine-orm zend-framework2

What is the top-performing PHP ORM for CodeIgniter?

Can someone recommend the ideal ORM for the codeigniter framework? I came across some related inquiries, but they were outdated, and the link provided was broken. Any guidance on this matter would be greatly appreciated. ...

php codeigniter orm frameworks

Encountering issues with Sequelize js when using the Having and Group by functions

Could there be a potential issue with my ORM query? My goal is to utilize sequelize's group and having functions to filter Reservation dates that have more than 30 records: SELECT "reservations"."reservationDate" FROM reservations, ...

node.js postgresql express orm sequelize.js

Utilizing SQL (specifically MySQL) to generate categories and products in Magento 1.9

My product list is quite large (10000 items) and using ORM for adding a new category and product is proving to be very slow. I am considering utilizing SQL for direct database access instead. However, with numerous tables to navigate, I am unsure of whic ...

php mysql sql magento orm

Attempting to utilize .hasMany with an entity that does not qualify as a Sequelize.Model subclass

I'm encountering an issue while trying to establish a foreign key relationship between two models. The error message I am receiving is as follows: throw new Error(this.name + '.hasMany called with something that\'s not a subclass of Se ...

mysql node.js orm sequelize.js node-modules

Creating a JSON object by utilizing database relationships and foreign keys in PHP

Seeking assistance with a task. The task involves establishing a simple mapping relation (FK) between two databases and then converting this data into JSON format using PHP. Consider the following abstract database structures: 1: Customer +-------+---- ...

php json database orm foreign-key-relationship

Removing associated data in Laravel 5.1 using Eloquent ORM

In my application, I have a customers model that has many Locations, and each Location has many contacts. I am looking to delete a Customer along with all its associated locations and contacts. Currently, the code below successfully removes the locations ...

php orm eloquent laravel-5.1 relationship

"Prisma encountered a roadblock when attempting to update a record, citing an issue with the unique constraint that resulted in

I have a prisma schema setup for Postgres database: model Member { id String @id @default(uuid()) token String @unique @default(uuid()) summary Summary[] } model Summary { id String @id @ ...

database postgresql next.js orm prisma

The datatype of an array in a Doctrine model

I am relatively new to using Doctrine, particularly when it comes to creating a MongoDb Model/Collection. I have a field called languages that needs to be an array structured like this: $var = [ array("fname"=>"test","lname"=>"test"), ...

php doctrine-orm orm doctrine

Can AdonisJS 4.1.0 support conditional queries?

I am exploring the capabilities of AdonisJs query builder by referring to their documentation at Currently, I am attempting to replicate a scenario similar to the one demonstrated under the 'Conditional Queries' section: const query = Database. ...

javascript database orm adonis.js

Using Sqlalchemy to apply a filter on an object

I am currently working on a script that will test various conditions of objects within a SQLAlachemy ORM driven database. The dynamic nature of this process has presented some challenges for me. My goal is to query the minimum number of objects for all te ...

python filter orm sqlalchemy python-3.6

Newtab Q&A