{"id":101844,"date":"2025-03-16T23:44:41","date_gmt":"2025-03-16T20:14:41","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/habit-logger-v2-17i\/"},"modified":"2025-03-16T23:44:41","modified_gmt":"2025-03-16T20:14:41","slug":"habit-logger-v2-17i","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/habit-logger-v2-17i\/","title":{"rendered":"Habit Logger v2 – \u062c\u0627\u0645\u0639\u0647 dev"},"content":{"rendered":"
\n

Habitloggerv2<\/p>\n\n

\u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u06af\u0627\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u06cc \u062f\u0631 ado.net<\/p>\n\n

\u0628\u0627\u0631\u06af\u06cc\u0631\u06cc SQLite
“\u0622\u0645\u0648\u0632\u0634 SQLITE \u0628\u0631\u0627\u06cc \u0645\u0628\u062a\u062f\u06cc\u0627\u0646 – \u0628\u062f\u0648\u0646 \u0647\u06cc\u0686 \u0648\u0642\u062a \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f
\u062a\u0646\u0638\u06cc\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u062f\u0631 \u0648\u06cc\u0698\u0648\u0627\u0644 \u0627\u0633\u062a\u0648\u062f\u06cc\u0648 (14\/23)<\/p>\n\n

git\/github
https:\/\/www.theserverside.com\/blog\/coffee-talk-java-news-stories-and-opinions\/how-to-push-an-existing-project-to-github
https:\/\/kbroman.org\/github_tutorial\/pages\/init.html
\u0627\u0628\u062a\u062f\u0627 \u06cc\u06a9 \u067e\u0631\u0648\u0646\u062f\u0647 .gitignore \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f .vs\/<\/code> <\/p>\n\n

\u06cc\u06a9 \u0631\u0648\u0634 \u06a9\u0645\u062a\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u0639\u0644\u0627\u0645 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:
int[] menuNumbers = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9];<\/code>
\u0628\u0631 \u062e\u0644\u0627\u0641
int[] menuNumbers = new int { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 };<\/code>
\u0645\u0646 \u062a\u0648\u0627\u0646\u0633\u062a\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06a9\u0634\u0646 IntelliSense “\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0628\u06cc\u0627\u0646” \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n

\u0645\u0648\u0627\u062f \u0628\u0644\u0627\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0631\u0627 \u062a\u0645\u06cc\u0632 \u06a9\u0646\u06cc\u062f (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u063a\u06cc\u0631 \u0636\u0631\u0648\u0631\u06cc using<\/code> \u0627\u0638\u0647\u0627\u0631\u0627\u062a \u062f\u0631 \u0628\u0627\u0644\u0627\u06cc \u06a9\u062f) \u0628\u0627 \u06a9\u0644\u06cc\u06a9 \u0631\u0648\u06cc \u0646\u0645\u0627\u062f \u062c\u0627\u0631\u0648 \u062f\u0631 \u067e\u0627\u06cc\u06cc\u0646 Vs.<\/p>\n\n

\u0647\u0646\u06af\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06a9\u0647 \u0627\u0632 \u06cc\u06a9 \u06a9\u0644\u06cc\u062f \u062e\u0627\u0631\u062c\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f ON DELETE CASCADE<\/code> \u062f\u0631 \u067e\u0627\u06cc\u0627\u0646 \u0627\u0639\u0644\u0627\u0645\u06cc\u0647 \u06a9\u0644\u06cc\u062f\u06cc \u062e\u0627\u0631\u062c\u06cc. \u0628\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u062a\u0645\u0627\u0645 \u0633\u0648\u0627\u0628\u0642 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u062c\u062f\u0648\u0644 \u06a9\u0647 \u0627\u0632 \u0622\u0646 \u0634\u0646\u0627\u0633\u0647 \u06a9\u0644\u06cc\u062f \u062e\u0627\u0631\u062c\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u062d\u0630\u0641 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 \u0634\u0645\u0627 \u0633\u0648\u0627\u0628\u0642 \u06cc\u062a\u06cc\u0645 \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0646\u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u062f\u06cc\u06af\u0631 \u0628\u0647 \u0686\u06cc\u0632\u06cc \u0645\u0631\u0628\u0648\u0637 \u0646\u0645\u06cc \u0634\u0648\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n

