oracle

package
v1.0.6 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Dec 3, 2022 License: Apache-2.0 Imports: 14 Imported by: 0

Documentation

Overview

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Copyright © 2020 Marvin

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at 

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Query 

func Query(ctx context.Context, db *sql.DB, querySQL string) ([]string, []map[string]string, error)

Types

type Oracle 

type Oracle struct {
	Ctx      context.Context
	OracleDB *sql.DB
	GormDB   *gorm.DB
}

func NewOracleSQLDB 

func NewOracleSQLDB(ctx context.Context, oracleDB *sql.DB, GormDB *gorm.DB) *Oracle

func (*Oracle) AddOracleLogminerlogFile 

func (o *Oracle) AddOracleLogminerlogFile(logFile string) error

func (*Oracle) CloseOracleChunkTask 

func (o *Oracle) CloseOracleChunkTask(taskName string) error

func (*Oracle) EndOracleLogminerStoredProcedure 

func (o *Oracle) EndOracleLogminerStoredProcedure() error

func (*Oracle) GetOracleALLRedoLogFile 

func (o *Oracle) GetOracleALLRedoLogFile() ([]string, error)

func (*Oracle) GetOracleArchivedLogFile 

func (o *Oracle) GetOracleArchivedLogFile(scn string) ([]map[string]string, error)

func (*Oracle) GetOracleArchivedLogSCN 

func (o *Oracle) GetOracleArchivedLogSCN(scn string) (uint64, error)

func (*Oracle) GetOracleAvgRowLength 

func (o *Oracle) GetOracleAvgRowLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleCodeObject 

