๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

์›น๊ณต๋ทฐ49

flutter ํ”Œ๋Ÿฌํ„ฐ csv ํŒŒ์ผ ์ฝ๊ธฐ ๊ธฐ๋Šฅ : ํ™”๋ฉด์—์„œ ํŠน์ • ๋ฒ„ํŠผ์„ ๋ˆ„๋ฅด๋ฉด csv ํŒŒ์ผ์„ ์ฝ์–ด์˜จ๋‹ค. 1. pub csv ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ถ”๊ฐ€ https://pub.dev/packages/csv/install csv | Dart Package A codec to transform between a string and a list of values. The string must be comma (configurable) separated values. pub.dev flutter pub add csv pubspec.yaml ํŒŒ์ผ์— ์•„๋ž˜์™€ ๊ฐ™์ด ๋“ฑ๋ก๋จ์„ ํ™•์ธ dependencies: flutter: sdk: flutter # The following adds the Cupertino Icons font to your application. # Use .. 2023. 6. 26.
flutterfire configure ์—๋Ÿฌ (๊ฒฐ๋ก ์€ ๋กœ๊ทธ์ธ) ์š”์ฆ˜ ์ธํ”„๋Ÿฐ์—์„œ ํ”Œ๋Ÿฌํ„ฐ ๊ฐ•์˜๋ฅผ ๋“ฃ๊ณ  ์žˆ๋‹ค. https://www.inflearn.com/course/flutter-์ž…๋ฌธ/dashboard Flutter ์ž…๋ฌธ - ์•ˆ๋“œ๋กœ์ด๋“œ, iOS ๊ฐœ๋ฐœ์„ ํ•œ ๋ฒˆ์— (with Firebase) - ์ธํ”„๋Ÿฐ | ๊ฐ•์˜ ์•ˆ๋“œ๋กœ์ด๋“œ์™€ iOS ๊ฐœ๋ฐœ์„ ํ•œ ๋ฒˆ์˜ ์ฝ”๋“œ๋กœ ์ž‘์„ฑํ•  ์ˆ˜ ์žˆ๋Š” Flutter ์ž…๋ฌธ ๊ฐ•์ขŒ์ž…๋‹ˆ๋‹ค., - ๊ฐ•์˜ ์†Œ๊ฐœ | ์ธํ”„๋Ÿฐ www.inflearn.com firebase์™€ ์—ฐ๋™ํ•˜๋Š” ๋ถ€๋ถ„์„ ์˜ค๋Š˜ ์‹œ์ž‘ํ–ˆ๋Š”๋ฐ ์™ ๊ฑธ. ๋”ฐ๋ผํ•˜๋‹ค๋ณด๋‹ˆ flutterfire ์—๋Ÿฌ๊ฐ€ ๋–ด๋‹ค. ๊ทธ๋ƒฅ ๋ช…๋ น์–ด flutterfire๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ์‹คํ–‰์€ ์ž˜๋œ๋‹ค. ํ•˜์ง€๋งŒ ํŒŒ์ด์–ด๋ฒ ์ด์Šค์—์„œ ๋งŒ๋“ค์–ด๋†“์€ ํ”„๋กœ์ ํŠธ๋ฅผ ๋ถˆ๋Ÿฌ์˜ค๋ ค flutterfire configure๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š”๊ฒƒ. i Found 0 Fireba.. 2023. 6. 7.
[JPA] MSSQL ์ตœ๊ทผ ๋‚ ์งœ๋กœ ์ •๋ ฌํ•˜์—ฌ ์•„์ดํ…œ 3๊ฐœ ์กฐํšŒํ•˜๊ธฐ ๋งŒ์ผ ์ด ๊ตฌ๋ฌธ์„ mssql ๋กœ ์ง์ ‘ ์ฟผ๋ฆฌ๋ฅผ ๋‚ ๋ฆฐ๋‹ค๋ฉด select TOP 3 * from kogas.dbo.tb_pcm_orders order by creation_date DESC; ์ด ๊ตฌ๋ฌธ์„ JPA๋กœ ํ•œ๋‹ค๋ฉด? public interface UserRepository extends JpaRepository { public List findTop3ByIndustryOrderByCreationDateDesc(Industry industry); } findTop3ByIndustryOrderByCreationDateDesc Top3 : ๋ช‡๊ฐœ ๊ฐ€์ ธ์˜ฌ์ง€. 10๊ฐœ๋ผ๋ฉด Top10, 5๊ฐœ๋ผ๋ฉด Top5 ByIndustry : User ๋ฆฌ์ŠคํŠธ๋ฅผ ๊ฐ€์ ธ์˜ฌ ๋•Œ์˜ ์กฐ๊ฑด. OrderBy : ์–ด๋–ค ์กฐ๊ฑด์ด๋ƒ๋ฉด CreationDate :.. 2022. 12. 24.
[JPA] MSSQL ๋ฌธ์ž์—ด์ด๋‚˜ ์ด์ง„ ๋ฐ์ดํ„ฐ๋Š” ์ž˜๋ฆฝ๋‹ˆ๋‹ค. com.microsoft.sqlserver.jdbc.SQLServerException: ๋ฌธ์ž์—ด์ด๋‚˜ ์ด์ง„ ๋ฐ์ดํ„ฐ๋Š” ์ž˜๋ฆฝ๋‹ˆ๋‹ค. CSV ํŒŒ์ผ์— ์žˆ๋Š” ํ•œ๊ธ€, ์˜์–ด๋กœ ๋œ description ์ •๋ณด๋ฅผ ํ…Œ์ด๋ธ”์— ๋ฐ€์–ด๋„ฃ๋Š” ๋„์ค‘ ์œ„์™€ ๊ฐ™์€ ๋ฉ”์‹œ์ง€๋ฅผ ๋ฐœ๊ฒฌํ–ˆ๋‹ค. ๋ณด์ž๋งˆ์ž ์•„ ๋งž๋‹ค. ํ…Œ์ด๋ธ”์˜ ์ปฌ๋Ÿผ ๊ธธ์ด๋ฅผ ๋””ํดํŠธ(255)๋กœ๋งŒ ์„ค์ •ํ–ˆ๊ตฌ๋‚˜ ์‹ถ์—ˆ๋‹ค. ์ฒ˜์Œ์—๋Š” columDefinition๊ฐ’์„ "TEXT"๋กœ ๋ณ€๊ฒฝํ–ˆ๋”๋‹ˆ "๋ฐ์ดํ„ฐ ํ˜•์‹ text ๋ฐ nvarchar์ด(๊ฐ€) equal to ์—ฐ์‚ฐ์ž์—์„œ ํ˜ธํ™˜๋˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค." ์—๋Ÿฌ ๋ฉ”์‹œ์ง€๊ฐ€ ๋™‡. mysql์„ ์‚ฌ์šฉํ–ˆ๋˜ ํ”„๋กœ์ ํŠธ์—์„œ๋Š” ์œ„์™€ ๊ฐ™์ด ๋ณ€ํ™˜ํ–ˆ์„ ๋•Œ ๋ณ„ ๋ฌธ์ œ๊ฐ€ ์—†์—ˆ๋Š”๋ฐ mssql์—์„œ๋Š” ์ •์ƒ์ ์œผ๋กœ ๋จนํžˆ์ง„ ์•Š์•˜๋‹ค. ๊ตฌ๊ธ€๋ง ๊ฒฐ๊ณผ varchar(MAX) ๋ผ๋Š” ์˜ต์…˜์ด ์žˆ๋‹ค๋Š” ๊ฒƒ์„ ์•Œ๊ฒŒ๋˜๊ณ  ์ด๋ฅผ ์ ์šฉํ•œ .. 2022. 12. 18.