2 * Copyright (c) 2009, 2010, 2011 Nicira Networks.
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at:
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
26 #include "command-line.h"
29 #include "dynamic-string.h"
35 #include "ovsdb-data.h"
36 #include "ovsdb-error.h"
37 #include "socket-util.h"
43 VLOG_DEFINE_THIS_MODULE(ovsdb_tool);
45 /* -m, --more: Verbosity level for "show-log" command output. */
46 static int show_log_verbosity;
48 static const struct command all_commands[];
50 static void usage(void) NO_RETURN;
51 static void parse_options(int argc, char *argv[]);
53 static const char *default_db(void);
54 static const char *default_schema(void);
57 main(int argc, char *argv[])
59 set_program_name(argv[0]);
60 parse_options(argc, argv);
61 signal(SIGPIPE, SIG_IGN);
62 run_command(argc - optind, argv + optind, all_commands);
67 parse_options(int argc, char *argv[])
69 static struct option long_options[] = {
70 {"more", no_argument, NULL, 'm'},
71 {"verbose", optional_argument, NULL, 'v'},
72 {"help", no_argument, NULL, 'h'},
73 {"version", no_argument, NULL, 'V'},
76 char *short_options = long_options_to_short_options(long_options);
81 c = getopt_long(argc, argv, short_options, long_options, NULL);
95 ovs_print_version(0, 0);
99 vlog_set_verbosity(optarg);
115 printf("%s: Open vSwitch database management utility\n"
116 "usage: %s [OPTIONS] COMMAND [ARG...]\n"
117 " create [DB [SCHEMA]] create DB with the given SCHEMA\n"
118 " compact [DB [DST]] compact DB in-place (or to DST)\n"
119 " convert [DB [SCHEMA [DST]]] convert DB to SCHEMA (to DST)\n"
120 " db-version [DB] report version of schema used by DB\n"
121 " db-cksum [DB] report checksum of schema used by DB\n"
122 " schema-version [SCHEMA] report SCHEMA's schema version\n"
123 " schema-cksum [SCHEMA] report SCHEMA's checksum\n"
124 " query [DB] TRNS execute read-only transaction on DB\n"
125 " transact [DB] TRNS execute read/write transaction on DB\n"
126 " [-m]... show-log [DB] print DB's log entries\n"
127 "The default DB is %s.\n"
128 "The default SCHEMA is %s.\n",
129 program_name, program_name, default_db(), default_schema());
131 printf("\nOther options:\n"
132 " -m, --more increase show-log verbosity\n"
133 " -h, --help display this help message\n"
134 " -V, --version display version information\n");
143 db = xasprintf("%s/conf.db", ovs_sysconfdir());
153 schema = xasprintf("%s/vswitch.ovsschema", ovs_pkgdatadir());
159 parse_json(const char *s)
161 struct json *json = json_from_string(s);
162 if (json->type == JSON_STRING) {
163 ovs_fatal(0, "\"%s\": %s", s, json->u.string);
169 print_and_free_json(struct json *json)
171 char *string = json_to_string(json, JSSF_SORT);
178 check_ovsdb_error(struct ovsdb_error *error)
181 ovs_fatal(0, "%s", ovsdb_error_to_string(error));
186 do_create(int argc, char *argv[])
188 const char *db_file_name = argc >= 2 ? argv[1] : default_db();
189 const char *schema_file_name = argc >= 3 ? argv[2] : default_schema();
190 struct ovsdb_schema *schema;
191 struct ovsdb_log *log;
194 /* Read schema from file and convert to JSON. */
195 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema));
196 json = ovsdb_schema_to_json(schema);
197 ovsdb_schema_destroy(schema);
199 /* Create database file. */
200 check_ovsdb_error(ovsdb_log_open(db_file_name, OVSDB_LOG_CREATE,
202 check_ovsdb_error(ovsdb_log_write(log, json));
203 check_ovsdb_error(ovsdb_log_commit(log));
204 ovsdb_log_close(log);
210 compact_or_convert(const char *src_name, const char *dst_name,
211 const struct ovsdb_schema *new_schema,
214 struct lockfile *src_lock;
215 struct lockfile *dst_lock;
216 bool in_place = dst_name == NULL;
220 /* Lock the source, if we will be replacing it. */
222 retval = lockfile_lock(src_name, 0, &src_lock);
224 ovs_fatal(retval, "%s: failed to lock lockfile", src_name);
228 /* Get (temporary) destination and lock it. */
230 dst_name = xasprintf("%s.tmp", src_name);
232 retval = lockfile_lock(dst_name, 0, &dst_lock);
234 ovs_fatal(retval, "%s: failed to lock lockfile", dst_name);
238 check_ovsdb_error(new_schema
239 ? ovsdb_file_open_as_schema(src_name, new_schema, &db)
240 : ovsdb_file_open(src_name, true, &db, NULL));
241 check_ovsdb_error(ovsdb_file_save_copy(dst_name, false, comment, db));
244 /* Replace source. */
246 if (rename(dst_name, src_name)) {
247 ovs_fatal(errno, "failed to rename \"%s\" to \"%s\"",
250 fsync_parent_dir(dst_name);
251 lockfile_unlock(src_lock);
254 lockfile_unlock(dst_lock);
258 do_compact(int argc, char *argv[])
260 const char *db = argc >= 2 ? argv[1] : default_db();
261 const char *target = argc >= 3 ? argv[2] : NULL;
263 compact_or_convert(db, target, NULL,
264 "compacted by ovsdb-tool "VERSION BUILDNR);
268 do_convert(int argc, char *argv[])
270 const char *db = argc >= 2 ? argv[1] : default_db();
271 const char *schema = argc >= 3 ? argv[2] : default_schema();
272 const char *target = argc >= 4 ? argv[3] : NULL;
273 struct ovsdb_schema *new_schema;
275 check_ovsdb_error(ovsdb_schema_from_file(schema, &new_schema));
276 compact_or_convert(db, target, new_schema,
277 "converted by ovsdb-tool "VERSION BUILDNR);
278 ovsdb_schema_destroy(new_schema);
282 do_needs_conversion(int argc, char *argv[])
284 const char *db_file_name = argc >= 2 ? argv[1] : default_db();
285 const char *schema_file_name = argc >= 3 ? argv[2] : default_schema();
286 struct ovsdb_schema *schema1, *schema2;
288 check_ovsdb_error(ovsdb_file_read_schema(db_file_name, &schema1));
289 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema2));
290 puts(ovsdb_schema_equal(schema1, schema2) ? "no" : "yes");
291 ovsdb_schema_destroy(schema1);
292 ovsdb_schema_destroy(schema2);
296 do_db_version(int argc, char *argv[])
298 const char *db_file_name = argc >= 2 ? argv[1] : default_db();
299 struct ovsdb_schema *schema;
301 check_ovsdb_error(ovsdb_file_read_schema(db_file_name, &schema));
302 puts(schema->version);
303 ovsdb_schema_destroy(schema);
307 do_db_cksum(int argc OVS_UNUSED, char *argv[])
309 const char *db_file_name = argc >= 2 ? argv[1] : default_db();
310 struct ovsdb_schema *schema;
312 check_ovsdb_error(ovsdb_file_read_schema(db_file_name, &schema));
314 ovsdb_schema_destroy(schema);
318 do_schema_version(int argc, char *argv[])
320 const char *schema_file_name = argc >= 2 ? argv[1] : default_schema();
321 struct ovsdb_schema *schema;
323 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema));
324 puts(schema->version);
325 ovsdb_schema_destroy(schema);
329 do_schema_cksum(int argc, char *argv[])
331 const char *schema_file_name = argc >= 2 ? argv[1] : default_schema();
332 struct ovsdb_schema *schema;
334 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema));
336 ovsdb_schema_destroy(schema);
340 transact(bool read_only, int argc, char *argv[])
342 const char *db_file_name = argc >= 3 ? argv[1] : default_db();
343 const char *transaction = argv[argc - 1];
344 struct json *request, *result;
347 check_ovsdb_error(ovsdb_file_open(db_file_name, read_only, &db, NULL));
349 request = parse_json(transaction);
350 result = ovsdb_execute(db, NULL, request, 0, NULL);
351 json_destroy(request);
353 print_and_free_json(result);
358 do_query(int argc, char *argv[])
360 transact(true, argc, argv);
364 do_transact(int argc, char *argv[])
366 transact(false, argc, argv);
370 print_db_changes(struct shash *tables, struct shash *names,
371 const struct ovsdb_schema *schema)
373 struct shash_node *n1;
375 SHASH_FOR_EACH (n1, tables) {
376 const char *table = n1->name;
377 struct ovsdb_table_schema *table_schema;
378 struct json *rows = n1->data;
379 struct shash_node *n2;
381 if (n1->name[0] == '_' || rows->type != JSON_OBJECT) {
385 table_schema = shash_find_data(&schema->tables, table);
386 SHASH_FOR_EACH (n2, json_object(rows)) {
387 const char *row_uuid = n2->name;
388 struct json *columns = n2->data;
389 struct shash_node *n3;
390 char *old_name, *new_name;
391 bool free_new_name = false;
393 old_name = new_name = shash_find_data(names, row_uuid);
394 if (columns->type == JSON_OBJECT) {
395 struct json *new_name_json;
397 new_name_json = shash_find_data(json_object(columns), "name");
399 new_name = json_to_string(new_name_json, JSSF_SORT);
400 free_new_name = true;
404 printf("\ttable %s", table);
408 printf(" insert row %s (%.8s):\n", new_name, row_uuid);
410 printf(" insert row %.8s:\n", row_uuid);
413 printf(" row %s (%.8s):\n", old_name, row_uuid);
416 if (columns->type == JSON_OBJECT) {
417 if (show_log_verbosity > 1) {
418 SHASH_FOR_EACH (n3, json_object(columns)) {
419 const char *column = n3->name;
420 const struct ovsdb_column *column_schema;
421 struct json *value = n3->data;
422 char *value_string = NULL;
426 ? shash_find_data(&table_schema->columns, column)
429 const struct ovsdb_error *error;
430 const struct ovsdb_type *type;
431 struct ovsdb_datum datum;
433 type = &column_schema->type;
434 error = ovsdb_datum_from_json(&datum, type,
440 ovsdb_datum_to_string(&datum, type, &s);
441 value_string = ds_steal_cstr(&s);
445 value_string = json_to_string(value, JSSF_SORT);
447 printf("\t\t%s=%s\n", column, value_string);
452 || (new_name != old_name && strcmp(old_name, new_name))) {
454 shash_delete(names, shash_find(names, row_uuid));
457 shash_add(names, row_uuid, (new_name
459 : xmemdup0(row_uuid, 8)));
461 } else if (columns->type == JSON_NULL) {
462 struct shash_node *node;
464 printf("\t\tdelete row\n");
465 node = shash_find(names, row_uuid);
467 shash_delete(names, node);
480 do_show_log(int argc, char *argv[])
482 const char *db_file_name = argc >= 2 ? argv[1] : default_db();
484 struct ovsdb_log *log;
485 struct ovsdb_schema *schema;
488 check_ovsdb_error(ovsdb_log_open(db_file_name, OVSDB_LOG_READ_ONLY,
495 check_ovsdb_error(ovsdb_log_read(log, &json));
500 printf("record %u:", i);
502 check_ovsdb_error(ovsdb_schema_from_json(json, &schema));
503 printf(" \"%s\" schema, version=\"%s\", cksum=\"%s\"\n",
504 schema->name, schema->version, schema->cksum);
505 } else if (json->type == JSON_OBJECT) {
506 struct json *date, *comment;
508 date = shash_find_data(json_object(json), "_date");
509 if (date && date->type == JSON_INTEGER) {
510 time_t t = json_integer(date);
513 strftime(s, sizeof s, "%Y-%m-%d %H:%M:%S", localtime(&t));
517 comment = shash_find_data(json_object(json), "_comment");
518 if (comment && comment->type == JSON_STRING) {
519 printf(" \"%s\"", json_string(comment));
522 if (i > 0 && show_log_verbosity > 0) {
524 print_db_changes(json_object(json), &names, schema);
531 ovsdb_log_close(log);
532 ovsdb_schema_destroy(schema);
533 /* XXX free 'names'. */
537 do_help(int argc OVS_UNUSED, char *argv[] OVS_UNUSED)
542 static const struct command all_commands[] = {
543 { "create", 0, 2, do_create },
544 { "compact", 0, 2, do_compact },
545 { "convert", 0, 3, do_convert },
546 { "needs-conversion", 0, 2, do_needs_conversion },
547 { "db-version", 0, 1, do_db_version },
548 { "db-cksum", 0, 1, do_db_cksum },
549 { "schema-version", 0, 1, do_schema_version },
550 { "schema-cksum", 0, 1, do_schema_cksum },
551 { "query", 1, 2, do_query },
552 { "transact", 1, 2, do_transact },
553 { "show-log", 0, 1, do_show_log },
554 { "help", 0, INT_MAX, do_help },
555 { NULL, 0, 0, NULL },