13.重新设计oj_model|综合测试|顶层makefile(C++)

重新设计oj_model

MySQL :: MySQL Product Archives

选择mysql connector c

点击dowload
将文件导入并改名为mysql-connector

ln -s ./comm/mysql-connector/include include

建立软链接

ln -s ./comm/mysql-connector/lib lib

链接到oj_server里

复制一个oj_model

#pragma once
//MySQL 版本
#include "../comm/util.hpp"
#include "../comm/log.hpp"
#include "include/mysql.h"
  
#include <iostream>
#include <string>
#include <vector>
#include <unordered_map>
#include <fstream>
#include <cstdlib>
#include <cassert>
  
// 根据题目list文件，加载所有的题目信息到内存中
// model: 主要用来和数据进行交互，对外提供访问数据的接口
  
namespace ns_model
{
    using namespace std;
    using namespace ns_log;
    using namespace ns_util;
  
    struct Question
    {
        std::string number; //题目编号，唯一
        std::string title;  //题目的标题
        std::string star;   //难度: 简单 中等 困难
        std::string desc;   //题目的描述
        std::string header; //题目预设给用户在线编辑器的代码
        std::string tail;   //题目的测试用例，需要和header拼接，形成完整代码
        int cpu_limit;      //题目的时间要求(S)
        int mem_limit;      //题目的空间要去(KB)
    };
  
    const std::string oj_questions = "oj_questions";
    const std::string host = "127.0.0.1";
    const std::string user = "oj_client";
    const std::string passwd = "123456";
    const std::string db = "oj";
    const int port = 3306;
  
    class Model
    {
    public:
        Model()
        {}
        bool QueryMySql(const std::string &sql, vector<Question> *out)
        {
            // 创建mysql句柄
            MYSQL *my = mysql_init(nullptr);
  
            // 连接数据库
            if(nullptr == mysql_real_connect(my, host.c_str(), user.c_str(), passwd.c_str(),db.c_str(),port, nullptr, 0)){
                LOG(FATAL) << "连接数据库失败!" << "\n";
                return false;
            }
  
            // 一定要设置该链接的编码格式, 要不然会出现乱码问题
            mysql_set_character_set(my, "utf8");
            LOG(INFO) << "连接数据库成功!" << "\n";
  
            // 执行sql语句
            if(0 != mysql_query(my, sql.c_str()))
            {
                LOG(WARNING) << sql << " execute error!" << "\n";
                return false;
            }
  
            // 提取结果
            MYSQL_RES *res = mysql_store_result(my);
  
            // 分析结果
            int rows = mysql_num_rows(res); //获得行数量
            int cols = mysql_num_fields(res); //获得列数量
  
            Question q;
  
            for(int i = 0; i < rows; i++)
            {
                MYSQL_ROW row = mysql_fetch_row(res);
                q.number = row[0];
                q.title = row[1];
                q.star = row[2];
                q.desc = row[3];
                q.header = row[4];
                q.tail = row[5];
                q.cpu_limit = atoi(row[6]);
                q.mem_limit = atoi(row[7]);
  
                out->push_back(q);
            }
            // 释放结果空间
            free(res);
            // 关闭mysql连接
            mysql_close(my);
  
            return true;
        }
        bool GetAllQuestions(vector<Question> *out)
        {
            std::string sql = "select * from ";
            sql += oj_questions;
            return QueryMySql(sql, out);
        }
        bool GetOneQuestion(const std::string &number, Question *q)
        {
            bool res = false;
            std::string sql = "select * from ";
            sql += oj_questions;
            sql += " where number=";
            sql += number;
            vector<Question> result;
            if(QueryMySql(sql, &result))
            {
                if(result.size() == 1){
                    *q = result[0];
                    res = true;
                }
            }
            return res;
        }
        ~Model()
        {}
    };
} // namespace ns_model

makefile

oj_server:oj_server.cc
    g++ -o $@ $^ -I./include -L./lib -std=c++11 -lpthread -lctemplate -ljsoncpp -lmysqlclient
  
.PHONY:clean
clean:
    rm -f oj_server

综合测试

ldd oj_server

如果到时候mysql找不到系统库

ls /etc/ld.so.conf.d/
cd /etc/ld.so.conf.d/
sudo touch oj_lib_search.conf

/root/OnlineJudge/oj_server/lib

把路径粘贴到oj_lib_search.conf里
在执行下条命令

ldconfig

再录题

直接刷新题库，就有了第二道题

顶层makefile

.PHONY: all
all:
    @cd compile_server;\
    make;\
    cd -;\
    cd oj_server;\
    make;\
    cd -;
  
.PHONY:output
output:
    @mkdir -p output/compile_server;\
    mkdir -p output/oj_server;\
    cp -rf compile_server/compile_server output/compile_server;\
    cp -rf compile_server/temp output/compile_server;\
    cp -rf oj_server/conf output/oj_server/;\
    cp -rf oj_server/lib output/oj_server/;\
    cp -rf oj_server/questions output/oj_server/;\
    cp -rf oj_server/template_html output/oj_server/;\
    cp -rf oj_server/wwwroot output/oj_server/;\
    cp -rf oj_server/oj_server output/oj_server/;
  
.PHONY:clean
clean:
    @cd compile_server;\
    make clean;\
    cd -;\
    cd oj_server;\
    make clean;\
    cd -;\
    rm -rf output;