Grep поиск и вывод блока?

Question

[Богдан]

Здравствуйте. Как правильно написать grep. Нужно найти значение и вывести весь блок который начитается со
Started и заканчивается Completed

Started POST "/institution/timesheets/ajax_filter_timesheets" for 127.0.0.1 at 2017-08-22 11:33:31 +0300
Processing by Institution::TimesheetsController#ajax_filter_timesheets as */*
  Parameters: {"date_start"=>"01.08.2017", "date_end"=>"31.08.2017", "sort_field"=>"", "sort_order"=>"", "timesheet"=>{}}
  Rendered institution/timesheets/ajax_filter_timesheets.js.erb (229.2ms)
Completed 200 OK in 780ms (Views: 587.7ms | ActiveRecord: 4.5ms)


Started GET "/institution/timesheets/dates?id=1191" for 127.0.0.1 at 2017-08-22 11:34:22 +0300
Processing by Institution::TimesheetsController#dates as HTML
  Parameters: {"id"=>"1191"}
  [1m[35m (28.0ms)[0m  [1m[33m          UPDATE timesheet_dates SET reasons_absence_id='2' WHERE id = 3083371
[0m
  [1m[36mInstitution Load (1.0ms)[0m  [1m[34mSELECT  "institutions"."id", "institutions"."code", "institutions"."name", "institutions"."branch_id" FROM "institutions" WHERE "institutions"."id" = $1 LIMIT $2[0m  [["id", 94], ["LIMIT", 1]]
Completed 200 OK in 582ms (Views: 411.4ms | ActiveRecord: 47.0ms)


Started POST "/institution/timesheets/ajax_filter_timesheet_dates" for 127.0.0.1 at 2017-08-22 11:34:23 +0300
Processing by Institution::TimesheetsController#ajax_filter_timesheet_dates as */*
  Parameters: {"id"=>1191, "field_id"=>"", "timesheet"=>{"id"=>1191}}
  Rendered institution/timesheets/ajax_filter_timesheet_dates.js.erb (5133.9ms)
Completed 200 OK in 13136ms (Views: 5467.0ms | ActiveRecord: 291.2ms)

Пока вот только написал выводит с начала файла и конец блока.

grep -Pzo "Star(.|\n)*?id = 308(.|\n)*?(?=\n{2})" ./log/development.log

а в результате нужен только блок

Started GET "/institution/timesheets/dates?id=1191" for 127.0.0.1 at 2017-08-22 11:34:22 +0300
Processing by Institution::TimesheetsController#dates as HTML
  Parameters: {"id"=>"1191"}
  [1m[35m (28.0ms)[0m  [1m[33m          UPDATE timesheet_dates SET reasons_absence_id='2' WHERE id = 3083371
[0m
  [1m[36mInstitution Load (1.0ms)[0m  [1m[34mSELECT  "institutions"."id", "institutions"."code", "institutions"."name", "institutions"."branch_id" FROM "institutions" WHERE "institutions"."id" = $1 LIMIT $2[0m  [["id", 94], ["LIMIT", 1]]
Completed 200 OK in 582ms (Views: 411.4ms | ActiveRecord: 47.0ms)

Comments

[Богдан]

Ваш вариант вообще не рабочий
Ключ

-z, --null-data
Treat the input as a set of lines, each terminated by a zero byte (the ASCII
NUL character) instead of a newline. Like the -Z or --null option, this option
can be used with commands like sort -z to process arbitrary file names.

все стает одной строкой и уже не будут работать ^ и $

Answer 1

[xp3]

cat test.txt | grep -oPz "^Started[\s\S]*?^Completed"

Comments

[Богдан]

Спасибо за отклик. Но не работает Ваша команда.

[xp3]

Богдан:
может не совсем понял вашу задачу
cat test.txt | grep -oPz "^Started[\s\w\"/?]*id=[0-9]{1,4}[\s\w\S]*?^Completed?"

это отрабатывает на примере выше

[Богдан]

Не работает.
Вот реальный файл.

spoiler

Started POST "/institution/receipts/product_update" for 127.0.0.1 at 2017-08-30 17:39:52 +0300
Processing by Institution::ReceiptsController#product_update as */*
Parameters: {"id"=>1674, "count_invoice"=>10, "receipt"=>{"id"=>1674}}
[1m[36mUser Load (0.5ms)[0m [1m[34mSELECT "users"."id", "users"."username", "users"."userable_type", "users"."userable_id" FROM "users" WHERE "users"."id" = $1 LIMIT $2[0m [["id", 2], ["LIMIT", 1]]
Unpermitted parameters: :id, :receipt
[1m[35m (1.0ms)[0m [1m[33m UPDATE receipt_products SET count_invoice=10 WHERE id = 1674
[0m
Completed 200 OK in 6ms (Views: 0.3ms | ActiveRecord: 1.5ms)

Started POST "/institution/receipts/product_update" for 127.0.0.1 at 2017-08-30 17:39:52 +0300
Processing by Institution::ReceiptsController#product_update as */*
Parameters: {"id"=>1674, "count"=>10, "receipt"=>{"id"=>1674}}
[1m[36mUser Load (0.5ms)[0m [1m[34mSELECT "users"."id", "users"."username", "users"."userable_type", "users"."userable_id" FROM "users" WHERE "users"."id" = $1 LIMIT $2[0m [["id", 2], ["LIMIT", 1]]
Unpermitted parameters: :id, :receipt
[1m[35m (1.5ms)[0m [1m[33m UPDATE receipt_products SET count=10 WHERE id = 1674
[0m
Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 2.0ms)

Started POST "/institution/receipts/product_update" for 127.0.0.1 at 2017-08-30 17:39:55 +0300
Started POST "/institution/receipts/product_update" for 127.0.0.1 at 2017-08-30 17:39:55 +0300
Processing by Institution::ReceiptsController#product_update as */*
Processing by Institution::ReceiptsController#product_update as */*
Parameters: {"id"=>1675, "count"=>5, "receipt"=>{"id"=>1675}}
Parameters: {"id"=>1675, "count_invoice"=>5, "receipt"=>{"id"=>1675}}
[1m[36mUser Load (0.5ms)[0m [1m[34mSELECT "users"."id", "users"."username", "users"."userable_type", "users"."userable_id" FROM "users" WHERE "users"."id" = $1 LIMIT $2[0m [["id", 2], ["LIMIT", 1]]
[1m[36mUser Load (1.5ms)[0m [1m[34mSELECT "users"."id", "users"."username", "users"."userable_type", "users"."userable_id" FROM "users" WHERE "users"."id" = $1 LIMIT $2[0m [["id", 2], ["LIMIT", 1]]
Unpermitted parameters: :id, :receipt
Unpermitted parameters: :id, :receipt
[1m[35m (1.0ms)[0m [1m[33m UPDATE receipt_products SET count_invoice=5 WHERE id = 1675
[0m
Completed 200 OK in 8ms (Views: 0.3ms | ActiveRecord: 1.5ms)

[1m[35m (4.0ms)[0m [1m[33m UPDATE receipt_products SET count=5 WHERE id = 1675
[0m
Completed 200 OK in 12ms (Views: 0.3ms | ActiveRecord: 5.5ms)

Started POST "/institution/receipts/send_sa" for 127.0.0.1 at 2017-08-30 17:39:55 +0300
Processing by Institution::ReceiptsController#send_sa as */*
Parameters: {"id"=>"1050", "receipt"=>{"id"=>"1050"}}
[1m[36mUser Load (0.6ms)[0m [1m[34mSELECT "users"."id", "users"."username", "users"."userable_type", "users"."userable_id" FROM "users" WHERE "users"."id" = $1 LIMIT $2[0m [["id", 2], ["LIMIT", 1]]
[1m[36mReceipt Load (2.0ms)[0m [1m[34mSELECT "receipts"."id", "receipts"."invoice_number", "receipts"."number", "receipts"."date", "receipts"."contract_number", supplier_orders.number AS so_number FROM "receipts" INNER JOIN "supplier_orders" ON "supplier_orders"."id" = "receipts"."supplier_order_id" WHERE "receipts"."id" = $1 LIMIT $2[0m [["id", 1050], ["LIMIT", 1]]
[1m[36mReceiptProduct Load (1.5ms)[0m [1m[34mSELECT "receipt_products"."id", "receipt_products"."count", "receipt_products"."count_invoice", "receipt_products"."date", "receipt_products"."product_id", causes_deviations.code AS deviation_code, products.code AS product_code FROM "receipt_products" INNER JOIN "causes_deviations" ON "causes_deviations"."id" = "receipt_products"."causes_deviation_id" INNER JOIN "products" ON "products"."id" = "receipt_products"."product_id" WHERE ("receipt_products"."receipt_id" = $1 AND ("receipt_products"."count" != $2) OR "receipt_products"."receipt_id" = $3 AND ("receipt_products"."count_invoice" != $4))[0m [["receipt_id", 1050], ["count", 0], ["receipt_id", 1050], ["count_invoice", 0]]
[1m[36mInstitution Load (1.0ms)[0m [1m[34mSELECT "institutions"."id", "institutions"."code", "institutions"."name", "institutions"."branch_id" FROM "institutions" WHERE "institutions"."id" = $1 LIMIT $2[0m [["id", 38], ["LIMIT", 1]]
Completed 200 OK in 12213ms (Views: 0.6ms | ActiveRecord: 5.1ms)

Вот результат команды


Ну в рамках заданичи нужно например отыскать значение и вывести весть блок к которому оно относиться, например, нужно отыскать значение
UPDATE receipt_products SET count=10 WHERE id = 1674


и вывести блок

Started POST "/institution/receipts/product_update" for 127.0.0.1 at 2017-08-30 17:39:52 +0300
Processing by Institution::ReceiptsController#product_update as */*
  Parameters: {"id"=>1674, "count"=>10, "receipt"=>{"id"=>1674}}
  [1m[36mUser Load (0.5ms)[0m  [1m[34mSELECT  "users"."id", "users"."username", "users"."userable_type", "users"."userable_id" FROM "users" WHERE "users"."id" = $1 LIMIT $2[0m  [["id", 2], ["LIMIT", 1]]
Unpermitted parameters: :id, :receipt
  [1m[35m (1.5ms)[0m  [1m[33m          UPDATE receipt_products SET count=10 WHERE id = 1674
[0m
Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 2.0ms)

Answer 2

[Ингвар]

grep 'Parameters:' -C 2

нашел более гибкий и точный ответ в Инете:

pcregrep -M 'Started.*\n.* Parameters.*\nCompleted.*'

ссылка на много примеров

Comments

[Богдан]

я использую Windws 10 и git bash , и там нет утилиты pcregrep .

[Ингвар]

1. поставить можно?
2. перейти на Linux?

[Богдан]

2. Из-за одной команды менять Ось, я конечно городской сумасшедший, но тут уже перебор )))

[Ингвар]

https://habrahabr.ru/company/spbau/blog/243473/ можно сразу в конец к главе "А почему всё-таки Linux так хорош?" ))