Skip to main content

CakePHP and composite primary keys

Today, I was doing some comprehensive research about CakePHP framework, as a part of our web application framework research. I installed it and developed a sample application following the official documentation. Some interesting facts were found. And, here, I am listing down few of the advantages and disadvantages of this framework in relation to our existing systems.

CakePHP has many good characteristics such as easy configuration, easy installation, light weight etc. And also, it's a excellent RAD tool, and it will save development time in a great margin. The database tasks can be done without writing one single sql query. And, CakePHP can be used with or without apache rewrite module, there is a clean url mechanism inside the framework instead of url rewriting.

Naming convention is very important in CakePHP. Database tables should have the same name as the relevant model classes. For example, by naming the model "Orange", CakePHP can automatically infer that this model will be used in the "OrangeController", and will be tied to a database table called "Oranges".

Composite primary keys can't be used for data base tables. Even if composite primary keys are kept in the tables, those are not used by the framework. Framework uses only one field as the primary key. If you want to use composite primary keys, you should hand write all the queries related to that task.

Alternatively, If we want to add a existing table that have two fields which compose the primary key, then what we have to do is we should add a new 'id' field as the primary key, and that field will be used by framework, we can make the other two fields (previous composite primary keys) as unique keys.


After all, the fact that the composite primary keys can't be used with CakePHP is clearly mentioned in the official documentation as well.

Comments

  1. Of course, cakePHP is an excellent framework. Most importantly it provides a facility called 'cake bake', you can automatically create your views, controllers and models with it.
    Your observation regarding composite primary keys is correct. Database should be carefully designed avoiding composite primary keys if you are using the cakePHP framework. I've done that in many cakePHP applications.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to create a new module for vtiger...

Recently, I had to create a new module for vtigerCRM for my client in current working place. I did search in many places including the official vtiger sites, but couldn’t find a better documentation for my purpose. The latest vtiger version at that time was 5.0.3. Because I had some experience doing lots of core modifications for this system, I did decide to read the source code and find how to add a new module. Finally, I could create a new module and started the project. So, I thought it will be a good thing to write some thing on my blog about this topic, so that others who want to do this thing can read. Given below is a brief description about how to create a new module for vtiger CRM 5.0.3. Source code of this example module is also available to Download.
Step 01: Creating the module directory and minimum required files.
Create a directory called “newModule” inside your vtiger modules directory, or any other name that you prefer. Now, module index file should be created. Create a…

How to create a simple Web Crawler

Web crawlers are used to extract information from web sites for many purposes.

The simple example given here accepts an URL and exposes some functions to query the content of the page.

To check out the source code of this example : https://github.com/nadeeth/crawler

If you are going to make any improvements to this code, I recommend you to follow TDD and use the unit test class in the code.

Step 1 : Create the class, init function and required attributes In this example, xpath is used for querying the given web page. There is an attribute to hold the page url, and another to hold the xpath object of the loaded page.

The init() function initializes the xpath object for the page URL assigned to url attribute.

class Crawler { public $url = false; protected $xpath = false; public function init() { $xmlDoc = new DOMDocument(); @$xmlDoc->loadHTML(file_get_contents($this->url)); $this->xpath = new DOMXPath(@$xmlDoc); } } In the next two ste…

De Morgan's Laws in Programming

Recently, while I was reviewing some codes, I saw there were some conditional statements that check for the same condition but written in different ways. Most of these statements were written with common sense without using any mathematical analysis, since those are too simple to go for a more formal approach. The two identical conditional statements that has been written in different ways are given below.

01)

if ($comment['deleted'] == '1' || $comment['approved'] == '0') {
                unset($conversationsArray[$key]);
} else {
               ++$count;
}

02)

if ($comment['deleted'] == '0' && $comment['approved'] == '1') {
               ++$count;             
} else {
             unset($conversationsArray[$key]);
}

Obviously, the above lines say that the inverse of the first condition is equals to the second condition and vice versa. That is...

 ($comment['deleted'] == '1' || $comment['ap…