NAME=QUERY1;
ROW TABLE5 FROM TABLE5;
NAME=QUERY2;
ROW TABLE1 FROM TABLE1;
FOR UPDATE, DELETE;
NAME=GET_ALL_USERS;
ROW USER FROM USER;
RETRIEVE USER.login,USER.first_name,USER.last_name;
NAME=USER_LOGIN;
ROW USER FROM USER;
WHERE(TEXT login, TEXT password){USER.login=${login}
AND
USER.password=${password}}
RETRIEVE USER.login,USER.first_name,USER.last_name,USER.PK;
NAME=GET_USERS_PUBLIC_MESSAGES;
ROW USER FROM USER;
ROW USER_MESSAGES FROM USER_MESSAGES;
USER RELATED USER_MESSAGES VIA USERS_MESSAGES;
WHERE(TEXT login){USER.login=${login}
AND
USER_MESSAGES.visible=1}
RETRIEVE USER_MESSAGES.message,USER_MESSAGES.creation_date;
ORDER BY USER_MESSAGES.creation_date DESCENDING;
NAME=GET_ALL_PUBLIC_MESSAGES;
ROW USER FROM USER;
ROW USER_MESSAGES FROM USER_MESSAGES;
USER RELATED USER_MESSAGES VIA USERS_MESSAGES;
RETRIEVE USER.first_name, USER.last_name,USER_MESSAGES.message,USER_MESSAGES.creation_date;
ORDER BY USER_MESSAGES.creation_date DESCENDING;
NAME=GET_USER_MESSAGES;
ROW USER FROM USER;
ROW USER_MESSAGES FROM USER_MESSAGES;
USER RELATED USER_MESSAGES VIA USERS_MESSAGES;
WHERE(SURID<USER_LOGIN> surid){USER.PK=${surid}}
RETRIEVE USER_MESSAGES into USER_MESSAGES;
FOR UPDATE, DELETE;
NAME=LOGIN;
ROW USER FROM USER;
WHERE(TEXT login, TEXT password){USER.login=${login}
AND
USER.password=${password}}
FOR UPDATE;
NAME=TEST_TABLE_QUERY;
ROW TEST_TABLE FROM TEST_TABLE;
FOR UPDATE, DELETE;