Training: Day Three - Persistence

This is the third in our four part training sessions introducing FenixEdu development for new collaborators.

In this third session, we introduce our persistence technology and database engine as well how to commit database changes to version control.

Transcript

1. Persistence SQL, Domain & Fenix Framework
2. How to change your grades SQL, Domain & Fenix Framework
3. MySQL Application Container (Tomcat, Jetty) Fenix Framework (STM) Domain Model JSP renderers Struts Faces Jersey (REST API)
4. Fenix Framework • Software Transactional Machine • Developed in part by our Team • Available at: ◦ https://github.com/fenix-framework/fenix-framework
5. Fenix Framework class PendingRequest { DateTime generationDate; String url; Boolean post; String buildVersion; } relation PendingRequestRootDomainObject { RootDomainObject playsRole rootDomainObject; PendingRequest playsRole pendingRequest { multiplicity *; } } DML
6. Fenix Framework DML valueType java.math.BigDecimal as BigDecimal { externalizeWith { String toString(); } } enum net.sourceforge.fenixedu.util.WeekDay as WeekDay;
7. Fenix Framework Entity DomainObject RootDomain Object 1 * DML
8. Fenix Framework class Degree extends AcademicProgram { Double ectsCredits; String nome (REQUIRED); } DML
9. Fenix Framework @ConsistencyPredicate private boolean checkRequiredSlots() { ConsistencyChecks.checkRequired(this, "nome", getNome()); return true; } DML
10. Fenix Framework Transactions • Use @Atomic • Can be READ, WRITE, SPECULATIVE_READ • DO NOT USE IN ACTIONS!
11. Fenix Framework • /src/main/dml/domain_model.dml • 1370 Entities, 1802 Relations, 54 Value Types & 200 Enums DML
13. Fenix Framework Fenix Domain Browser • Available at: ◦ https://fenix-ashes.ist.utl.pt/fdb/ • Source code at: ◦ https://github.com/nurv/Fenix-Domain-Browser • Demo:
14. Fenix Framework Changes • Edit domain_model.dml. • Run mvn clean test -PSQLUpdateGenerator • Edit /etc/database_operations/updates.sql • Rename updates.sql • Edit /etc/database_operations/run • Run /etc/database_operations/run
15. ⚠ BE CAREFUL!
16. Fenix Framework Dumps • Goto: ◦ https://fenix-ashes.ist.utl.pt/jenkins/ • Demo
17. MySQL • You are going to run the database in a remote server. • How to connect: ◦ ssh -A -fNg -L <localport>:localhost:3306 mysqluser@fenix64bit.ist.utl.pt ◦ mysql -h localhost -u<istid> --protocol=TCP -P <localport> -p<dbpass> <istid>_fenix -A
18. MySQL • Edit fenix-framework.properties: ◦ dbAlias=//localhost:<localport>/<istid>_fenix? useUnicode=true&characterEncoding=utf8&clobCha racterEncoding=utf8&zeroDateTimeBehavior=conve rtToNull ◦ dbUsername=<istid> ◦ dbPassword=<dbpass>
19. So, how do you change your marks?