Compare commits
4 Commits
dependabot
...
master
Author | SHA1 | Date |
---|---|---|
|
99daa34a12 | |
|
009f3c8566 | |
![]() |
9d1bc25ffa | |
![]() |
3a3ee994c2 |
|
@ -176,3 +176,4 @@ To maintain a uniform standard and ensure seamless compatibility with many curre
|
|||
<a href="https://github.com/Significant-Gravitas/AutoGPT/graphs/contributors" alt="View Contributors">
|
||||
<img src="https://contrib.rocks/image?repo=Significant-Gravitas/AutoGPT&max=1000&columns=10" alt="Contributors" />
|
||||
</a>
|
||||
|
||||
|
|
|
@ -6,9 +6,14 @@
|
|||
- AITextGeneratorBlock
|
||||
- AIStructuredResponseGeneratorBlock
|
||||
with a double brace format.
|
||||
- This migration can be slow for a large updated AgentNode tables.
|
||||
*/
|
||||
BEGIN;
|
||||
SET LOCAL statement_timeout = '10min';
|
||||
|
||||
WITH to_update AS (
|
||||
SELECT
|
||||
"id",
|
||||
"agentBlockId",
|
||||
"constantInput"::jsonb AS j
|
||||
FROM "AgentNode"
|
||||
|
@ -27,6 +32,7 @@ WITH to_update AS (
|
|||
),
|
||||
updated_rows AS (
|
||||
SELECT
|
||||
"id",
|
||||
"agentBlockId",
|
||||
(
|
||||
j
|
||||
|
@ -75,4 +81,6 @@ updated_rows AS (
|
|||
UPDATE "AgentNode" AS an
|
||||
SET "constantInput" = ur."newConstantInput"
|
||||
FROM updated_rows ur
|
||||
WHERE an."agentBlockId" = ur."agentBlockId";
|
||||
WHERE an."id" = ur."id";
|
||||
|
||||
COMMIT;
|
||||
|
|
Loading…
Reference in New Issue