Skip to content

Instantly share code, notes, and snippets.

@POMXARK

POMXARK/sql запросы валидации

Created August 13, 2024 21:44
Show Gist options
  • Save POMXARK/278fe389fc91cd757ce2b74f730221ba to your computer and use it in GitHub Desktop.
Save POMXARK/278fe389fc91cd757ce2b74f730221ba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql запросы валидации
Если страна отеля (равно | не равно) countries.id
SELECT *
FROM countries
JOIN cities ON countries.id = cities.country_id
JOIN hotels ON cities.id = hotels.city_id
WHERE countries.id = 1 AND hotels.id = 1
Если город отеля (равно | не равно) cities.id
SELECT *
FROM cities
JOIN hotels ON cities.id = hotels.city_id
WHERE cities.id = 1 AND hotels.id = 1
Если звездность отеля (равно | не равно) hotels.stars
SELECT *
FROM hotels
WHERE hotels.stars = 5 AND hotels.id = 1
Если в договоре комиссия или скидка hotel_agreements.discount_percent
или hotel_agreements.comission_percent (равно | не равно | больше | меньше) integer
SELECT *
FROM hotel_agreements
WHERE discount_percent > 1 AND comission_percent = 0 AND hotel_id = 1
Если договор по умолчанию hotel_agreements.is_default (равно) boolean
SELECT *
FROM hotel_agreements
WHERE is_default = 1 AND hotel_id = 1
Если черный список agency_hotel_options.is_black (равно) boolean
SELECT *
FROM agency_hotel_options
WHERE is_black = 0 AND hotel_id = 1
Если рекомендованный отель agency_hotel_options.is_recomend (равно) boolean
SELECT *
FROM agency_hotel_options
WHERE is_recomend = 0 AND hotel_id = 1
Если белый список agency_hotel_options.is_white (равно) boolean
SELECT *
FROM agency_hotel_options
WHERE is_white = 0 AND hotel_id = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment