signIn.js 818 B

12345678910111213141516171819202122232425262728293031323334
  1. import { Pool } from 'pg';
  2. import { hash } from 'bcrypt'
  3. export default defineEventHandler(async (event) => {
  4. try {
  5. const pool = new Pool({
  6. user: "de-user10",
  7. host: 'de-db.ptk.itiscaf.ru',
  8. database: 'de-user10',
  9. port: 5441,
  10. password: 'fGz0uG18uK'
  11. })
  12. const body = await readBody(event);
  13. let { login, password} = body;
  14. const hash_password = hash(password, 10);
  15. const res = await pool.query('SELECT * FROM users WHERE login = $1 RETURNING id',
  16. [login]
  17. );
  18. if(res.rows[0]){
  19. const user = res.rows[0]
  20. setCookie(event, 'online', JSON.stringify({user}))
  21. }
  22. } catch (error) {
  23. console.log('server signUp error', error);
  24. }
  25. })