Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/simple_sql/changes/?format=api&page=7
{ "count": 396, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/changes/?format=api&page=8", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/changes/?format=api&page=6", "results": [ { "unit": "https://weblate.osgeo.org/api/units/99344/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:40.991595Z", "action": 7, "target": "\"SELECT\" の全てのパラメータの概要については、`PostgresSQL 文書 <https://www.postgresql.jp/document/current/html/sql-select.html>`_ をご覧下さい。", "id": 1899887, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899887/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99343/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:35.961157Z", "action": 7, "target": "SELECTクエリは一般的に次の形式になります:", "id": 1899886, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899886/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99342/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:32.210526Z", "action": 7, "target": "SELECT クエリ", "id": 1899885, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899885/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99341/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:29.705284Z", "action": 7, "target": "空間関数を使うテーブルの問合せでは、使うのはほとんど \"SELECT\" だけになります。", "id": 1899884, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899884/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99339/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:25.580545Z", "action": 7, "target": "``DELETE``,テーブルから行を削除します", "id": 1899883, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899883/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99338/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:23.845045Z", "action": 7, "target": "``UPDATE``, テーブルの既存の行に変更を加えます", "id": 1899882, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899882/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99337/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:21.931104Z", "action": 7, "target": "``INSERT``, 新しい行をテーブルに追加します", "id": 1899881, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899881/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99336/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:19.534058Z", "action": 7, "target": "``SELECT``, クエリに応答して行を返します", "id": 1899880, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899880/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99335/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:02:13.978941Z", "action": 2, "target": "しかし、ここで何が起こったのでしょう? これを理解するために、SQL の四つの「動詞」から始めましょう、", "id": 1899879, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1899879/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99335/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:01:53.129163Z", "action": 7, "target": "しかし、ここで何が起こったのでしょう? これを理解するために、SQL の四つの「動詞」から始めましょう。", "id": 1899878, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899878/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99334/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:01:19.535708Z", "action": 7, "target": "クエリは数秒 (数ミリ秒) 間実行されて、129 件の結果が返ります。", "id": 1899877, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899877/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99333/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:01:17.363603Z", "action": 7, "target": "最後に **Execute Query** ボタン (緑の三角形) をクリックします。", "id": 1899876, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899876/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99331/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:01:15.261315Z", "action": 7, "target": "クエリウィンドウに次のクエリを入力して", "id": 1899875, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899875/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99330/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:01:13.193932Z", "action": 7, "target": "\"Query Tool\" ボタンをクリックして、pgAdmin の SQLクエリウィンドウを開きます。", "id": 1899874, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899874/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99329/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:01:10.970795Z", "action": 7, "target": "「ニューヨーク市内の全ての地区の名前を知りたい」", "id": 1899873, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899873/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99328/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:00:56.849621Z", "action": 7, "target": "これはデータベースに関する問合せでした。現時点では既にデータをロードしています。SQL でデータの問合せを実行してみましょう! 例を示します:", "id": 1899872, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899872/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99327/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:00:43.635537Z", "action": 7, "target": ":term:`SQL` (\"Structured Query Language\") は、リレーショナルデータベースにおいて、問合せ、更新を行う手段です。データベースの生成の地点で、みなさんは既に SQL を見ています。思い返してみましょう:", "id": 1899871, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899871/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99341/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:00:29.607848Z", "action": 4, "target": "空間関数を使うテーブルの問合せでは、使うのはほとんど \"SELECT\" だけになります。", "id": 1899870, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899870/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99328/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:00:29.555213Z", "action": 4, "target": "これはデータベースに関する問合せでした。現時点では既にデータをロードしています。SQL でデータの問合せを実行してみましょう! 例を示します:", "id": 1899869, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899869/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99327/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T03:00:29.533348Z", "action": 4, "target": ":term:`SQL` (\"Structured Query Language\") は、リレーショナルデータベースにおいて、問合せ、更新を行う手段です。データベースの生成の地点で、みなさんは既に SQL を見ています。思い返してみましょう:", "id": 1899868, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899868/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99326/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:23.186431Z", "action": 7, "target": "単純なSQL", "id": 1899867, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899867/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99364/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.363664Z", "action": 4, "target": "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: 入力値の標準偏差を返す PostgreSQL 集約関数。", "id": 1899866, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899866/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99363/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.355903Z", "action": 4, "target": "`char_length(string) <https://www.postgresql.jp/document/current/html/functions-string.html>`_: 文字列の文字数を返すPostgreSQL 文字列関数。", "id": 1899865, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899865/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99361/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.348112Z", "action": 4, "target": "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 数値カラムの値の平均を返す PostgreSQL 集約関数。", "id": 1899864, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899864/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99359/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.340433Z", "action": 4, "target": "出力結果に \"boroname\" (行政区名) カラムが含まれているので、どの統計がどの行政区に適用されるかの判断ができます。集約クエリでは、(a) グループ句のメンバーか、または (b) 集約関数かのカラムだけを出力できます。", "id": 1899863, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899863/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99358/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.332297Z", "action": 4, "target": "「ニューヨーク市の、行政区ごとの地区の名前の文字数の平均値を知りたい」", "id": 1899862, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899862/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99357/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.323961Z", "action": 4, "target": "最後の例での集約関数は、結果集合の全ての行に適用されました。もし結果集合全体をより小さなグループにして集計を実行したい場合には、どうするでしょうか。その場合には、\"GROUP BY\"句 を追加します。集約関数はしばしば、1以上のカラムによる結果セットのグループ化のために \"GROUP BY\"句 を追加しなければなりません。", "id": 1899861, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899861/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99355/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.316178Z", "action": 4, "target": "「ブルックリンの全地区の名前の文字数の平均値と標準偏差を知りたい」", "id": 1899860, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899860/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99354/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.305911Z", "action": 4, "target": "PostgrSQL は、平均値を求める :command:`avg()` や、標準偏差を求める :command:`stddev()` などといった汎用的な一連の組込集約関数を持っています。", "id": 1899859, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899859/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99353/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.298263Z", "action": 4, "target": "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地区名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。", "id": 1899858, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899858/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99352/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.290710Z", "action": 4, "target": "幸運なことに、PostgreSQL には、文字列長を得る :command:`char_length(string)`. という関数があります。", "id": 1899857, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899857/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99351/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.281696Z", "action": 4, "target": "「ブルックリンの全ての地区の名前の文字数を知りたい」", "id": 1899856, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899856/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99350/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.274105Z", "action": 4, "target": "時々、関数をクエリの結果に適用する必要があります。例を挙げます、", "id": 1899855, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899855/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99349/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.266716Z", "action": 4, "target": "クエリは、さらに短く、数 (ミリ) 秒で終わり、23件の結果を返します。", "id": 1899854, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899854/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99348/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.259127Z", "action": 4, "target": "``nyc_neighborhoods`` テーブルに話を戻します。テーブルはニューヨーク市の全ての地区を持っていますが、ブルックリン内の地区だけを求めています。", "id": 1899853, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899853/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99346/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.251462Z", "action": 4, "target": "「ブルックリンの全ての地区の名前を知りたい」", "id": 1899852, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899852/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99345/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.244026Z", "action": 4, "target": "\"some_columns\" は、カラム名またはカラム値の半数のいずれかです。\"some_data_source\" は、単一のテーブルか、二つのテーブルをキーまたは条件で結合した複合テーブルです。\"some_condition\" は、返される行数を制限するフィルタです。", "id": 1899851, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899851/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99344/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.236169Z", "action": 4, "target": "\"SELECT\" の全てのパラメータの概要については、`PostgresSQL 文書 <https://www.postgresql.jp/document/current/html/sql-select.html>`_ をご覧下さい。", "id": 1899850, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899850/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99343/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.228455Z", "action": 4, "target": "SELECTクエリは一般的に次の形式になります:", "id": 1899849, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899849/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99342/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.220973Z", "action": 4, "target": "SELECT クエリ", "id": 1899848, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899848/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99341/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.213405Z", "action": 4, "target": "空間関数を使うテーブルの問い合わせでは、使うのはほとんど \"SELECT\" だけになります。", "id": 1899847, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899847/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99339/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.205701Z", "action": 4, "target": "``DELETE``,テーブルから行を削除します", "id": 1899846, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899846/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99338/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.198191Z", "action": 4, "target": "``UPDATE``, テーブルの既存の行に変更を加えます", "id": 1899845, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899845/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99337/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.190725Z", "action": 4, "target": "``INSERT``, 新しい行をテーブルに追加します", "id": 1899844, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899844/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99336/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.182909Z", "action": 4, "target": "``SELECT``, クエリに応答して行を返します", "id": 1899843, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899843/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99335/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.172016Z", "action": 4, "target": "しかし、ここで何が起こったのでしょう? これを理解するために、SQL の四つの「動詞」から始めましょう。", "id": 1899842, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899842/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99334/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.147206Z", "action": 4, "target": "クエリは数秒 (数ミリ秒) 間実行されて、129 件の結果が返ります。", "id": 1899841, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899841/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99333/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.139427Z", "action": 4, "target": "最後に **Execute Query** ボタン (緑の三角形) をクリックします。", "id": 1899840, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899840/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99331/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.131667Z", "action": 4, "target": "クエリウィンドウに次のクエリを入力して", "id": 1899839, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899839/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99330/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-04T02:58:05.123760Z", "action": 4, "target": "\"Query Tool\" ボタンをクリックして、pgAdmin の SQLクエリウィンドウを開きます。", "id": 1899838, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899838/?format=api" } ] }