tests/ovsdb-tool.at

   1 AT_BANNER([OVSDB -- ovsdb-tool])
   2
   3 # OVSDB_CHECK_EXECUTION(TITLE, SCHEMA, TRANSACTIONS, OUTPUT, [KEYWORDS])
   4 #
   5 # Creates a database with the given SCHEMA and runs each of the
   6 # TRANSACTIONS (which should be a quoted list of quoted strings)
   7 # against it with ovsdb-tool one at a time.
   8 #
   9 # Checks that the overall output is OUTPUT, but UUIDs in the output
  10 # are replaced by markers of the form <N> where N is a number.  The
  11 # first unique UUID is replaced by <0>, the next by <1>, and so on.
  12 # If a given UUID appears more than once it is always replaced by the
  13 # same marker.
  14 #
  15 # TITLE is provided to AT_SETUP and KEYWORDS to AT_KEYWORDS.
  16 m4_define([OVSDB_CHECK_EXECUTION],
  17   [AT_SETUP([$1])
  18    AT_KEYWORDS([ovsdb file positive $5])
  19    $2 > schema
  20    touch .db.~lock~
  21    AT_CHECK([ovsdb-tool create db schema], [0], [stdout], [ignore])
  22    m4_foreach([txn], [$3],
  23      [AT_CHECK([ovsdb-tool transact db 'txn'], [0], [stdout], [ignore])
  24 cat stdout >> output
  25 ])
  26    AT_CHECK([uuidfilt output], [0], [$4])
  27    AT_CLEANUP])
  28
  29 EXECUTION_EXAMPLES
  30
  31 AT_SETUP([transaction comments])
  32 AT_KEYWORDS([ovsdb file positive])
  33 ordinal_schema > schema
  34 touch .db.~lock~
  35 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
  36 AT_CHECK([[ovsdb-tool transact db '
  37     ["ordinals",
  38      {"op": "insert",
  39       "table": "ordinals",
  40       "row": {"name": "five", "number": 5}},
  41      {"op": "comment",
  42       "comment": "add row for 5"}]']], [0], [stdout], [ignore])
  43 AT_CHECK([uuidfilt stdout], [0],
  44  [[[{"uuid":["uuid","<0>"]},{}]
  45 ]])
  46 AT_CHECK([grep "add row for 5" db], [0], [ignore])
  47 AT_CLEANUP
  48
  49 AT_SETUP([ovsdb-tool compact])
  50 AT_KEYWORDS([ovsdb file positive])
  51 ordinal_schema > schema
  52 dnl Make sure that "ovsdb-tool create" works with a dangling symlink,
  53 dnl creating the target of the symlink rather than replacing the symlink
  54 dnl with a regular file, and that the lockfile gets created relative to
  55 dnl the symlink's target.
  56 mkdir dir
  57 : > dir/.db.~lock~
  58 if test "$IS_WIN32" = "no"; then
  59     ln -s dir/db db
  60     AT_SKIP_IF([test ! -h db])
  61 fi
  62 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
  63 if test "$IS_WIN32" = "no"; then
  64     AT_CHECK([test ! -e .db.~lock])
  65     AT_CHECK([test -h db])
  66     AT_CHECK([test -f dir/db])
  67 fi
  68 dnl Do a bunch of random transactions that put crap in the database log.
  69 AT_CHECK(
  70   [[for pair in 'zero 0' 'one 1' 'two 2' 'three 3' 'four 4' 'five 5'; do
  71       set -- $pair
  72       ovsdb-tool transact db '
  73         ["ordinals",
  74          {"op": "insert",
  75           "table": "ordinals",
  76           "row": {"name": "'$1'", "number": '$2'}},
  77          {"op": "comment",
  78           "comment": "add row for '"$pair"'"}]'
  79       ovsdb-tool transact db '
  80         ["ordinals",
  81          {"op": "delete",
  82           "table": "ordinals",
  83           "where": [["number", "==", '$2']]},
  84          {"op": "comment",
  85           "comment": "delete row for '"$2"'"}]'
  86       ovsdb-tool transact db '
  87         ["ordinals",
  88          {"op": "insert",
  89           "table": "ordinals",
  90           "row": {"name": "'$1'", "number": '$2'}},
  91          {"op": "comment",
  92           "comment": "add back row for '"$pair"'"}]'
  93     done]],
  94   [0], [stdout], [ignore])
  95 dnl Check that all the crap is in fact in the database log.
  96 AT_CHECK([[uuidfilt db | grep -v ^OVSDB | sed 's/"_date":[0-9]*/"_date":0/' | ovstest test-json --multiple -]], [0],
  97   [[{"cksum":"12345678 9","name":"ordinals","tables":{"ordinals":{"columns":{"name":{"type":"string"},"number":{"type":"integer"}},"indexes":[["number"]]}},"version":"5.1.3"}
  98 {"_comment":"add row for zero 0","_date":0,"ordinals":{"<0>":{"name":"zero"}}}
  99 {"_comment":"delete row for 0","_date":0,"ordinals":{"<0>":null}}
 100 {"_comment":"add back row for zero 0","_date":0,"ordinals":{"<1>":{"name":"zero"}}}
 101 {"_comment":"add row for one 1","_date":0,"ordinals":{"<2>":{"name":"one","number":1}}}
 102 {"_comment":"delete row for 1","_date":0,"ordinals":{"<2>":null}}
 103 {"_comment":"add back row for one 1","_date":0,"ordinals":{"<3>":{"name":"one","number":1}}}
 104 {"_comment":"add row for two 2","_date":0,"ordinals":{"<4>":{"name":"two","number":2}}}
 105 {"_comment":"delete row for 2","_date":0,"ordinals":{"<4>":null}}
 106 {"_comment":"add back row for two 2","_date":0,"ordinals":{"<5>":{"name":"two","number":2}}}
 107 {"_comment":"add row for three 3","_date":0,"ordinals":{"<6>":{"name":"three","number":3}}}
 108 {"_comment":"delete row for 3","_date":0,"ordinals":{"<6>":null}}
 109 {"_comment":"add back row for three 3","_date":0,"ordinals":{"<7>":{"name":"three","number":3}}}
 110 {"_comment":"add row for four 4","_date":0,"ordinals":{"<8>":{"name":"four","number":4}}}
 111 {"_comment":"delete row for 4","_date":0,"ordinals":{"<8>":null}}
 112 {"_comment":"add back row for four 4","_date":0,"ordinals":{"<9>":{"name":"four","number":4}}}
 113 {"_comment":"add row for five 5","_date":0,"ordinals":{"<10>":{"name":"five","number":5}}}
 114 {"_comment":"delete row for 5","_date":0,"ordinals":{"<10>":null}}
 115 {"_comment":"add back row for five 5","_date":0,"ordinals":{"<11>":{"name":"five","number":5}}}
 116 ]])
 117
 118 dnl Dump out and check the actual database contents.
 119 on_exit 'kill `cat ovsdb-server.pid`'
 120 AT_CHECK([[ovsdb-server --detach --pidfile --no-chdir --remote=punix:socket db]],
 121          [0], [stdout], [ignore])
 122 AT_CHECK([[ovsdb-client dump unix:socket ordinals]],
 123          [0], [stdout], [ignore])
 124 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 125
 126 AT_CHECK([uuidfilt stdout], [0], [dnl
 127 ordinals table
 128 _uuid                                name  number
 129 ------------------------------------ ----- ------
 130 <0> five  5
 131 <1> four  4
 132 <2> one   1
 133 <3> three 3
 134 <4> two   2
 135 <5> zero  0
 136 ])
 137 dnl Now compact the database in-place.
 138 touch .db.tmp.~lock~
 139 AT_CHECK([[ovsdb-tool compact db]], [0], [], [ignore])
 140 dnl Make sure that "db" is still a symlink to dir/db instead of getting
 141 dnl replaced by a regular file.
 142 if test "$IS_WIN32" = "no"; then
 143     AT_CHECK([test ! -e .db.~lock])
 144     AT_CHECK([test -h db])
 145     AT_CHECK([test -f dir/db])
 146 fi
 147 dnl We can't fully re-check the contents of the database log, because the
 148 dnl order of the records is not predictable, but there should only be 4 lines
 149 dnl in it now.
 150 AT_CAPTURE_FILE([db])
 151 AT_CHECK([test `wc -l < db` -eq 4])
 152 dnl And check that the dumped data is the same too:
 153 AT_CHECK([[ovsdb-server --detach --pidfile --no-chdir --remote=punix:socket db]],
 154          [0], [stdout], [ignore])
 155 AT_CHECK([[ovsdb-client dump unix:socket ordinals]],
 156          [0], [stdout], [ignore])
 157 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 158
 159 AT_CHECK([uuidfilt stdout], [0], [dnl
 160 ordinals table
 161 _uuid                                name  number
 162 ------------------------------------ ----- ------
 163 <0> five  5
 164 <1> four  4
 165 <2> one   1
 166 <3> three 3
 167 <4> two   2
 168 <5> zero  0
 169 ])
 170 AT_CLEANUP
 171
 172 AT_SETUP([ovsdb-tool convert -- removing a column])
 173 AT_KEYWORDS([ovsdb file positive])
 174 ordinal_schema > schema
 175 AT_DATA([new-schema],
 176   [[{"name": "ordinals",
 177      "tables": {
 178        "ordinals": {
 179          "columns": {
 180            "number": {"type": "integer"}}}}}
 181 ]])
 182 touch .db.~lock~
 183 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
 184 dnl Put some data in the database.
 185 AT_CHECK(
 186   [[for pair in 'zero 0' 'one 1' 'two 2' 'three 3' 'four 4' 'five 5'; do
 187       set -- $pair
 188       ovsdb-tool transact db '
 189         ["ordinals",
 190          {"op": "insert",
 191           "table": "ordinals",
 192           "row": {"name": "'$1'", "number": '$2'}},
 193          {"op": "comment",
 194           "comment": "add row for '"$pair"'"}]'
 195     done]],
 196   [0], [stdout], [ignore])
 197 dnl Dump out and check the actual database contents.
 198 AT_CHECK([[ovsdb-server --detach --no-chdir --pidfile --remote=punix:socket db]],
 199   [0])
 200 AT_CHECK([ovsdb-client dump unix:socket ordinals], [0], [stdout], [ignore])
 201 AT_CHECK([uuidfilt stdout], [0], [dnl
 202 ordinals table
 203 _uuid                                name  number
 204 ------------------------------------ ----- ------
 205 <0> five  5
 206 <1> four  4
 207 <2> one   1
 208 <3> three 3
 209 <4> two   2
 210 <5> zero  0
 211 ])
 212 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 213 dnl Now convert the database in-place.
 214 touch .db.tmp.~lock~
 215 AT_CHECK([[ovsdb-tool convert db new-schema]], [0], [], [ignore])
 216 dnl We can't fully re-check the contents of the database log, because the
 217 dnl order of the records is not predictable, but there should only be 4 lines
 218 dnl in it now.
 219 AT_CAPTURE_FILE([db])
 220 AT_CHECK([test `wc -l < db` -eq 4])
 221 dnl And check that the dumped data is the same except for the removed column:
 222 AT_CHECK([[ovsdb-server --detach --no-chdir --pidfile --remote=punix:socket db]],
 223   [0])
 224 AT_CHECK([ovsdb-client dump unix:socket ordinals], [0], [stdout], [ignore])
 225 AT_CHECK([uuidfilt stdout], [0], [dnl
 226 ordinals table
 227 _uuid                                number
 228 ------------------------------------ ------
 229 <0> 0
 230 <1> 1
 231 <2> 2
 232 <3> 3
 233 <4> 4
 234 <5> 5
 235 ])
 236 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 237 AT_CLEANUP
 238
 239 AT_SETUP([ovsdb-tool convert -- adding a column])
 240 AT_KEYWORDS([ovsdb file positive])
 241 AT_DATA([schema],
 242   [[{"name": "ordinals",
 243      "tables": {
 244        "ordinals": {
 245          "columns": {
 246            "number": {"type": "integer"}}}}}
 247 ]])
 248 ordinal_schema > new-schema
 249 touch .db.~lock~
 250 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
 251 dnl Put some data in the database.
 252 AT_CHECK(
 253   [[for number in 0 1 2 3 4 5; do
 254       ovsdb-tool transact db '
 255         ["ordinals",
 256          {"op": "insert",
 257           "table": "ordinals",
 258           "row": {"number": '$number'}},
 259          {"op": "comment",
 260           "comment": "add row for '"$number"'"}]'
 261     done]],
 262   [0], [stdout], [ignore])
 263 dnl Dump out and check the actual database contents.
 264 AT_CHECK([[ovsdb-server --detach --no-chdir --pidfile --remote=punix:socket db]],
 265   [0])
 266 AT_CHECK([ovsdb-client dump unix:socket ordinals], [0], [stdout], [ignore])
 267 AT_CHECK([uuidfilt stdout], [0], [dnl
 268 ordinals table
 269 _uuid                                number
 270 ------------------------------------ ------
 271 <0> 0
 272 <1> 1
 273 <2> 2
 274 <3> 3
 275 <4> 4
 276 <5> 5
 277 ])
 278 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 279 dnl Now convert the database in-place.
 280 touch .db.tmp.~lock~
 281 AT_CHECK([[ovsdb-tool convert db new-schema]], [0], [], [ignore])
 282 dnl We can't fully re-check the contents of the database log, because the
 283 dnl order of the records is not predictable, but there should only be 4 lines
 284 dnl in it now.
 285 AT_CAPTURE_FILE([db])
 286 AT_CHECK([test `wc -l < db` -eq 4])
 287 dnl And check that the dumped data is the same except for the added column:
 288 AT_CHECK([[ovsdb-server --detach --no-chdir --pidfile --remote=punix:socket db]],
 289   [0])
 290 AT_CHECK([ovsdb-client dump unix:socket ordinals], [0], [stdout], [ignore])
 291 AT_CHECK([uuidfilt stdout], [0], [dnl
 292 ordinals table
 293 _uuid                                name number
 294 ------------------------------------ ---- ------
 295 <0> ""   0
 296 <1> ""   1
 297 <2> ""   2
 298 <3> ""   3
 299 <4> ""   4
 300 <5> ""   5
 301 ])
 302 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 303 AT_CLEANUP
 304
 305 AT_SETUP([ovsdb-tool unsupported cluster operations])
 306 AT_KEYWORDS([ovsdb file negative compact query transact convert])
 307 ordinal_schema > schema
 308 AT_CHECK([ovsdb-tool create-cluster db schema unix:s1.raft])
 309 AT_CHECK([ovsdb-tool compact db], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 310 ])
 311 AT_CHECK([ovsdb-tool convert db schema], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 312 ])
 313 AT_CHECK([ovsdb-tool needs-conversion db schema], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 314 ])
 315 AT_CHECK([ovsdb-tool query db '[[]]'], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 316 ])
 317 AT_CHECK([ovsdb-tool transact db '[[]]'], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 318 ])
 319 AT_CLEANUP
 320
 321 AT_SETUP([ovsdb-tool schema-version, schema-cksum, schema-name])
 322 AT_KEYWORDS([ovsdb file positive schema-version schema-cksum])
 323 ordinal_schema > schema
 324 AT_CHECK([ovsdb-tool schema-version schema], [0], [5.1.3
 325 ])
 326 AT_CHECK([ovsdb-tool schema-cksum schema], [0], [12345678 9
 327 ])
 328 AT_CHECK([ovsdb-tool schema-name schema], [0], [ordinals
 329 ])
 330 AT_CLEANUP
 331
 332 AT_SETUP([ovsdb-tool database inspection commands - standalone])
 333 AT_KEYWORDS([ovsdb file positive db-version db-cksum db-name db-cid db-sid db-local-address])
 334 ordinal_schema > schema
 335 touch .db.~lock~
 336 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
 337 AT_CHECK([ovsdb-tool db-version db], [0], [5.1.3
 338 ])
 339 AT_CHECK([ovsdb-tool db-cksum db], [0], [12345678 9
 340 ])
 341 AT_CHECK([ovsdb-tool db-name db], [0], [ordinals
 342 ])
 343 AT_CHECK([ovsdb-tool db-cid db], [1], [], [ovsdb-tool: db: not a clustered database
 344 ])
 345 AT_CHECK([ovsdb-tool db-sid db], [1], [], [ovsdb-tool: db: not a clustered database
 346 ])
 347 AT_CHECK([ovsdb-tool db-local-address db], [1], [], [ovsdb-tool: db: not a clustered database
 348 ])
 349 AT_CLEANUP
 350
 351 AT_SETUP([ovsdb-tool database inspection commands - clustered])
 352 AT_KEYWORDS([ovsdb file negative db-version db-cksum db-name db-cid db-sid db-local-address cluster])
 353 ordinal_schema > schema
 354 touch .db.~lock~
 355 AT_CHECK([ovsdb-tool create-cluster db schema tcp:1.2.3.4:1234])
 356 AT_CHECK([ovsdb-tool db-version db], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 357 ])
 358 AT_CHECK([ovsdb-tool db-cksum db], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 359 ])
 360 AT_CHECK([ovsdb-tool db-name db], [0], [ordinals
 361 ])
 362 AT_CHECK([(ovsdb-tool db-cid db; ovsdb-tool db-sid db) | uuidfilt], [0], [<0>
 363 <1>
 364 ])
 365 AT_CHECK([ovsdb-tool db-local-address db], [0], [tcp:1.2.3.4:1234
 366 ])
 367 AT_CLEANUP
 368
 369 AT_SETUP([ovsdb-tool database inspection commands - joining a cluster])
 370 AT_KEYWORDS([ovsdb file positive db-version db-cksum db-name db-cid db-sid db-local-address cluster join joining])
 371 ordinal_schema > schema
 372 touch .db.~lock~
 373 for cid in '' 520cf525-3772-43cc-8268-23bf5b548cf4; do
 374     if test -z "$cid"; then
 375         cid_option=
 376     else
 377         cid_option=--cid=$cid
 378     fi
 379     AT_CHECK([rm -f db && ovsdb-tool $cid_option join-cluster db ordinals tcp:1.2.3.4:1234 tcp:2.3.4.5:1234], [0], [], [ignore])
 380     AT_CHECK([ovsdb-tool db-version db], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 381 ])
 382     AT_CHECK([ovsdb-tool db-cksum db], [1], [], [ovsdb-tool: ovsdb error: db: cannot apply this operation to clustered database file
 383 ])
 384     AT_CHECK([ovsdb-tool db-name db], [0], [ordinals
 385 ])
 386     if test -z "$cid"; then
 387         AT_CHECK([ovsdb-tool db-cid db], [2], [], [db: cluster ID not yet known
 388 ])
 389     else
 390         AT_CHECK_UNQUOTED([ovsdb-tool db-cid db], [0], [$cid
 391 ])
 392     fi
 393     AT_CHECK([ovsdb-tool db-sid db | uuidfilt], [0], [<0>
 394 ])
 395     AT_CHECK([ovsdb-tool db-local-address db], [0], [tcp:1.2.3.4:1234
 396 ])
 397 done
 398 AT_CLEANUP
 399
 400 AT_SETUP([ovsdb-tool needs-conversion (no conversion needed)])
 401 AT_KEYWORDS([ovsdb file positive])
 402 ordinal_schema > schema
 403 touch .db.~lock~
 404 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
 405 AT_CHECK([ovsdb-tool needs-conversion db schema], [0], [no
 406 ])
 407 AT_CLEANUP
 408
 409 AT_SETUP([ovsdb-tool needs-conversion (conversion needed)])
 410 AT_KEYWORDS([ovsdb file positive])
 411 ordinal_schema > schema
 412 touch .db.~lock~
 413 AT_CHECK([ovsdb-tool create db schema], [0], [], [ignore])
 414 sed 's/5\.1\.3/5.1.4/' < schema > schema2
 415 AT_CHECK([diff schema schema2], [1], [ignore])
 416 AT_CHECK([ovsdb-tool needs-conversion db schema2], [0], [yes
 417 ])
 418 AT_CLEANUP
 419
 420 AT_SETUP([ovsdb-tool create-cluster with initial data])
 421 AT_KEYWORDS([ovsdb file positive])
 422
 423 # Create a standalone database and put some data in it.
 424 ordinal_schema > schema
 425 ovsdb-tool create db1 schema
 426 AT_CHECK(
 427   [[for pair in 'zero 0' 'one 1' 'two 2' 'three 3' 'four 4' 'five 5'; do
 428       set -- $pair
 429       ovsdb-tool transact db1 '
 430         ["ordinals",
 431          {"op": "insert",
 432           "table": "ordinals",
 433           "row": {"name": "'$1'", "number": '$2'}},
 434          {"op": "comment",
 435           "comment": "add row for '"$pair"'"}]'
 436     done | uuidfilt]], [0],
 437 [[[{"uuid":["uuid","<0>"]},{}]
 438 [{"uuid":["uuid","<1>"]},{}]
 439 [{"uuid":["uuid","<2>"]},{}]
 440 [{"uuid":["uuid","<3>"]},{}]
 441 [{"uuid":["uuid","<4>"]},{}]
 442 [{"uuid":["uuid","<5>"]},{}]
 443 ]], [ignore])
 444
 445 # Dump the data.
 446 AT_CHECK([ovsdb-server -vfile -vvlog:off --detach --no-chdir --pidfile --log-file --remote=punix:db.sock db1])
 447 AT_CHECK([ovsdb-client dump > expout])
 448 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 449
 450 # Create a clustered database from the standalone one.
 451 ovsdb-tool create-cluster db2 db1 unix:s1.raft
 452
 453 # Dump the data.
 454 AT_CHECK([ovsdb-server -vconsole:off -vfile -vvlog:off --detach --no-chdir --pidfile --log-file --remote=punix:db.sock db2])
 455 AT_CHECK([ovsdb-client wait ordinals connected])
 456 AT_CHECK([ovsdb-client dump > dump2])
 457 OVS_APP_EXIT_AND_WAIT([ovsdb-server])
 458
 459 # Make sure that the clustered data matched the standalone data.
 460 AT_CHECK([cat dump2], [0], [expout])
 461 AT_CLEANUP