• 欢迎光临~

MongoDB 中的查询方法。

开发技术 开发技术 2022-05-31 次浏览

使用 Robo 3T

查找

对象结构

{
    "_id" : "051723f8-dacf-422d-ba84-d7d88b1ca540",
    "TaskName" : "_SpreadJS V10 Edge Testing",
    "Description" : "",
    "VCSList" : [ 
        {
            "_t" : "TFS_VCS",
            "Enable" : true,
            "VCSRootName" : "%SpreadJSV10%",
            "VCSRootID" : "SpreadJSV10Test",
            "SourceRootPath" : "$/XIANToolsTest/Development/SpreadJSAutoTestV10",
            "StepName" : "TFS Get Test Source",
            "LocalPath" : "%SpreadJSV10%",
            "TFSURL" : "http://xa-cm-tfs2:8080/tfs",
            "CollectionName" : "XAToolsCollection",
            "UserName" : "SunLiu",
            "Password" : "Ljc19711209",
            "Domain" : "GrapeCity"
        }
    ],
    "BuildStepList" : [ 
        {
            "_t" : "MSBuildRunner",
            "Enable" : true,
            "StepName" : "Build Scripts",
            "BuildFilePath" : "%SpreadJSV10%\SpreadJS_TestScript.sln",
            "OutputPath" : "%Root%\Bin",
            "CommandLineParameters" : "/p:Configuration=Debug /nologo /t:rebuild /verbosity:m"
        }, 
        {
            "_t" : "CopyContentRunner",
            "Enable" : true,
            "StepName" : "Copy Config File",
            "SourceFilePath" : "%SpreadJSV10%\SpreadJS_TestScript\TestConfigrationFile\EdgeTest.config",
            "TargetFilePath" : "%Root%\Bin\SpreadJS_TestScript.dll.config"
        }
    ],
    "TaskSettings" : {
        "IsSendComparedMail" : true
    },
    "TestSettings" : {
        "ToolType" : 1,
        "ResourcePath" : null,
        "RunFailureCaseTimes" : 3,
        "ToolPath" : "",
        "TestAssemblies" : [ 
            "%Root%\Bin\SpreadJS_TestScript.dll"
        ],
        "ReportPath" : "",
        "EnableTestToolLog" : false,
        "IsRestartAgentClientBeforeTest" : true,
        "RestartAgentClientDelayTime" : 5,
        "MustWindowsClassicTheme" : true,
        "ResolutionX" : 1280,
        "ResolutionY" : 1024,
        "IsSendMail" : false,
        "MailSubject" : "SpreadJS V10 Edge Testing",
        "MailFrom" : "at@contact.grapecity.com",
        "MailFromDisplay" : "AutoTest Managment System",
        "MailTo" : "robert.wang@grapecity.com;Ally.zhang@grapecity.com;sun.liu@grapecity.com",
        "MailSMTPServer" : "10.32.0.200",
        "MailPort" : "25",
        "MailPassword" : "",
        "MailAccount" : "",
        "MailEnableSSL" : false,
        "TestTimeout" : 300000,
        "IsResetTimeZone" : false,
        "TimeZoneId" : "China Standard Time",
        "ResetKeyboard" : true,
        "ResetMouse" : true,
        "MouseResetPosition" : 1,
        "CustomMouseResetPositionX" : 0,
        "CustomMouseResetPositionY" : 0,
        "IsMonitorLeakage" : true,
        "MemoryLoad" : 85,
        "HandleLoad" : 90,
        "AutoTesterAccount" : "Component Test",
        "AutoTesterPassword" : "xA070613",
        "AutoTesterLoginAddress" : "",
        "AutoTesterTaskAddress" : "",
        "MaxTestResultCount" : 200
    },
    "PerformanceSettings" : {},
    "Trigger" : [ 
        {
            "_t" : "DailySchedule",
            "TriggerID" : "1ed10150-10b8-44ea-9d16-f573a583ca63",
            "Enable" : false,
            "LastExecutionTime" : ISODate("2018-01-08T04:30:00.643Z"),
            "ExecutionTime" : ISODate("1981-03-01T04:30:00.000Z"),
            "TaskID" : "051723f8-dacf-422d-ba84-d7d88b1ca540"
        }
    ],
    "Requirement" : {
        "AgentList" : [ 
            "XA-AT-015W10J64"
        ],
        "ExcludedAgentList" : [],
        "OSType" : 4,
        "MustJPVersion" : null,
        "Must64BitOS" : null,
        "MustSupportWebAii" : null,
        "IEVersion" : 0,
        "InputLanguage" : 7,
        "RuntimeEnvironment" : 1,
        "HasChrome" : false,
        "HasFireFox" : false,
        "HasSafari" : false
    },
    "ProcessCollectionName" : "SpreadJSv10EdgeTesting",
    "PerformanceCollectionName" : null
} 

获取属性 -id

