|
215 | 215 | }, |
216 | 216 | "query":"\n WITH\n lock AS (\n SELECT * FROM pgml.notebooks WHERE id = $1 FOR UPDATE\n ),\n max_cell AS (\n SELECT COALESCE(MAX(cell_number), 0) AS cell_number\n FROM pgml.notebook_cells\n WHERE notebook_id = $1\n AND deleted_at IS NULL\n )\n INSERT INTO pgml.notebook_cells\n (notebook_id, cell_type, contents, cell_number, version)\n VALUES\n ($1, $2, $3, (SELECT cell_number + 1 FROM max_cell), 1)\n RETURNING id,\n notebook_id,\n cell_type,\n contents,\n rendering,\n execution_time,\n cell_number,\n version,\n deleted_at" |
217 | 217 | }, |
| 218 | +"5200e99503a6d5fc51cd1a3dee54bbb7c388a3badef93153077ba41abc0b3543": { |
| 219 | +"describe": { |
| 220 | +"columns": [ |
| 221 | + { |
| 222 | +"name":"id", |
| 223 | +"ordinal":0, |
| 224 | +"type_info":"Int8" |
| 225 | + }, |
| 226 | + { |
| 227 | +"name":"name", |
| 228 | +"ordinal":1, |
| 229 | +"type_info":"Text" |
| 230 | + }, |
| 231 | + { |
| 232 | +"name":"task", |
| 233 | +"ordinal":2, |
| 234 | +"type_info":"Text" |
| 235 | + }, |
| 236 | + { |
| 237 | +"name":"created_at", |
| 238 | +"ordinal":3, |
| 239 | +"type_info":"Timestamp" |
| 240 | + } |
| 241 | + ], |
| 242 | +"nullable": [ |
| 243 | +false, |
| 244 | +false, |
| 245 | +null, |
| 246 | +false |
| 247 | + ], |
| 248 | +"parameters": { |
| 249 | +"Left": [ |
| 250 | +"Int8" |
| 251 | + ] |
| 252 | + } |
| 253 | + }, |
| 254 | +"query":"SELECT\n id,\n name,\n task::text,\n created_at\n FROM pgml.projects\n WHERE id = $1" |
| 255 | + }, |
218 | 256 | "568dd47e8e95d61535f9868364ad838d040f4c66c3f708b5b2523288dd955d33": { |
219 | 257 | "describe": { |
220 | 258 | "columns": [ |
|
489 | 527 | }, |
490 | 528 | "query":"SELECT * FROM pgml.notebooks" |
491 | 529 | }, |
| 530 | +"66f62d3857807d6ae0baa2301e7eae28b0bf882e7f56f5edb47cc56b6a80beee": { |
| 531 | +"describe": { |
| 532 | +"columns": [ |
| 533 | + { |
| 534 | +"name":"id", |
| 535 | +"ordinal":0, |
| 536 | +"type_info":"Int8" |
| 537 | + }, |
| 538 | + { |
| 539 | +"name":"name", |
| 540 | +"ordinal":1, |
| 541 | +"type_info":"Text" |
| 542 | + }, |
| 543 | + { |
| 544 | +"name":"task", |
| 545 | +"ordinal":2, |
| 546 | +"type_info":"Text" |
| 547 | + }, |
| 548 | + { |
| 549 | +"name":"created_at", |
| 550 | +"ordinal":3, |
| 551 | +"type_info":"Timestamp" |
| 552 | + } |
| 553 | + ], |
| 554 | +"nullable": [ |
| 555 | +false, |
| 556 | +false, |
| 557 | +null, |
| 558 | +false |
| 559 | + ], |
| 560 | +"parameters": { |
| 561 | +"Left": [] |
| 562 | + } |
| 563 | + }, |
| 564 | +"query":"SELECT\n id,\n name,\n task::TEXT,\n created_at\n FROM pgml.projects\n WHERE task::text != 'embedding'\n ORDER BY id DESC" |
| 565 | + }, |
492 | 566 | "7095e7b76e23fa7af3ab2cacc42778645f8cd748e5e0c2ec392208dac6755622": { |
493 | 567 | "describe": { |
494 | 568 | "columns": [ |
|
899 | 973 | }, |
900 | 974 | "query":"UPDATE pgml.notebook_cells\n SET\n cell_type = $1,\n contents = $2,\n version = version + 1\n WHERE id = $3" |
901 | 975 | }, |
902 | | -"c51dddac8ca1272eb957b5cbfd789e63c9e8897d62bc2c57c168eba5ada12dc3": { |
903 | | -"describe": { |
904 | | -"columns": [ |
905 | | - { |
906 | | -"name":"id", |
907 | | -"ordinal":0, |
908 | | -"type_info":"Int8" |
909 | | - }, |
910 | | - { |
911 | | -"name":"name", |
912 | | -"ordinal":1, |
913 | | -"type_info":"Text" |
914 | | - }, |
915 | | - { |
916 | | -"name":"task", |
917 | | -"ordinal":2, |
918 | | -"type_info":"Text" |
919 | | - }, |
920 | | - { |
921 | | -"name":"created_at", |
922 | | -"ordinal":3, |
923 | | -"type_info":"Timestamp" |
924 | | - } |
925 | | - ], |
926 | | -"nullable": [ |
927 | | -false, |
928 | | -false, |
929 | | -null, |
930 | | -false |
931 | | - ], |
932 | | -"parameters": { |
933 | | -"Left": [] |
934 | | - } |
935 | | - }, |
936 | | -"query":"SELECT\n id,\n name,\n task::TEXT,\n created_at\n FROM pgml.projects\n ORDER BY id DESC" |
937 | | - }, |
938 | 976 | "c5eaa1c003a32a2049545204ccd06e69eace7754291d1c855da059181bd8b14e": { |
939 | 977 | "describe": { |
940 | 978 | "columns": [], |
|
998 | 1036 | }, |
999 | 1037 | "query":"SELECT\n a.id,\n project_id,\n model_id,\n strategy::TEXT,\n created_at,\n a.id = last_deployment.id AS active\n FROM pgml.deployments a\n CROSS JOIN LATERAL (\n SELECT id FROM pgml.deployments b\n WHERE b.project_id = a.project_id\n ORDER BY b.id DESC\n LIMIT 1\n ) last_deployment\n WHERE a.id = $1\n ORDER BY a.id DESC" |
1000 | 1038 | }, |
1001 | | -"d8fb565e5ca7f3b60a28e00080902ec34a9036a77ffdde04957f8a6fd543e31d": { |
1002 | | -"describe": { |
1003 | | -"columns": [ |
1004 | | - { |
1005 | | -"name":"id", |
1006 | | -"ordinal":0, |
1007 | | -"type_info":"Int8" |
1008 | | - }, |
1009 | | - { |
1010 | | -"name":"name", |
1011 | | -"ordinal":1, |
1012 | | -"type_info":"Text" |
1013 | | - }, |
1014 | | - { |
1015 | | -"name":"task", |
1016 | | -"ordinal":2, |
1017 | | -"type_info":"Text" |
1018 | | - }, |
1019 | | - { |
1020 | | -"name":"created_at", |
1021 | | -"ordinal":3, |
1022 | | -"type_info":"Timestamp" |
1023 | | - } |
1024 | | - ], |
1025 | | -"nullable": [ |
1026 | | -false, |
1027 | | -false, |
1028 | | -null, |
1029 | | -false |
1030 | | - ], |
1031 | | -"parameters": { |
1032 | | -"Left": [ |
1033 | | -"Int8" |
1034 | | - ] |
1035 | | - } |
1036 | | - }, |
1037 | | -"query":"SELECT\n id,\n name,\n task::TEXT,\n created_at\n FROM pgml.projects\n WHERE id = $1" |
1038 | | - }, |
1039 | 1039 | "da28d578e5935c65851410fbb4e3a260201c16f9bfacfc9bbe05292c292894a2": { |
1040 | 1040 | "describe": { |
1041 | 1041 | "columns": [ |
|