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.
25 #include "command-line.h"
32 #include "ovsdb-error.h"
33 #include "socket-util.h"
39 VLOG_DEFINE_THIS_MODULE(ovsdb_tool);
41 /* -m, --more: Verbosity level for "show-log" command output. */
42 static int show_log_verbosity;
44 static const struct command all_commands[];
46 static void usage(void) NO_RETURN;
47 static void parse_options(int argc, char *argv[]);
50 main(int argc, char *argv[])
52 set_program_name(argv[0]);
53 parse_options(argc, argv);
54 signal(SIGPIPE, SIG_IGN);
55 run_command(argc - optind, argv + optind, all_commands);
60 parse_options(int argc, char *argv[])
62 static struct option long_options[] = {
63 {"more", no_argument, NULL, 'm'},
64 {"verbose", optional_argument, NULL, 'v'},
65 {"help", no_argument, NULL, 'h'},
66 {"version", no_argument, NULL, 'V'},
69 char *short_options = long_options_to_short_options(long_options);
74 c = getopt_long(argc, argv, short_options, long_options, NULL);
88 ovs_print_version(0, 0);
92 vlog_set_verbosity(optarg);
108 printf("%s: Open vSwitch database management utility\n"
109 "usage: %s [OPTIONS] COMMAND [ARG...]\n"
110 " create DB SCHEMA create DB with the given SCHEMA\n"
111 " compact DB [DST] compact DB in-place (or to DST)\n"
112 " convert DB SCHEMA [DST] convert DB to SCHEMA (to DST)\n"
113 " db-version DB report version of schema used by DB\n"
114 " db-cksum DB report checksum of schema used by DB\n"
115 " schema-version SCHEMA report SCHEMA's schema version\n"
116 " schema-cksum SCHEMA report SCHEMA's checksum\n"
117 " query DB TRNS execute read-only transaction on DB\n"
118 " transact DB TRNS execute read/write transaction on DB\n"
119 " show-log DB prints information about DB's log entries\n",
120 program_name, program_name);
122 printf("\nOther options:\n"
123 " -m, --more increase show-log verbosity\n"
124 " -h, --help display this help message\n"
125 " -V, --version display version information\n");
130 parse_json(const char *s)
132 struct json *json = json_from_string(s);
133 if (json->type == JSON_STRING) {
134 ovs_fatal(0, "\"%s\": %s", s, json->u.string);
140 print_and_free_json(struct json *json)
142 char *string = json_to_string(json, JSSF_SORT);
149 check_ovsdb_error(struct ovsdb_error *error)
152 ovs_fatal(0, "%s", ovsdb_error_to_string(error));
157 do_create(int argc OVS_UNUSED, char *argv[])
159 const char *db_file_name = argv[1];
160 const char *schema_file_name = argv[2];
161 struct ovsdb_schema *schema;
162 struct ovsdb_log *log;
165 /* Read schema from file and convert to JSON. */
166 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema));
167 json = ovsdb_schema_to_json(schema);
168 ovsdb_schema_destroy(schema);
170 /* Create database file. */
171 check_ovsdb_error(ovsdb_log_open(db_file_name, OVSDB_LOG_CREATE,
173 check_ovsdb_error(ovsdb_log_write(log, json));
174 check_ovsdb_error(ovsdb_log_commit(log));
175 ovsdb_log_close(log);
181 compact_or_convert(const char *src_name, const char *dst_name,
182 const struct ovsdb_schema *new_schema,
185 struct lockfile *src_lock;
186 struct lockfile *dst_lock;
187 bool in_place = dst_name == NULL;
191 /* Lock the source, if we will be replacing it. */
193 retval = lockfile_lock(src_name, 0, &src_lock);
195 ovs_fatal(retval, "%s: failed to lock lockfile", src_name);
199 /* Get (temporary) destination and lock it. */
201 dst_name = xasprintf("%s.tmp", src_name);
203 retval = lockfile_lock(dst_name, 0, &dst_lock);
205 ovs_fatal(retval, "%s: failed to lock lockfile", dst_name);
209 check_ovsdb_error(new_schema
210 ? ovsdb_file_open_as_schema(src_name, new_schema, &db)
211 : ovsdb_file_open(src_name, true, &db, NULL));
212 check_ovsdb_error(ovsdb_file_save_copy(dst_name, false, comment, db));
215 /* Replace source. */
217 if (rename(dst_name, src_name)) {
218 ovs_fatal(errno, "failed to rename \"%s\" to \"%s\"",
221 fsync_parent_dir(dst_name);
222 lockfile_unlock(src_lock);
225 lockfile_unlock(dst_lock);
229 do_compact(int argc OVS_UNUSED, char *argv[])
231 compact_or_convert(argv[1], argv[2], NULL,
232 "compacted by ovsdb-tool "VERSION BUILDNR);
236 do_convert(int argc OVS_UNUSED, char *argv[])
238 const char *schema_file_name = argv[2];
239 struct ovsdb_schema *new_schema;
241 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &new_schema));
242 compact_or_convert(argv[1], argv[3], new_schema,
243 "converted by ovsdb-tool "VERSION BUILDNR);
244 ovsdb_schema_destroy(new_schema);
248 do_needs_conversion(int argc OVS_UNUSED, char *argv[])
250 const char *db_file_name = argv[1];
251 const char *schema_file_name = argv[2];
252 struct ovsdb_schema *schema1, *schema2;
254 check_ovsdb_error(ovsdb_file_read_schema(db_file_name, &schema1));
255 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema2));
256 puts(ovsdb_schema_equal(schema1, schema2) ? "no" : "yes");
257 ovsdb_schema_destroy(schema1);
258 ovsdb_schema_destroy(schema2);
262 do_db_version(int argc OVS_UNUSED, char *argv[])
264 const char *db_file_name = argv[1];
265 struct ovsdb_schema *schema;
267 check_ovsdb_error(ovsdb_file_read_schema(db_file_name, &schema));
268 puts(schema->version);
269 ovsdb_schema_destroy(schema);
273 do_db_cksum(int argc OVS_UNUSED, char *argv[])
275 const char *db_file_name = argv[1];
276 struct ovsdb_schema *schema;
278 check_ovsdb_error(ovsdb_file_read_schema(db_file_name, &schema));
280 ovsdb_schema_destroy(schema);
284 do_schema_version(int argc OVS_UNUSED, char *argv[])
286 const char *schema_file_name = argv[1];
287 struct ovsdb_schema *schema;
289 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema));
290 puts(schema->version);
291 ovsdb_schema_destroy(schema);
295 do_schema_cksum(int argc OVS_UNUSED, char *argv[])
297 const char *schema_file_name = argv[1];
298 struct ovsdb_schema *schema;
300 check_ovsdb_error(ovsdb_schema_from_file(schema_file_name, &schema));
302 ovsdb_schema_destroy(schema);
306 transact(bool read_only, const char *db_file_name, const char *transaction)
308 struct json *request, *result;
311 check_ovsdb_error(ovsdb_file_open(db_file_name, read_only, &db, NULL));
313 request = parse_json(transaction);
314 result = ovsdb_execute(db, NULL, request, 0, NULL);
315 json_destroy(request);
317 print_and_free_json(result);
322 do_query(int argc OVS_UNUSED, char *argv[])
324 transact(true, argv[1], argv[2]);
328 do_transact(int argc OVS_UNUSED, char *argv[])
330 transact(false, argv[1], argv[2]);
334 print_db_changes(struct shash *tables, struct shash *names)
336 struct shash_node *n1;
338 SHASH_FOR_EACH (n1, tables) {
339 const char *table = n1->name;
340 struct json *rows = n1->data;
341 struct shash_node *n2;
343 if (n1->name[0] == '_' || rows->type != JSON_OBJECT) {
347 SHASH_FOR_EACH (n2, json_object(rows)) {
348 const char *row_uuid = n2->name;
349 struct json *columns = n2->data;
350 struct shash_node *n3;
351 char *old_name, *new_name;
352 bool free_new_name = false;
354 old_name = new_name = shash_find_data(names, row_uuid);
355 if (columns->type == JSON_OBJECT) {
356 struct json *new_name_json;
358 new_name_json = shash_find_data(json_object(columns), "name");
360 new_name = json_to_string(new_name_json, JSSF_SORT);
361 free_new_name = true;
365 printf("\ttable %s", table);
369 printf(" insert row %s:\n", new_name);
371 printf(" insert row %.8s:\n", row_uuid);
374 printf(" row %s:\n", old_name);
377 if (columns->type == JSON_OBJECT) {
378 if (show_log_verbosity > 1) {
379 SHASH_FOR_EACH (n3, json_object(columns)) {
380 const char *column = n3->name;
381 struct json *value = n3->data;
384 value_string = json_to_string(value, JSSF_SORT);
385 printf("\t\t%s=%s\n", column, value_string);
390 || (new_name != old_name && strcmp(old_name, new_name))) {
392 shash_delete(names, shash_find(names, row_uuid));
395 shash_add(names, row_uuid, (new_name
397 : xmemdup0(row_uuid, 8)));
399 } else if (columns->type == JSON_NULL) {
400 struct shash_node *node;
402 printf("\t\tdelete row\n");
403 node = shash_find(names, row_uuid);
405 shash_delete(names, node);
418 do_show_log(int argc OVS_UNUSED, char *argv[])
420 const char *db_file_name = argv[1];
422 struct ovsdb_log *log;
425 check_ovsdb_error(ovsdb_log_open(db_file_name, OVSDB_LOG_READ_ONLY,
431 check_ovsdb_error(ovsdb_log_read(log, &json));
436 printf("record %u:", i);
437 if (json->type == JSON_OBJECT) {
438 struct json *date, *comment;
440 date = shash_find_data(json_object(json), "_date");
441 if (date && date->type == JSON_INTEGER) {
442 time_t t = json_integer(date);
445 strftime(s, sizeof s, "%Y-%m-%d %H:%M:%S", localtime(&t));
449 comment = shash_find_data(json_object(json), "_comment");
450 if (comment && comment->type == JSON_STRING) {
451 printf(" \"%s\"", json_string(comment));
454 if (i > 0 && show_log_verbosity > 0) {
456 print_db_changes(json_object(json), &names);
463 ovsdb_log_close(log);
464 /* XXX free 'names'. */
468 do_help(int argc OVS_UNUSED, char *argv[] OVS_UNUSED)
473 static const struct command all_commands[] = {
474 { "create", 2, 2, do_create },
475 { "compact", 1, 2, do_compact },
476 { "convert", 2, 3, do_convert },
477 { "needs-conversion", 2, 2, do_needs_conversion },
478 { "db-version", 1, 1, do_db_version },
479 { "db-cksum", 1, 1, do_db_cksum },
480 { "schema-version", 1, 1, do_schema_version },
481 { "schema-cksum", 1, 1, do_schema_cksum },
482 { "query", 2, 2, do_query },
483 { "transact", 2, 2, do_transact },
484 { "show-log", 1, 1, do_show_log },
485 { "help", 0, INT_MAX, do_help },
486 { NULL, 0, 0, NULL },