ExportContext

import type { ExportContext } from "https://googleapis.deno.dev/v1/sqladmin:v1.ts";

Database instance export context.

interface ExportContext {

bakExportOptions?: {

bakType?:

| "BAK_TYPE_UNSPECIFIED"

| "FULL"

| "DIFF"

| "TLOG";

copyOnly?: boolean;

differentialBase?: boolean;

exportLogEndTime?: Date;

exportLogStartTime?: Date;

stripeCount?: number;

striped?: boolean;

};

csvExportOptions?: {

escapeCharacter?: string;

fieldsTerminatedBy?: string;

linesTerminatedBy?: string;

quoteCharacter?: string;

selectQuery?: string;

};

databases?: string[];

fileType?:

| "SQL_FILE_TYPE_UNSPECIFIED"

| "SQL"

| "CSV"

| "BAK"

| "TDE";

kind?: string;

offload?: boolean;

sqlExportOptions?: {

mysqlExportOptions?: {

masterData?: number;

};

parallel?: boolean;

postgresExportOptions?: {

clean?: boolean;

ifExists?: boolean;

};

schemaOnly?: boolean;

tables?: string[];

threads?: number;

};

tdeExportOptions?: {

certificatePath?: string;

name?: string;

privateKeyPassword?: string;

privateKeyPath?: string;

};

uri?: string;

}

§Properties

bakExportOptions?: {

bakType?:

| "BAK_TYPE_UNSPECIFIED"

| "FULL"

| "DIFF"

| "TLOG";

copyOnly?: boolean;

differentialBase?: boolean;

exportLogEndTime?: Date;

exportLogStartTime?: Date;

stripeCount?: number;

striped?: boolean;

}

[src]

Options for exporting BAK files (SQL Server-only)

csvExportOptions?: {

escapeCharacter?: string;

fieldsTerminatedBy?: string;

linesTerminatedBy?: string;

quoteCharacter?: string;

selectQuery?: string;

}

[src]

Options for exporting data as CSV. MySQL and PostgreSQL instances only.

databases?: string[]

[src]

Databases to be exported. MySQL instances: If fileType is SQL and no database is specified, all databases are exported, except for the mysql system database. If fileType is CSV, you can specify one database, either by using this property or by using the csvExportOptions.selectQuery property, which takes precedence over this property. PostgreSQL instances: If you don't specify a database by name, all user databases in the instance are exported. This excludes system databases and Cloud SQL databases used to manage internal operations. Exporting all user databases is only available for directory-formatted parallel export. If fileType is CSV, this database must match the one specified in the csvExportOptions.selectQuery property. SQL Server instances: You must specify one database to be exported, and the fileType must be BAK.

fileType?: "SQL_FILE_TYPE_UNSPECIFIED" | "SQL" | "CSV" | "BAK" | "TDE"

[src]

The file type for the specified uri.

kind?: string

[src]

This is always sql#exportContext.

offload?: boolean

[src]

Whether to perform a serverless export.

sqlExportOptions?: {

mysqlExportOptions?: {

masterData?: number;

};

parallel?: boolean;

postgresExportOptions?: {

clean?: boolean;

ifExists?: boolean;

};

schemaOnly?: boolean;

tables?: string[];

threads?: number;

}

[src]

Options for exporting data as SQL statements.

tdeExportOptions?: {

certificatePath?: string;

name?: string;

privateKeyPassword?: string;

privateKeyPath?: string;

}

[src]

Optional. Export parameters specific to SQL Server TDE certificates

uri?: string

[src]

The path to the file in Google Cloud Storage where the export will be stored. The URI is in the form gs://bucketName/fileName. If the file already exists, the request succeeds, but the operation fails. If fileType is SQL and the filename ends with .gz, the contents are compressed.