db.getCollection('TestTask').find({"_id":"051723f8-dacf-422d-ba84-d7d88b1ca540"});

获取子对象中的属性:

db.getCollection('TestTask').find({ "Requirement.AgentList":"XA-AT-015W10J64" })

获取字符串包含内容,需要使用正则来获得。

db.getCollection('TestTask').find({"Requirement.AgentList" : /^.*AT.*$/})

{    "_id" : "051723f8-dacf-422d-ba84-d7d88b1ca540",    "TaskName" : "_SpreadJS V10 Edge Testing",    "Description" : "",    "VCSList" : [         {            "_t" : "TFS_VCS",            "Enable" : true,            "VCSRootName" : "%SpreadJSV10%",            "VCSRootID" : "SpreadJSV10Test",            "SourceRootPath" : "$/XIANToolsTest/Development/SpreadJSAutoTestV10",            "StepName" : "TFS Get Test Source",            "LocalPath" : "%SpreadJSV10%",            "TFSURL" : "http://xa-cm-tfs2:8080/tfs",            "CollectionName" : "XAToolsCollection",            "UserName" : "SunLiu",            "Password" : "Ljc19711209",            "Domain" : "GrapeCity"        }    ],    "BuildStepList" : [         {            "_t" : "MSBuildRunner",            "Enable" : true,            "StepName" : "Build Scripts",            "BuildFilePath" : "%SpreadJSV10%\SpreadJS_TestScript.sln",            "OutputPath" : "%Root%\Bin",            "CommandLineParameters" : "/p:Configuration=Debug /nologo /t:rebuild /verbosity:m"        },         {            "_t" : "CopyContentRunner",            "Enable" : true,            "StepName" : "Copy Config File",            "SourceFilePath" : "%SpreadJSV10%\SpreadJS_TestScript\TestConfigrationFile\EdgeTest.config",            "TargetFilePath" : "%Root%\Bin\SpreadJS_TestScript.dll.config"        }    ],    "TaskSettings" : {        "IsSendComparedMail" : true    },    "TestSettings" : {        "ToolType" : 1,        "ResourcePath" : null,        "RunFailureCaseTimes" : 3,        "ToolPath" : "",        "TestAssemblies" : [             "%Root%\Bin\SpreadJS_TestScript.dll"        ],        "ReportPath" : "",        "EnableTestToolLog" : false,        "IsRestartAgentClientBeforeTest" : true,        "RestartAgentClientDelayTime" : 5,        "MustWindowsClassicTheme" : true,        "ResolutionX" : 1280,        "ResolutionY" : 1024,        "IsSendMail" : false,        "MailSubject" : "SpreadJS V10 Edge Testing",        "MailFrom" : "at@contact.grapecity.com",        "MailFromDisplay" : "AutoTest Managment System",        "MailTo" : "robert.wang@grapecity.com;Ally.zhang@grapecity.com;sun.liu@grapecity.com",        "MailSMTPServer" : "10.32.0.200",        "MailPort" : "25",        "MailPassword" : "",        "MailAccount" : "",        "MailEnableSSL" : false,        "TestTimeout" : 300000,        "IsResetTimeZone" : false,        "TimeZoneId" : "China Standard Time",        "ResetKeyboard" : true,        "ResetMouse" : true,        "MouseResetPosition" : 1,        "CustomMouseResetPositionX" : 0,        "CustomMouseResetPositionY" : 0,        "IsMonitorLeakage" : true,        "MemoryLoad" : 85,        "HandleLoad" : 90,        "AutoTesterAccount" : "Component Test",        "AutoTesterPassword" : "xA070613",        "AutoTesterLoginAddress" : "",        "AutoTesterTaskAddress" : "",        "MaxTestResultCount" : 200    },    "PerformanceSettings" : {},    "Trigger" : [         {            "_t" : "DailySchedule",            "TriggerID" : "1ed10150-10b8-44ea-9d16-f573a583ca63",            "Enable" : false,            "LastExecutionTime" : ISODate("2018-01-08T04:30:00.643Z"),            "ExecutionTime" : ISODate("1981-03-01T04:30:00.000Z"),            "TaskID" : "051723f8-dacf-422d-ba84-d7d88b1ca540"        }    ],    "Requirement" : {        "AgentList" : [             "XA-AT-015W10J64"        ],        "ExcludedAgentList" : [],        "OSType" : 4,        "MustJPVersion" : null,        "Must64BitOS" : null,        "MustSupportWebAii" : null,        "IEVersion" : 0,        "InputLanguage" : 7,        "RuntimeEnvironment" : 1,        "HasChrome" : false,        "HasFireFox" : false,        "HasSafari" : false    },    "ProcessCollectionName" : "SpreadJSv10EdgeTesting",    "PerformanceCollectionName" : null}
程序员灯塔
转载请注明原文链接:MongoDB 中的查询方法。
喜欢 (0)