Mercurial > dive4elements > framework
diff artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 413:f5ecca16f601
Implement method to find/get a user by its account name
artifacts/trunk@5260 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Fri, 24 Aug 2012 14:04:38 +0000 |
| parents | 08731e7403b5 |
| children | 4213dd6ca169 |
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties Thu Aug 23 14:03:16 2012 +0000 +++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties Fri Aug 24 14:04:38 2012 +0000 @@ -37,6 +37,7 @@ users.select.id.by.gid=SELECT id FROM users WHERE gid = ?::uuid users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?::uuid +users.select.account=SELECT id, name, account, role FROM users WHERE account = ? users.delete.id=DELETE FROM users WHERE id = ?