Commit graph

30 commits

Author SHA1 Message Date
Las Zenow
02f711aa97 Add tokenfield tag editor 2021-05-01 11:08:38 +00:00
Las Zenow
1536d97d8d Update to use pg/v10 2020-11-30 19:03:31 +00:00
Las Zenow
c82fd09e0d Optimize submission deletion
The nested select was producing a sequential lookup into the books
table, that took hours to resolv.
2020-11-18 11:52:26 +00:00
Las Zenow
a1ee320eba Add hashes for each book
Check if the uploaded book is already in the library
2020-05-03 10:14:50 +00:00
Las Zenow
383214ee19 Add search by date 2020-03-23 11:35:10 +00:00
Las Zenow
3e3ba1bd7e Merge remote-tracking branch 'mr/7' 2019-12-23 19:11:03 +00:00
endangered
f836f40f89 Provide command line variables for initializing an admin user. Previously to get admin access on a fresh install I had to create a user in the web interface (to make sure the password hash/salt is properly setup) then manually change the role in the database to 'admin' using a postgresql client. This was a pain in the ass, and I think there really needs to be an easy way to create the admin user on the initial deployment. This solution fixes this, and adds documentation to the README file on how to use those variables. 2019-11-25 06:58:44 +09:30
endangered
9ea77c095f Submission uploads (lib.uploadRequest.processFile) generate an error: null value in column active violates not-null constraint. This sets a default value on this column of false and columns in the visits table to zero which also have not-null constraints, ensuring errors like these are prevented 2019-11-25 06:15:28 +09:30
Las Zenow
defaa2ae0b Update to pg v9 2019-11-06 06:53:41 +00:00
Las Zenow
cea8d21105 Clean up old submissions 2019-03-05 21:07:34 +00:00
Las Zenow
60379ba1ef Be able to list users submisions
- Closes: #45
2019-03-05 21:07:34 +00:00
Las Zenow
8b996803c8 Add download counter on each book
* Closes: #40
2018-11-19 03:14:26 +00:00
Las Zenow
1ab2fd882c Add indexes to list entries 2018-04-09 10:51:20 +00:00
Las Zenow
c0a70a18e1 Add book list support in the database 2018-04-09 00:15:58 +00:00
Las Zenow
f2b393a453 Make the tests pass 2018-04-08 22:11:19 +00:00
Las Zenow
6f906ccae4 Add user management interface 2018-04-08 10:55:30 +00:00
Las Zenow
8bcff3c826 Add comments to submissions 2018-04-07 23:50:01 +00:00
Las Zenow
c9b967a2ef Create tables, indexes, functions and triggers programatically 2017-09-21 21:05:06 +00:00
Las Zenow
cc12981a50 Add submission page for uploads
* Closes: #13
2017-09-21 12:09:04 +00:00
Las Zenow
d40dc21627 Cache front page results 2017-06-05 23:03:24 +00:00
Las Zenow
71d975c2f7 Keep count of downladed/viewed books 2017-05-30 22:10:21 +00:00
Las Zenow
83ab1b461d Expose AddRaw[User|News] for scripting 2017-05-21 22:48:43 +00:00
Las Zenow
d0670c0b62 Cache the full book counter 2017-05-21 11:07:13 +00:00
Las Zenow
e0854aa001 Using master pg library 2017-05-21 11:05:37 +00:00
Las Zenow
18baa2938b Remove statistics and add frequent tags in memory 2017-05-21 10:55:53 +00:00
Las Zenow
52b9882be9 Convert Id to ID 2017-05-21 10:50:59 +00:00
Las Zenow
e72de38725 [WIP] migration to psql
TODO:
[ ] stats
[ ] indexes
2017-05-21 10:44:43 +00:00
Las Zenow
e1bd235785 Implement Read Only mode 2017-05-21 10:16:51 +00:00
Las Zenow
8e82ee3702 Add search terms to the moderation page
* Closes: #22
2017-02-04 12:45:42 +00:00
Las Zenow
9d1f1ad5c0 Move all the code to a lib folder 2016-05-02 21:41:40 -04:00
Renamed from database/database.go (Browse further)