Class: PostRepository

backend.PostRepository

Hierarchy

• BaseRepository<Post>

  ↳ PostRepository

Table of contents

Constructors

• constructor

Properties

• dbType

Methods

• applyBaseFilter
• applyDeleteMany
• applyGetEntityViews
• applyPostFilter
• createEntity
• createPost
• deleteEntity
• deleteMany
• deleteManyFilteredPosts
• deletePost
• getAll
• getById
• getBySlug
• getEntityViews
• getFilteredEntities
• getFilteredPosts
• getPaged
• getPostById
• getPostBySlug
• getPosts
• getSqlBoolStr
• getSqlLike
• getTagsOfPost
• quote
• updateEntity
• updatePost

Constructors

constructor

• new PostRepository()

Overrides

BaseRepository.constructor

Defined in

system/core/backend/src/repositories/post.repository.ts:21

Properties

dbType

• dbType: "mysql" | "mariadb" | "postgres" | "cockroachdb" | "sqlite" | "mssql" | "sap" | "oracle" | "cordova" | "nativescript" | "react-native" | "sqljs" | "mongodb" | "aurora-data-api" | "aurora-data-api-pg" | "expo" | "better-sqlite3" | "capacitor"

Inherited from

BaseRepository.dbType

Defined in

system/core/backend/src/repositories/base.repository.ts:24

Methods

applyBaseFilter

▸ applyBaseFilter<EntityType>(qb, filter?): SelectQueryBuilder<EntityType>

Type parameters

Name	Type
EntityType	TBasePageEntity

Parameters

Name	Type
qb	SelectQueryBuilder<EntityType>
filter?	BaseFilterInput

Returns

SelectQueryBuilder<EntityType>

Inherited from

BaseRepository.applyBaseFilter

Defined in

system/core/backend/src/repositories/base.repository.ts:155

---

applyDeleteMany

▸ applyDeleteMany(qb, input): Promise<void>

Parameters

Name	Type
qb	SelectQueryBuilder<Post> | DeleteQueryBuilder<Post>
input	TDeleteManyInput

Returns

Promise<void>

Inherited from

BaseRepository.applyDeleteMany

Defined in

system/core/backend/src/repositories/base.repository.ts:108

---

applyGetEntityViews

▸ applyGetEntityViews(qb, entityType): SelectQueryBuilder<TBasePageEntity>

Parameters

Name	Type
qb	SelectQueryBuilder<TBasePageEntity>
entityType	EDBEntity

Returns

SelectQueryBuilder<TBasePageEntity>

Inherited from

BaseRepository.applyGetEntityViews

Defined in

system/core/backend/src/repositories/base.repository.ts:133

---

applyPostFilter

▸ applyPostFilter(qb, filterParams?): SelectQueryBuilder<TPost>

Parameters

Name	Type
qb	SelectQueryBuilder<TPost>
filterParams?	PostFilterInput

Returns

SelectQueryBuilder<TPost>

Defined in

system/core/backend/src/repositories/post.repository.ts:113

---

createEntity

▸ createEntity(input, id?): Promise<Post>

Parameters

Name	Type
input	Post
id?	null | number

Returns

Promise<Post>

Inherited from

BaseRepository.createEntity

Defined in

system/core/backend/src/repositories/base.repository.ts:70

---

createPost

▸ createPost(createPost, id?): Promise<Post>

Parameters

Name	Type
createPost	TPostInput
id?	null | number

Returns

Promise<Post>

Defined in

system/core/backend/src/repositories/post.repository.ts:82

---

deleteEntity

▸ deleteEntity(id): Promise<boolean>

Parameters

Name	Type
id	number

Returns

Promise<boolean>

Inherited from

BaseRepository.deleteEntity

Defined in

system/core/backend/src/repositories/base.repository.ts:97

---

deleteMany

▸ deleteMany(input): Promise<boolean>

Parameters

Name	Type
input	TDeleteManyInput

Returns

Promise<boolean>

Inherited from

BaseRepository.deleteMany

Defined in

system/core/backend/src/repositories/base.repository.ts:125

---

deleteManyFilteredPosts

▸ deleteManyFilteredPosts(input, filterParams?): Promise<undefined | boolean>

Parameters

Name	Type
input	TDeleteManyInput
filterParams?	PostFilterInput

Returns

Promise<undefined | boolean>

Defined in

system/core/backend/src/repositories/post.repository.ts:174

---

deletePost

▸ deletePost(id): Promise<boolean>

Parameters

Name	Type
id	number

Returns

Promise<boolean>

