ColdFusion と GCP Firestore

<cfscript>cred = {
projectId: &quot;my-gcp-project&quot;,
        Vendor: &quot;GCP&quot;、
credentialJsonFilePath: &quot;File-path-cred. json&quot;
};
conf = {
serviceName: &quot;firestore&quot;
};
   
    db=getCloudService(cred, conf)
    docRef = db.collection(&quot;Ecom_D&quot;).document(&quot;Order2&quot;);
docData = ${
OrderID: 1002233,
ItemID: 00001,
Price: 499.00,
Seller: &quot;ABC&quot;		
    }
docRef.set(docData).get()
    writeOutput(docRef.getDocument().get().getID())
//writeOutput(docRef.getDocument().get())
</cfscript>

<cfscript>
    cred = {
projectId : &quot;my-project-id&quot;,
credentialJsonFilePath : &quot;Path-creds-file.json&quot;
};
conf = {
serviceName : &quot;firestore&quot;
};
    db=getCloudService(cred,conf)
    docData=${
    firstName: &quot;Jack&quot;,
    lastName: &quot;Sparrow&quot;,
    age2: #Int(22)#,
    arrMarks: [89,90,91,92],
    percentage: 90.54,
    isPass: True,
    feeDue: &quot;Null&quot;
    }
    // データを追加
    response=db.collection(&quot;Student_D&quot;).add(docData).get()
    writeDump(response)
</cfscript>

<cfscript>
    cred = {
        projectId : &quot;my-project-id&quot;,
        credentialJsonFilePath : &quot;Path-creds-file.json&quot;
    };
    conf = {
        serviceName : &quot;firestore&quot;
    };
    db=getCloudService(cred,conf)
    objPerson = new testFiles.
_Person(&quot;Jack&quot;, &quot;Sparrow&quot;, 8989898989);
    response=db.collection(&quot;Users_D&quot;).add(objPerson).get()
    writeDump(response)
</cfscript>_Person(&quot;Jack&quot;, &quot;Sparrow&quot;, 8989898989);
    response=db.collection(&quot;Users_D&quot;).add(objPerson).get()
    writeDump(response)
</cfscript>

<cfscript>
    cred = {
projectId : &quot;my-project-id&quot;,
credentialJsonFilePath : &quot;Path-creds-file.json&quot;
};
conf = {
serviceName : &quot;firestore&quot;
};
    db=getCloudService(cred,conf)
    docSchool2=${
        name:&quot;NYU&quot;,
        location:&quot;NY&quot;,
        year:2010
    }
    try{
        createResponse=db.collection(&quot;Coll_Doc_2&quot;).document(&quot;doc_Doc_2&quot;).create(docSchool2).get()
        writeOutput(&quot;Document created successfully&quot;)
        writeDump(createResponse)
    }
    catch(any e){
        writeDump(e)
    }
</cfscript>

