create-order.js 755 B

123456789101112131415161718192021222324252627282930
  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 { user_id, nameorder, date, pay } = body;
  14. const hash_password = hash(password, 10);
  15. const res = await pool.query('INSERT INTO users(user_id, nameorder, date, pay ) VALUES($1, $2, $3) RETURNING id',
  16. [user_id, nameorder, date, pay ]
  17. );
  18. } catch (error) {
  19. console.log('server signUp error', error);
  20. }
  21. })