\n
static<\/span> void<\/span> CreateTables<\/span>(<\/span>SQLiteConnection<\/span> connection<\/span>)<\/span>\n{<\/span>\n    using<\/span> (<\/span>var<\/span> command<\/span> =<\/span> connection<\/span>.<\/span>CreateCommand<\/span>())<\/span>\n    {<\/span>\n        command<\/span>.<\/span>CommandText<\/span> =<\/span> @\"\n            CREATE TABLE IF NOT EXISTS Habits (\n                Id INTEGER PRIMARY KEY AUTOINCREMENT,\n                Habit TEXT NOT NULL,\n                Unit TEXT NOT NULL\n            );\n\n            CREATE TABLE IF NOT EXISTS HabitInstances (\n                Id INTEGER PRIMARY KEY AUTOINCREMENT,\n                HabitId INTEGER NOT NULL,\n                Date TEXT NOT NULL,\n                Quantity INTEGER NOT NULL,\n                FOREIGN KEY (HabitId) REFERENCES Habits(Id) ON DELETE CASCADE\n            );\"<\/span>;<\/span>\n\n        command<\/span>.<\/span>ExecuteNonQuery<\/span>();<\/span>\n    }<\/span>\n}<\/span>\n<\/code><\/pre>\n
\n
\n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0648\u0642\u062a\u06cc DeleteHabit()<\/code> \u0631\u0648\u0634 \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f \u060c \u0639\u0627\u062f\u062a \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0647\u0645\u0647 \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u062f HabitInstances<\/code> \u0633\u0648\u0627\u0628\u0642 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0622\u0646 \u0639\u0627\u062f\u062a.<\/p>\n\n
\u0627\u0646\u062a\u062e\u0627\u0628 \u060c Ctrl K \u060c Ctrl F – \u0631\u0641\u0639 \u062a\u0648\u0631\u0641\u062a\u06af\u06cc<\/p>\n\n
\u0627\u0632 \u0647\u0645\u0627\u0646 \u0627\u062a\u0635\u0627\u0644 DB \u0628\u0631\u0627\u06cc \u06a9\u0644 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u06a9\u0646\u06cc\u062f (\u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f)<\/p>\n
\n
using<\/span> (<\/span>var<\/span> connection<\/span> =<\/span> new<\/span> SQLiteConnection<\/span>(<\/span>$\"Data Source=<\/span>{<\/span>dbPath<\/span>}<\/span>\"<\/span>))<\/span>\n{<\/span>\n\n}<\/span>\n<\/code><\/pre>\n
\n
\n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
using<\/code>  \u0642\u0646\u062f \u0646\u062d\u0648\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u067e\u0634\u062a \u0635\u062d\u0646\u0647 \u06cc\u06a9 \u0628\u0644\u0648\u06a9 \u0627\u0645\u062a\u062d\u0627\u0646\/\u06af\u0631\u0641\u062a\u0646 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f …<\/p>\n
\n
try<\/span>\n{<\/span>\n    \/\/new connection<\/span>\n    \/\/do something<\/span>\n}<\/span>\ncatch<\/span> (<\/span>Exception<\/span> e<\/span>)<\/span>\n{<\/span>\n    \/\/handle error here<\/span>\n}<\/span>\nfinally<\/span>\n{<\/span>\n    connection<\/span>.<\/span>Close<\/span>()<\/span>\n}<\/span>\n<\/code><\/pre>\n
\n
\n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0645\u062b\u0627\u0644:<\/p>\n
\n
void<\/span> AddHabit<\/span>()<\/span>\n{<\/span>\n    using<\/span> (<\/span>var<\/span> connection<\/span> =<\/span> new<\/span> SQLiteConnection<\/span>(<\/span>$\"Data Source=<\/span>{<\/span>dbPath<\/span>}<\/span>\"<\/span>))<\/span>\n    {<\/span>\n        connection<\/span>.<\/span>Open<\/span>();<\/span>\n\n        Console<\/span>.<\/span>Clear<\/span>();<\/span>\n        PrintHabits<\/span>(<\/span>\"Add Habit\"<\/span>);<\/span>\n\n        Console<\/span>.<\/span>WriteLine<\/span>(<\/span>\"\\nEnter the new habit name:\"<\/span>);<\/span>\n        string<\/span>?<\/span> habitName<\/span> =<\/span> Console<\/span>.<\/span>ReadLine<\/span>();<\/span>\n        Console<\/span>.<\/span>WriteLine<\/span>(<\/span>\"\\nEnter the unit of measurement (e.g., miles, pages, minutes, etc.)\"<\/span>);<\/span>\n        string<\/span>?<\/span> unit<\/span> =<\/span> Console<\/span>.<\/span>ReadLine<\/span>();<\/span>\n\n        using<\/span> (<\/span>var<\/span> command<\/span> =<\/span> connection<\/span>.<\/span>CreateCommand<\/span>())<\/span>\n        {<\/span>\n            command<\/span>.<\/span>CommandText<\/span> =<\/span> \"INSERT INTO Habits (Habit, Unit) VALUES (@habit, @unit)\"<\/span>;<\/span>\n            command<\/span>.<\/span>Parameters<\/span>.<\/span>AddWithValue<\/span>(<\/span>\"@habit\"<\/span>,<\/span> habitName<\/span>);<\/span>\n            command<\/span>.<\/span>Parameters<\/span>.<\/span>AddWithValue<\/span>(<\/span>\"@unit\"<\/span>,<\/span> unit<\/span>);<\/span>\n            command<\/span>.<\/span>ExecuteNonQuery<\/span>();<\/span>\n        }<\/span>\n\n        Console<\/span>.<\/span>WriteLine<\/span>(<\/span>\"\\nHabit added successfully!\"<\/span>);<\/span>\n    }<\/span>\n}<\/span>\n<\/code><\/pre>\n
\n
\n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u06af\u0631\u0686\u0647 \u0641\u06a9\u0631 \u0645\u06cc \u06a9\u0646\u0645 \u0645\u0646 \u0647\u0646\u0648\u0632 \u0647\u0645 \u0628\u0627\u0632 \u0645\u06cc \u0634\u0648\u0645 using<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647 \u062e\u06cc\u0644\u06cc \u0632\u0648\u062f \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0648 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0642\u0628\u0644 \u0627\u0632 \u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 DB \u0627\u0633\u062a \u060c \u0628\u0647\u062a\u0631 \u0628\u0627\u0634\u062f \u067e\u0633 \u0627\u0632 \u0628\u06cc\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0648 \u0627\u0639\u0644\u0627\u0645\u06cc\u0647 \u0647\u0627\u06cc \u0645\u062a\u063a\u06cc\u0631 \u0628\u0647\u062a\u0631 \u0628\u0627\u0634\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
Habitloggerv2 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u06af\u0627\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u06cc \u062f\u0631 ado.net \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc SQLite“\u0622\u0645\u0648\u0632\u0634 SQLITE \u0628\u0631\u0627\u06cc \u0645\u0628\u062a\u062f\u06cc\u0627\u0646 – \u0628\u062f\u0648\u0646 \u0647\u06cc\u0686 \u0648\u0642\u062a \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f\u062a\u0646\u0638\u06cc\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 SQLite \u062f\u0631 \u0648\u06cc\u0698\u0648\u0627\u0644 \u0627\u0633\u062a\u0648\u062f\u06cc\u0648 (14\/23) git\/githubhttps:\/\/www.theserverside.com\/blog\/coffee-talk-java-news-stories-and-opinions\/how-to-push-an-existing-project-to-githubhttps:\/\/kbroman.org\/github_tutorial\/pages\/init.html\u0627\u0628\u062a\u062f\u0627 \u06cc\u06a9 \u067e\u0631\u0648\u0646\u062f\u0647 .gitignore \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f .vs\/ \u06cc\u06a9 \u0631\u0648\u0634 \u06a9\u0645\u062a\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u0639\u0644\u0627\u0645 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:int[] menuNumbers = [0, 1, 2, 3, 4, 5, …<\/p>\n","protected":false},"author":2,"featured_media":101845,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-101844","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/101844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=101844"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/101844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/101845"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=101844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=101844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=101844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}