Method DeleteDatabase

class/databaseModel/sqlserverModel.py:168–193

@删除数据库

(self, args)

        return public.returnMsg(True, 'ADD_SUCCESS')

    def DeleteDatabase(self, args):
        """
        @删除数据库
        """

        id = args['id']
        find = public.M('databases').where("id=? AND LOWER(type)=LOWER('SQLServer')", (id,)).field('id,pid,name,username,password,type,accept,ps,addtime,sid,db_type').find()
        if not find: return public.returnMsg(False, '指定数据库不存在.')

        name = args['name']
        username = find['username']

        mssql_obj = self.get_mssql_obj_by_sid(find['sid'])
        mssql_obj.execute("ALTER DATABASE %s SET SINGLE_USER with ROLLBACK IMMEDIATE" % name)
        result = mssql_obj.execute("DROP DATABASE %s" % name)

        if self.get_database_size_by_id(find['sid']):
            isError = self.IsSqlError(result)
            if isError != None: return isError

        mssql_obj.execute("DROP LOGIN %s" % username)

        # 删除SQLITE
        public.M('databases').where("id=? AND LOWER(type)=LOWER('SQLServer')", (id,)).delete()
        public.WriteLog("TYPE_DATABASE", 'DATABASE_DEL_SUCCESS', (name,))
        return public.returnMsg(True, 'DEL_SUCCESS')

    def ToBackup(self, args):
        """