default=False,
help="drop database before importing.",
dest="do_drop")
# Single insert mode
parser.add_option("-b",
"--bulk-insert",
action="store_true",
dest="bulk_insert",
default=False,
help="use bulk "
"insert statements for data (default:False)")
# No header option
add_no_headers_option(parser,
restricted_formats=['tab', 'csv'],
help_msg="files do not contain column headers")
# Dryrun mode
parser.add_option("--dryrun",
action="store_true",
dest="dryrun",
default=False,
help="import the files and generate the "
"statements but do not execute them - useful for "
"testing file validity")
# Add table for import raw csv files
parser.add_option("--table",
action="store",
dest="table",
default="definitions", help="control the export of "
"either 'data' = only the table data for the tables in "
"the database list, 'definitions' = export only the "
"definitions for the objects in the database list, or "
"'both' = export the metadata followed by the data "
"(default: export definitions)", type="choice",
choices=_PERMITTED_EXPORTS)
# Single insert mode
parser.add_option("-b", "--bulk-insert", action="store_true",
dest="bulk_import", default=False,
help="use bulk insert statements for data "
"(default:False)")
# No header option
add_no_headers_option(parser, restricted_formats=['tab', 'csv'])
# Skip blobs for export
parser.add_option("--skip-blobs", action="store_true", dest="skip_blobs",
default=False, help="do not export blob data.")
# File-per-table mode
parser.add_option("--file-per-table", action="store_true",
dest="file_per_tbl", default=False, help="write table "
"data to separate files. Valid only for --export=data "
"or --export=both.")
# Add the exclude database option
parser.add_option("-x", "--exclude", action="append", dest="exclude",
type="string", default=None, help="exclude one or more "
"objects from the operation using either a specific "
default="definitions", help="control the export of "
"either 'data' = only the table data for the tables in "
"the database list, 'definitions' = export only the "
"definitions for the objects in the database list, or "
"'both' = export the metadata followed by the data "
"(default: export definitions)", type="choice",
choices=_PERMITTED_EXPORTS)
# Single insert mode
parser.add_option("-b", "--bulk-insert", action="store_true",
dest="bulk_import", default=False,
help="use bulk insert statements for data "
"(default:False)")
# No header option
add_no_headers_option(parser, restricted_formats=['tab', 'csv'])
# Skip blobs for export
parser.add_option("--skip-blobs", action="store_true", dest="skip_blobs",
default=False, help="do not export blob data.")
# File-per-table mode
parser.add_option("--file-per-table", action="store_true",
dest="file_per_tbl", default=False, help="write table "
"data to separate files. Valid only for --export=data "
"or --export=both.")
# Add the exclude database option
add_exclude(parser)
# Add the all database options
"definitions for the objects in the database list, or "
"'both' = import the metadata followed by the data "
"(default: import definitions)", type="choice",
choices=_PERMITTED_IMPORTS)
# Drop mode
parser.add_option("-d", "--drop-first", action="store_true", default=False,
help="drop database before importing.", dest="do_drop")
# Single insert mode
parser.add_option("-b", "--bulk-insert", action="store_true",
dest="bulk_insert", default=False, help="use bulk "
"insert statements for data (default:False)")
# No header option
add_no_headers_option(parser, restricted_formats=['tab', 'csv'],
help_msg="files do not contain column headers")
# Dryrun mode
parser.add_option("--dryrun", action="store_true", dest="dryrun",
default=False, help="import the files and generate the "
"statements but do not execute them - useful for "
"testing file validity")
# Add table for import raw csv files
parser.add_option("--table", action="store", dest="table", default=None,
help="destination table in the form: <db>.<table>.")
# Skip blobs for import
parser.add_option("--skip-blobs", action="store_true", dest="skip_blobs",
default=False, help="do not import blob data.")