What data types are available in Python?
Python
What are ACID requirements? Briefly comment on each property.
What is the difference between CMD and ENTRYPOINT in Dockerfile?
How have you used dunder methods in your work and for which implementations have they been useful?
What are the advantages of ORM compared to raw SQL?
What is data normalization and what is it used for?
How can GIL limitations be bypassed and subsequent requests not blocked when executing one?
What is a lambda function, why is it convenient, and where is it used?
What are the normal forms and what do they solve?
What is the difference between WHERE and HAVING operators?
What is GIL, what are its advantages, disadvantages, and the inconveniences it creates?
How to prevent shared resource usage by threads so that resources are isolated for each instance?
What mechanism in the database prevents duplicate creation during concurrent requests with the same idempotency key?
What are the differences between PostgreSQL, MongoDB, and ClickHouse, and when should each be chosen?
What happens if two requests with the same idempotency key arrive simultaneously from different threads or processes?
How was your CI pipeline structured: what stages and jobs did it consist of?
class PayoutService: def __init__(self): # ... pass def create_payout(self, idempotency_key: str, terminal_id: int, amount: float) -> dict: """ Should return a dictionary of the form: {"payout_id": <int>, "terminal_id": <int>, "amount": <float>, "status": "success"} Guarantees: - on first call with a new idempotency_key — a new payout is created - on subsequent calls with an already used idempotency_key — the result of the first call is returned, a new payout is NOT created - amount must be > 0, otherwise — raise ValueError """ raise NotImplementedError
In which cases would you consciously refuse ORM in favor of raw SQL queries?
How are microservices divided by responsibility and according to what rule?
What is a generator, how does it work, what is its optimality, and how to distinguish it in code?