Matheus Sampaio Queiroga
c000946e26
- Introduced error handling for non-existent servers and users. - Updated user management methods to include email retrieval. - Modified user creation to accept password as a parameter. - Added server management methods for retrieving friends and backups. - Removed obsolete PostgreSQL implementation. - Enhanced SQLite implementation with new SQL scripts for user and server management. - Implemented encryption for user passwords using AES-192 and scrypt. - Added tests for database operations and encryption functionality. - Improved server and user structures to include additional fields. Signed-off-by: Matheus Sampaio Queiroga <srherobrine20@gmail.com>
16 lines
270 B
SQL
16 lines
270 B
SQL
SELECT id,
|
|
name,
|
|
owner,
|
|
software,
|
|
version,
|
|
create_at,
|
|
update_at
|
|
FROM server
|
|
WHERE server.owner = $1
|
|
OR server.id IN (
|
|
SELECT server_id
|
|
FROM friends,
|
|
json_each(friends.permissions)
|
|
WHERE user_id = $1
|
|
AND json_each.value = 'view'
|
|
); |