• Implement Method findByID:

Feature description::

Add documentation method find_by_id

Implementation:

Update file /docs/model/methods.md

The options available for these parameters:

• SET NULL
• SET DEFAULT
• RESTRICT
• NO ACTION
• CASCADE

The default value is: NO ACTION

Reference Postgres: https://www.postgresqltutorial.com/postgresql-foreign-key/
Reference SQLite: https://www.sqlitetutorial.net/sqlite-foreign-key/

Add field:

• Timestamp

Support for postgresql and sqlite.

In Postgresql: https://www.postgresql.org/docs/9.1/datatype-datetime.html
On sqlite: https://www.sqlite.org/datatype3.html

When at the python level the user should be able to access all the methods of the datetime.datetime class in Python.

Feature description::

Currently to save a record in a table:

person_1 = Person(first_name="Teste 1", last_name="teste lastname", age=19, salary=5000)

person_1 = await Person.save(person_1)

This issue wants to add a new way to save, making it easier for the user:

person_1 = Person(first_name="Teste 1", last_name="teste lastname", age=19, salary=5000)

await person_1.save()

Need:

Make it easier for the user to save a new record.

Feature description::

Code coverage is currently only 87%, but with several files well below that coverage. The idea is to leave the overall coverage above 90% and also for each file.

Need:

This way we will have much better confidence about any future changes that are made to the code. Facilitating its evolution.

Implementation:

Continue test implementation as is.

Feature description::

Support the migrations.

Still under development.

Need:

Useful for applications already in production

Implementation:

Still under development.

Feature description::

Add documentation of field Timestamp.

Implementation:

Update file /docs/fields/index.md

Get started with ORM documentation:

• See ORMs documentation
• Decide what to do, and how to do it

#4

The options available for these parameters:

• SET NULL
• SET DEFAULT
• RESTRICT
• NO ACTION
• CASCADE

The default value is: NO ACTION

Reference Postgres: https://www.postgresqltutorial.com/postgresql-foreign-key/
Reference SQLite: https://www.sqlitetutorial.net/sqlite-foreign-key/

• Study a way to add limit in the find_all method.
• See how other ORMs work

Feature description::

Create a models manager, this manager will have all the models and it will be here that it will contain several ready-made functions. As the create_tables method that will create tables regardless of having to create one table before another, it will do this automatically. It will also make it easier to create future features.

Need:

from databases import Database
from duck_orm.sql import fields as Field
from duck_orm.model import Model, ManagerModel

db = Database('sqlite:///example.db')
manager = ManagerModel()
await db.connect()

class City(Model):
    __tablename__ = 'cities'
    __db__ = db
    manager = manager

    id: int = Field.Integer(primary_key=True, auto_increment=True)
    name: str = Field.String(unique=True)

    def relationships(self):
        self.persons = OneToMany(
            model=Person,
            name_in_table_fk='city',
            name_relation='person_city'
        )


class Person(Model):
    __tablename__ = 'persons'
    __db__ = db
    manager = manager

    id: int = Field.Integer(primary_key=True, auto_increment=True)
    first_name: str = Field.String(unique=True)
    last_name: str = Field.String(not_null=True)
    age: int = Field.BigInteger()
    salary: int = Field.BigInteger()
    city: City = ForeignKey(model=City, name_in_table_fk='id')

# He will know that he must create the `City` table first.
await manager.create_tables()

Feature description::

As is the title.

Implementation:

The same was done in the ForeignKey field.

Bug description:

Correction in the automatic deployment of documentation. Put to deploy only when merged into the docs branch

With this, when new features are added along with its documentation, the site will not be deployed before deploying the library in pypi

Expected behavior:

Deploy from the documentation site after being merged into the docs branch

Add the name_constraints parameter to the ForeignKey field

Type Fields:

• OneToOne
• OneToMany
• ManyToMany

Development branch: Branch

Parameter improvement: name_in_table_fk.

Currently, this parameter serves to link with the primary key of another model.

Exemplo:

class User(Model):
    __tablename__ = 'users'
    __db__ = db

    id: int = Field.Integer(primary_key=True, auto_increment=True)
    name: str = Field.String()

    @classmethod
    def relationships(cls):
        cls.working_day = ManyToMany(model=WorkingDay,
                                        model_relation=UsersWorkingDay)

class WorkingDay(Model):
    __tablename__ = 'working_days'
    __db__ = db

    id: int = Field.Integer(primary_key=True, auto_increment=True)
    week_day: str = Field.String()
    working_date: str = Field.String()

    @classmethod
    def relationships(cls):
        cls.users = ManyToMany(model=User, model_relation=UsersWorkingDay)

class UsersWorkingDay(Model):
    __tablename__ = 'users_working_day'
    __db__ = db

    id: int = Field.Integer(primary_key=True, auto_increment=True)
    users: User = ForeignKey(
        model=User, name_in_table_fk='id')
    working_days: WorkingDay = ForeignKey(
        model=WorkingDay, name_in_table_fk='id')

We want it to become:

class UsersWorkingDay(Model):
    __tablename__ = 'users_working_day'
    __db__ = db

    id: int = Field.Integer(primary_key=True, auto_increment=True)
    users: User = ForeignKey(
        model=User, name_in_table_fk=User.id)
    working_days: WorkingDay = ForeignKey(
        model=WorkingDay, name_in_table_fk=WorkingDay.id)

So it is supporting the typing of the model.

• Change in code.
• Change in documentation.
• Change in tests

Feature description::

Add logs throughout lib, especially queries run by ORM.

Need:

To help debug the lib and even to make it easier for users who are going to use the ORM.

Implementation:

https://docs.python.org/pt-br/3/howto/logging.html