Zabbix

---

test case: "successfully parsed #1"

in:

  start_id: 100

  count1: 1

  count2: 0

  shift: 0

  repeat: 0

  field_name: itemid

  sql_where: select * from items where

out:

  sql_regex: select \* from items where itemid=100

  sqlora_regex: select \* from items where itemid=100

  sqlite_regex: select \* from items where itemid=100

---

test case: "successfully parsed #4"

in:

  start_id: 100

  count1: 4

  count2: 0

  shift: 0

  repeat: 0

  field_name: itemid

  sql_where: select * from items where

out:

  sql_regex: select \* from items where itemid in \(100,(?:\d+,){2}103\)

  sqlora_regex: select \* from items where itemid in \(100,(?:\d+,){2}103\)

  sqlite_regex: select \* from items where itemid in \(100,(?:\d+,){2}103\)

---

test case: "successfully parsed #10"

in:

  start_id: 100

  count1: 10

  count2: 0

  shift: 0

  repeat: 0

  field_name: itemid

  sql_where: select * from items where

out:

  sql_regex: select \* from items where itemid in \(100,(?:\d+,){8}109\)

  sqlora_regex: select \* from items where itemid between 100 and 109

  sqlite_regex: select \* from items where itemid in \(100,(?:\d+,){8}109\)

---

test case: "successfully parsed #951"

in:

  start_id: 1000

  count1: 951

  count2: 0

  shift: 0

  repeat: 0

  field_name: itemid

  sql_where: select * from items where

out:

  sql_regex: select \* from items where itemid in \(1000,(?:\d+,){949}1950\)

  sqlora_regex: select \* from items where itemid between 1000 and 1950

  sqlite_regex: select \* from items where \(itemid in \(1000,(?:\d+,){948}1949\) or itemid in \(1950\)

---

test case: "successfully parsed #1000"

in:

  start_id: 1000

  count1: 1000

  count2: 0

  shift: 0