Database Layer

Database Features

Database Schema

Real-World Example

// Find nearby services with provider details using query()
async function findNearbyServices(userLocation, radiusKm = 5) {
  // First, get services within radius using spatial query
  const nearbyServices = await OracleObjectModel.spatialProximity({
    queryEntity: {
      'service_id': 'id',
      'title': null,
      'category': null,
      'price': null,
      'user_id': 'providerId',
      'distance_km': 'distance'
    },
    queryTable: 'services',
    location: userLocation,
    radiusKm: radiusKm
  });

  // Then get provider details using query() - much cleaner!
  const providerIds = nearbyServices.map(s => s.providerId);
  const providers = await OracleObjectModel.query(
    ['user_id:id', 'first_name', 'last_name', 'profile_image:avatar'],
    'users',
    { user_id: { $in: providerIds } }
  );
  // Returns: [{ id, firstName, lastName, avatar }]

  // Combine results
  return nearbyServices.map(service => ({
    ...service,
    provider: providers.find(p => p.id === service.providerId)
  }));
}