remove schema capabilities

qgis · Jan 29, 2021 · 802ef3d · 802ef3d
1 parent ac21374
commit 802ef3d
Show file tree

Hide file tree

Showing 2 changed files with 0 additions and 36 deletions.
diff --git a/src/providers/oracle/qgsoracleproviderconnection.cpp b/src/providers/oracle/qgsoracleproviderconnection.cpp
@@ -71,17 +71,13 @@ void QgsOracleProviderConnection::setDefaultCapabilities()
     Capability::DropVectorTable,
     Capability::DropRasterTable,
     Capability::CreateVectorTable,
-    //Capability::RenameSchema,
-    Capability::DropSchema,
-    Capability::CreateSchema,
     Capability::RenameVectorTable,
     Capability::RenameRasterTable,
     Capability::Vacuum,
     Capability::ExecuteSql,
     Capability::SqlLayers,
     //Capability::Transaction,
     Capability::Tables,
-    Capability::Schemas,
     Capability::Spatial,
     Capability::TableExists,
     Capability::CreateSpatialIndex,
@@ -156,35 +152,6 @@ QList<QgsVectorDataProvider::NativeType> QgsOracleProviderConnection::nativeType
   return types;
 }
 
-void QgsOracleProviderConnection::createSchema( const QString &name ) const
-{
-  checkCapability( Capability::CreateSchema );
-  executeSqlPrivate( QStringLiteral( "CREATE USER %1" )
-                     .arg( QgsOracleConn::quotedIdentifier( name ) ) );
-  executeSqlPrivate( QStringLiteral( "GRANT ALL PRIVILEGES TO %1" )
-                     .arg( QgsOracleConn::quotedIdentifier( name ) ) );
-}
-
-void QgsOracleProviderConnection::dropSchema( const QString &name,  bool force ) const
-{
-  checkCapability( Capability::DropSchema );
-  executeSqlPrivate( QStringLiteral( "DROP USER %1 %2" )
-                     .arg( QgsOracleConn::quotedIdentifier( name ) )
-                     .arg( force ? QStringLiteral( "CASCADE" ) : QString() ) );
-}
-
-QStringList QgsOracleProviderConnection::schemas( ) const
-{
-  checkCapability( Capability::Schemas );
-  QStringList schemas;
-
-  QList<QVariantList> users = executeSqlPrivate( QStringLiteral( "SELECT USERNAME FROM ALL_USERS" ) );
-  for ( QVariantList userInfos : users )
-    schemas << userInfos.at( 0 ).toString();
-
-  return schemas;
-}
-
 QList<QVariantList> QgsOracleProviderConnection::executeSqlPrivate( const QString &sql, QgsFeedback *feedback ) const
 {
   QList<QVariantList> results;

diff --git a/src/providers/oracle/qgsoracleproviderconnection.h b/src/providers/oracle/qgsoracleproviderconnection.h
@@ -37,12 +37,9 @@ class QgsOracleProviderConnection : public QgsAbstractDatabaseProviderConnection
 
     QString tableUri( const QString &schema, const QString &name ) const override;
     void dropVectorTable( const QString &schema, const QString &name ) const override;
-    void createSchema( const QString &name ) const override;
-    void dropSchema( const QString &name, bool force = false ) const override;
 
     QList<QgsAbstractDatabaseProviderConnection::TableProperty> tables( const QString &schema,
         const TableFlags &flags = TableFlags() ) const override;
-    QStringList schemas( ) const override;
     void store( const QString &name ) const override;
     void remove( const QString &name ) const override;
     QList<QgsVectorDataProvider::NativeType> nativeTypes() const override;