Questions tagged [crud]

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

The four basic operations that can be used on a relational database table are

  • C reating
  • R eading
  • U pdating
  • D eleting

A CRUD application is one that performs these basic operations. A CRUD framework is an application framework that gives these functionalities as a base for the development.

Also see: , ,

4608 questions
13
votes
5 answers

Magento - Module INSERT,UPDATE, DELETE, SELECT code

I created a module and want to used core write and read function to insert,update,delete or select database value with condition, how can I do it without using SQL? Example: $customer_id=123 Model=(referral/referral) SELECT $collection3 =…
Lim Heng Cheun
  • 229
  • 1
  • 3
  • 13
12
votes
3 answers

UI Design of WinForm CRUD App, What works?

I am designing a WinForms CRUD "like" app for a large group of Nurses and Social Workers to interact with Client information. There are many different forms(about 30ish) that they need to "possiblly" interact with for any given client and they…
Refracted Paladin
  • 12,096
  • 33
  • 123
  • 233
12
votes
1 answer

PHP CRUD JSON file instead of a database like mysql

I'm in a bit of pickle, I received a request to create CRUD app to edit JSON object in an array and upload them. I did a bit of research and came across http://www.taffydb.com/ but it doesn't really fit my requirements. EDIT: I also came across…
fupuchu
  • 307
  • 1
  • 2
  • 11
12
votes
4 answers

is there a good PHP CRUD code generator?

Is there any better PHP CRUD code generator? I want to get Data Access Object, Business Object and Value Object. It would be difficult to match my needs, but I am happy at least I can get any relevant one. [EDIT] I am working on an MVC based…
Muneer
  • 7,384
  • 7
  • 38
  • 62
11
votes
1 answer

How To Create Generic Data Access Object (DAO) CRUD Methods with LINQ to SQL

I am new to LINQ to SQL and attempting to create a generic Data Access Object (DAO) for the basic Create, Read, Update, and Destroy (CRUD) methods so that I can reuse the code. I was successful in creating a generic method that will delete any…
Grasshopper
  • 4,717
  • 9
  • 36
  • 62
11
votes
1 answer

Overriding Angular's Service Worker to handle POST requests

I have an angular/nodejs application in which a User can see a list of resources, update them, create them, and delete them (a basic CRUD application). I want to turn this into a PWA so the user can work offline. It must : Cache the assets (html,…
11
votes
8 answers

Rails: Prevent duplicate inserts due to pressing back button and save again

Think about a simple Rails scaffold application with a "new" action containing a form to add records to a database with a "save" button. After the "create" action the controller redirects to the "show" action, where the user can use the "edit" link…
Georg Ledermann
  • 2,712
  • 4
  • 31
  • 35
11
votes
4 answers

Is there a tool or framework to Generate a CRUD UI in Swing?

I am looking for a tool/framework to (automatically) generate a Swing user interface to perform CRUD operations on an underlying database. I would also like to configure the database fields that should be exposed. Something like django (via…
Guido
  • 46,642
  • 28
  • 120
  • 174
11
votes
5 answers

getting Gii to work on Yii 2.0

i downloaded the advanced template, extracted it and changed the root documents for the back-end and the front-end, but i can't seem to figure out how to get Gii working to perform the crud operations. there is require and require-dev field in the…
tareq
  • 1,119
  • 6
  • 14
  • 28
11
votes
3 answers

Custom queries with CrudRepository

I would like to custom my queries with CrudRepository : This is my code: @Repository public interface CustomerRepository extends CrudRepository { @Query("UPDATE customer c SET c.firstName = :firstName WHERE c.id = :id") Integer…
user2931656
  • 253
  • 2
  • 3
  • 13
11
votes
4 answers

Django: The best practice to implement CRUD outside the contrib.admin

I'm currently developing a Blog project using Post model, which will be used by multiple authors. I want to make an admin/control-panel interface where each author of the Post can view the Post list the author created (so he won't see the Post…
Adrian Liem
  • 251
  • 1
  • 3
  • 11
10
votes
2 answers

Dapper and Oracle CRUD issues, how to?

How do i make Dapper.NET to CRUD my Oracle DB? I have table named: PLAYER_LOG it's identity is done by trigger, here is the sql SELECT SQ_MASTER_SEQUENCE.NEXTVAL INTO tmpVar FROM dual; :NEW.ID := tmpVar; my Model is: public class PlayerLogStorage :…
hackp0int
  • 4,052
  • 8
  • 59
  • 95
10
votes
10 answers

What would you name this CRUD class?

Trying to avoid the SomethingManager trap here... Let's say I'm going to write a User editor which will allow administrators to create users in the system. Pretty basic functionality - view a list of existing users, create a new user, update an…
MrDustpan
  • 5,508
  • 6
  • 34
  • 39
10
votes
5 answers

How to set a default value in Symfony2 so that automatic CRUD generated forms don't require those fields?

As I've already found out, Doctrine2 "does not support to set the default values in columns through the “DEFAULT” keyword in SQL. ... you can just use your class properties as default values". class Product { // ... /** * @var string…
Czechnology
  • 14,832
  • 10
  • 62
  • 88
10
votes
6 answers

Good pattern or framework for adding auditing to an existing app?

I have an existing J2EE enterprise application to which I need to add auditing, i.e. be able to record CRUD operations on several important domain types (Employee, AdministratorRights, etc.). The application has a standard n-tier architecture: Web…
Andrew Swan
  • 13,427
  • 22
  • 69
  • 98