How to develop a simple online scheduling system using MySQL and Ruby on Rails

How to use MySQL and Ruby on Rails to develop a simple online scheduling system

With the continuous development of technology, more and more enterprises and organizations need an efficient Scheduling system to manage and allocate resources. Using MySQL and Ruby on Rails to develop a simple online scheduling system is a common and feasible option. This article will introduce in detail how to use these two technologies to build an online scheduling system with basic functions and provide corresponding code examples.

MySQL is a popular open source relational database management system that provides powerful data storage and query capabilities. Ruby on Rails is a popular web development framework based on the Ruby language that allows developers to build efficient and scalable web applications faster.

Before starting development, we need to make sure we have installed the required software and tools. First, you need to install the MySQL database and Rails development framework. These installations can be completed by executing the commands brew install mysql and gem install rails. Once the installation is complete, we can start creating our scheduling system.

The first step is to create a new Rails application. Execute the command rails new dispatch_system in the terminal to create a new Rails application named "dispatch_system". Enter the application directory and execute the command cd dispatch_system.

Next, we need to create a model for scheduling tasks and the corresponding database table. Execute the command rails generate model DispatchTask name:string status:boolean in the terminal to generate a model named "DispatchTask" and add a string type field named "name" and a field named " status" Boolean type field. Execute the command rails db:migrate to create the corresponding database table.

Next, we need to create a controller to handle the addition, deletion, modification and query operations of scheduled tasks. Execute the command rails generate controller DispatchTasks to generate a controller named "DispatchTasks". Open the generated controller file "app/controllers/dispatch_tasks_controller.rb" and add the following code:

class DispatchTasksController < ApplicationController
  def index
    @tasks = DispatchTask.all
  end

  def new
    @task = DispatchTask.new
  end

  def create
    @task = DispatchTask.new(task_params)
    
    if @task.save
      redirect_to dispatch_tasks_path
    else
      render :new
    end
  end

  def edit
    @task = DispatchTask.find(params[:id])
  end

  def update
    @task = DispatchTask.find(params[:id])
    
    if @task.update(task_params)
      redirect_to dispatch_tasks_path
    else
      render :edit
    end
  end

  def destroy
    @task = DispatchTask.find(params[:id])
    @task.destroy
    
    redirect_to dispatch_tasks_path
  end

  private

  def task_params
    params.require(:dispatch_task).permit(:name, :status)
  end
end

This controller defines a series of methods for operating scheduled tasks, including displaying all tasks, creating new tasks, and editing tasks, update tasks and delete tasks. In this controller, we use the DispatchTask model to handle database operations and implement page jumps through path.

Next, we need to create the corresponding view file. In the "app/views/dispatch_tasks" directory, create four files "index.html.erb", "new.html.erb", "edit.html.erb" and "_form.html.erb" and add The following code:

index.html.erb:

<h1 id="调度任务列表">调度任务列表</h1>

<table>
  <tr>
    <th>名称</th>
    <th>状态</th>
    <th>操作</th>
  </tr>
  
  <% @tasks.each do |task| %>
    <tr>
      <td><%= task.name %></td>
      <td><%= task.status ? "完成" : "未完成" %></td>
      <td>
        <%= link_to "编辑", edit_dispatch_task_path(task) %>
        <%= link_to "删除", dispatch_task_path(task), method: :delete, data: { confirm: "确定要删除吗？" } %>
      </td>
    </tr>
  <% end %>
</table>

<%= link_to "新增任务", new_dispatch_task_path %>

new.html.erb:

<h1 id="新增调度任务">新增调度任务</h1>

<%= render "form" %>

<%= link_to "返回", dispatch_tasks_path %>

edit.html.erb:

<h1 id="编辑调度任务">编辑调度任务</h1>

<%= render "form" %>

<%= link_to "返回", dispatch_tasks_path %>

_form. html.erb:

<%= form_with(model: @task, local: true) do |form| %>
  <%= form.label :name, "任务名称" %>
  <%= form.text_field :name %>

  <%= form.label :status, "任务状态" %>
  <%= form.check_box :status %>
  
  <%= form.submit "保存" %>
<% end %>

These view files define the interface and forms of the scheduling system, and use the erb template engine to embed Ruby code. In these view files, we use fields from the DispatchTask model to display the name and status of the task, and use the link_to method to generate the corresponding links.

Finally, we need to configure the database connection. Open the "config/database.yml" file and confirm that the database connection configuration is correct, including database name, user name and password. In this file, you can usually find a configuration with "default" as the key name. We need to ensure that the content of the configuration is correct.

So far, we have completed the development of a basic online scheduling system. Execute the command rails s in the terminal to start the Rails server, and then visit "http://localhost:3000/dispatch_tasks" in the browser to view and use this dispatch system. Tasks can be created, edited and deleted by clicking the corresponding links and buttons.

Of course, this is just a simple example of a scheduling system, and there are many areas that can be improved and perfected. But through this example, we can learn how to use MySQL and Ruby on Rails to develop an online scheduling system, and have a preliminary understanding of the basic use of these two technologies. Hope this article can be helpful to you!

The above is the detailed content of How to develop a simple online scheduling system using MySQL and Ruby on Rails. For more information, please follow other related articles on the PHP Chinese website!