Function Oldest

basic model collection retrieval

await FedacoTestUser.createQuery().create({
  id: 1,
  email: 'linbolen@gradii.com'
});
await FedacoTestUser.createQuery().create({
  id: 2,
  email: 'xsilen@gradii.com'
});
const models = await new FedacoTestUser().NewQuery().oldest('id').get();

Reference	Looks Like	Value
isArray(models)	exactly match	true
models[0]	instance type exactly match	FedacoTestUser
models[1]	instance type exactly match	FedacoTestUser
models[0].email	exactly match	'linbolen@gradii.com'
models[1].email	exactly match	'xsilen@gradii.com'

---

see also prerequisites

paginated model collection retrieval when no elements and default per page

const models = await new FedacoTestUser().NewQuery().oldest('id').paginate();

---

see also prerequisites

paginated model collection retrieval when no elements

// Paginator.currentPageResolver(() => {
//   return 1;
// });
let models = await new FedacoTestUser().NewQuery().oldest('id').paginate(1, 2);

// expect(models).toInstanceOf(LengthAwarePaginator);
// Paginator.currentPageResolver(() => {
//   return 2;
// });
models = await new FedacoTestUser().NewQuery().oldest('id').paginate(2, 2);

---

see also prerequisites

paginated model collection retrieval

await new FedacoTestUser().NewQuery().create({
  id: 1,
  email: 'linbolen@gradii.com'
});
await new FedacoTestUser().NewQuery().create({
  id: 2,
  email: 'xsilen@gradii.com'
});
await new FedacoTestUser().NewQuery().create({
  id: 3,
  email: 'foo@gmail.com'
});
// Paginator.currentPageResolver(() => {
//   return 1;
// });
let models = await new FedacoTestUser().NewQuery().oldest('id').paginate(1, 2);

Reference	Looks Like	Value
models.items[0]	instance type exactly match	FedacoTestUser
models.items[1]	instance type exactly match	FedacoTestUser
models.items[0].email	exactly match	'linbolen@gradii.com'
models.items[1].email	exactly match	'xsilen@gradii.com'

Reference	Looks Like	Value
models.items.length	exactly match	1
models.items[0]	instance type exactly match	FedacoTestUser
models.items[0].email	exactly match	'foo@gmail.com'

---

see also prerequisites

pluck with column name containing a space

await FedacoTestUserWithSpaceInColumnName.createQuery().create({
  id: 1,
  email_address: 'linbolen@gradii.com'
});
await FedacoTestUserWithSpaceInColumnName.createQuery().create({
  id: 2,
  email_address: 'xsilen@gradii.com'
});
const simple = await FedacoTestUserWithSpaceInColumnName.createQuery()
  .oldest('id')
  .pluck('users_with_space_in_colum_name.email_address');
const keyed = await FedacoTestUserWithSpaceInColumnName.createQuery()
  .oldest('id')
  .pluck('email_address', 'id');

Reference	Looks Like	Value
keyed	match	`({

  1: 'linbolen@gradii.com',
  2: 'xsilen@gradii.com'
});` |

---

see also prerequisites

pluck

await FedacoTestUser.createQuery().create({
  id: 1,
  email: 'linbolen@gradii.com'
});
await FedacoTestUser.createQuery().create({
  id: 2,
  email: 'xsilen@gradii.com'
});
const simple = await FedacoTestUser.createQuery()
  .oldest('id')
  .pluck('users.email');
const keyed = await FedacoTestUser.createQuery()
  .oldest('id')
  .pluck('users.email', 'users.id');

Reference	Looks Like	Value
keyed	match	`({

  1: 'linbolen@gradii.com',
  2: 'xsilen@gradii.com'
});` |

---

see also prerequisites