In this RAD Server CRUD Procedures – Part 1 post, we will discuss the the default generated CRUD procedure implementations from the RAD Server Package Wizard. In the RAD Server CRUD Procedures – Part 2 post, we will discuss modifying the default generated CRUD procedure implementations from the RAD Server Package Wizard using both Delphi and C++ Builder, to show possible ways to implement Get, GetItem, Post, Put and Delete, including Delphi and C++ Builder clients to call the CRUD procedures. Create, retrieve, update and delete (CRUD) refers to the four major functions implemented in database applications. The CRUD functions are the user interfaces to databases, as they permit users to create, view, modify and alter data. CRUD works on entities in databases and manipulates these entities. These four methods create, retrieve, update and delete are re-used across all types of objects. So, for example, you can create new Employees, read Employees, update Employees, and delete Employees. These four CRUD methods are also reflected in the way HTTP functions with these four methods; GET, POST, PUT, and DELETE. The HTTP methods POST, GET, PUT and Delete are typically translated as CREATE, READ, UPDATE, and DELETE, respectfully. This offers us the uniform interface that’s required as part of a REST application, as the well understood CRUD pattern. In order to transfer data to and from a REST Service, JSON – JavaScript Object Notation, is typically used as the transfer encoding. The Embarcadero RAD Server (also known as EMS – Enterprise Mobility Server) uses the industry standards of REST, and you can build any client front-end that you want for your RAD Server application. And any tool that can consume JSON via HTTP can be used to build a RAD Server client, such as Delphi and/or C++ Builder VCL or FMX application, PHP, Javascript, Angular, C#, whatever – it doesn’t matter. As the graphic below shows, you can leverage almost anything to consume a RAD Server (EMS) service: Let’s now take a look at implementing CRUD procedures using RAD Studio, Delphi and/or C++ Builder in a RAD Server EMS Resource Module. Specifically, we’ll look at how to create and implement the RAD Server Endpoints for GET, POST, PUT and DELETE. For this implementation, I’m using the Delphi 10.4.2 IDE. For the Employee Table, I’m using the InterBase Employee database, located at:localhost:C:UsersPublicDocumentsEmbarcaderoStudio21.0Samplesdataemployee.gdb Steps:1. File | New | Other | Delphi Projects | RAD Server (EMS) | RAD Server Package 2. This gives us the RAD Server Package Wizard, allowing me to (1) Create empty package, or (2) Create package with resource. The option (1) Create empty package, creates an empty package allowing you to add resources later. Or option (2) Create package with resource, creates for me a package with an existing resource. This option (2) lets the IDE do some of the work for me, by creating a template resource for me. So we will select this Option (2) ) Create package with resource. 3. Click Next. Here, we see an entry for Resource name. In RAD Server the terminology of a Resource is a Collection. So, for example, we can have a RAD Server resource defined as http://localhost:8080/employees For this example, http://localhost:8080/employees we will get a Collection of Employee records from the Employees database. The table employee in the Employees database […]
