Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Active Record pattern #79

Open
iluwatar opened this issue Jun 23, 2015 · 17 comments · May be fixed by #3087
Open

Active Record pattern #79

iluwatar opened this issue Jun 23, 2015 · 17 comments · May be fixed by #3087
Assignees
@ipaulaandreea
Labels
epic: pattern type: feature

Comments

@iluwatar
Copy link
Owner

iluwatar commented Jun 23, 2015 •
edited
Loading

Description

The Active Record design pattern is a common architectural pattern used to manage database records. It simplifies data access by encapsulating the database logic within a model class. Each instance of the model corresponds to a row in the database, and the model class includes methods for CRUD (Create, Read, Update, Delete) operations.

Main Elements of Active Record Pattern:

  1. Model Class: Represents a table in the database. Each instance represents a single row.
  2. CRUD Operations: Methods for Create, Read, Update, and Delete operations are defined within the model.
  3. Database Connection: The model class manages the database connection.
  4. Simple Queries: Basic querying capabilities are encapsulated within the model.

References

Acceptance Criteria

  1. A new model class should be created, representing a database table.
  2. The model class should include methods for basic CRUD operations.
  3. The implementation should adhere to the project’s contribution guidelines and include relevant documentation and unit tests.
@stephen-lazarionok
Copy link

I may help with implementing this pattern. Please let me know if it's oaky with you.

@iluwatar
Copy link
Owner Author

Sure, go ahead, your contribution is welcome!

@stephen-lazarionok
Copy link

Okay, I will work on this pattern

@stephen-lazarionok
Copy link

Pull request #206 is prepared. Please review.

@npathai npathai mentioned this issue Aug 16, 2015
Closed
@stephen-lazarionok
Copy link

I've fixed the points raised and left my comments

@iluwatar iluwatar mentioned this issue Aug 22, 2015
Closed
@iluwatar
Copy link
Owner Author

jOOQ uses Active Record pattern: http://www.jooq.org/

@iluwatar
Copy link
Owner Author

iluwatar commented Jul 7, 2020

Described in book "Patterns of Enterprise Application Architecture" by Fowler

@iluwatar
Copy link
Owner Author

https://www.vertabelo.com/blog/orms-under-the-hood/

@TwentyVentti
Copy link

TwentyVentti commented Oct 12, 2022 •
edited
Loading

@iluwatar I can help work on this pattern let me know if that’s okay with you.

@iluwatar
Copy link
Owner Author

Nice, please go ahead @TwentyVentti

@iluwatar iluwatar moved this to In Progress in Java Design Patterns project Oct 29, 2022
This was referenced Oct 30, 2022
Closed
Merged
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 1, 2024
@sergejsvisockis
add TODO (iluwatar#79)
3d8fec0
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 1, 2024
@sergejsvisockis
fix type (iluwatar#79)
99bd30c
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 1, 2024
@sergejsvisockis
add plantUML diagram (iluwatar#79)
f308c15
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
provide an initial module and stubs (iluwatar#79)
fedbb99
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
format the code as per the google checkstyle (iluwatar#79)
8940396
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
provide an initial implementation - not tested (iluwatar#79)
33aecdc
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
update README.md (iluwatar#79)
f4e2520
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
update an exception message (iluwatar#79)
584a8ca
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
add javadoc (iluwatar#79)
aaf203c
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
update README.md (iluwatar#79)
6cfbf80
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
draft more comprehensive explanation (iluwatar#79)
a8cdba2
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
no comment (iluwatar#79)
fe908cc
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
extend the logic of the RecordBase + manual test (iluwatar#79)
29ed0f9
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
fix all the checkstyle violations (iluwatar#79)
99d5a5a
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
work on exceptions (iluwatar#79)
ad80931
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
make order an active record class as well + javadoc (iluwatar#79)
1b8217c
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
fix POM (iluwatar#79)
53304a5
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
polish + exception (iluwatar#79)
49c3f63
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
implement a simple save method (iluwatar#79)
670c1b7
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
developers -> engineers (iluwatar#79)
df5dfa9
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
add TODO (iluwatar#79)
1a8d330
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
fix type (iluwatar#79)
318d34e
sergejsvisockis added a commit to sergejsvisockis/java-design-patterns that referenced this issue Apr 15, 2024
@sergejsvisockis
add plantUML diagram (iluwatar#79)
c314241
@iluwatar
Copy link
Owner Author

Updated task description

@ipaulaandreea
Copy link

@iluwatar Can you assign me with this task, please?

@iluwatar iluwatar moved this from Todo to In Progress in Java Design Patterns project Oct 13, 2024
ipaulaandreea added a commit to ipaulaandreea/java-design-patterns that referenced this issue Nov 5, 2024
@ipaulaandreea
finished task iluwatar#79
26a31de
@ipaulaandreea ipaulaandreea linked a pull request Nov 5, 2024 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ipaulaandreea ipaulaandreea

Labels
epic: pattern type: feature
Projects
Java Design Patterns project
Status: In Progress
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Active Record Pattern #79 ipaulaandreea/java-design-patterns
6 participants
@iluwatar @npathai @sergejsvisockis @stephen-lazarionok @TwentyVentti @ipaulaandreea