lithium.cc 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158
  1. #include "lithium_http_backend.hh"
  2. #if TFB_MYSQL
  3. #include "lithium_mysql.hh"
  4. #elif TFB_PGSQL
  5. #include "lithium_pgsql.hh"
  6. #endif
  7. #include "symbols.hh"
  8. using namespace li;
  9. template <typename B>
  10. void escape_html_entities(B& buffer, const std::string& data)
  11. {
  12. for(size_t pos = 0; pos != data.size(); ++pos) {
  13. switch(data[pos]) {
  14. case '&': buffer << "&amp;"; break;
  15. case '\"': buffer << "&quot;"; break;
  16. case '\'': buffer << "&apos;"; break;
  17. case '<': buffer << "&lt;"; break;
  18. case '>': buffer << "&gt;"; break;
  19. default: buffer << data[pos]; break;
  20. }
  21. }
  22. }
  23. int main(int argc, char* argv[]) {
  24. if (argc != 4)
  25. {
  26. std::cerr << "Usage: " << argv[0] << " sql_host port nprocs" << std::endl;
  27. return 1;
  28. }
  29. int port = atoi(argv[2]);
  30. int nprocs = atoi(argv[3]);
  31. #if TFB_MYSQL
  32. auto sql_db =
  33. mysql_database(s::host = argv[1], s::database = "hello_world", s::user = "benchmarkdbuser",
  34. s::password = "benchmarkdbpass", s::port = 3306, s::charset = "utf8");
  35. int mysql_max_connection = sql_db.connect()("SELECT @@GLOBAL.max_connections;").read<int>() * 0.75;
  36. li::max_mysql_connections_per_thread = (mysql_max_connection / nprocs);
  37. #elif TFB_PGSQL
  38. auto sql_db =
  39. pgsql_database(s::host = argv[1], s::database = "hello_world", s::user = "benchmarkdbuser",
  40. s::password = "benchmarkdbpass", s::port = 5432, s::charset = "utf8");
  41. int pgsql_max_connection = atoi(sql_db.connect()("SHOW max_connections;").read<std::string>().c_str()) * 0.75;
  42. li::max_pgsql_connections_per_thread = (pgsql_max_connection / nprocs);
  43. #endif
  44. auto fortunes = sql_orm_schema(sql_db, "Fortune").fields(
  45. s::id(s::auto_increment, s::primary_key) = int(),
  46. s::message = std::string());
  47. auto random_numbers = sql_orm_schema(sql_db, "World").fields(
  48. s::id(s::auto_increment, s::primary_key) = int(),
  49. s::randomNumber = int());
  50. http_api my_api;
  51. my_api.get("/plaintext") = [&](http_request& request, http_response& response) {
  52. response.set_header("Content-Type", "text/plain");
  53. response.write("Hello, World!");
  54. };
  55. my_api.get("/json") = [&](http_request& request, http_response& response) {
  56. response.write_json(s::message = "Hello, World!");
  57. };
  58. my_api.get("/db") = [&](http_request& request, http_response& response) {
  59. response.write_json(random_numbers.connect(request.yield).find_one(s::id = 1234).value());
  60. };
  61. my_api.get("/queries") = [&](http_request& request, http_response& response) {
  62. std::string N_str = request.get_parameters(s::N = std::optional<std::string>()).N.value_or("1");
  63. int N = atoi(N_str.c_str());
  64. N = std::max(1, std::min(N, 500));
  65. auto c = random_numbers.connect(request.yield);
  66. std::vector<decltype(random_numbers.all_fields())> numbers(N);
  67. for (int i = 0; i < N; i++)
  68. numbers[i] = c.find_one(s::id = 1 + rand() % 9999).value();
  69. response.write_json(numbers);
  70. };
  71. my_api.get("/updates") = [&](http_request& request, http_response& response) {
  72. std::string N_str = request.get_parameters(s::N = std::optional<std::string>()).N.value_or("1");
  73. int N = atoi(N_str.c_str());
  74. N = std::max(1, std::min(N, 500));
  75. auto c = random_numbers.connect(request.yield);
  76. auto& raw_c = c.backend_connection();
  77. std::vector<decltype(random_numbers.all_fields())> numbers(N);
  78. raw_c("START TRANSACTION");
  79. for (int i = 0; i < N; i++)
  80. {
  81. numbers[i] = c.find_one(s::id = 1 + rand() % 9999).value();
  82. numbers[i].randomNumber = 1 + rand() % 9999;
  83. }
  84. std::sort(numbers.begin(), numbers.end(), [] (auto a, auto b) { return a.id < b.id; });
  85. #if TFB_MYSQL
  86. for (int i = 0; i < N; i++)
  87. c.update(numbers[i]);
  88. #elif TFB_PGSQL
  89. std::ostringstream ss;
  90. ss << "UPDATE World SET randomNumber=tmp.randomNumber FROM (VALUES ";
  91. for (int i = 0; i < N; i++)
  92. ss << "(" << numbers[i].id << ", " << numbers[i].randomNumber << ") "<< (i == N-1 ? "": ",");
  93. ss << ") AS tmp(id, randomNumber) WHERE tmp.id = World.id";
  94. raw_c(ss.str());
  95. #endif
  96. raw_c("COMMIT");
  97. response.write_json(numbers);
  98. };
  99. my_api.get("/fortunes") = [&](http_request& request, http_response& response) {
  100. typedef decltype(fortunes.all_fields()) fortune;
  101. std::vector<fortune> table;
  102. auto c = fortunes.connect(request.yield);
  103. c.forall([&] (auto f) { table.emplace_back(f); });
  104. table.emplace_back(0, "Additional fortune added at request time.");
  105. std::sort(table.begin(), table.end(),
  106. [] (const fortune& a, const fortune& b) { return a.message < b.message; });
  107. char b[100000];
  108. li::output_buffer ss(b, sizeof(b));
  109. ss << "<!DOCTYPE html><html><head><title>Fortunes</title></head><body><table><tr><th>id</th><th>message</th></tr>";
  110. for(auto& f : table)
  111. {
  112. ss << "<tr><td>" << f.id << "</td><td>";
  113. escape_html_entities(ss, f.message);
  114. ss << "</td></tr>";
  115. }
  116. ss << "</table></body></html>";
  117. response.set_header("Content-Type", "text/html; charset=utf-8");
  118. response.write(ss.to_string_view());
  119. };
  120. http_serve(my_api, port, s::nthreads = nprocs);
  121. return 0;
  122. }