- 10a (1000m제곱당 수확량)
- false가 노지 true가 시설
- 오이랑 상추만 시설
-- 사과 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('사과', 2066, 8852139, 3823247, 5028892, 56.8, false);
-- 감귤 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('감귤', 2557, 5196222, 1903310, 3292913, 63.4, false);
-- 수박 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('수박', 4447, 4523275, 2273084, 2250191, 49.7, false);
-- 배 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('배', 2448, 7265401, 3641190, 3624211, 49.9, false);
-- 포도 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('포도', 1545, 10642010, 4213986, 6428025, 60.4, false);
-- 양파 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('양파', 6787, 5077135, 2274485, 2802649, 55.2, false);
-- 대파 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('대파', 3769, 4352848, 1770456, 2582392, 59.3, false);
-- 오이 (시설)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('오이', 9974, 22729042, 12018109, 10710933, 47.1, true);
-- 상추 (시설)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('상추', 3062, 11087540, 6119823, 4967717, 44.8, true);
-- 고구마 (노지)
INSERT INTO crops (crops_name, quantity, total_price, operating_price, total_real_price, total_rate, house)
VALUES ('고구마', 1812, 4108604, 2023417, 2085187, 50.8, false);
- 1kg 당 시세 예측 정보 (작물별)
- 시설수박, 시설포도( AND house = true;)만 시세 예측 데이터가 null임
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 2024.573974609375,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 2052.865478515625,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 2039.0390625,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 2261.031982421875,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 2295.0732421875,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 2334.068115234375,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 2397.01904296875,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 2145.0546875,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 1960.308349609375,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 2210.23828125,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 2260.0625,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 2268.335205078125,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '고구마' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 2436.139848590315,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 4523.649716995557,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 4468.035849318106,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 3886.1328920498,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 2590.626561504229,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 1958.1799792914724,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 1904.7123001244345,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 2584.820372518129,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 2406.091960443787,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 2504.932696276358,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 2764.973747122535,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 2943.303901323412,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '수박' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 5534.353177248809,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 3908.8944801974058,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 3642.6414039879055,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 3078.107310031905,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 2962.2584441971526,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 3753.7933082729937,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 7679.752654686599,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 8906.341039087903,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 9965.462250252358,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 7195.533931911217,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 3292.490300518736,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 3810.894285508797,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '상추' AND house = true;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 2008.06583871572,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 1992.640835889763,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 5014.922580686585,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 6162.670635623678,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 8572.493213995527,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 7165.921958356081,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 6183.335287836432,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 6588.517842913551,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 5264.752900916377,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 1919.596573899792,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 2008.908295555202,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 2287.839290259246,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '감귤' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 1114.1868896484375,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 1043.6083984375,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 1077.8909912109375,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 1077.320068359375,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 1130.8731689453125,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 1193.2047119140625,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 1268.16650390625,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 1293.9393310546875,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 1152.23828125,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 1068.609619140625,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 1075.2177734375,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 1028.107666015625,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '양파' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 4497.792159808232,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 4159.138065616548,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 3825.1535808166914,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 2342.912555826032,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 1710.4938254973183,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 1515.7409672514789,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 1925.1336548938489,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 2184.6183876232685,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 2571.1927467472738,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 2456.270362906353,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 2984.0632402498136,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 3534.7220581125,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '오이' AND house = true;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 8133.966483768438,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 5706.68918778023,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 5880.98116052781,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 5618.072715769259,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 6082.39822319558,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 7721.415781993408,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 8721.238090105879,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 6187.480066176376,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 5842.5324570636185,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 5083.656538445094,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 6262.878812337506,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 6356.66882409652,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '포도' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 1631.292236328125,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 1551.76513671875,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 1641.645263671875,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 1643.03564453125,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 1642.84326171875,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 1641.23828125,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 1610.6007080078125,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 1633.43310546875,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 1629.2437744140625,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 1629.08154296875,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 1623.8427734375,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 1631.9434814453125,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '대파' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 3988.193603515625,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 3929.417724609375,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 3883.34521484375,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 3789.367431640625,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 3498.9287109375,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 3564.0390625,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 3448.339599609375,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 3366.809326171875,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 3384.636962890625,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 3358.965576171875,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 3361.896240234375,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 3382.168212890625,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '배' AND house = false;
UPDATE crops
SET monthly_price = '{
"monthly_data": [
{
"date": "2025-01-01",
"price_forecast": 4048.131591796875,
"year": 2025,
"month": 1
},
{
"date": "2025-02-01",
"price_forecast": 4047.738037109375,
"year": 2025,
"month": 2
},
{
"date": "2025-03-01",
"price_forecast": 4050.502685546875,
"year": 2025,
"month": 3
},
{
"date": "2025-04-01",
"price_forecast": 4878.77392578125,
"year": 2025,
"month": 4
},
{
"date": "2025-05-01",
"price_forecast": 4545.30615234375,
"year": 2025,
"month": 5
},
{
"date": "2025-06-01",
"price_forecast": 4427.04833984375,
"year": 2025,
"month": 6
},
{
"date": "2025-07-01",
"price_forecast": 3650.759765625,
"year": 2025,
"month": 7
},
{
"date": "2025-08-01",
"price_forecast": 4111.814453125,
"year": 2025,
"month": 8
},
{
"date": "2025-09-01",
"price_forecast": 4222.06884765625,
"year": 2025,
"month": 9
},
{
"date": "2025-10-01",
"price_forecast": 4270.69970703125,
"year": 2025,
"month": 10
},
{
"date": "2025-11-01",
"price_forecast": 4242.91796875,
"year": 2025,
"month": 11
},
{
"date": "2025-12-01",
"price_forecast": 4222.88037109375,
"year": 2025,
"month": 12
}
]
}'
WHERE crops_name = '사과' AND house = false;
- 1kg 당 2023,2024 수익
- 시설수박, 시설포도( AND house = true;)만 시세 예측 데이터가 null임
- 노지는 ( AND house = false;)
-- Update statement for 사과 (Apple)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 2510.975551334362,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 2085.845368678227,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 2379.484598836648,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 2656.968378691809,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 3141.6069136141323,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 4136.494871592277,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 3172.149505212141,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 4588.787012151184,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 4504.077252368344,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 4370.3156688625,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 3756.731245491913,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 4098.909936817547,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 4997.455343483935,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 5566.048256800022,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 5623.346546050166,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 5826.228012312578,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 5605.075837053631,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 4821.654059223493,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 3137.0407177545108,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 3663.931128921404,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 2729.875858922843,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 3293.6918988975917,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 3393.0965399039,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 3789.1733779418096,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name= '사과' AND house = false;
-- Update statement for 감귤 (Tangerine)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 2044.2118506680213,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 2292.89831069072,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 3768.986049542944,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 4997.475508040203,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 8489.817980617303,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 6199.537979665146,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 5495.509769524622,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 7056.78839224382,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 5073.488319586829,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 1780.0506670480318,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 2046.9405830904177,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 2376.346765957984,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 3761.346173986269,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 5573.258232000759,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 6295.072896788864,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 5681.568748508014,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 8004.037650989464,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 6253.7446735460735,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 4883.987346204318,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 5436.163866831866,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 4319.03503643034,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 1813.7467933925104,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 2254.029210452984,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 2742.64362980827,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '감귤' AND house = false;
-- Update statement for 수박 (Watermelon)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 2751.3519850305474,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 4687.20532631925,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 3247.763424731343,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 2690.537440707254,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 1985.1232717859364,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 1689.6941338868685,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 1405.409086229868,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 2775.558960904073,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 2064.4387984396253,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 1496.7320974191202,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 1839.8484326967584,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 2075.140316453054,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 4493.480676155735,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 4133.088576087889,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 3917.983776004187,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 3655.390546908468,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 2244.442199520377,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 1360.083400826035,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 1360.7602563021471,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 2176.3299386808344,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 1903.6880217293892,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 2559.5049286021854,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 2303.771890897284,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 2930.7131417804994,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '수박' AND house = false;
-- Update statement for 배 (Pear)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 1922.3740200837808,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 1587.3178357253555,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 1552.921355835881,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 1519.1984241186012,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 1757.593000145658,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 2185.735462187551,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 1977.209485734392,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 2459.7704175458293,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 2821.6488519197283,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 2318.2184146487416,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 2780.707042125644,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 3264.557504342425,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 4016.846077512882,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 4416.893333142126,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 4926.56001774122,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 5307.327710843373,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 5710.356615913947,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 7046.397467782049,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 7031.665802905379,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 2912.347878086174,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 2785.283511234928,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 2107.7932904984555,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 3177.4063698453224,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 3609.191090015519,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '배' AND house = false;
-- Update statement for 포도 (Grape)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 5456.334696787895,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 5471.852530039462,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 5323.1352536657605,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 4996.699141281503,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 5010.43548931211,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 7524.5823528552,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 9599.69099152478,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 6984.975769350198,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 5476.971514194368,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 4132.012041968253,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 5472.832914211123,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 6008.448068489978,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 7364.941855186815,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 8165.06129176146,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 7372.220717504249,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 6389.816425967727,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 7014.100218433324,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 8404.59611314543,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 7958.229562604252,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 5863.595796377615,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 4169.384756183279,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 3073.8432052968656,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 4002.780312656697,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 4043.7696308276586,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '포도' AND house = false;
-- Update statement for 양파 (Onion)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 1264.5481094671695,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 1400.2958026070037,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 1382.624538638691,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 1117.6179141311284,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 1020.3817535051604,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 838.6825113547438,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 929.5358748722094,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 1057.662066672682,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 1061.7290272017158,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 1061.2612272574245,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 1024.4498419451977,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 1045.0691677520963,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 1016.2340161367504,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 1073.505262443767,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 1283.9666996816477,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 1242.781273918912,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 997.6818964184828,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 656.1189772381099,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 750.2977282450277,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 898.5761515967932,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 1013.56698406989,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 1023.1622729669292,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 1114.6556947688823,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 1125.3795009694657,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '양파' AND house = false;
-- Update statement for 대파 (Green Onion)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 1685.3163822178535,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 1950.8612974615487,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 1748.1949618734388,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 1185.2924438823902,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 1503.8750158429116,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 1340.9519360286192,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 1459.6696688875115,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 1695.4440512909464,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 1722.48017232163,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 2151.7809749749517,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 2177.2254683401093,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 2461.008768694906,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 2700.2994442161826,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 2725.772940111467,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 2221.8217423520696,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 1573.7826066734376,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 1483.938858286177,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 1336.6925975929614,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 1261.5353643225592,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 1512.6746673736554,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 1772.171861013226,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 1726.2125885039454,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 1628.7119824849674,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 1697.954561362122,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '대파' AND house = false;
-- Update statement for 오이 (Cucumber)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 3895.362565780272,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 4046.7929793917615,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 2982.0138684989697,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 1979.1060439917155,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 1463.7603878148932,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 1321.5416149811251,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 1382.5632426752518,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 1637.012559842927,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 1945.8038819109963,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 2010.137860061935,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 2355.476914624688,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 2906.042585676922,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 4254.653051501368,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 4844.486116094382,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 3754.320308461008,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 2230.4991407499124,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 1390.8499430004206,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 1070.0426372605757,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 1685.5188362829826,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 1722.3556956756768,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 2088.187368925315,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 2589.8439736770065,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 3218.0370865172167,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 3200.4404872520417,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '오이' AND house = true;
-- Update statement for 상추 (Lettuce)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 4978.053639398896,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 3803.45549134948,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 3192.010133972045,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 2746.29514769478,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 2352.321075912026,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 3002.591090941953,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 8803.119298793406,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 5936.642819511267,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 6038.395388430014,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 4981.849803421356,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 3381.625201631043,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 2784.5484926547383,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 4314.454308957112,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 2868.3791090984405,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 3621.7568104851534,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 2167.3958997564573,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 2210.037517806777,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 2420.825991239507,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 6135.883308649484,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 7208.874688679954,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 11879.944173608728,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 10245.708529379584,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 3495.35577216365,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 2649.345417568359,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '상추' AND house = true;
-- Update statement for 고구마 (Sweet Potato)
UPDATE crops SET past_price = '{
"past_data": [
{
"date": "2023-01-01",
"price_forecast": 1549.2394415592169,
"year": 2023,
"month": 1
},
{
"date": "2023-02-01",
"price_forecast": 1631.8657195688063,
"year": 2023,
"month": 2
},
{
"date": "2023-03-01",
"price_forecast": 1272.6008348527553,
"year": 2023,
"month": 3
},
{
"date": "2023-04-01",
"price_forecast": 1818.670934218146,
"year": 2023,
"month": 4
},
{
"date": "2023-05-01",
"price_forecast": 2074.006524848404,
"year": 2023,
"month": 5
},
{
"date": "2023-06-01",
"price_forecast": 2275.5776937171227,
"year": 2023,
"month": 6
},
{
"date": "2023-07-01",
"price_forecast": 2437.4639940377688,
"year": 2023,
"month": 7
},
{
"date": "2023-08-01",
"price_forecast": 2473.124754407303,
"year": 2023,
"month": 8
},
{
"date": "2023-09-01",
"price_forecast": 1874.976646354301,
"year": 2023,
"month": 9
},
{
"date": "2023-10-01",
"price_forecast": 1523.161717651087,
"year": 2023,
"month": 10
},
{
"date": "2023-11-01",
"price_forecast": 1702.9041884890962,
"year": 2023,
"month": 11
},
{
"date": "2023-12-01",
"price_forecast": 1890.2788614353856,
"year": 2023,
"month": 12
},
{
"date": "2024-01-01",
"price_forecast": 2050.6366563374486,
"year": 2024,
"month": 1
},
{
"date": "2024-02-01",
"price_forecast": 2149.4482486799543,
"year": 2024,
"month": 2
},
{
"date": "2024-03-01",
"price_forecast": 2312.688624531785,
"year": 2024,
"month": 3
},
{
"date": "2024-04-01",
"price_forecast": 2391.7567729074976,
"year": 2024,
"month": 4
},
{
"date": "2024-05-01",
"price_forecast": 2844.815855863323,
"year": 2024,
"month": 5
},
{
"date": "2024-06-01",
"price_forecast": 2353.248339062221,
"year": 2024,
"month": 6
},
{
"date": "2024-07-01",
"price_forecast": 1783.7677967474106,
"year": 2024,
"month": 7
},
{
"date": "2024-08-01",
"price_forecast": 1888.4697229444,
"year": 2024,
"month": 8
},
{
"date": "2024-09-01",
"price_forecast": 1778.7897368435222,
"year": 2024,
"month": 9
},
{
"date": "2024-10-01",
"price_forecast": 1489.431571948712,
"year": 2024,
"month": 10
},
{
"date": "2024-11-01",
"price_forecast": 1615.1995456421143,
"year": 2024,
"month": 11
},
{
"date": "2024-12-01",
"price_forecast": 1798.359679232646,
"year": 2024,
"month": 12
}
]
}' WHERE crops_name = '고구마' AND house = false;