Advertisement
Guest User

Untitled

a guest
Nov 7th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. def sql = new Sql(connection);
  2.  
  3. String newUid; //Create must return UID.
  4.  
  5. def keys = sql.executeInsert("INSERT INTO D_UTENTI(SEQU_LONG_ID, CODI_USER_ID, INDI_EMAIL, DESC_PASSWORD_CORR, PERS_COGNOME, PERS_NOME, PERS_CODICEFISCALE,FLAG_ABILITAZIONE_01,DTTM_CREAZIONE,LK_UTENTI_CREAZIONE,FLAG_SUPERUSER_01, FLAG_PASSWD_NO_EXPIRE_01, FLAG_EXPORT_LDAP, FK_LIVELLO_RISERVATEZZA, FLAG_ PASSW_CRYPT_01) VALUES (S_D_UTENTI.NEXTVAL, ?, ?, 'Password.1', ?, ?, ?, 1, SYSDATE, 2, 0, 0, 0, 5, 0)",
  6. [
  7. attributes?.get("CODI_USER_ID")?.get(0),
  8. attributes?.get("INDI_EMAIL")?.get(0),
  9. attributes?.get("PERS_COGNOME")?.get(0),
  10. attributes?.get("PERS_NOME")?.get(0),
  11. attributes?.get("PERS_CODICEFISCALE")?.get(0)
  12. ])
  13. def firstRow = sql.rows("SELECT SEQU_LONG_ID FROM D_UTENTI WHERE CODI_USER_ID = '"+attributes?.get("CODI_USER_ID")?.get(0)+"'");
  14.  
  15. newUid = firstRow[0][0];
  16.  
  17. return newUid;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement