moacirmoda

# http://dojopuzzles.com/problemas/exibe/geracao-de-fatores-primos/

i = 10000

primos = []
for y in range(1, i+1):
    is_primo = True
    for x in range(y, i+1):
        if y % x == 0 and x > 1 and x != y:
            is_primo = False

moacirmoda

CREATE USER username WITH PASSWORD 'password';
ALTER USER username CREATEDB;
CREATE DATABASE database_name;
GRANT ALL PRIVILEGES ON DATABASE database_name to username;

moacirmoda

version: "3"

services:
  database:
    image: postgres:9.6.0
    restart: always
    volumes:
      - ./pgdata:/var/lib/postgresql/data
    environment:
      - LC_ALL=C.UTF-8

moacirmoda

class Business_Cards(models.Model):
    ownerName = models.CharField(max_chars=20)
    quantity = models.PositiveIntegerField()

moacirmoda

class BusinessCard(models.Model):
    owner_name = models.CharField(max_chars=20)
    quantity = models.PositiveIntegerField()

moacirmoda

class Reporter(models.Model):
    # ...
    pass

class Article(models.Model):
    reporter = models.ForeignKey(Reporter, on_delete=models.CASCADE)

moacirmoda

class Reporter(models.Model):
    # ...
    pass

class Article(models.Model):
    reporter = models.ForeignKey(Reporter, on_delete=models.CASCADE, related_name='articles')

moacirmoda

>>> reporter = Reporter.objects.first()
>>> reporter.articles.all()

>>> reporter.articles == reporter.article_set

moacirmoda

>>> Article.objects.filter(reporter__name='Moacir')

moacirmoda

class Reporter(models.Model):
    # ...
    pass

  
class Article(models.Model):
    reporter = models.ForeignKey(Reporter, on_delete=models.CASCADE, related_query_name='author')
    
    
>>> Article.objects.filter(author__name='Moacir')