FilesExpand file tree

main

/

note.server.ts

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

74 lines (62 loc) · 1.34 KB

main

/

note.server.ts

Copy path

Top

File metadata and controls

• Code
• Blame

74 lines (62 loc) · 1.34 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

import type { User } from "./user.server";

import { supabase } from "./user.server";

export type Note = {

id: string;

title: string;

body: string;

profile_id: string;

};

export async function getNoteListItems({ userId }: { userId: User["id"] }) {

const { data } = await supabase

.from("notes")

.select("id, title")

.eq("profile_id", userId);

return data;

}

export async function createNote({

title,

body,

userId,

}: Pick<Note, "body" | "title"> & { userId: User["id"] }) {

const { data, error } = await supabase

.from("notes")

.insert([{ title, body, profile_id: userId }])

.single();

if (!error) {

return data;

}

return null;

}

export async function deleteNote({

id,

userId,

}: Pick<Note, "id"> & { userId: User["id"] }) {

const { error } = await supabase

.from("notes")

.delete({ returning: "minimal" })

.match({ id, profile_id: userId });

if (!error) {

return {};

}

return null;

}

export async function getNote({

id,

userId,

}: Pick<Note, "id"> & { userId: User["id"] }) {

const { data, error } = await supabase

.from("notes")

.select("*")

.eq("profile_id", userId)

.eq("id", id)

.single();

if (!error) {

return {

userId: data.profile_id,

id: data.id,

title: data.title,

body: data.body,

};

}

return null;

}