A many-to-many relation requires an additional table to relate the two tables in relationship. In this article, by Ahsanul Bari and Anupom Syam, we will learn how to define associations in models for many-to-many relations. Then, we will look at how to retrieve, delete, and save related data from and into database tables using model association in this special type of relation.Read Working with Complex Associations using CakePHP in full
Database relationship is hard to maintain even for a mid-sized PHP/MySQL application, particularly, when multiple levels of relationships are involved because complicated SQL queries are needed. CakePHP offers a simple yet powerful feature called 'object relational mapping' or ORM to handle database relationships with ease.In CakePHP, relations between the database tables are defined through association—a way to represent the database table relationship inside CakePHP. Once the associations are defined in models according to the table relationships, we are ready to use its wonderful functionalities. Using CakePHP's ORM, we can save, retrieve, and delete related data into and from different database tables with simplicity, in a better way—no need to write complex SQL queries with multiple JOINs anymore!
In this article by Ahsanul Bari and Anupom Syam, we will have a deep look at various types of associations and their uses. In particular, the purpose of this article is to learn:
- How to figure out association types from database table relations
- How to define different types of associations in CakePHP models
- How to utilize the association for fetching related model data
- How to relate associated data while saving
Python Data Persistence using MySQL Part III: Building Python Data Structures Upon the Underlying Database Data
This article, the third one in the Python Data Persistence using MySQL series by Yuli Vasiliev, discusses how you can implement Python data structures representing data structures stored in the underlying database and then manipulate those data structures on the Python side.Read Python Data Persistence using MySQL Part III: Building Python Data Structures Upon the Underlying Database Data in full
Among other merits, Python is an ideal language for writing server-side scripts, allowing you to integrate interactive behavior with HTML. Persisting dynamic content to an underlying database is fairly straightforward. By installing an appropriate Python DB module, you get the ability to interact with the database of choice from within Python code, moving your application data in and out of the underlying persistent store.
This article by Yuli Vasiliev will walk you through the process of building a simple Python application that interacts with a MySQL database. In a nutshell, the application picks up some live data from a web site and then persists it to an underlying MySQL database.Read Python Data Persistence using MySQL in full
It is not always possible to conduct the automated tests. There are situations where we may need the manual tests. Manual testing is a document or a text file, which contains a set of steps for the tester to follow. Manual testing can be conducted in between automated tests or anywhere between a series of different tests. For example, after some sets of automated tests, we may have to check log files or configuration information or settings based on the tests executed to continue with the remaining automated tests. We can group all these tests together, order them, and create an ordered test to execute the tests in an order.
In some cases, we may need to execute the tests that are not created by using Visual Studio but required for this current application. In that case, we go for the generic test, which acts as a wrapper for the tests written by some third-party tool and executes that test inside Visual Studio IDE. Once it is wrapped, it is executed normally like any other test inside Visual Studio.
This article by Subashni.S and N Satheesh Kumar talks about the manual, generic, and ordered test types in detail. We will go through the steps to create and manage these tests types in VSTS.Read Manual, Generic, and Ordered Tests using Visual Studio 2008 in full
In this article by Mark Noble, we will introduce our imaginary client, the Good Eatin' Bistro, and discuss their plans to build a newsletter for their web site. We will add some new features which will allow Chef Wanyama, who is the owner of the Good Eatin' Bistro, a popular upscale restaurant, to keep his customers informed of current events at Good Eatin' restaurant. We will provide a new means of communication. The feature which is covered in this article is a quarterly newsletter that customers can subscribe to. The newsletter will contain valuable information from Chef Wanyama including coupons, news, recipes, and more.Read Adding Newsletters to a Web Site Using Drupal 6 in full
measured by testing the product based on the requirement, using different testing tools and techniques. Even though we test the product with different tools, the real judgement of the product comes from the testing that simulates the real life situation, for example, by simulating the actual number of users, by simulating the load and simulating the actual production environment, and then by measuring the product. Microsoft Visual Studio 2008 provides not only the development environment and code maintenance for application but also different testing features such as Unit test, Load test, Web test, Coded tests, and Ordering tests list.
This article by Subashni.S and N Satheesh Kumar, will give us an understanding of the tools in Visual Studio and an overview of the different types of testing supported by Visual Studio.Read Visual Studio 2008 Test Types in full
In the first part of this article we concentrated on two aspects Problem and Design. We started with the Problem, that is, defining what we need to implement the Friends concept, finding and inviting friends to join our network and developing an alert system. We then moved to Design wherein we actually finalized the requirements. And finally we began with the Solution, that is, actually implementing the features. In this part of the article by Andrew Siemer, we will continue with the solution part.Read ASP.NET Social Networks—Making Friends (Part 2) in full
In this article by Peter Svensson, we will have a look at Dijit or Dojo Widget which is an instance of a Dojo class that lives in the page and usually has a DOM node associated with it. Examples are FloatingPane, Tree, NumberSpinner, and ValidationtextBox.
The basic premise of a Dijit is that you should be able to create any number of widgets of the same type on the same page, regardless of where on the page you choose to put them. Certain Dijits have special requirements, naturally, such as the Layout Containers, which assume that they are surrounding ContentPane Dijits.
In general, Dijits are very versatile and much time has been spent to assure portability and modularization of the Dijit system. Best of all, this is accessible to you as a developer as well.Read Basic Dijit Knowledge in Dojo in full
In this article by Andrew Siemer, we will cover the most important aspect of any community site—making friends. We will divide this article in two parts. This part starts with the discussion of Problem, that is, what we need to do to achieve success for the article's topic—finding and inviting friends to your network on a community site. It then moves to Design part where we decide on our requirements, and finally the article reaches Solution part where we begin discussing how to actually implement the features.Read ASP.NET Social Networks—Making Friends (Part 1) in full
Before you begin with coding, there are a few files and folders that have to be created, as well as a query that has to be run. This will not only allow you to build Joomla! components, but will also help you try different features without extensive configuration. The component in this article will be called restaurants.
After installing your basic Joomla! component and making the website ready, there are a few additional features that you can include. One of them came up with the idea of allowing visitors to send reviews to their friends through email. Another could be adding audio reviews in addition to text. We can also begin to look into ways of expanding the market for the software. Internationalizing the component now will make it easy to translate the user interface later.
In the following article by Joseph L. LeBlanc, we will be taking a look at including the following additional features :
- Sending emails
- Managing languages
- Creating translations
- Handling file uploads
There are times when we will need to serve the same content in multiple ways whether it's displaying a printable version of a page, creating festive themes for holidays or promotions, or using a different set of templates for mobile devices.
There are a number of approaches to these tasks, and no one is "right". As we will see, the best choice depends on the circumstances specific to your site and users.
In this article by Scott Newman we will:
- Consider the different approaches to tailoring output
- Explore the challenges of serving content to mobile devices
- Create printer-friendly output via URL parameters
In this article by Andrew Siemer, we will talk about the concept of Blogging and how it could be applied to our community site Fisharoo. With search engines, users, and security in mind, Andrew invests a part of this article to address an issue that plagues many dynamic websites—query string data being used to determine page output.
The article starts with the discussion of Problem, that is, what we need to do to achieve success for the article's topic-Blogs so to speak. Then it moves on to Design where we decide on and write down the physical requirements for our feature. And finally comes the Solution part where we discuss how to implement all the requirements for each feature.Read ASP.NET Social Networks—Blogs in Fisharoo in full
Blogging in Drupal encompasses a range of learning activities. When incorporated into a course as a regular part of the coursework, blogs provide an incredibly powerful means of tracking student growth. For students who are disorganized (that is, students whose backpacks resemble tumbleweed), the blog can also be an organizational tool. Most importantly, though, blogs create a record of student work that can be accessed at any time. As such, blogs provide a convenient window into both process (how students work) and product (the end results of student work). In this article by Bill Fitzgerald, we will see how to create a student blog.Read Creating the Student Blog in Drupal using Cloning in full
Continuing with the sample discussed in the Python Data Persistence using MySQL article, this Part II: Moving Data Processing to the Data by Yuli Vasiliev explains how you can implement some data processing inside your database, resulting in better application design and better performance in the long run. In this article, you will look at triggers in action. Stored procedures and functions can be used similarly.Read Python Data Persistence using MySQL Part II: Moving Data Processing to the Data in full