Create Get: ListAssetByCreator

[Shubhaankar-Sharma]

Summary

Create New Endpoint Get: ListAssetByCreator
Checkpoints:

• Add Pagination
• Use Already Created Function store.ListAssetByCreator (maybe you would have to change the query ping me in the server if we do)
• Requires User_id

[Shubhaankar-Sharma]

var pageSize int32 = 5
var pageNumber int32 = 1
args := ListAssetByCreatorParams{
CreatorID: generatedAsset.CreatorID,
Limit:     5,
Offset:    (pageNumber - 1) * pageSize,
}
assetLists, err := testQueries.ListAssetByCreator(r.Context(), args)

this is how pagination is to be done

cdn/db/sqlc/cdn_test.go

Line 109 in ef9b65a

func TestQueries_ListAssetByCreator(t *testing.T) {

its been done in this test