Arav
/
justguestbook
1
0
Fork 0
Code Releases 7 Activity
58 Commits 1 Branch 8 Tags 119 KiB
Commit Graph

58 Commits

Author SHA1 Message Date
Alexander Andreev 8c8c1f2617
Added some more comments. 2023-05-22 02:37:37 +04:00
Alexander Andreev 16e5ececf5
Added a check for a website field's length. 2023-05-22 02:35:39 +04:00
Alexander Andreev 141e1215a3
Added comments. 2023-05-22 02:35:07 +04:00
Alexander Andreev 5d56b56882
Oh, changed email in LICENSE. 2023-05-22 02:12:13 +04:00
Alexander Andreev d272dada83
Let's delete README. 2023-05-22 01:01:43 +04:00
Alexander Andreev 84ff66b4f4
Fixed package name. 2023-05-22 01:01:10 +04:00
Alexander Andreev 9a93ad9a3a
Structure was simplified. 2023-05-22 00:50:11 +04:00
Alexander Andreev fe47f60581
Version incremented in a README. 2023-05-09 23:32:06 +04:00
Alexander Andreev 5a72fbecb4
Found why Edit*() methods didn't work, for UPDATE query Exec() method must be used instead of QueryRow(). 2023-05-09 23:31:39 +04:00
Alexander Andreev cb623e8087
Fixed TestSqliteEditEntry test. 2023-05-09 23:30:18 +04:00
Alexander Andreev 1d6a05d15c
Version in a README was incremented. 2023-05-09 21:45:51 +04:00
Alexander Andreev 761b7626c9
Date now stored as Unix time (int64). No NULL is being returned so no such check is needed. 2023-05-09 21:32:01 +04:00
Alexander Andreev 6cfe0a7d8b
Return both website and hide_website fields (for use on an admin page). Using COALESCE to return 0 and an empty string if there is no reply to not deal with NULL. 2023-05-09 21:30:17 +04:00
Alexander Andreev 613f0c1616
PRIMARY KEY moved out on a separate line. Use INTEGER (Unix time) for created dates to save space. 2023-05-09 21:27:52 +04:00
Alexander Andreev c658b798aa
Changed version in README.md. 2023-05-06 22:24:46 +04:00
Alexander Andreev 1c424e1ec9
Removed unnecessary braces around CASE ... END statement. 2023-05-06 22:22:40 +04:00
Alexander Andreev b9963c9521
Do not change created field in replyUpdate.sql. 2023-05-06 22:22:08 +04:00
Alexander Andreev 9d7088f2cd
Changed formatting for entryCount.sql. 2023-05-06 22:21:47 +04:00
Alexander Andreev f5631bf3d0
Modified tests accordingly to all changes. 2023-05-06 22:21:23 +04:00
Alexander Andreev 2cc91b351c
Don't modify reply's date when edit. 2023-05-06 22:20:58 +04:00
Alexander Andreev 9347a16fca
Do not return number of affected rows in Delete*() methods. 2023-05-06 22:20:11 +04:00
Alexander Andreev bea8df31cb
Return Guestbook interface instead of SQLiteDatabase instance. 2023-05-06 22:19:04 +04:00
Alexander Andreev f602dddff3
Replaced Update*() with Edit*(). 2023-05-06 22:18:20 +04:00
Alexander Andreev 32c1fa6aa1
Reorder fields of Entry struct. 2023-05-06 22:16:40 +04:00
Alexander Andreev 723d2d4772
Make DeleteReply() return count of affected rows. 2023-03-23 17:03:23 +04:00
Alexander Andreev 506a010b23
Module's min Go version was set down to 1.16. 2023-03-23 16:56:28 +04:00
Alexander Andreev c64c3846af
Changed version to 1.0.2 in README. 2023-03-11 22:24:44 +04:00
Alexander Andreev 3b561c2247
Changed version to 1.0.1 in README. 2023-03-11 22:23:48 +04:00
Alexander Andreev 89814cd2af
Added year 2023 to LICENSE. 2023-03-11 22:22:31 +04:00
Alexander Andreev 0bcf1bfce3
Changed arav.top to arav.su. 2023-03-11 22:21:33 +04:00
Alexander Andreev aa18347d31
git.arav.top changed to git.arav.su. 2023-03-11 22:21:12 +04:00
Alexander Andreev c79ab5cf60
Date cannot be scanned directly to time.Time type, so we need to read a date to a string first. 2023-02-05 20:03:36 +04:00
Alexander Andreev 837fec8545
Removed unneded CURRENT_TIMESTAMP defaults. 2023-02-05 20:02:22 +04:00
Alexander Andreev 081d6147b8
Removed RETURNING statements. 2023-02-05 20:01:52 +04:00
Alexander Andreev 309044f651
Dates are now of type time.Time. 2023-02-05 16:28:55 +04:00
Alexander Andreev 729e58fdca
Files are moved out of pkg directory. 2023-01-16 04:25:04 +04:00
Alexander Andreev 4bb06cb2a1
This project was made into a library. 2023-01-12 03:27:45 +04:00
Alexander Andreev be5d0782b6
Changed Update() handler accordingly to a new logic. 2022-10-21 04:38:53 +04:00
Alexander Andreev 6c08e4cb16
Now ID in Reply could be rendered as JSON. 2022-10-21 04:38:08 +04:00
Alexander Andreev b94b5caf4c
Added entryID arg to Update*() methods. So IDs could be changed. 2022-10-21 04:37:28 +04:00
Alexander Andreev 6abae1d7ca
Added entry_id to change in UPDATE for an entry. 2022-10-21 04:36:41 +04:00
Alexander Andreev 95b74985f0
Added entry_id to UPDATE to change for a reply. 2022-10-21 04:36:22 +04:00
Alexander Andreev 8221da67eb
Switched ID and Created fields of a reply in Exec(). 2022-10-21 04:28:55 +04:00
Alexander Andreev 121c3ff8fd
Implemented Count() and update and delete methods. 2022-10-21 04:25:15 +04:00
Alexander Andreev 056985799f
Added Update() handler. A little reorganising in Entries(). 2022-10-21 04:24:07 +04:00
Alexander Andreev 57879522a1
Added PUT endpoints in main. 2022-10-21 04:22:26 +04:00
Alexander Andreev 005330ff2c
Added new sql statements. In new reply entry_id and created swapped places. 2022-10-21 04:22:07 +04:00
Alexander Andreev 49a92151e4
In entryGetAll.sql entry.message moved next to name. 2022-10-21 04:20:53 +04:00
Alexander Andreev d5b850d36b
Added log for a fail of retrieving entries. Added error handling and log for entries JSON encoding. 2022-10-21 03:22:57 +04:00
Alexander Andreev a000d1edad
Added PUT method to HttpServer. 2022-10-21 03:21:53 +04:00