Giter Club home page Giter Club logo

alfabankhackathon's Introduction

Hi there , my name is Artemii!

I am currently a beginner of Python developer

I'm passionate about programming and development, studying the backend on Python and write pet projects and practice my skills.

  • 💪 Skills: Python, Backend, HTML, SQL
  • 🛠 Tools: macOS, PyCharm, VS Code, Git, Postman
  • 📖 I’m currently learning: web development
  • 📫 How to reach me:
  • 🌍 Languages: Russian, English
  • 💻 I'm on Codewars: Codewars

python django docker flask html5 postgresql postman sqlite

alfabankhackathon's People

Contributors

conqerorior avatar inferno681 avatar thatcoderman avatar vladislavcr avatar

Watchers

 avatar

Forkers

vladislavcr

alfabankhackathon's Issues

Feature: logging

Describe the solution you'd like
Добавить logger для отслеживания работы программы.

Bug with task creating to unexisting pdp

Не понятно как ловить ошибку при создании задачи к несуществующему ИПР.

sqlalchemy.exc.IntegrityError: (sqlalchemy.dialects.postgresql.asyncpg.IntegrityError)
 <class 'asyncpg.exceptions.ForeignKeyViolationError'>: 
insert or update on table "task" violates foreign key constraint "task_pdp_id_fkey"
DETAIL:  Key (pdp_id)=(17) is not present in table "pdp".

Bug with endpoint employees

Describe the bug
Дублируются данные о сотруднике в консоли при выводе /employees

To Reproduce

  1. statup server
  2. login by CHIEF (with employees)
  3. get employees by GET api/v1/employees

Expected behavior

[
  {"id": 4, ...},
  {"id": 5, ...}
]

Real behavior

[
  {"id": 4, ...},
  {"id": 4, ...},
  {"id": 4, ...},
  {"id": 4, ...},
  {"id": 5, ...},
  {"id": 5, ...},
  {"id": 5, ...},
  {"id": 5, ...}
]

Additional context
Ошибка в CRUD users. Скорее всего ошибка с join

Task POST 500 Error

DETAIL: Ключ (pdp_id)=(1) отсутствует в таблице "pdp".
[SQL: INSERT INTO task (pdp_id, type_id, status_id, title, description, link, chief_comment, employee_comment, starting_date, deadline) VALUES ($1::INTEGER, $2::INTEGER, $3::INTEGER, $4::VARCHAR, $5::VARCHAR, $6::VARCHAR, $7::VARCHAR, $8::VARCHAR, $9::DATE, $10::DATE) RETURNING task.id]

При создании Task с несуществующим pdp_id выводится ошибка 500 Error: Internal Server Error

Token Lifetime

def get_jwt_strategy() -> JWTStrategy:
return JWTStrategy(secret=settings.secret, lifetime_seconds=3600)

Bug with getting PDPs without tasks

При получении PDP у которого нет Task - вылетает ошибка. Необходимо при получении объекта PDP, если его не существует, ставить статистику total=0, done=0.

Bug with copy Task to Template and Template to Task

При копировании данных из Task в Template в функции create_from_dict в файле app/crud/template.py или наоборот вылезает ошибка.

sqlalchemy.exc.IntegrityError: 
(sqlalchemy.dialects.postgresql.asyncpg.IntegrityError) <class 'asyncpg.exceptions.UniqueViolationError'>: 
duplicate key value violates unique constraint "template_pkey"

При таком создании, индексы начинают идти с 0 и только когда они превысят индекс уже существующего элемента в базе, то начнут создаваться. После этого метод отрабатывает корректно.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.