<cfscript>
    cred = {
        projectId : &quot;my-project-id&quot;,
        vendorName: &quot;GCP&quot;,
        credentialJsonFilePath : &quot;Path-creds-file.json&quot;
    };
    conf = {
        serviceName: &quot;firestore&quot;
    };
    db=getCloudService(cred, conf)
    docRef1 = db.collection(&quot;Cities_s&quot;).document(&quot;SF15&quot;);
    docRef2 = db.collection(&quot;Cities_s&quot;).document(&quot;SF16&quot;);

    docData = ${
        Country: &quot;USA&quot;,
        Population: 901
    }
    docData1 = ${
        Country: &quot;USA&quot;,
        Population: 902
    }
    docRef1.set(docData).get();
    docRef2.set(docData1).get();
       returnValue = db.runTransaction(transaction => {
            try {
        getAllFuture=transaction.getAll([docRef1, docRef2], [&quot;Population&quot;]).get();
        cfloop(array=&quot;#getAllFuture#&quot;, item=&quot;itm&quot;)
    {
   cfloop(collection = &quot;#itm.getData()#&quot;,item = &quot;key&quot;);
   {
        if(itm.getData()[&quot;Population&quot;] > 900)
      transaction.update(db.document(itm.getPath()), {&quot;Population&quot; : itm.getData()[&quot;Population&quot;]+1});
    }
  }
    return transaction;
            }
            catch (any e)
            { return e; }
        }).get();
</cfscript>

<cfscript>
    cred = {
        projectId : &quot;my-project-id&quot;,
        credentialJsonFilePath : &quot;Path-creds-file.json&quot;
    };
    conf = {
       serviceName : &quot;firestore&quot;
    };
    db=getCloudService(cred,conf)
    db = getCloudService(this.cred, this.conf);
    objPerson1 = new testFiles.
_Person(&quot;Jack&quot;, &quot;Sparrow&quot;, 9090909090);
    response=db.collection(&quot;Users_D&quot;).document().create(objPerson1).get()
    writeDump(response)
</cfscript>_Person(&quot;Jack&quot;, &quot;Sparrow&quot;, 9090909090);
    response=db.collection(&quot;Users_D&quot;).document().create(objPerson1).get()
    writeDump(response)
</cfscript>

<cfscript>
    cred = {
        projectId : &quot;my-project-id&quot;,
        credentialJsonFilePath : &quot;Path-creds-file.json&quot;
    };
    conf = {
        serviceName : &quot;firestore&quot;
    };
    db=getCloudService(cred,conf)
    for (i = 1; i <= 5; i++) {
    docData = ${
        name: &quot;Chicago&quot;&i,
        state: &quot;IL&quot;&i,
        country: &quot;USA&quot;&i
    }
    response=db.collection(&quot;cities_D&quot;).document(i).set(docData); //Updating the document
    writeDump(response)
    }
</cfscript>

<cfscript>
    cred = {
        projectId : &quot;my-project-id&quot;,
        credentialJsonFilePath : &quot;Path-creds-file.json&quot;
    };
    conf = {
        serviceName : &quot;firestore&quot;
    };
    db=getCloudService(cred,conf)
    objPerson = new testFiles.
_Person(&quot;Jack&quot;, &quot;Sparrow&quot;, 8989898989);
    response=db.collection(&quot;Users_D&quot;).add(objPerson).get()
    writeDump(response)
</cfscript>_Person(&quot;Joy&quot;, &quot;Division&quot;, 8989898989);
    future = runAsync(x => db.collection(&quot;Users_D&quot;).document(&quot;D1&quot;).set(objPerson).get())
    writeDump(future)
</cfscript>

<cfscript>
    cred = {
        projectId : &quot;my-project-id&quot;,
        credentialJsonFilePath : &quot;Path-creds-file.json&quot;
    };
    conf = {
        serviceName : &quot;firestore&quot;
    };
    db=getCloudService(cred,conf)
    docRef = db.collection(&quot;Cities_D&quot;).document(&quot;SF12&quot;);

    docData = ${
        Country: &quot;USA&quot;,
        Population: 860000
        }
    docData1 = ${
        Country: &quot;USA&quot;,
        Population: 90000
        }
    docRef.set(docData).get();
    createdDate=docRef.getDocument().get().getCreateTime();
    response=docRef.update(docData1,createdDate).get()
    writeDump(response)
</cfscript>

<cfscript>
    	cred = {
            projectId : &quot;my-project-id&quot;,
            credentialJsonFilePath : &quot;Path-creds-file.json&quot;
        };
        conf = {
            serviceName : &quot;firestore&quot;
        };
    	db=getCloudService(cred,conf)

        docRef = db.collection(&quot;Cities_D&quot;).document(&quot;SF12&quot;);		
        docData = ${
            Country: &quot;USA&quot;,
            Population: 860000
        }
        docData1 = ${
            Country: &quot;USA&quot;,
            Population: 90000
        }
        docRef.set(docData).get();
        createdDate=docRef.getDocument().get().getCreateTime();
        docRef.update(docData1,createdDate).get(); //日時の前提条件を使用して更新しようとしています。writeOutput(&quot;Population is updated&quot;)
response=db.document(&quot;Cities_D/SF12&quot;).getDocument().get().getData()[&quot;Population&quot;]);
        writeDump(response)
 </cfscript>