Defined in

system/core/backend/src/repositories/post.repository.ts:101

---

getAll

▸ getAll(): Promise<Post[]>

Returns

Promise<Post[]>

Inherited from

BaseRepository.getAll

Defined in

system/core/backend/src/repositories/base.repository.ts:44

---

getById

▸ getById(id, relations?): Promise<Post>

Parameters

Name	Type
id	number
relations?	string[]

Returns

Promise<Post>

Inherited from

BaseRepository.getById

Defined in

system/core/backend/src/repositories/base.repository.ts:49

---

getBySlug

▸ getBySlug(slug, relations?): Promise<Post>

Parameters

Name	Type
slug	string
relations?	string[]

Returns

Promise<Post>

Inherited from

BaseRepository.getBySlug

Defined in

system/core/backend/src/repositories/base.repository.ts:60

---

getEntityViews

▸ getEntityViews(entityId, entityType): Promise<any>

Parameters

Name	Type
entityId	number
entityType	EDBEntity

Returns

Promise<any>

Inherited from

BaseRepository.getEntityViews

Defined in

system/core/backend/src/repositories/base.repository.ts:144

---

getFilteredEntities

▸ getFilteredEntities(pagedParams?, filterParams?): Promise<TPagedList<Post>>

Parameters

Name	Type
pagedParams?	PagedParamsInput<Post>
filterParams?	BaseFilterInput

Returns

Promise<TPagedList<Post>>

Inherited from

BaseRepository.getFilteredEntities

Defined in

system/core/backend/src/repositories/base.repository.ts:164

---

getFilteredPosts

▸ getFilteredPosts(pagedParams?, filterParams?): Promise<TPagedList<TPost>>

Parameters

Name	Type
pagedParams?	PagedParamsInput<Post>
filterParams?	PostFilterInput

Returns

Promise<TPagedList<TPost>>

Defined in

system/core/backend/src/repositories/post.repository.ts:167

---

getPaged

▸ getPaged(params?): Promise<TPagedList<Post>>

Parameters

Name	Type
params?	TPagedParams<Post>

Returns

Promise<TPagedList<Post>>

Inherited from

BaseRepository.getPaged

Defined in

system/core/backend/src/repositories/base.repository.ts:38

---

getPostById

▸ getPostById(id): Promise<undefined | Post>

Parameters

Name	Type
id	number

Returns

Promise<undefined | Post>

Defined in

system/core/backend/src/repositories/post.repository.ts:30

---

getPostBySlug

▸ getPostBySlug(slug): Promise<undefined | Post>

Parameters

Name	Type
slug	string

Returns

Promise<undefined | Post>

Defined in

system/core/backend/src/repositories/post.repository.ts:35

---

getPosts

▸ getPosts(params): Promise<TPagedList<Post>>

Parameters

Name	Type
params	TPagedParams<Post>

Returns

Promise<TPagedList<Post>>

Defined in

system/core/backend/src/repositories/post.repository.ts:25

---

getSqlBoolStr

▸ getSqlBoolStr(b): "true" | "false" | "1" | "0"

Parameters

Name	Type
b	boolean

Returns

"true" | "false" | "1" | "0"

Inherited from

BaseRepository.getSqlBoolStr

Defined in

system/core/backend/src/repositories/base.repository.ts:34

---

getSqlLike

▸ getSqlLike(): "ILIKE" | "LIKE"

Returns

"ILIKE" | "LIKE"

Inherited from

BaseRepository.getSqlLike

Defined in

system/core/backend/src/repositories/base.repository.ts:35

---

getTagsOfPost

▸ getTagsOfPost(postId): Promise<undefined | null | Tag[]>

Parameters

Name	Type
postId	number

Returns

Promise<undefined | null | Tag[]>

Defined in

system/core/backend/src/repositories/post.repository.ts:187

---

quote

▸ quote(str): string

Parameters

Name	Type
str	string

Returns

string

Inherited from

BaseRepository.quote

Defined in

system/core/backend/src/repositories/base.repository.ts:36

---

updateEntity

▸ updateEntity(id, input): Promise<Post>

Parameters

Name	Type
id	number
input	Post

Returns

Promise<Post>

Inherited from

BaseRepository.updateEntity

Defined in

system/core/backend/src/repositories/base.repository.ts:82

---

updatePost

▸ updatePost(id, updatePost): Promise<Post>

Parameters

Name	Type
id	number
updatePost	TPostInput

Returns

Promise<Post>

Defined in

system/core/backend/src/repositories/post.repository.ts:92