#Data source properties
spring.datasource.url = jdbc:postgresql://localhost:5432/Invoices
spring.datasource.username = admin
spring.datasource.password = admin

# Hibernate properties
spring.jpa.show-sql = true
#spring.jpa.hibernate.ddl-auto = none
spring.jpa.hibernate.naming.implicit-strategy = org.hibernate.boot.model.naming.ImplicitNamingStrategyJpaCompliantImpl
spring.jpa.properties.hibernate.format_sql=true
spring.datasource.platform=postgresql
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true


## queries
spring.queries.users-query=select email, password, active from users where email=?
spring.queries.roles-query=select u.email, r.role_name from users u inner join user_role ur on(u.user_id=ur.user_id) inner join roles r on(ur.role_id=r.id) where u.email=?