miniprojectDB

• Tomasz Ostafin
• Piotr Witek
• Jędrzej Ziebura

SQL Database for DB course on semester 4 year 2 at Computer Science UST

Technologies:

• Backend: Python
• Frontend: Pygame
• Database dialect: PostgreSQL

DB schema

Database guidebook

Authentication

• API authentication ➡️ here
• Storing user login info ➡️ Table logs line 334 here
• Storing blocked users ➡️ Table blocked_users line 359 here
• Names of procedures & functions & triggers
  • trigger_block_user
  • add_log

Market

• All procedures code ➡️ here
• API Market handling ➡️ here
• API market tests ➡️ here

Auctions

• Names of procedures & functions & triggers
  • place_bet
  • resolve_auction
  • add_new_item_on_sale
  • add_finalizing_auction

Auctions market tests ➡️ here

Buy now

• Names of procedures & functions & triggers
  • add_new_item_on_sale
  • buy_now

Buy orders

• Names of procedures & functions & triggers

  • create_new_buy_now_order
  • check_buy_orders

  Buy now market tests ➡️ here

Filtering

• Names of procedures & functions & triggers
  • filter_items

Filtering tests ➡️ here

Auxiliary functions

• Names of procedures & functions & triggers
  • add_new_cron_job

NPC shops

• Names of procedures & functions & triggers
  • sell_item_from_armour_shop
  • sell_item_from_magic_shop
  • sell_item_from_steed_shop
  • sell_item_from_weapon_shop
  • trigger_refresh_all_shops
  • remove_from_storage
  • add_to_storage
  • refresh_all_shops_for_hero

NPC Armour shop tests ➡️ here