Update Database Tables #3

Merged

clement.freville2 merged 12 commits from update-bdd into main

colin.frizot commented

Owner

Update Database Tables

User

Tables

Add the email field

API

Add a route to update the email

Work

Tables

Add the title
Add date fields

API

Add a route to update the title (/works/:id/title)
Add a route to update the content (/works/:id/content)

colin.frizot added 2 commits

a9651ed09f Add an email to User and title, date to Work

9c194b218d Add the update of the title and the content

clement.freville2 requested review from clement.freville2

clement.freville2 requested changes

src/server.ts Outdated

clement.freville2 commented

Owner

-    db.insertWork(database, link, id_user, id_language, title, code, date);
+    await db.insertWork(database, link, id_user, id_language, title, code, date);

clement.freville2 marked this conversation as resolved

src/server.ts Outdated

clement.freville2 commented

Owner

-    db.updateWorkTitle(database, id, newTitle);
+    await db.updateWorkTitle(database, id, newTitle);

clement.freville2 marked this conversation as resolved

src/server.ts Outdated

clement.freville2 commented

Owner

-    db.updateWorkContent(database, id, newContent);
+    await db.updateWorkContent(database, id, newContent);

clement.freville2 marked this conversation as resolved

colin.frizot added 1 commit

27778a68f4 Add await to the calls and add the date by default

colin.frizot requested review from clement.freville2

clement.freville2 approved these changes

clement.freville2 left a comment

Owner

Great!

clement.freville2 force-pushed update-bdd from 27778a68f4 to 0e352a37d0

clement.freville2 force-pushed update-bdd from 0e352a37d0 to 99b29432cd

matis.mazingue added 1 commit

10c9d5e41b Merge branch 'update-bdd' of https://codefirst.iut.uca.fr/git/sandkasten/labyrinth into update-bdd

matis.mazingue added 1 commit

aa0516dc72 selectWorkById et selectLastWorkByUserId

clement.freville2 added 1 commit

b22caee202 Remove trailing whitespaces

matis.mazingue added 2 commits

d9ffd73313 get last work's link by user id

e900312cd7 Merge branch 'update-bdd' of https://codefirst.iut.uca.fr/git/sandkasten/labyrinth into update-bdd

matis.mazingue added 1 commit

1240b3ebe7 delete table language + delete getLastLinkWorkByUSerId

colin.frizot added 1 commit

f9b0fb5e10 Change the get and add link

matis.mazingue requested review from clement.freville2

clement.freville2 added 1 commit

3dabedd89b Merge branch 'main' into update-bdd

clement.freville2 merged commit 96bb32ac32 into main 10 months ago

clement.freville2 referenced this issue from a commit

Update Database Tables (#3)

clement.freville2 deleted branch update-bdd

Reviewers

clement.freville2 was requested for review

continuous-integration/drone/push Build is passing

Details

continuous-integration/drone/pr Build is passing

Details

The pull request has been merged as 96bb32ac32.

No Label

No Milestone

No project

No Assignees

3 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: sandkasten/labyrinth#3

     const { id } = request.params;
     const { newEmail } = request.body;
     await db.updateUserEmail(database, id, newEmail);
     reply.send({ success: true });

         id_language: Type.Number(),
         title: Type.String(),
         code: Type.String(),
         date: Type.String(),

     const { id_user, link, id_language, code } = request.body;
     db.insertWork(database, link, id_user, id_language, code);
     const { id_user, link, id_language, title, code, date } = request.body;
     db.insertWork(database, link, id_user, id_language, title, code, date);

   async (request, reply) => {
     const { id } = request.params;
     const { newTitle } = request.body;
     db.updateWorkTitle(database, id, newTitle);

   async (request, reply) => {
     const { id } = request.params;
     const { newContent } = request.body;
     db.updateWorkContent(database, id, newContent);