Have you worked with ORM and raw SQL queries? Which approach do you prefer?
Middle
108
Python
11010
584
It is necessary to validate the structure ONLY for the correctness of opening and closing brackets. test_data = [ "[][[]]", # valid "[[[]]]", # valid "[][][]", # valid "]]][[", # invalid "[[[]", # invalid "[]]", # invalid "[[]]", # invalid "][]]", # invalid "[]][[]", # invalid "[][[]", # invalid ] def is_valid(value: str):
Senior
107
Why is the context manager 'with' used when working with files? Where else is it applied?
Middle
102
What is unit testing and why are mock objects needed?
Middle
96
Can you handle writing a raw SQL query?
Senior
89
Provide the number of users registered in the last 30 days and sort the result by registration date.
Senior
82
Have you ever written tests?
Senior
80
Show the top 5 users by the number of transactions they have made.
Senior
79
How to ensure separate display of the fee in the transaction history while maintaining the correctness and atomicity of the transfer?
Senior
70
Implement pseudocode for fee collection in the existing method `User.transfer`: what entries and checks are necessary?
Senior
70
Have you ever interacted with databases through ORM and written raw SQL queries?
Senior
69
After launching the fee, the money is deducted from users, but the manager does not see the company's income. Where could the money be and how to diagnose it?
Senior
68
Who should pay the fee when transferring and how should it be reflected in the operation?
Senior
68
The table contains 100–500 million records and working with it has become slow. What can be done to optimize?
Senior
67
How to organize fee collection when transferring money between users: what questions to ask the business and what technical solutions to suggest?
Senior
63
Briefly tell what fixtures in pytest are and how they differ from each other.
Senior
61
How to change the data model to unambiguously combine four transactions of one transfer and then perform a refund with one action?
Senior
53
Have you ever worked with Docker or Kubernetes?
Senior
53
How do you navigate and work in Unix systems: how to connect and perform basic diagnostics?
Senior
45