https://github.com/byceps/byceps

sort by:
Revision Author Date Message Commit Date
1816cfa Fix type conversion SQL (correcting the previous commit, fixing the `WHERE` clause): UPDATE user_log_entries SET data = data - 'initiator_id' WHERE event_type IN ('user-avatar-removed', 'user-avatar-updated') AND initiator_id IS NOT NULL; 12 September 2024, 07:44:49 UTC
f6bced8 User `UserLogEntry.initiator_id` if available, only falling back to `UserLogEntry.data[initiator_id]` SQL: UPDATE user_log_entries SET initiator_id = (data->>'initiator_id')::uuid WHERE event_type IN ('user-avatar-removed', 'user-avatar-updated') AND initiator_id IS NULL; UPDATE user_log_entries SET data = data - 'initiator_id' WHERE event_type IN ('user-avatar-removed', 'user-avatar-updated') AND initiator_id IS NULL; 12 September 2024, 07:31:57 UTC
8f33c2f Extract function to collect initators 12 September 2024, 07:29:37 UTC
92db56a Extract function to collect log entries 12 September 2024, 07:29:23 UTC
69d255e Use `user_service.get_users_indexed_by_id` 12 September 2024, 07:29:23 UTC
2325309 Use `UserID` as dict key type 12 September 2024, 07:29:23 UTC
a175519 Pass actual `UserID` objects to user service 12 September 2024, 07:29:21 UTC
174cda6 Fix age adjectives that got harmed in translation 02 September 2024, 19:13:59 UTC
8b6748c Recompile translations 02 September 2024, 18:15:42 UTC
5a09faf Update translations 02 September 2024, 18:15:09 UTC
a8429e3 Fix translation string key inconsistency 02 September 2024, 18:14:57 UTC
b725b87 Link to shop catalogs 02 September 2024, 02:38:00 UTC
46ca2ad Display catalog title instead of ID with storefront 02 September 2024, 02:29:32 UTC
f797fb5 Put catalog object instead of ID into `Storefront` field 02 September 2024, 02:28:31 UTC
6e76f8d Pass catalog object instead of IDs to `create_storefront`, `update_storefront` 02 September 2024, 02:20:02 UTC
d7a6fb1 Hide empty product collections 02 September 2024, 01:31:23 UTC
ac97d8f Fix shop order view when storefront is closed or no products are available 01 September 2024, 22:58:56 UTC
95f75bb Introduce product collection models to render multiple product groups in the frontend 01 September 2024, 15:39:36 UTC
9289006 Turn method `ProductCompilationItem.has_fixed_quantity` into property 01 September 2024, 15:15:53 UTC
b0bcfc2 Use `with` statement to extract product from product compilation item in read-only view 01 September 2024, 05:57:45 UTC
3334cbd Create product in domain service 01 September 2024, 05:39:59 UTC
444afd1 Pass product default quantity from service to database entity constructor 01 September 2024, 05:31:30 UTC
ed99660 Display shop product images in admin UI 01 September 2024, 04:46:45 UTC
cf7215d Add basic backend for shop product images 01 September 2024, 04:43:55 UTC
be1534a Ensure email config exists for brand admin view tests 01 September 2024, 04:27:46 UTC
067742f Set default values for catalog models outside of database model 01 September 2024, 02:42:51 UTC
44a79e2 Set default values for order cancellation request of database model 01 September 2024, 02:42:51 UTC
9f92db5 Set default values for order action outside of database model, switch to UUID7 01 September 2024, 02:42:51 UTC
241a0b1 Set default values for attached product outside of database model 01 September 2024, 02:21:43 UTC
bf5c4e4 Set default values for product outside of database model 01 September 2024, 02:21:43 UTC
c41547c Set default values for product number sequence outside of database model, switch to UUID7 01 September 2024, 02:21:43 UTC
b6385e1 Set default values for order number sequence outside of database model, switch to UUID7 01 September 2024, 02:21:43 UTC
310cbd8 Use `with` statement to extract product from product compilation item 01 September 2024, 01:41:43 UTC
9535d30 Fix `find_user_by_screen_name` for case-sensitive queries 01 September 2024, 01:33:56 UTC
0fe2c07 Look up user by email MD5 hash, not avatar 01 September 2024, 00:45:39 UTC
fd14964 Return user avatar from `find_user_by_email_address`, `find_user_by_screen_name` 01 September 2024, 00:38:53 UTC
b67fcd9 Clarify names 01 September 2024, 00:30:30 UTC
2087d10 Add service function that returns all users 31 August 2024, 23:57:16 UTC
76a74b8 Add missing macro import 31 August 2024, 23:34:18 UTC
cfa7c93 Remove "false" from text This should reduce the risk of readers overlooking the actual required configuration file syntax that follows. 31 August 2024, 22:09:13 UTC
f30fd77 Docker Compose requires booleans to be strings now to avoid the classic YAML surprises 31 August 2024, 22:07:04 UTC
65144de Rename "paid products report" to "sold products" 31 August 2024, 21:22:21 UTC
b71c584 Sort admin blueprint registrations 31 August 2024, 21:13:55 UTC
002c5d5 Show fallback message if admin is not permitted to see any "more" items 31 August 2024, 21:07:01 UTC
5861108 Extract macro to render admin "more" items 31 August 2024, 21:03:36 UTC
6775b2d Select visible admin "more" items in code instead of in templates 31 August 2024, 20:52:37 UTC
e04b25a Define items for admin "more" views in code instead of in templates 31 August 2024, 20:51:59 UTC
60599b0 Translate more 31 August 2024, 19:49:28 UTC
086f300 Translate birthday messages 31 August 2024, 19:34:13 UTC
d34de37 Move fallback for empty list of birthdays into macro 31 August 2024, 18:53:36 UTC
f1bce12 Extract macro to render orga birthday list items in admin UI 31 August 2024, 18:52:38 UTC
a28d976 Unify orga birthday list styling in admin UI 31 August 2024, 17:42:31 UTC
a3eeb87 Move birthday icon out of sentence 31 August 2024, 17:31:28 UTC
198eed9 Set minimum list height to avoid overflow of background icon 31 August 2024, 17:24:45 UTC
579d357 Remove redundant `grid` wrapper 31 August 2024, 17:22:55 UTC
3d60e45 Tweak translations 31 August 2024, 14:19:43 UTC
fd554c2 Adjust response evaluation to httpx 28 August 2024, 23:25:38 UTC
96ce45f Return ticket bundle transfer object from `create_bundle` 28 August 2024, 23:18:45 UTC
28e0221 Do not delete tickets, ticket bundles, ticket categories on test teardown 28 August 2024, 22:58:32 UTC
3ab6560 Do not delete seating areas and seats on test teardown 28 August 2024, 22:45:55 UTC
150b174 Do not delete seating areas in tests 28 August 2024, 22:43:09 UTC
cc59a75 Return error if check-in event specifies no initiator 28 August 2024, 21:39:18 UTC
e2b0230 Generate ticket check-in ID outside of database model 28 August 2024, 21:27:59 UTC
e31af68 Generate ticket category ID outside of database model 28 August 2024, 21:27:27 UTC
1e48dc6 Pass `TicketCategory` object instead of party ID, ticket ID to `DbTicket` constructor 28 August 2024, 20:17:54 UTC
173ca99 Pass `TicketCategory` object instead of party ID, ticket ID to `build_tickets` 28 August 2024, 20:13:46 UTC
b097923 Pass `TicketCategory` object instead of party ID, ticket ID to `create_tickets` 28 August 2024, 20:09:59 UTC
eab924d Pass `TicketCategory` object instead of party ID, ticket ID to `create_ticket` 28 August 2024, 20:06:14 UTC
09531fe Pass `TicketCategory` object instead of party ID, ticket ID to `DbTicketBundle` constructor 28 August 2024, 19:48:50 UTC
9515607 Pass `TicketCategory` object instead of party ID, ticket ID to `create_bundle` 28 August 2024, 19:48:23 UTC
f7dfb57 Do not pass `DbTicketBundle` instance to `build_tickets`, just the ID 28 August 2024, 19:45:36 UTC
a157dcc Do not pass `DbTicketBundle` instance to `DbTicket` constructor, just the ID 28 August 2024, 19:44:54 UTC
d4c24f9 Generate ticket default values outside of database model 28 August 2024, 18:44:43 UTC
36b5ad0 Generate ticket bundle default values outside of database model 28 August 2024, 18:43:58 UTC
2afe9e1 Handle no party being set for site in site order view 28 August 2024, 00:10:48 UTC
5b28bcf Introduce party setting `order_cancellation_requesting_enabled` When set to `true`, user-initiated ticket order cancellations are allowed for the related party. When not set, this is interpreted as cancellation not enabled. SQL: INSERT INTO party_settings (party_id, name, value) VALUES ('<your party ID>', 'order_cancellation_requesting_enabled', 'true'); 28 August 2024, 00:02:49 UTC
e16cd94 Render optional snippet `ticketing_intro` above personal ticket index 27 August 2024, 23:12:21 UTC
bfa6f11 Remove misplaced product tag from order list 27 August 2024, 20:17:51 UTC
64f9e5a Pass report object further down Allows for easier customization with additional fields like flags. 27 August 2024, 20:17:36 UTC
3bb1a95 Do not pass unused argument 27 August 2024, 20:15:59 UTC
efac636 Fix paid products reports URL 27 August 2024, 19:26:54 UTC
b6136a4 Add paid products report generator 27 August 2024, 19:24:32 UTC
aafc0f7 Add light color for progress bars 27 August 2024, 16:56:26 UTC
de51bf0 Style tags at the beginning of level 2 headings in admin UI 27 August 2024, 16:56:08 UTC
551db6a Allow to mark articles as archived SQL: ALTER TABLE shop_products ADD COLUMN archived boolean; UPDATE shop_products SET archived = false; ALTER TABLE shop_products ALTER COLUMN archived SET NOT NULL; 27 August 2024, 00:12:59 UTC
e3c6dc7 Rename shop "article" to "product" Changes names in labels, URLs, filenames, the database, etc. Shop product permissions `create` and `update` have been merged into `administrate`. New role `shop_product_admin` replaces `shop_article_admin`. Make sure to assign the new role to all users that should have access to product administration. SQL: -- Drop constraints and indexes with old names. ALTER TABLE shop_article_number_sequences DROP CONSTRAINT shop_article_number_sequences_pkey; ALTER TABLE shop_article_number_sequences DROP CONSTRAINT shop_article_number_sequences_shop_id_fkey; ALTER TABLE shop_article_number_sequences DROP CONSTRAINT shop_article_number_sequences_prefix_key; DROP INDEX ix_shop_article_number_sequences_shop_id; ALTER TABLE shop_attached_articles DROP CONSTRAINT shop_attached_articles_pkey1; ALTER TABLE shop_attached_articles DROP CONSTRAINT shop_attached_articles_article_id_fkey; ALTER TABLE shop_attached_articles DROP CONSTRAINT shop_attached_articles_attached_to_article_id_fkey; ALTER TABLE shop_attached_articles DROP CONSTRAINT shop_attached_articles_article_id_attached_to_article_id_key; ALTER TABLE shop_attached_articles DROP CONSTRAINT shop_attached_articles_quantity_check; DROP INDEX ix_shop_attached_articles_article_id; DROP INDEX ix_shop_attached_articles_attached_to_article_id; ALTER TABLE shop_catalog_articles DROP CONSTRAINT shop_catalog_articles_pkey; ALTER TABLE shop_catalog_articles DROP CONSTRAINT shop_catalog_articles_article_id_fkey; ALTER TABLE shop_catalog_articles DROP CONSTRAINT shop_catalog_articles_collection_id_fkey; ALTER TABLE shop_catalog_articles DROP CONSTRAINT shop_catalog_articles_collection_id_article_id_key; DROP INDEX ix_shop_catalog_articles_article_id; DROP INDEX ix_shop_catalog_articles_collection_id; ALTER TABLE shop_order_actions DROP CONSTRAINT shop_order_actions_article_id_fkey; DROP INDEX ix_shop_order_actions_article_id; ALTER TABLE shop_order_line_items DROP CONSTRAINT shop_order_line_items_article_id_fkey; ALTER TABLE shop_order_line_items DROP CONSTRAINT shop_order_line_items_article_number_fkey; DROP INDEX ix_shop_order_line_items_article_id; DROP INDEX ix_shop_order_line_items_article_number; ALTER TABLE shop_articles DROP CONSTRAINT shop_articles_pkey; ALTER TABLE shop_articles DROP CONSTRAINT shop_articles_shop_id_fkey; ALTER TABLE shop_articles DROP CONSTRAINT shop_articles_item_number_key; ALTER TABLE shop_articles DROP CONSTRAINT shop_articles_shop_id_name_key; ALTER TABLE shop_articles DROP CONSTRAINT shop_articles_check; ALTER TABLE shop_articles DROP CONSTRAINT shop_articles_quantity_check; -- Rename tables and fields. ALTER TABLE shop_article_number_sequences RENAME TO shop_product_number_sequences; ALTER TABLE shop_articles RENAME TO shop_products; ALTER TABLE shop_attached_articles RENAME article_id TO product_id; ALTER TABLE shop_attached_articles RENAME attached_to_article_id TO attached_to_product_id; ALTER TABLE shop_attached_articles RENAME TO shop_attached_products; ALTER TABLE shop_catalog_articles RENAME article_id TO product_id; ALTER TABLE shop_catalog_articles RENAME TO shop_catalog_products; ALTER TABLE shop_order_actions RENAME article_id TO product_id; ALTER TABLE shop_order_line_items RENAME article_type TO product_type; ALTER TABLE shop_order_line_items RENAME article_id TO product_id; ALTER TABLE shop_order_line_items RENAME article_number TO product_number; -- Create constraints and indexes with new names. ALTER TABLE shop_product_number_sequences ADD CONSTRAINT shop_product_number_sequences_pkey PRIMARY KEY(id); ALTER TABLE shop_product_number_sequences ADD CONSTRAINT shop_product_number_sequences_shop_id_fkey FOREIGN KEY (shop_id) REFERENCES shops (id); ALTER TABLE shop_product_number_sequences ADD CONSTRAINT shop_product_number_sequences_prefix_key UNIQUE(prefix); CREATE INDEX ix_shop_product_number_sequences_shop_id ON shop_product_number_sequences (shop_id); ALTER TABLE shop_products ADD CONSTRAINT shop_products_pkey PRIMARY KEY(id); ALTER TABLE shop_products ADD CONSTRAINT shop_products_shop_id_fkey FOREIGN KEY (shop_id) REFERENCES shops (id); ALTER TABLE shop_products ADD CONSTRAINT shop_products_item_number_key UNIQUE(item_number); ALTER TABLE shop_products ADD CONSTRAINT shop_products_shop_id_name_key UNIQUE(shop_id, name); ALTER TABLE shop_products ADD CONSTRAINT shop_products_check CHECK (available_from < available_until); ALTER TABLE shop_products ADD CONSTRAINT shop_products_quantity_check CHECK (quantity >= 0); CREATE INDEX ix_shop_products_shop_id ON shop_products (shop_id); ALTER TABLE shop_attached_products ADD CONSTRAINT shop_attached_products_pkey PRIMARY KEY(id); ALTER TABLE shop_attached_products ADD CONSTRAINT shop_attached_products_attached_to_product_id_fkey FOREIGN KEY (attached_to_product_id) REFERENCES shop_products (id); ALTER TABLE shop_attached_products ADD CONSTRAINT shop_attached_products_product_id_fkey FOREIGN KEY (product_id) REFERENCES shop_products (id); ALTER TABLE shop_attached_products ADD CONSTRAINT shop_attached_products_product_id_attached_to_product_id_key UNIQUE(product_id, attached_to_product_id); ALTER TABLE shop_attached_products ADD CONSTRAINT shop_attached_products_quantity_check CHECK (quantity > 0); CREATE INDEX ix_shop_attached_products_attached_to_product_id ON shop_attached_products (attached_to_product_id); CREATE INDEX ix_shop_attached_products_product_id ON shop_attached_products (product_id); ALTER TABLE shop_catalog_products ADD CONSTRAINT shop_catalog_products_pkey PRIMARY KEY(id); ALTER TABLE shop_catalog_products ADD CONSTRAINT shop_catalog_products_collection_id_fkey FOREIGN KEY (collection_id) REFERENCES shop_catalog_collections (id); ALTER TABLE shop_catalog_products ADD CONSTRAINT shop_catalog_products_product_id_fkey FOREIGN KEY (product_id) REFERENCES shop_products (id); ALTER TABLE shop_catalog_products ADD CONSTRAINT shop_catalog_products_collection_id_product_id_key UNIQUE(collection_id, product_id); CREATE INDEX ix_shop_catalog_products_collection_id ON shop_catalog_products (collection_id); CREATE INDEX ix_shop_catalog_products_product_id ON shop_catalog_products (product_id); ALTER TABLE shop_order_actions ADD CONSTRAINT shop_order_actions_product_id_fkey FOREIGN KEY (product_id) REFERENCES shop_products (id); CREATE INDEX ix_shop_order_actions_product_id ON shop_order_actions (product_id); ALTER TABLE shop_order_line_items ADD CONSTRAINT shop_order_line_items_product_id_fkey FOREIGN KEY (product_id) REFERENCES shop_products (id); ALTER TABLE shop_order_line_items ADD CONSTRAINT shop_order_line_items_product_number_fkey FOREIGN KEY (product_number) REFERENCES shop_products (item_number); CREATE INDEX ix_shop_order_line_items_product_id ON shop_order_line_items (product_id); CREATE INDEX ix_shop_order_line_items_product_number ON shop_order_line_items (product_number); -- Update roles and permissions. INSERT INTO authz_roles VALUES ('shop_product_admin', 'Shop-Produkte verwalten'); INSERT INTO authz_role_permissions VALUES ('shop_product_admin', 'shop_product.administrate'); INSERT INTO authz_role_permissions VALUES ('shop_product_admin', 'shop_product.view'); DELETE FROM authz_role_permissions WHERE role_id = 'shop_article_admin'; -- After it is no longer assigned to anyone, delete the old role. DELETE FROM authz_roles WHERE id = 'shop_article_admin'; 26 August 2024, 23:58:24 UTC
662c3a7 Remove obsolete `get_avatar_url_for_user`, `get_avatar_urls_for_users` from user avatar service 25 August 2024, 01:03:40 UTC
0f14343 Fetch user objects for orga birthdays separately 25 August 2024, 00:59:36 UTC
8fabe0c Fetch user objects for attendee list separately 25 August 2024, 00:57:18 UTC
8145934 Rename variable 25 August 2024, 00:44:16 UTC
b0cdd4a Optimize number of SQL queries on attendees list 25 August 2024, 00:11:51 UTC
af5baa2 Fix sorting of attendee tickets when seats have no labels 24 August 2024, 23:32:17 UTC
f34209f Move user avatar path assembly out of database model 24 August 2024, 22:16:13 UTC
0f9d33f Clarify names of database objects 24 August 2024, 22:16:13 UTC
0b84646 Add `row.is-hcentered` 23 August 2024, 21:34:13 UTC
3dbd9fd Update Werkzeug to v3.0.4 (from v3.0.3) 23 August 2024, 15:09:58 UTC
2916e33 Update Sentry-SDK to v2.13.0 (from v2.12.0) 23 August 2024, 15:09:51 UTC
94edb26 Update schwifty to v2024.8.1 (from v2024.6.1) 23 August 2024, 15:09:20 UTC
327fbc9 Remove unused imports 23 August 2024, 14:34:53 UTC
54b1e00 Introduce user avatar events 23 August 2024, 14:33:23 UTC
back to top