func (o *Oracle) GetOracleCodeObject(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleColumnTypeAndMaxLength 

func (o *Oracle) GetOracleColumnTypeAndMaxLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleConstraintType 

func (o *Oracle) GetOracleConstraintType(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleCurrentRedoMaxSCN 

func (o *Oracle) GetOracleCurrentRedoMaxSCN() (uint64, uint64, string, error)

func (*Oracle) GetOracleCurrentSnapshotSCN 

func (o *Oracle) GetOracleCurrentSnapshotSCN() (uint64, error)

func (*Oracle) GetOracleDBCharacterNLSCompCollation 

func (o *Oracle) GetOracleDBCharacterNLSCompCollation() (string, error)

func (*Oracle) GetOracleDBCharacterNLSSortCollation 

func (o *Oracle) GetOracleDBCharacterNLSSortCollation() (string, error)

func (*Oracle) GetOracleDBCharacterSet 

func (o *Oracle) GetOracleDBCharacterSet() (string, error)

func (*Oracle) GetOracleDBName 

func (o *Oracle) GetOracleDBName() (string, string, string, error)

func (*Oracle) GetOracleDBVersion 

func (o *Oracle) GetOracleDBVersion() (string, error)

func (*Oracle) GetOracleDataRowStrings 

func (o *Oracle) GetOracleDataRowStrings(querySQL string) ([]string, *strset.Set, uint32, error)

func (*Oracle) GetOracleDataTotal 

func (o *Oracle) GetOracleDataTotal() (string, error)

func (*Oracle) GetOracleExtendedMode 

func (o *Oracle) GetOracleExtendedMode() (bool, error)

func (*Oracle) GetOracleGlobalName 

func (o *Oracle) GetOracleGlobalName() (string, error)

func (*Oracle) GetOracleIndexType 

func (o *Oracle) GetOracleIndexType(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleInstance 

func (o *Oracle) GetOracleInstance() ([]map[string]string, error)

func (*Oracle) GetOracleMaxActiveSessionCount 

func (o *Oracle) GetOracleMaxActiveSessionCount() ([]map[string]string, error)

func (*Oracle) GetOracleMemoryGB 

func (o *Oracle) GetOracleMemoryGB() (string, error)

func (*Oracle) GetOracleNumCPU 

func (o *Oracle) GetOracleNumCPU() (string, error)

func (*Oracle) GetOracleObjectTypeOverview 

func (o *Oracle) GetOracleObjectTypeOverview(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleParameters 

func (o *Oracle) GetOracleParameters() (string, string, string, string, error)

func (*Oracle) GetOraclePartitionObjectType 

func (o *Oracle) GetOraclePartitionObjectType(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOraclePartitionTableINFO 

func (o *Oracle) GetOraclePartitionTableINFO(schemaName, tableName string) ([]map[string]string, error)

func (*Oracle) GetOraclePartitionTableOver1024 

func (o *Oracle) GetOraclePartitionTableOver1024(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleRedoLogFile 

func (o *Oracle) GetOracleRedoLogFile(scn string) ([]map[string]string, error)

func (*Oracle) GetOracleRedoLogSCN 

func (o *Oracle) GetOracleRedoLogSCN(scn string) (uint64, error)

func (*Oracle) GetOracleSchemaClusteredTable 

func (o *Oracle) GetOracleSchemaClusteredTable(schemaName string) ([]string, error)

func (*Oracle) GetOracleSchemaCollation 

func (o *Oracle) GetOracleSchemaCollation(schemaName string) (string, error)

func (*Oracle) GetOracleSchemaOverview 

func (o *Oracle) GetOracleSchemaOverview(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaPartitionTable 

func (o *Oracle) GetOracleSchemaPartitionTable(schemaName string) ([]string, error)

func (*Oracle) GetOracleSchemaTable 

func (o *Oracle) GetOracleSchemaTable(schemaName string) ([]string, error)

func (*Oracle) GetOracleSchemaTableCheckKey 

func (o *Oracle) GetOracleSchemaTableCheckKey(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableCollation 

func (o *Oracle) GetOracleSchemaTableCollation(schemaName, schemaCollation string) (map[string]string, error)

func (*Oracle) GetOracleSchemaTableColumn 

func (o *Oracle) GetOracleSchemaTableColumn(schemaName string, tableName string, oraCollation bool) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableColumnComment 

func (o *Oracle) GetOracleSchemaTableColumnComment(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableComment 

func (o *Oracle) GetOracleSchemaTableComment(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableForeignKey 

func (o *Oracle) GetOracleSchemaTableForeignKey(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableNormalIndex 

func (o *Oracle) GetOracleSchemaTableNormalIndex(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTablePrimaryKey 

func (o *Oracle) GetOracleSchemaTablePrimaryKey(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableRowsTOP 

func (o *Oracle) GetOracleSchemaTableRowsTOP(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableType 

func (o *Oracle) GetOracleSchemaTableType(schemaName string) (map[string]string, error)

func (*Oracle) GetOracleSchemaTableUniqueIndex 

func (o *Oracle) GetOracleSchemaTableUniqueIndex(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTableUniqueKey 

func (o *Oracle) GetOracleSchemaTableUniqueKey(schemaName string, tableName string) ([]map[string]string, error)

func (*Oracle) GetOracleSchemaTemporaryTable 

func (o *Oracle) GetOracleSchemaTemporaryTable(schemaName string) ([]string, error)

func (*Oracle) GetOracleSchemas 

func (o *Oracle) GetOracleSchemas() ([]string, error)

func (*Oracle) GetOracleSynonymObjectType 

func (o *Oracle) GetOracleSynonymObjectType(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableActualRows 

func (o *Oracle) GetOracleTableActualRows(oraQuery string) (int64, error)

func (*Oracle) GetOracleTableChunksByNUMBER 

func (o *Oracle) GetOracleTableChunksByNUMBER(taskName, numberColName string) ([]map[string]string, error)

func (*Oracle) GetOracleTableChunksByRowID 

func (o *Oracle) GetOracleTableChunksByRowID(taskName string) ([]map[string]string, error)

func (*Oracle) GetOracleTableColumnCountsOver512 

func (o *Oracle) GetOracleTableColumnCountsOver512(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableColumnDistinctValue 

func (o *Oracle) GetOracleTableColumnDistinctValue(schemaName, tableName string, columnList []string) ([]string, error)

func (*Oracle) GetOracleTableColumnNameLength 

func (o *Oracle) GetOracleTableColumnNameLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableIndexCountsOver64 

func (o *Oracle) GetOracleTableIndexCountsOver64(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableIndexLengthOver3072 

func (o *Oracle) GetOracleTableIndexLengthOver3072(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableIndexNameLength 

func (o *Oracle) GetOracleTableIndexNameLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableNameLength 

func (o *Oracle) GetOracleTableNameLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableNumberTypeCheck 

func (o *Oracle) GetOracleTableNumberTypeCheck(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableRowLengthOver6M 

func (o *Oracle) GetOracleTableRowLengthOver6M(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableRowsByStatistics 

func (o *Oracle) GetOracleTableRowsByStatistics(schemaName, tableName string) (int, error)

func (*Oracle) GetOracleTableRowsData 

func (o *Oracle) GetOracleTableRowsData(querySQL string, insertBatchSize int) ([]string, []string, error)

获取表字段名以及行数据 -> 用于 FULL/ALL

func (*Oracle) GetOracleTableSequenceNameLength 

func (o *Oracle) GetOracleTableSequenceNameLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTableViewNameLength 

func (o *Oracle) GetOracleTableViewNameLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleTemporaryTable 

func (o *Oracle) GetOracleTemporaryTable(schemaName []string) ([]map[string]string, error)

func (*Oracle) GetOracleUsernameLength 

func (o *Oracle) GetOracleUsernameLength(schemaName []string) ([]map[string]string, error)

func (*Oracle) IsNumberColumnTYPE 

func (o *Oracle) IsNumberColumnTYPE(schemaName, tableName, indexFiledName string) (bool, error)

func (*Oracle) IsOraclePartitionTable 

func (o *Oracle) IsOraclePartitionTable(schemaName, tableName string) (bool, error)

func (*Oracle) StartOracleChunkCreateTask 

func (o *Oracle) StartOracleChunkCreateTask(taskName string) error

func (*Oracle) StartOracleCreateChunkByNUMBER 

func (o *Oracle) StartOracleCreateChunkByNUMBER(taskName, schemaName, tableName, numberColName string, chunkSize string) error

func (*Oracle) StartOracleCreateChunkByRowID 

func (o *Oracle) StartOracleCreateChunkByRowID(taskName, schemaName, tableName string, chunkSize string) error

func (*Oracle) StartOracleLogminerStoredProcedure 

func (o *Oracle) StartOracleLogminerStoredProcedure(scn string) error

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.