Chapter 5. Developing a Reservation System
In this chapter, you will learn how to configure and manage databases, using SQL or ActiveRecord directly, then you will see how to solve common tasks, such as saving single and multiple models from a form, and how to create data aggregation and filtered views.
We will cover the following topics in this chapter:
- Configuring a DB connection:
- For example, creating rooms, customers, and reservations tables
- For example, testing a connection and executing a SQL query
- Using Gii to create room, customer, and reservation models
- Using ActiveRecord to manipulate data:
- For example, querying rooms list with ActiveRecord
- Working with relationships:
- For example, using relationships to connect rooms, reservations, and customers
- How to save a model from a form:
- For example, creating and updating a room from a form
- Setting up the GMT time zone
- Using multiple database connections:
- For example, configuring a second DB connection to export data to a local SQLite DB
