国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

<p>我正在嘗試使用Lambda函數(shù)向AWS Aurora MySQL資料庫(kù)寫入資料。 </p> <h3>代碼</h3> <p>出於某種原因，它似乎無(wú)法正常工作。到目前為止，我的程式碼非常簡(jiǎn)單，但無(wú)法正確執(zhí)行。這是一個(gè)簡(jiǎn)單的Lambda函數(shù)，當(dāng)使用者註冊(cè)到Cognito時(shí)調(diào)用，應(yīng)該在SQL資料庫(kù)中建立一個(gè)新條目，包含使用者憑證。 </p> <pre class="brush:php;toolbar:false;">const mysql = require('mysql') const db = mysql.createConnection({ host: "*****", port: *****, user: "*****", password: "*****", database: "*****", }) export const lambdaHandler = async (event: any, context: any,) => { const user = { uid: event.request.userAttributes.sub, username: event.request.userAttributes.nickname, email: event.request.userAttributes.email, } console.log("before query") const query = `INSERT INTO users (Uid, Username, Email) VALUES (${user.uid}, ${user.username}, ${user.email})` await db.query(query, (err: any, result: any) => { if (err) console.error(err) console.log("query response: " result) }) console.log("after query") return event; };</pre> <p>函數(shù)的輸出如下：</p> <pre class="brush:php;toolbar:false;">START RequestId: bb1d2143-97e4-4761-a48a-f482cf94f73b Version: $LATEST 2022-03-17T14:02:35.956Z bb1d2143-97e4-4761-a48a-f482cf94f73b INFO before query 2022-03-17T14:02:35.961Z bb1d2143-97e4-4761-a48a-f482cf94f73b INFO after query END RequestId: bb1d2143-97e4-4761-a48a-f482cf94f73b REPORT RequestId: bb1d2143-97e4-4761-a48a-f482cf94f73b Init Duration: 0.14 ms Duration: 138.07 ms Billed Duration: 139 ms Memory Size: 138.07 ms Billed Duration: 139 ms Memory Size: 128 MB Memory Usgt; <p>注意：查詢函數(shù)沒有找到日誌記錄（應(yīng)該拋出錯(cuò)誤或記錄回應(yīng)）</p> <h3>策略</h3> <p>Lambda函數(shù)的執(zhí)行角色包含以下策略：<code>AWSLambdaVPCAccessExecutionRole</code>和<code>AWSLambda_FullAccess</code></p> <h3>其他</h3> <p>Lambda函數(shù)和Aurora位於同一VPC的不同子網(wǎng)路。我不確定這是否會(huì)導(dǎo)致問題。但這不會(huì)導(dǎo)致函數(shù)拋出錯(cuò)誤嗎？類似<code>missing authorization</code>的錯(cuò)誤？ </p> <p>我不明白我在這一點(diǎn)上還缺少什麼</p>

const util = require('util');
const mysql = require('mysql');

const db = mysql.createConnection({
    host: "*****",
    port: *****,
    user: "*****",
    password: "*****",
    database: "*****",
});

// 將db.query轉(zhuǎn)換為返回promise的函數(shù)
const promisifiedQuery = util.promisify(db.query);

export const lambdaHandler = async (event: any, context: any,) => {
    const user = {
        uid: event.request.userAttributes.sub,
        username: event.request.userAttributes.nickname,
        email: event.request.userAttributes.email,
    };

    console.log("before query");

    // 順便說(shuō)一下，這樣做是不好的。請(qǐng)閱讀有關(guān)如何避免SQL注入的內(nèi)容。
    const query = `INSERT INTO users (Uid, Username, Email) VALUES (${user.uid}, ${user.username}, ${user.email})`;

    await promisifiedQuery(query).then(result => {
        console.log("query response: " + result)
        console.log("after query")
    }).catch(console.error)

    return event;
};