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
10
votes
3 answers

Database to CRUD application, Rails 3

I have a fairly large DB schema and about 100M rows with I would like to expose to the web, using Rails 3. By exposing to the web, I mean the following: A REST api (json & xml) Views to present the data hierarchically Editors for specific parts of…
Georgios Gousios
  • 2,405
  • 1
  • 24
  • 34
10
votes
2 answers

How To Properly Unit-Test CRUD Operations on a Repository?

Realize this may sound like a broad question - so let me clarify. I have a Repository exposed via an interface, with two concrete implementations - a MockRepository and a EntityFrameworkRepository. Now, i have a Unit-Test project for which all tests…
RPM1984
  • 72,246
  • 58
  • 225
  • 350
10
votes
3 answers

Processing file on front-end vs back-end

I am developing a web application with angularjs as the front-end and a CRUD service at the backend. One of the requirements is to allow the user to upload a csv file containing a list of items to be created. This can be implemented on the front-end…
vjain27
  • 3,514
  • 9
  • 41
  • 60
10
votes
4 answers

I need an idea for a RESTful implementation of inventory API for an RPG game

I'm working on an kind of an RPG game. And I'm trying to figure out a nice, clean and RESTful way to define inventory API. inventory consists of several slots like head, chest etc (like in most RPG games). Now I need to define REST API to move all…
Vitaly Kushner
  • 9,247
  • 8
  • 33
  • 41
10
votes
3 answers

You have specified an invalid database connection group codeigniter error

i'm making a CRUD from a tutorial. And i'm getting this error. You have specified an invalid database connection group. What would be the problem? database.php - database config $db['default']['hostname'] = 'localhost'; $db['default']['username']…
Beabi
  • 139
  • 1
  • 2
  • 8
10
votes
2 answers

How to log query and its execution time of each query which runs on a db?

I have a huge database with more than 250 tables. Different type of queries are ran on the database. Since the database has grown over the years and now I need to optimise the database and queries. I have already followed optimisation concepts such…
Techie
  • 44,706
  • 42
  • 157
  • 243
10
votes
3 answers

play! framework 2.0 crud module

Im using play 2.0.1 to build my application. Also Im using Ebean for the backend layer and mysql as a database so far. Java as the language. Question: Isn't there a CRUD module (dynamic) or a crud creation module? I looked on the internet and it is…
whereismydipp
  • 556
  • 1
  • 8
  • 23
10
votes
6 answers

How to check the user's CRUD permissions for an object in Salesforce?

According to a requirement, i have to change the owner of an account if the user does not have read access to a third object. I need a functionality similar to the isAccessible() method of Describe Field Result, but it is only available for the…
ntnng
  • 303
  • 4
  • 7
  • 12
9
votes
2 answers

ArgumentError: wrong number of arguments (1 for 2)

I'm very new to Rails, MVC, and CRUD, and I'm trying to use the update method to change the amount of votes on a post. I have the following code in my Posts Controller update method: def update @post = Post.find(params[:id]) if…
airplaneman19
  • 1,139
  • 6
  • 19
  • 32
9
votes
3 answers

Laravel 8 - Could not find driver : Illuminate\Database\QueryException could not find driver (SQL: select * from `list`)

I have installed Laravel 8 on my Linux Mint 20 for my personal experiment so I'm new on Laravel's new version. I've searching many source how to show tables with CRUD method so the table is shown in the web with contains data from MySQL database But…
pup_in_the_tree
  • 169
  • 1
  • 1
  • 8
9
votes
3 answers

What are the best practices for functional programming and database interaction?

I know that in pure object-oriented languages like Java it usually makes sense to use ORMs like Hibernate. But what would I do when writing a CRUD-type functionality in Clojure or Common LISP? Passing around SQL as the first-order functions? But…
mannicken
  • 6,885
  • 4
  • 31
  • 38
9
votes
2 answers

Create programmatically a product using CRUD methods in Woocommerce 3

I'd like to create a new Woocommerce product programmatically with PHP code and I have tried it with the Woocommerce 3 CRUD methods: //Woocommerce CRUD $objProduct = new WC_Product_Simple(); $objProduct->set_name('My Product 1'); //Set product…
Martijn
  • 105
  • 1
  • 1
  • 5
9
votes
4 answers

Firebase: Update or Create

i am using Firebase and Node. I would like to use the same method to either update an object, or create it, if for some reason it does not exist. Consider the following method const firebaseSave = async function(data) { const uid =…
Lee
  • 5,816
  • 6
  • 45
  • 61
9
votes
12 answers

CRUD vs AGUD vs AFUD...what's your naming convention of preference

Do you write createSomething() or addSomething()? Do you write readSomething(), getSomething() or fetchSomething()? This is totally a petty gripe. In the meeting room we refer to it as CRUD, but in actual code, it's becoming AGUD. What's your naming…
user45441
  • 91
  • 1
  • 5
9
votes
1 answer

How to get user's authorization credentials in code with spring security?

What I'm trying to do is to build CRUD REST service. It will maintain a database of users and theirs records. I'd like to allow users to get access only to their own records. I use Spring Security for authentication and store user's password hashed…
Alex
  • 161
  • 1
  • 3
  • 9