Commit Graph

348 Commits (release/0.25.1)

Author SHA1 Message Date
Steven d426f89cf0 chore: add time filter to timeline 2 years ago
Wen Sun a22ad90174
fix: set memo resources error in mysql (#2761)
Fix error updating memo resources in mysql
2 years ago
Steven 8e0ce4d678 fix: list memos with pinned 2 years ago
Wen Sun 6cfd94cc69
fix: deleting inbox records that senders have been deleted (#2743)
Deleting inbox records that senders have been deleted
2 years ago
Steven 9c663b1ba2 fix: merge mysql dsn with params 2 years ago
Steven 9459ae8265 chore: update postgres stmt builder 2 years ago
Steven d67eaaaee2 chore: update database migrator 2 years ago
Steven fd8333eeda chore: fix memo parent_id 2 years ago
Steven a297cc3140 chore: exclude comments in memo list response 2 years ago
Steven 8b9455d784 chore: fix memo resources position 2 years ago
Steven 501f8898f6 chore: fix postgres stmts 2 years ago
Steven c797099950 chore: update resource internal path migrator 2 years ago
Lincoln Nogueira 411e807dcc
chore: use consistent relative paths for resources (#2683)
- always store resources with a relative path with forward slashes, which will be transformed as needed when the file is accessed

- fix an issue with thumbnail generation on Windows

- add several validations for local storage setting

- improve front-end error feedback when changing local storage

- add migrations to make existing resource paths relative (not needed, but improves database consistency)
2 years ago
Steven 02265a6e1a chore: fix memo search 2 years ago
Athurg Gooth f184d65267
fix: attachments send from telegram lost (#2650) 2 years ago
Steven 762cb25227 chore: update memo service 2 years ago
Steven fc01a796f8 chore: fix demo seed data 2 years ago
Steven e0cacfc6d6 chore: retire auto backup for sqlite 2 years ago
Steven a3a1bbe8de chore: tweak responsible styles 2 years ago
Steven fe4ec0b156 chore: rename navigator 2 years ago
Steven 7c5fdd1b06 chore: remove demo banner 2 years ago
Steven d8a0528135 chore: tweak variable names 2 years ago
Steven 47af632c79 chore: update inline parser 2 years ago
Steven 7735cfac31 chore: update seed data 2 years ago
Steven 2d9c5d16e1 chore: fix user string 2 years ago
Steven 7eb5be0a4e chore: fix update user 2 years ago
Steven 603a6a4971 chore: fix vacuum memo 2 years ago
Cologler 6bda64064e
fix: delete one memo will delete all memos on pgsql (#2611)
fix: delete single memo will all memos on pgsql

Close #2605
2 years ago
Steven c608877c3e chore: clean binary entries 2 years ago
Steven 52f399a154 chore: remove unused functions 2 years ago
Steven 9f4f2e8e27 chore: fix user setting values 2 years ago
Steven 0127e08a28 fix: data conflict handler 2 years ago
Steven d275713aff chore: fix timestamp type in postgres 2 years ago
Steven c50f4f4cb4 chore: update migration scripts 2 years ago
Steven abda6ad041 chore: update latest schema 2 years ago
Steven 7fc7b19d64 chore: deprecate user setting legacy api 2 years ago
Steven b2d898dc15 chore: fix import order 2 years ago
Steven 15425093af chore: skip user setting key checks 2 years ago
steven c68bfcc3b9 chore: fix user setting store 2 years ago
Steven fa6693a7ae chore: update list memos 2 years ago
Athurg Gooth 5f86769255
fix: field type of row_status for table webhook (#2579)
Fix field type of row_status for table webhook
2 years ago
Irving Ou 9c18960f47
feat: support Postgres (#2569)
* skeleton of postgres

skeleton

* Adding Postgres specific db schema sql

* user test passed

* memo store test passed

* tag is working

* update user setting test done

* activity test done

* idp test passed

* inbox test done

* memo_organizer, UNTESTED

* memo relation test passed

* webhook test passed

* system setting test passed

* passed storage test

* pass resource test

* migration_history done

* fix memo_relation_test

* fixing server memo_relation test

* passes memo relation server test

* paess memo test

* final manual testing done

* final fixes

* final fixes cleanup

* sync schema

* lint

* lint

* lint

* lint

* lint
2 years ago
Steven a12844f5db chore: tweak seed data 2 years ago
Steven 1a5bce49c2 chore: implement webhook store 2 years ago
Steven 6529375a8b chore: update seed data 2 years ago
Steven ec2995d64a chore: fix order by pinned 2 years ago
Steven 981bfe0464 feat: add version checker 2 years ago
Steven 695fb1e0ca chore: update migration history store 2 years ago
Steven 405fc2b4d2 chore: simplify find migration history 2 years ago
Steven eacd3e1c17 chore: fix mysql latest schema 2 years ago
Athurg Gooth b966c16dd5
fix: data too large for mysql (#2470)
* Extend some TEXT field to LONGTEXT in mysql

* move db migration version

* fix error in migrate SQL
2 years ago
Steven 88fb79e458 chore: impl inbox store for mysql 2 years ago
Steven 3c36cc2953 feat: add inbox ui 2 years ago
Steven 18107248aa chore: rename list inbox 2 years ago
Steven 1b34119e60 chore: update activity store definition 2 years ago
Steven 67d2e4ebcb chore: update method name 2 years ago
Steven 4ea78fa1a2 chore: impl inbox store methods 2 years ago
Steven 93b8e2211c chore: update dev latest schema 2 years ago
Steven 052216c471 chore: fix list activities typo 2 years ago
Steven e5978a70f5 chore: initial inbox store model 2 years ago
Steven 5b3af827e1 chore: move common packages to internal 2 years ago
Steven d06d01cef2 chore: release mysql driver 2 years ago
Athurg Gooth af7c0a76d0
fix: fail to update user's update_ts (#2410) 2 years ago
Steven 1b105db958 chore: fix field syntax 2 years ago
Steven 6f2ca6c87a chore: update find memo api 2 years ago
guopeng 73f59eaf09
fix: storage setting changed don't take effect (#2385)
* fix: Storage setting changed don't take effect

* fix: Storage setting changed don't take effect

* fix: Storage setting changed don't take effect
2 years ago
Athurg Gooth 6bb6c043e5
feat: add support for ListMemoOrganizer (#2367)
* Add support for ListMemoOrganizer

* fix rows not close
2 years ago
Athurg Gooth fa2bba51c1
feat: add support for ListActivity (#2365)
Add support for ListActivity
2 years ago
Athurg Gooth 425b43b3bb
fix: ListTag not support omit params (#2366)
fix ListTag not support omit params
2 years ago
Athurg Gooth 287f1beb90
fix: create storage without some attributes (#2358) 2 years ago
Athurg Gooth 7680be1a2f
fix: create user without some attributes (#2357) 2 years ago
Athurg Gooth 55e0fbf24e
fix: create activity without some attributes (#2356) 2 years ago
Athurg Gooth eaac17a236
fix: create memo without some attributes (#2355) 2 years ago
Athurg Gooth 1fbd568dfe
fix: create resource without some attributes (#2354) 2 years ago
Athurg Gooth c0619ef4a4
fix: CreateIdentityProvider without id (#2352) 2 years ago
Athurg Gooth b2aa66b4fd
fix: migration always in mysql (#2353) 2 years ago
Steven b938c8d7b6 chore: only show comments in memo detail page 2 years ago
Steven 553de3cc7e fix: mysql syntax 2 years ago
Steven c0422dea5b chore: fix sqlite migrator 2 years ago
Steven 7791fb10d8 chore: update new db driver 2 years ago
Steven a6ee61e96d chore: update package name 2 years ago
Athurg Gooth 5121e9f954
chore: move migration and seed code into driver (#2294)
Move migration and seed code into driver
2 years ago
Steven 9abf294eed chore: update seed data 2 years ago
Steven 71ee299de7 chore: drop shortcut 2 years ago
Steven 6007f48b7d chore: retire memo resource relation table 2 years ago
Steven 8c2f89edc5 chore: update demo username 2 years ago
Steven 6cff920f0c chore: update user demo data 2 years ago
Steven cd0ea6558d chore: update golangci-lint config 2 years ago
Steven 3a1f82effa fix: migration script 2 years ago
Steven a3d7cc9392 fix: migration script 2 years ago
Steven 28a1888163 chore: fix user seed data 2 years ago
Steven 33d9c13b7e chore: remove openid field from user 2 years ago
boojack ad1822d308
chore: update db utils (#2177) 2 years ago
boojack 4af0d03e93
chore: add user profile page (#2175)
chore: some enhancements
2 years ago
boojack 4c33d8d762
chore: remove unused transaction in store (#1995)
* chore: remove unused transaction in store

* chore: update
2 years ago
Lincoln Nogueira c8961ad489
fix: database is locked (#1992)
* fix: database is locked

The option "_journal_mode=WAL" is currently *not* being applied when
provided in the DSN.

This issue affects only new memos installations, not older ones where
the database journal was properly set to WAL mode by the previous sqlite
library go-sqlite3.

modernc.org/sqlite DSN parsing is different from go-sqlite3. It requires
the `_pragma=` prefix and even some options order matter.

https://gitlab.com/cznic/sqlite/-/issues/115

Closes #1985

* chore: upgraded notes on sqlite DSN
2 years ago
boojack 5e20094386
chore: add indexes (#1959) 2 years ago
boojack 40a30d46af
chore: update db connection params (#1960) 2 years ago
boojack 698380f940
chore: update seed data (#1928) 2 years ago
boojack 7e391bd53d
chore: remove resource public id (#1912)
* chore: remove resource public id

* chore: update
2 years ago
boojack 223404a240
chore: update memo seed data (#1884) 2 years ago
boojack 07e82c3f4a
fix: schema migrate (#1846)
* fix: schema migrate

* chore: update
2 years ago
Athurg Gooth ddf4cae537
feat: disable CGO_ENABLED (#1766)
* Replace mattn/go-sqlite3 with modernc.org/sqlite

* Disable CGO to make binary work without special c lib

* Replace mattn/go-sqlite3 with modernc.org/sqlite in testing code

* Tidy go module

---------

Co-authored-by: Athurg Feng <athurg@gooth.org>
2 years ago
boojack 2e34ce90a1
chore: upgrade version `0.13.1` (#1754) 2 years ago
boojack 1d7627dd72
chore: upgrade version `0.13.0` (#1685)
* chore: upgrade version `0.13.0`

* chore: update
2 years ago
boojack 1a8310f027
chore: update system setting default value (#1665) 2 years ago
Zeng1998 9eafb6bfb5
chore: add the default value of MaxUploadSizeMiB (#1663) 2 years ago
boojack cd6ab61c2d
chore: add memo_relation (#1585) 2 years ago
boojack 6ff7cfddda
fix: return external link directly (#1465)
* fix: return external link directly

* chore: update
3 years ago
boojack bdc00d67b2
chore: add default local storage path (#1457) 3 years ago
boojack 5aa4ba32c9
fix: system setting field name (#1453) 3 years ago
boojack 4419b4d4ae
chore: update version and remove isDev flag (#1452)
* chore: update version and remove isDev flag

* chore: update
3 years ago
boojack 1cab30f32f
feat: add public id field to resource (#1451)
* feat: add public id field to resource

* feat: support reset resource link
3 years ago
boojack 4f2adfef7b
chore: update system setting name convention (#1448) 3 years ago
boojack 8a33290722
chore: update user setting key convention (#1447)
* chore: update user settng key convention

* chore: update
3 years ago
boojack 41c50e758a
chore: revert resource visibility changes (#1444) 3 years ago
boojack 993ea024fd
chore: update demo seed data (#1421) 3 years ago
Zeng1998 f3090b115d
feat: support local storage (#1383)
* feat: support local storage

* update

* update

* update

* update
3 years ago
boojack ff8851fd9f
fix: golangci-lint version (#1381)
* chore: update interface declare

* chore: update args

* chore: update

* chore: update
3 years ago
boojack 977e7f55e5
feat: add visibility field to resource (#1185) 3 years ago
boojack cc23d5cafe
chore: upgrade version to `0.11.0` (#1143)
* chore: upgrade version to `0.11.0`

* chore: update
3 years ago
boojack 9c5b44d070
feat: update storage schema (#1142) 3 years ago
boojack ffe1073292
fix: schema path for demo mode (#1124) 3 years ago
Yoshino-s afaaec8492
feat(mode): add demo mode (#1121)
* feat(mode): add demo mode

* chroe: Update store/db/db.go

Co-authored-by: boojack <stevenlgtm@gmail.com>

* chroe: Update store/db/db.go

Co-authored-by: boojack <stevenlgtm@gmail.com>

---------

Co-authored-by: boojack <stevenlgtm@gmail.com>
3 years ago
boojack 096a71c58b
feat: add `avatar_url` field to user table (#1106)
refactor: add `avatar_url` field to user table
3 years ago
boojack a538b9789b
feat: introduce idp table (#1105)
* feat: introduce idp table

* chore: update
3 years ago
boojack c6e525b06f
chore: remove unused fields of storage table (#1104) 3 years ago
Zeng1998 1e4a81dea9
feat: storage service backend (#1086)
* feat: storage service backend

* update go.mod

* update the column name (urlPrefix -> url_prefix)

* update

* update
3 years ago
Zeng1998 11924ad4c5
feat: add storage service table (#1070)
* feat: add storage service table

* update json field name

* update table name

* add updated_ts
3 years ago
boojack 9bf869767d
chore: update seed data (#1042) 3 years ago
boojack 1ace332152
feat: graceful shutdown server (#1016) 3 years ago
boojack 4a7b764ab3
chore: remove unused flags for sqlite (#997) 3 years ago
boojack 848ecd99ee
chore: format SQL (#987)
chore: format sql
3 years ago
boojack 677750ef51
chore: upgrade version to `0.10.1` (#949) 3 years ago
boojack 0f057e81e9
fix: version compare (#916)
* fix: version compare

* chore: update
3 years ago
boojack e2e8130f4c
fix: sort version (#914) 3 years ago
boojack 46c13a4b7f
chore: add skipper for secure (#913) 3 years ago
boojack d50ad9433f
feat: persistent session name (#902)
* feat: persistent session name

* chore: update
3 years ago
boojack 5195012217
feat: add `activity` table (#888)
feat: introduce activity
3 years ago
boojack 119603da5d
chore: upgrade version to `0.9.0` (#835) 3 years ago
boojack 201c0b020d
chore: update seed data for tag (#817)
* chore: update seed data

* chore: add `_journal_mode` for SQLite

* chore: update create tag dialog
3 years ago
boojack e4a8a4d708
feat: tag table (#811)
* feat: tag table

* chore: update

* chore: update
3 years ago
boojack b704c20809
chore: return raw text for html (#782) 3 years ago
boojack 6c17f94ef6
fix: max open conns for SQLite (#781) 3 years ago
boojack 575a0610a3
chore: revert "feat: add `visibility` field to resource (#743)" (#751)
Revert "feat: add `visibility` field to resource (#743)"

This reverts commit b68cc08592.
3 years ago
boojack b68cc08592
feat: add `visibility` field to resource (#743) 3 years ago
boojack 045819c312
fix: initial database schema (#601) 3 years ago
boojack 88c3b1ad0f
feat: update prod version (#577) 3 years ago
boojack 2042737004
feat: add username field (#544)
* feat: add username field

* chore: update
3 years ago
boojack d149926a39
chore: update seed data (#507) 3 years ago
boojack a4a5e539ed
chore: update dev version (#489) 3 years ago
boojack e53f5fdd29
chore: update seed data (#437) 3 years ago
boojack cf75054106
feat: add system setting to allow user signup (#407) 3 years ago
boojack 0ccfd0c743
fix: resource table migration (#369)
* fix: resource table migration

* chore: update
3 years ago
boojack 0ea1733acc
fix: missing column in resource table (#368) 3 years ago
boojack 9705406b82
feat: remove foreign key and triggers (#345) 3 years ago
boojack 69e3ba6bed
chore: update demo seeding data (#318)
chore: update seeding data
3 years ago
Steven f407488128 chore: update dev version 3 years ago
Steven 269d92e637 fix: create triggers after dropping old tables 3 years ago
steven ea911387f1 chore: update migration sql file 3 years ago
steven 0b9b89db81 chore: update `VACUUM` 3 years ago
steven 0f65b8bdd3 fix: re-generate table columns foreign keys 3 years ago
steven 6a3b052fa2 chore: don't clean data in dev mode 3 years ago
steven cff0e86989 feat: add `memo_resource` model 3 years ago
Steven d316c04837 feat: update dev latest schema 3 years ago
Steven 4608894e56 fix: add `_foreign_keys` to sqlite dsn 3 years ago
Steven 707d1a96eb chore: move `version` pkg to `server/version` 3 years ago
Steven b8a7df21f2 chore: release `v0.4.3` 3 years ago
boojack dc9f531447
fix: find latest migration history (#190)
* fix: auth action button

* fix: find latest migration history
3 years ago
Steven 922cc21abc chore: update seed data 3 years ago
Steven 7d0407013e chore: make `golangci-lint` happy 3 years ago
Steven a8a3cf31b4 chore: make `golangci-lint` happy 3 years ago
Steven 68b30063a9 chore: update prod schema 3 years ago
boojack 90b881502d
feat: add `user_setting` model (#145)
* feat: add `user_setting` model

* chore: add global store

* chore: update settings in web

* chore: update `i18n` example
3 years ago
boojack 735938395b chore: use `transaction` for migration history 3 years ago
boojack 0c2adfa1d2 feat: add delete user api 3 years ago
boojack b7339e00ba feat: update finding memo with visibility 3 years ago
boojack cfa4151cff chore: update migration folder 3 years ago
boojack 3d33b5d564
chore: update `memo` visibility field (#132)
chore: update `memo` visibility field in schema
3 years ago
boojack 15e1037433 chore: create backup when migration 3 years ago
boojack 21702b615a chore: update seed data 3 years ago
boojack de7058532a fix: schema migration for minor version 3 years ago
boojack 6a8c559e8c chore: update visitor view buttons 3 years ago
boojack 697d01e306
feat: add `visibility` field to memo (#109)
* feat: add `visibility` field to memo

* chore: fix typo
3 years ago
boojack bdc9632b5b
chore: rename user role (#108)
* chore: rename user role to `host`

* chore: related frontend changes

* chore: fix migration file

* chore: use tricky sql
3 years ago
boojack 6f32643d7c
refactor: visitor view (#107)
* refactor: update api

* refactor: visitor view

* chore: update seed data
3 years ago
Hyoban 6b5d5e757e
feat: personal memos page (#105)
* feat: no need to log in to view memos

* chore: add a normal user to seed

* feat: page for other members

* fix: replace window.location

* fix: can not get username on home

* fix: check userID

* fix: can visit other user's page after login

* fix: do not redirect on wrong path

* fix: path error when clicked heatmap

* refactor: revise for review

* chore: remove unused import

* refactor: revise for review

* feat: update each user's route to /u/:userId.

* chore: eslint for import sort

* refactor: revise for review
3 years ago
boojack 3b0346d84c chore: update seed data 3 years ago
boojack 2fe2b82809 chore: update seed data 3 years ago
boojack 536627007d
feat: schema migration handler (#100)
* chore: update about site dialog

* feat: schema migration

* chore: lint with golangci
3 years ago
boojack 3c58953e56 chore: add version checker 3 years ago
boojack 9611ff7386
chore: release v0.1.3 (#98)
* chore: update github action

* chore: release `v0.1.3`

* fix: create migration_history table

* fix: compare migration_history
3 years ago
boojack 87e6277977 fix: upsert migration history 3 years ago
boojack bfc6e4dd0f chore: update seed data 3 years ago
boojack 011fcc7dd4 chore: rename module 3 years ago
boojack 183ce534b9 chore: add `ON DELETE CASCADE` 3 years ago
boojack c3c2882dc5 chore: update server profile 3 years ago
boojack 8e01eb8702 feat: `store/db` module with sqlite 3 years ago