Parameters
- __namedParameters: {
category?: string;
createdAt?: DbTimestampCriteria;
customerId: string;
idempotencyKey?: string;
ids?: string[];
orderBy?: DbOrderByCriterion<
Omit<
PgTableWithColumns<
{
columns: {
accountId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
accountType: PgBuildColumn<
"reward_ledger",
Set$Type<SetNotNull<(...)>, (...) | (...)>,
{
data: (...) | (...);
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
amount: PgBuildColumn<
"reward_ledger",
SetNotNull<PgNumericBuilder>,
{
data: string;
dataType: "string numeric";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
category: PgBuildColumn<
"reward_ledger",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
createdAt: PgBuildColumn<
"reward_ledger",
SetHasDefault<SetNotNull<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
currency: PgBuildColumn<
"reward_ledger",
Set$Type<SetNotNull<(...)>, "MOVEUSD">,
{
data: "MOVEUSD";
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
customerExternalId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
customerId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgIntegerBuilder>,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
externalId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
id: PgBuildColumn<
"reward_ledger",
HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: "byDefault";
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
idempotencyKey: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
note: PgBuildColumn<
"reward_ledger",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
promotedFromAccountId: PgBuildColumn<
"reward_ledger",
PgIntegerBuilder,
{
data: number;
dataType: "number int32";
driverParam: (...)
| (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
rewardAccountId: PgBuildColumn<
"reward_ledger",
PgIntegerBuilder,
{
data: number;
dataType: "number int32";
driverParam: (...)
| (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
transactionType: PgBuildColumn<
"reward_ledger",
Set$Type<SetNotNull<(...)>, (...) | (...)>,
{
data: (...) | (...);
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
updatedAt: PgBuildColumn<
"reward_ledger",
SetHasDefault<SetHasDefault<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
};
dialect: "pg";
isAlias: false;
name: "reward_ledger";
schema: "b2b";
},
>,
"enableRLS",
>,
"createdAt"
| "updatedAt"
| "amount",
>[];
page?: number;
pageSize?: number;
recipient?: { entityId: string } | { email: string } | { phone: string };
transactionType?: "DEBIT" | "CREDIT";
updatedAt?: DbTimestampCriteria;
withPhone?: boolean;
}
-
Optionalcategory?: string
-
-
customerId: string
-
OptionalidempotencyKey?: string
-
Optionalids?: string[]
-
OptionalorderBy?: DbOrderByCriterion<
Omit<
PgTableWithColumns<
{
columns: {
accountId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
accountType: PgBuildColumn<
"reward_ledger",
Set$Type<SetNotNull<(...)>, (...) | (...)>,
{
data: (...) | (...);
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
amount: PgBuildColumn<
"reward_ledger",
SetNotNull<PgNumericBuilder>,
{
data: string;
dataType: "string numeric";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
category: PgBuildColumn<
"reward_ledger",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
createdAt: PgBuildColumn<
"reward_ledger",
SetHasDefault<SetNotNull<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
currency: PgBuildColumn<
"reward_ledger",
Set$Type<SetNotNull<(...)>, "MOVEUSD">,
{
data: "MOVEUSD";
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
customerExternalId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
customerId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgIntegerBuilder>,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
externalId: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
id: PgBuildColumn<
"reward_ledger",
HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
{
data: number;
dataType: "number int32";
driverParam: (...) | (...);
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: "byDefault";
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
idempotencyKey: PgBuildColumn<
"reward_ledger",
SetNotNull<PgTextBuilder<(...)>>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
note: PgBuildColumn<
"reward_ledger",
PgTextBuilder<[(...), ...(...)[]]>,
{
data: string;
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
promotedFromAccountId: PgBuildColumn<
"reward_ledger",
PgIntegerBuilder,
{
data: number;
dataType: "number int32";
driverParam: (...)
| (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
rewardAccountId: PgBuildColumn<
"reward_ledger",
PgIntegerBuilder,
{
data: number;
dataType: "number int32";
driverParam: (...)
| (...);
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: false;
tableName: "reward_ledger";
},
>;
transactionType: PgBuildColumn<
"reward_ledger",
Set$Type<SetNotNull<(...)>, (...) | (...)>,
{
data: (...) | (...);
dataType: "string";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: false;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
updatedAt: PgBuildColumn<
"reward_ledger",
SetHasDefault<SetHasDefault<(...)>>,
{
data: Date;
dataType: "object date";
driverParam: string;
enumValues: undefined;
generated: undefined;
hasDefault: true;
hasRuntimeDefault: false;
identity: undefined;
isAutoincrement: false;
isPrimaryKey: false;
name: string;
notNull: true;
tableName: "reward_ledger";
},
>;
};
dialect: "pg";
isAlias: false;
name: "reward_ledger";
schema: "b2b";
},
>,
"enableRLS",
>,
"createdAt"
| "updatedAt"
| "amount",
>[]
-
Optionalpage?: number
-
OptionalpageSize?: number
-
Optionalrecipient?: { entityId: string } | { email: string } | { phone: string }
-
OptionaltransactionType?: "DEBIT" | "CREDIT"
-
-
OptionalwithPhone?: boolean
Returns Promise<
| { error: RewardAccountError; ok: false }
| { ok: true; value: { hasNext: boolean; items: Reward[]; total: number } },
>
reward entries, all of them or one recipient's
Manage rewards for entities
Internally, this is using a ledger so each reward causes a double-entry.