Advise on orm modelling in django

See also questions close to this topic

• Upload file from html when block public access is true

  I am using django-s3direct to file upload

  https://github.com/bradleyg/django-s3direct

  Using IAM role setting because I upload the file from the server on ECS container.

  Now I set the blockPublicAccess of S3 false.

  When uploading images from html, there comes error.

  https://s3.ap-northeast-1.amazonaws.com/static-resource-v/images/c64d6e593de44aa5b10dcf1766582547/_origin.jpg?uploads (403 (Forbidden)
  )
  
  initiate error: static-resource-v/line-assets/images/c64d6e593de44aa5b10dcf1766582547/_origin.jpg AWS Code: AccessDenied, Message:Access Deniedstatus:403
  

  OK, it is understandable.

  Browser try to access the for initiation.

  However there is any way to upload file from browser when blockPublicAccess is true??
• Test a decorated function in Python

  I have a python function which is decorated.

      @retry_if_access_token_expired(app_id)
      def add_something(
          self,
          *,
          argument1,
          argument1 = None,
      ):
  
            """adding something"""
  

  I've written tests for the given as below.

      @patch("other inside function to mock")
      @patch("other insdie function to mock 2")
      def test_add_something(
          self, mock_1, mock_2
      ):
          """ some logic to test the add something method """
  

  But I am getting this error that says add_somehthing takes 1 positional argument.

  TypeError: add_something() takes 1 positional argument but 3 were given
• how to pass null value to just one specific key of the one object using same DRF serializer

  I'm just passing the same object 2 times in the same serializer but I want to pass key: "retweet": null in one object and in another object I want to pass some values like some many-to-many field values because key "retweet" is many-to-many field and having data

  Thanks in advance!
• How to create a full text index with PHP attributes and Symfony 6?

  I need to create a search input inside my symfony 6.0 project. I'm using PHP 8.1.5

  In the old days i used the following syntax with annotations :

  /**
   * @ORM\Table(name="category", indexes={@ORM\Index(columns={"name", "description"}, flags={"fulltext"})})
   */
  class Category
  {
  

  But right now i'm not able to find the good way to do it using attributes. I tried the following :

  #[ORM\Index(name: 'category_idx', columns: ['name', 'description'])] 
  

  but the migration didn't create a full text index.

  Could you please tell me how you did it if you already had this situation ?
• joinColumns in Hibernate for standard relations?

  In the following example, there are 3 entities which have relations e.g. @ManyToMany, @OneToMany and @ManyToOne:

  Student:

  @Entity
  @Data
  public class Student {
  
      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      Long id;
  
      private String name;
  
  
      @JsonIgnore
      @ManyToMany(mappedBy = "students")
      private Set<Subject> subjects = new HashSet<>();
  }
  

  Subject:

  @Entity
  @Data
  public class Subject {
  
      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      Long id;
  
      private String name;
  
  
      @ManyToMany
      @JoinTable(
              name = "subject_student",
              joinColumns = @JoinColumn(name = "subject_id"),
              inverseJoinColumns = @JoinColumn(name = "student_id")
      )
      Set<Student> students = new HashSet<>();
  
      @ManyToOne(cascade = CascadeType.ALL)
      @JoinColumn(name = "teacher_id", referencedColumnName = "id")
      private Teacher teacher;
  }
  

  Teacher:

  @Entity
  @Data
  public class Teacher {
  
      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      private Long id;
  
      private String name;
  
  
      @JsonIgnore
      @OneToMany(mappedBy = "teacher")
      private Set<Subject> subjects;
  }
  

  1. In the subject entity, I tried to remove @JoinColumn and the related entities are connected as the example above:

  @ManyToMany
  @JoinTable(name="subject_student")
  public Set<Student> students = new HashSet<>();
  
  @ManyToOne(cascade = CascadeType.ALL)
  private Teacher teacher;
  

  So, if we want to use subject_id - student_id pair in subject_student table and use teacher_id in subject table as it is created in the example, can I use my simplified notation by removing @JoinColumn? Because, if there is not a special case, I think it is redundant to verbose notation of relations.

  2. When I use the second approach, the columns are created as plural e.g. subjects_id - students_id in subject_student. So, can I prevent this and create them as in the previous example by using my approach?
• How To Access A Column In M-M Relationship Table In Laravel

  I made a many-to-many relationship in laravel, where users can make announcements on an event.

  The problem is that I want to retrieve the announcement message from the database using the relationship.

  Here is my code:

  Database Migration:

     Schema::create('announcements', function (Blueprint $table) {
          $table->id();
          $table->text("message");
          $table->foreignId('user_id')->constrained()->cascadeOnDelete()->cascadeOnUpdate();
          $table->foreignId('event_id')->constrained()->cascadeOnDelete()->cascadeOnUpdate();
          $table->timestamps();
      });
  

  Event Model:

  public function announcements() {
      return $this->belongsToMany(User::class, 'announcements');
  }
  

  User Model:

  public function announcements() {
      return $this->belongsToMany(Event::class, 'announcements');
  }
  

  Events Controller:

   public function getEventAnnouncements($id) {
      $event = Event::find($id);
  
  
      $ann = [];
      $event->announcements->each(function ($a) use ($ann) {
          // echo $a;
          // $ann += $a->message;
      });
  
      return $ann;
  }
  

  What Should I Write In The Controller To Get The Content Of messages Column ?