nginx擴充直接生成應用，不用通過程式設計語言，執行個體

    最近聽說淘寶開發了很多nginx的擴充，這些擴充可以獨立與程式設計語言直接開發各種應用，下面看看例子：

       This sample demonstrates how to route incoming requests to different MySQL queries based on different combinations of URI query arguments, preserving streaming output capabilities provided byDrizzleNginxModule and RdsJsonNginxModule.

      這個例子是示範通過路由url請求來查詢mysql,這種通過不同的Url查詢字元串來産生字元輸出的能力是通過DrizzleNginxModule和RdsJsonNginxModule這兩個nginx擴充實作的！

This demo uses the modules DrizzleNginxModule, LuaNginxModule, RdsJsonNginxModule, and SetMiscNginxModule bundled by OpenResty.

這個執行個體中用到的擴充：DrizzleNginxModule,LuaNginxModule, RdsJsonNginxModule,SetMiscNginxModule是在OpenResty部落格中有提到

Here's the complete code listing for our

nginx.conf

:

這是完整的配置資訊：

worker_processes  2;

error_log logs/error.log warn;

events {

    worker_connections 1024;

}

http {

    upstream backend {

        drizzle_server 127.0.0.1:3306 protocol=mysql

                       dbname=ngx_test user=ngx_test password=ngx_test;

        drizzle_keepalive max=10 overflow=ignore mode=single;

    }

    server {

        listen 8080;

        location @cats-by-name {

            set_unescape_uri $name $arg_name;

            set_quote_sql_str $name;

            drizzle_query 'select * from cats where name=$name';

            drizzle_pass backend;

            rds_json on;

        }

        location @cats-by-id {

            set_quote_sql_str $id $arg_id;

            drizzle_query 'select * from cats where id=$id';

            drizzle_pass backend;

            rds_json on;

        }

        location = /cats {

            access_by_lua '

                if ngx.var.arg_name then

                    return ngx.exec("@cats-by-name")

                end

                if ngx.var.arg_id then

                    return ngx.exec("@cats-by-id")

                end

            ';

            rds_json_ret 400 "expecting \"name\" or \"id\" query arguments";

        }

    }

}

And then we start our Nginx server with this configure file and test with our

/cats

service like this:

接下來，我們開始測試上面的nginx配置,通路伺服器下/cats位址:

$ curl 'localhost:8080/cats'
{"errcode":400,"errstr":"expecting \"name\" or \"id\" query arguments"}

$ curl 'localhost:8080/cats?name=bob'
[{"id":3,"name":"bob"}]

$ curl 'localhost:8080/cats?id=2'
[{"id":2,"name":null}]
      

The actual output rows may vary depending on the actual contents in your

cats

table anyway.

傳回的格式取決于nginx配置資訊中指定的格式（指定的是json格式）。