Questions tagged [crud]

The four basic operations for a data management system: Create, Read, Update, Delete

Filter by
Sorted by
Tagged with
14
votes
1answer
478 views

Example script for teaching DDL and CRUD/DML operations

I have taught some SQL to others before, and I thought of making a script that has these attributes, for the purposes of teaching: Fully functional to run on local DB instance with no fuss Easy to ...
11
votes
5answers
10k views

Validation that also returns error messages

My Create, Update and Delete methods should return a ...
7
votes
3answers
1k views

CRUD operations for a contact list using PyMySQL

I am from Java background, learning Python. Please review my code and guide me to learn Python properly. This is a sample code to perform all CRUD operations of contact app. ...
6
votes
4answers
1k views

SharePoint CRUD class

I am writing an application where I have some objects like customer, supplier, product, etc. I have written a class for the object 'supplier' and wanted to ask if this is a good design. I have put in ...
6
votes
2answers
3k views

User Authentication/Permissions for PHP MySQL CRUD

I took my first stab at a user authentication function. I invented my own way of doing this. Is this a safe and efficient way of giving a user Read/Edit/Delete permission on tables in a MySQL database?...
6
votes
1answer
183 views

Simple Flask API backend to maintain a word list

I made a little toy project last semester. I would like to get some insights about my code, particularly the part of handling the database. It is a CRUD kind of traditional API. ...
5
votes
1answer
2k views

VB.NET class for MySQL CRUD

I've been using this code in a few basic CRUD (Create, Read, Update, Delete) applications, but I think it can be improved and refactored. I have 3 SELECT type functions(return a table, return a value,...
4
votes
1answer
150 views

Restful CRUD API with Node.js and Express

I build a RESTful CRUD API with Node.js and Express. This application allows, for example, to create a table on the client side with the ability to add, update and remove data by ID. I generate an ...
4
votes
2answers
197 views

ProductManager: a basic CRUD for products with SQLite

I would like to have a review of this basic CRUD application so I can improve and learn from your experience. The code can be found here. Design pattern/coding principles improvement that could be ...
4
votes
1answer
387 views

Node module for DRY CRUD endpoints

As a learning project I recently started writing a node module to generate / handle the creation of CRUD endpoints in a DRY way. The problem I was initially wanting to solve was that in my generator-...
4
votes
1answer
109 views

Simple view for CRUD with miglayout

I have created the following view extending the JPanel class, the objective of this view is to allow the user to perform 3 CRUD operations create,delete and modify on the entity "Attribute", this ...
4
votes
1answer
137 views

Code for my first crud app

I would like to ask more experienced developers to review my code, it's my first app, self-made, I know there is a lot to improve, it would be great if you could just point the main errors. I'm ...
4
votes
1answer
2k views

Flat-file DB with CRUD

I just finished writing a flat-file DB class for PHP which supports selecting, updating, inserting and deleting. I was wondering if there are any ways to make it faster or if I'm doing anything the ...
4
votes
0answers
7k views

Simple MVC CRUD with JDBC

I would like to review my simple piece of code. I am beginner (I learn java for 1 year) and I would like to find out whether I am on good way. I have created simple MVC CRUD java app "ProductManager"....
3
votes
1answer
259 views

C in CRUD for Silverlight

The C in CRUD Silverlight: Create new Silverlight business application "CRUD" Add ADO.NET Entity Data Model to CRUD.web Select the db, the tables, build the project Add Domain Service Class to CRUD....
3
votes
1answer
171 views

Rest Api with generic crud operations

I am learning how to create a rest api in which I've decided to use generic for crud operation. I am attaching the code which I have written so far. Please have a look. Thanks for the review in ...
3
votes
1answer
122 views

Linq-to-Sage: CRUD Operations

Following-up on my Linq-to-Sage implementation, I ended up implementing all CRUD operations, following the Sage 300 view protocols. So, the entities derive from classes that look like this: ...
3
votes
1answer
392 views

UserDAO with CRUD functionality for my UserRepository

This is my first attempt at creating a DAO. I would like to get some feedback regarding the following aspects if possible: Code readability Efficiency Usability I also would appreciate any other ...
3
votes
1answer
177 views

Redirecting the web client after deleting an item

In my web-app, it is possible to delete an Item when visiting any of 4 different pages: the Show Item page the Edit Item page the List Items page the List Items in Room page If the visitor uses a ...
3
votes
1answer
348 views

Repository/persistence-service implementation

I have the following situation: I have... Models like ServerRoom and ServerCabinet ...
3
votes
0answers
50 views

F# method to insert, update, or delete events in a dictionary

I have the following code: ...
3
votes
0answers
89 views

Fulfillment webhook with Dialogflow to operate on a Firestore database

I'm currently calling a fulfillment webhook with dialogflow in my node backend, performing crud operations on a firestore db. Is there a better, cleaner way to ...
3
votes
0answers
42 views

A simple list of objects to display and edit with Angular

I want to create a simple CRUD app using angular on the frontend. I'm not really happy with the logic here, it seems a bit convoluted for fairly simple functionality. ...
2
votes
2answers
405 views

CRUD operations for a patient database

My code performs CRUD operations in PHP using OOP and dynamic queries. How can I completely separate HTML tables from this code? Db.php ...
2
votes
1answer
887 views

Basic CRUD application for Product, Category & Location with SQLite

