Skip to content

PostgreSQL: Fix database error #236

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

Merged
ebrahimmfadae merged 2 commits into from
Apr 26, 2022
Merged

PostgreSQL: Fix database error #236

Show file tree
Hide file tree
Changes from all commits
Commits
Show all changes
2 commits
Select commit Hold shift + click to select a range
525db56
PostgreSQL: Fix database error
ebrahimmfadae Apr 26, 2022
b62b873
Changed user attributes
Marchosiax Apr 26, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
5 changes: 3 additions & 2 deletions resources/postgres/init-backup-user.sh
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -6,6 +6,7 @@ psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-E
GRANT CONNECT ON DATABASE $POSTGRES_DB TO $POSTGRES_BACKUP_USER;
GRANT USAGE ON SCHEMA public TO $POSTGRES_BACKUP_USER;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO $POSTGRES_BACKUP_USER
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO $POSTGRES_BACKUP_USER;
GRANT SELECT ON TABLES TO $POSTGRES_BACKUP_USER;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON SEQUENCES TO $POSTGRES_BACKUP_USER;
EOSQL
28 changes: 14 additions & 14 deletions ...ement/keycloak-gateway/src/main/kotlin/co/nilin/opex/auth/gateway/data/UserProfileInfo.kt
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -4,13 +4,13 @@ class UserProfileInfo {

var firstNameEn: String? = null
var lastNameEn: String? = null
var firstNameFa: String? = null
var lastNameFa: String? = null
var birthday: String? = null
var birthdayAlt: String? = null
var nationalID: String? = null
var passport: String? = null
var phoneNumber: String? = null
var firstName: String? = null
var lastName: String? = null
var birthdayJ: String? = null
var birthdayG: String? = null
var nationalId: String? = null
var passportNumber: String? = null
var mobile: String? = null
var telephone: String? = null
var postalCode: String? = null
var residence: String? = null
Expand All @@ -35,13 +35,13 @@ class UserProfileInfo {
) {
this.firstNameEn = firstNameEn
this.lastNameEn = lastNameEn
this.firstNameFa = firstNameFa
this.lastNameFa = lastNameFa
this.birthday = birthday
this.birthdayAlt = birthdayJalali
this.nationalID = nationalID
this.passport = passport
this.phoneNumber = phoneNumber
this.firstName = firstNameFa
this.lastName = lastNameFa
this.birthdayJ = birthday
this.birthdayG = birthdayJalali
this.nationalId = nationalID
this.passportNumber = passport
this.mobile = phoneNumber
this.telephone = homeNumber
this.postalCode = postalCode
this.residence = address
Expand Down
15 changes: 7 additions & 8 deletions ...cloak-gateway/src/main/kotlin/co/nilin/opex/auth/gateway/extension/UserProfileResource.kt
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -5,7 +5,6 @@ import co.nilin.opex.auth.gateway.data.UserProfileInfo
import co.nilin.opex.auth.gateway.utils.ErrorHandler
import co.nilin.opex.auth.gateway.utils.ResourceAuthenticator
import co.nilin.opex.utility.error.data.OpexError
import co.nilin.opex.utility.error.data.OpexException
import org.jboss.resteasy.plugins.providers.multipart.InputPart
import org.keycloak.models.KeycloakSession
import org.keycloak.models.UserModel
Expand Down Expand Up @@ -53,13 +52,13 @@ class UserProfileResource(private val session: KeycloakSession) : RealmResourceP
with(request) {
firstNameEn?.let { user.setSingleAttribute("firstNameEn", it) }
lastNameEn?.let { user.setSingleAttribute("lastNameEn", it) }
firstNameFa?.let { user.setSingleAttribute("firstNameFa", it) }
lastNameFa?.let { user.setSingleAttribute("lastNameFa", it) }
birthday?.let { user.setSingleAttribute("birthday", it) }
birthdayAlt?.let { user.setSingleAttribute("birthdayAlt", it) }
nationalID?.let { user.setSingleAttribute("nationalID", it) }
passport?.let { user.setSingleAttribute("passport", it) }
phoneNumber?.let { user.setSingleAttribute("phoneNumber", it) }
firstName?.let { user.setSingleAttribute("firstName", it) }
lastName?.let { user.setSingleAttribute("lastName", it) }
birthdayJ?.let { user.setSingleAttribute("birthdayJ", it) }
birthdayG?.let { user.setSingleAttribute("birthdayG", it) }
nationalId?.let { user.setSingleAttribute("nationalId", it) }
passportNumber?.let { user.setSingleAttribute("passportNumber", it) }
mobile?.let { user.setSingleAttribute("mobile", it) }
telephone?.let { user.setSingleAttribute("telephone", it) }
postalCode?.let { user.setSingleAttribute("postalCode", it) }
residence?.let { user.setSingleAttribute("residence", it) }
Expand Down