All Questions
208 questions
0
votes
0
answers
74
views
Notes not showing up on Main View (Flutter App)
Ive been following freecodecamp 37 hour flutter course by Vandad.
The course was running smoothly without any problem until 21:50:42, when he teaches how to show all notes in main ui. Ive wrote the ...
0
votes
2
answers
117
views
.NET / EF Core CRUD The database operation was expected to affect 1 row(s), but actually affected 0 row(s);
I'm creating a new project trying to use Generics as much as possible, but I've encountered an issue when doing HttpPut and using EF Core.
I'm using SQL Server in a container to store temporary data.
...
- 27
0
votes
0
answers
43
views
How to implement separate databases for each user in a CRUD web app?
I am currently building a simple crud web app for companies (user) to store their employee details. The problem is about "how do I implement so that each user can would have their own database ...
- 1
0
votes
0
answers
32
views
Many one-to-one relationships pointing to the same model Django
I'm designing an application in Django where I have an Item model with numerous attributes for each item. I'm experiencing very poor performance in my application and I'm wondering if there are flaws ...
- 1
0
votes
1
answer
64
views
Why is my PHP code not correctly updating my CRUD application?
I am trying to make a CRUD app for my business, I have little knowledge with PHP. I followed a guide that has proven to be successful until I got to the update portion.
<?php
$servername = "...
- 5
0
votes
2
answers
74
views
Having problems saving an object in Hibernate
Maybe a trivial problem, but I looked through everything I could and couldn’t find a solution
I’m trying to save a new GeologicalClass using a post request (not the best naming, but that’s the task), ...
0
votes
0
answers
91
views
SqlQueryRaw custom model class, dealing with columns of multiple data types, constructor overloading not working
(Using EntityFrameworkCore v8.0.1)
For my item management application, I would like to be able to gather the groups for each column of the database.For instance, the column "Manufacturer" ...
0
votes
1
answer
69
views
Mongoose: Deleting a value from an array in an object from a document
I would like to know how I would go about doing this.
I have a webshop that I'm working on for school. This is the category array I would like to remove from the object (the one inside "products&...
- 13
2
votes
1
answer
1k
views
Revoked All Privileges On Database But Still The User Can Create Table
I am new at Postgresql that's why I can't figure out some privileges here.
Database called Denemedb23 is already created. I created the user NoxUser.
I executed these commands:
REVOKE ALL PRIVILEGES ...
2
votes
2
answers
1k
views
Java spring JPA : Method 'PUT' is not supported
I have following problem. I just wanted to do a simple update request to my postgresql database.
But I always get following error code, if I try to test the request with Android Studio.
{
"...
- 145
0
votes
0
answers
89
views
RESTful api for database management
I have a restful api pet project and I thought I could make it better for others to use.
I'm not entirely sure about the applicability of such api but the question is whether it is supposed to manage ...
-1
votes
1
answer
134
views
How can I display book details in Laravel using Eloquent join and where clauses?
Undefined property: Illuminate\Database\Query\Builder::$title
public function show(string $id) {
$books = DB::table("book_tbls")
->where("author_tbls.id", "=&...
- 1
0
votes
1
answer
80
views
Django many-to-many formset for books and authors: only books added to database
My aim is to have a form where users can enter a book and its authors into the database using an 'Add Author' button if there's more than one author. I use a many-to-many relationship so all of these ...
- 29
2
votes
3
answers
289
views
MongooseError: The MongoDB server disallows overwriting documents using `updateOne`
I am trying to update a document in MongoDB using mongoose.
I have tried in updateOne() and updateMany() but both of them are giving same error, Apart from Put req , Get, Post, and Delete requests are ...
- 47
-1
votes
2
answers
249
views
How to get a single item(id) from search table? Laravel [duplicate]
I only need id data from a table for an insert data for another table. But I don't know how?
So I created search data request
$iduser = User::where('username','like','%' . request('username') . '%')-&...
- 33
0
votes
1
answer
43
views
How to Delete a Object from Array in MongoDB?
Here is my MongoDB Collection :
{
"_id": {
"$oid": "63e9e567a71412b168b38172"
},
"Love": [
{
"key": 1,
"title": &...
-3
votes
1
answer
40
views
i got error while rename the data in python and sqlite3
So i had a problem, i make CRUD program with python with sqlite3. im already add data to db and want to rename the data, and then im runnin the code and there appear error problem in my definition. ...
-2
votes
1
answer
107
views
How to write deadlock-proof upsert T-SQL? [closed]
For a web api performing standard CRUD operations against a database :
For the DML CUD operations I could see two strategies at the endpoint :
Strategy 1 : CUD SPs accept params for table keys. First ...
- 8,927
0
votes
0
answers
10
views
DATA Is Not Updating In The Database [duplicate]
I was following a tutorial, i can insert data and display it. But when i try to update the data, it does give me the success message, but the data doesn't change.'s still the same.
Here is the code :
...
user19468046
0
votes
1
answer
79
views
SQLALCHEMY - returning a pretty format [duplicate]
I am trying to create a basic CRUD application with python using sqlalchemy. It is just a virtual contact book, that runs in the terminal.
I have managed to create this and get it working successfully,...
- 65
0
votes
1
answer
543
views
Edit and delete row in HTML table
I am using flask and have a app.route that takes data submitted in a form and adds it to a database on AWS RDS mysql database.
@app.route('/insert',methods = ['post'])
def insert():
if request....
- 1
2
votes
1
answer
1k
views
delete data from the database using symfony
I just started learning symfony for the past couple of weeks and i've been trying to create a form to delete users from my database but the code that i've wrote doesnt work and i don't undertand what ...
user19437292
5
votes
1
answer
20k
views
Most efficient way of updating ~100 million rows in Postgresql database?
I have a database with a single table. This table will need to be updated every few weeks. We need to ingest third-party data into it and it will contain 100-120 million rows. So the flow is basically:...
- 1,075
0
votes
1
answer
55
views
AJAX fails to get data from input
I am trying to create/insert data into the database, but I am still getting an error for getting the data I've input. I tried using the dump and die method, and I encountered that no data is being ...
0
votes
2
answers
819
views
ModelService does not remove the model in groovy script
I'm trying to remove a model from database using ModelService in my groovy script but it doesn't remove.
import de.hybris.platform.core.model.order.OrderModel
import de.hybris.platform.ordersplitting....
- 11
-1
votes
2
answers
320
views
PostgreSQL database online
I am developing a CRUD in Python, which will be useful for a project. However, I want to connect the database that I currently have created in PostgreSQL to a kind of online server or online DB, so ...
0
votes
0
answers
252
views
Laravel 7 CRUD (Update) doesn't have error but db is not updating
I am trying to update a data but it doesn't change in the database. The ajax tells that the data is successful and the console did not show any error. Please help me. I need to finish this before ...
-1
votes
1
answer
37
views
How can I cancel the identityy
0
I work in asp.NetCore mvc technology. I was able to connect 2 tables according to FK and PK, When I perform an insert operation to db. The identity of my table is advanced and what happens is that ...
- 75
1
vote
1
answer
661
views
After submitting the data from the form it directs to white screen
I have an issue when I clicked the button and submit the data from the form.it gets directly to the white screen and nothing happen I checked the database it does not add. it doesn't have error so ...
- 13
2
votes
0
answers
239
views
how are Updates and Deletes handled in both Data Warehouses and Data Lakes?
I'm trying to understand how Update and Delete functions are performed in Data Warehouses, Lakes and Lakehouses.
Databricks argues that they can perform upserts easily, which I would understand as ...
- 155
0
votes
1
answer
39
views
What is the proper workflow for storing data without multiple instances of database models?
I'm relatively new to web development. I am using ruby on rails.
If I had a website with blog posts, I would have a Post model inside my DB and would CRUD instances of it. What if I had an "about&...
- 137
0
votes
0
answers
97
views
Django - Retieve Data from Reservation Form and Display back to User
Trying to pull data from my Database and display it back to the user so they can edit/delete it for full CRUD functionality. At the moment when i iterate through the reservations it comes back empty. ...
- 15
1
vote
2
answers
867
views
Update last element of a nested array in mongodb
I have tried the below query of mongoose which does not seem to work:
Model.findOneAndUpdate(
{
name: origin
},
{
$set: {
'field1.$[id1].field2.-1': "value&...
0
votes
2
answers
406
views
mySQL to PHP DropDown List with a delete button that removes entire record
Hi Everyone. I would like to create a drop down list that has a bunch of library books that comes from a table called "library" in a mySQL database.
I was able to create an add book to the ...
user14310306
-1
votes
1
answer
105
views
Not removing from database
My code does not remove any row from the database. These rows were shown in the listview in forms. They can be remove and disappear from the listview in the form but they are not removed from the ...
1
vote
0
answers
178
views
How to make data in typescript?
I'm currently trying to make a create function but there are some problems.
So first i made an input in the .html file.
<ng-template #formFieldTemplate let-form="form" let-field="...
- 27
0
votes
1
answer
195
views
Packaged application for CRUD operations on a database [closed]
I know that there are many tools for the visualization of databases such as metabase, grafana, tableau, superset ...
But I don't know of any packaged software that allows CRUD operations (crete, read, ...
- 3,444
0
votes
2
answers
159
views
Error Querying OrientDB: Cannot query demodb database
Hi i'm new to OrientDB and i'm having querying errors with the latest version 3.2.2. GA Community Edition.
When using the default database "DemoDB" and going to the graph tab, using the ...
- 37
0
votes
2
answers
2k
views
The this.http.post() gives a 404 (Not Found) error
I'm currently trying to make a create function(to make a quote) with a server in angular.
So i made a form with an input in the html file.
<form [formGroup]="addquoteform" (submit)="...
- 27
0
votes
1
answer
880
views
How to update tables with many-to-many relationship when performing crud operations in Spring Boot
I'm trying to create a Spring Boot backend for my project. In the database I have Deck and Word tables with a many-to-many relationship connected via DeckWord table. The bridge table has additional ...
- 69
-1
votes
1
answer
23k
views
Warning: Trying to access array offset on value of type null in C:\xampp\htdocs\crud\read.php on line 41 [closed]
I want to create a website that can do the basic my SQL functions like create, read, update and delete and I was working on the read page when I got this error:
Warning: Trying to access array offset ...
0
votes
0
answers
80
views
How to update many-to-one entities correctly - how to update Order with OrderItem
I would like to ask about the concept, so pseudo-code or example in your preferred language should be enough.
Problem:
Let's say, I have two entities. Order and OrderItem. Order has many OrderItems. ...
- 85
-1
votes
1
answer
119
views
button react js doesn't work but it is the good code
I'm following this video to make a crud in React Js.The problem is at 13 minutes.
https://www.youtube.com/watch?v=-quobUzNmuA
I copy his code but it doesn't work. I don't understand why.
My ...
- 3
0
votes
1
answer
77
views
(CRUD) How to know which database records to target from html rows
Been googling and trying all kinds of things but still can't figure it out.
Suppose i have a html form which has a table with lines (and input fields) in it. The lines have been populated by database (...
- 471
3
votes
0
answers
784
views
Benefits of Hash and UUID for python database?
I am learning python and I came across a code (*) that uses Hash and UUID for storing data in python.
Below is a simpler excerpt for the topic in question.
Basically, when data is passed to DataBase, ...
- 625
1
vote
1
answer
882
views
Generate custom id
I need to generate custom id (which is primary key) based on 3 other columns from this table. Those 3 columns are hashed and as a result I get id as a primary key. Can I do something like this using ...
- 113
2
votes
0
answers
61
views
Making sure CRUD operations either fully success or fully fail
My app will use MongoDB as a database and Firebase Storage for storing images (although the question is actually general to any 2 different databases used in the same app).
I'm looking for the correct ...
- 634
0
votes
1
answer
136
views
How to check for dependency in database?
I have another question!
My CRUD webapp is almost there, I do have a problem writing queries for my database!
Database has 3 tables: Department, Location, Personnel.
Relationship is retrieved by using ...
1
vote
1
answer
263
views
How can I update changes in a Table (rhandsontable package) to a PostgreSQL database?
I have a very simple shiny App, where I Just display a Table (rhandsontable) with some values. The table is connected to a PostgreSQL database. I just need to know, how can I update the Table to the ...
- 21
0
votes
2
answers
597
views
Flutter CRUD offline
I need to create a CRUD in Flutter that connects to an online database but if it loses the connection it can work with a local database but when recovering the connection it can send that data to the ...