I improved the code from my previous question. At this moment, the 3 entities have not yet a connection with each other. They should only be available for CRUD actions in a SQLite database. I would ...
2
votes
1answer
111 views

Controller.js of CRUD vehicles

I never took an application in a Model-View-Controller architecture and have some difficulties in front-end. The following code works fine, but what can I do to make "layers" of better code and even ...
2
votes
1answer
835 views

Angularjs CRUD views, controllers, navigation

I just started to learn AngularJS. I created a simple site using ASP.NET MVC as a backend. I created 1 main view and 4 partial views for the CRUD operations with a Company Entity. In the main page I ...
2
votes
1answer
3k views

Separate model from DB mapper (entity manager)

I've read that it is good to separate model from DB mapper (entity manager) (but at the end, it is perhaps personal - just a matter of opinion). Anyway, if I understood correctly, I should not have ...
2
votes
1answer
126 views

A color class and a CRUD class for it

Is it better to have only one class color and include the functions from the second class in the 1st one? Or leave them apart? Why is one better than the other or ...
2
votes
1answer
678 views

CRUD app for managing customers

I am practicing using the Prototype pattern and to do so, I am building a simple CRUD app that allows me to view, add, and delete customers. Here is a JsFiddle for you to see what I've got so far. <...
2
votes
0answers
105 views

Implementation of CRUD todo list

We have a todo list, which by default holds two of them. The newTodo means what has been recorded in the input form to be the next todo to be added. needsUpdate and idOfTodoToUpdate are used to handle ...
2
votes
0answers
44 views

CRUD UI for managing banners in React

How can I improve this code? I am a beginner learning react. This is a UI for managing banners. Users upload the image for the banner and specify a start date and end date between which the banner ...
2
votes
0answers
307 views

A clean way to do CRUD with pagination

What do you think about the following approach to CRUD? Here is the reading+pagination example. DTO types have Dto* prefix, EF Entity Types have E* prefix. DAL example: ...
1
vote
1answer
80 views

Simple CRUD back-end for an inventory-tracking web API

This is the simple back-end, albeit crude, that I made for a React Native mobile app project as a proof of concept. It's a basic CRUD for tracking supply inventory. The "shopping list" is items with a ...
1
vote
2answers
227 views

CRUD menu creation

I would like to re-write this C# code so it is easier to understand. Should I create a separate function to configure a menu item? Is there is some kind of using ...
1
vote
1answer
6k views

EF entity, extended with partial classes for actions

Me colleague and I recently had a discussion on good practices in EF. So I showed one of mine. He said it is a little bit muddler. My practice consists of modifying the autogenerated class in a ...
1
vote
1answer
3k views

Reusable project for CRUD

I wrote this class to make it reusable in any project. It uses PDO as the MySQL connection. Beside not using Setters and Getters, is this code secure and good practice for CRUD? ...
1
vote
2answers
819 views

Preparing code for more versatile CRUD functions

I am using C# and the .NET entity framework, and I'm also learning how to better use OOP concepts in my program. My code is all displayed below. I would like to ensure my logic is properly organized ...
1
vote
2answers
170 views

Design Pattern to Add, Edit and Delete Records

This code allows Add, Edit and Delete a database record for the Category table. Separate Service classes are implemented to handle these operations which are called ...
1
vote
0answers
155 views

Handling CRUD methods with gorm and go-swagger

I've an application that uses gorm and go-swagger for a simple API. One of the route's handlers bloated to 66 lines, being ...
1
vote
0answers
105 views

Edit js CRUD table with using popup

I created JS CRUD table with the ability to edit with popup. This is part of the code for editing. Editing includes the following steps: click button "edit" in the row of the table with selected data ...
1
vote
0answers
69 views

CRUD in JSP AND SQL

I would like to simplify my code when I add an entry. All is OK for 1 table (table = "ecole"). I can add an entry without problem. My problem is that I will wish to add a second table named "nom" in ...
1
vote
0answers
316 views

Extend the Laravel Eloquent model in order to easier implement CRUD REST for my routes

By extending the Model and using this inside my routefiles, I can easily call these functions inside the corresponding HTTP ...
1
vote
0answers
178 views

Update operation with hibernate

I am creating a project about hotel reservations. I created a udirection one to many relationship between users and reservations. That is, A user can have many reservations. Here is the User class. <...
1
vote
0answers
103 views

Folder model controller view

I'm using a slim router and have made a folder model controller view. Below is one of my model files. I made one database with one model. I have some problem in my project: there are several ...
0
votes
2answers
193 views

CRUD App in Haskell with Servant/Opaleye

I was trying to learn how to use libraries like Opaleye and Servant. I wrote this toy Create/Read/Update/Delete App. ...
0
votes
1answer
713 views

Simple PHP CRUD application with Google Maps

I've got some experience with Laravel but for fun I started a small project (basically a CRUD with also Google Maps) without a framework because I considered that is oversized. This is the directory ...
0
votes
1answer
46 views

Watch for CRUD state changes and make sure only one is active at once

I'm using AngularJS and I have a watch task in my controller that needs to be dried up if possible. Basically it watches for state changes in my front end. I have 3 buttons: add, edit, and delete ...
0
votes
1answer
162 views

Naming a complex crud function

I have a function below that does the following uses a bunch of smaller CRUD operations which I call create, ...
0
votes
0answers
31 views

Simple laravel class for data save, validating and search, with controller

Order class - stores data, validates it, saves relations data, returns search data: ...