noam-honig

import {
  Entity,
  FieldRef,
  Fields,
  FieldsRef,
  getEntityRef,
  IdEntity,
  isBackend,
  LifecycleEvent,

noam-honig

    return new Proxy(db, {
      get(target, prop) {
        if (prop == 'getEntityDataProvider') {
          return (meta: EntityMetadata) => {
            return new Proxy(db.getEntityDataProvider(meta), {
              get(target, prop) {
                if (prop == 'find') {
                  return async (options: EntityDataProviderFindOptions) => {
                    const start = performance.now();
                    const result = await target.find(options);

noam-honig

async function bulkInsert<entityType extends EntityBase>(
  array: entityType[],
  db: SqlDatabase,
) {
  if (array.length == 0) return

  const chunkSize = 250
  for (let i = 0; i < array.length; i += chunkSize) {
    const items = array.slice(i, i + chunkSize)

noam-honig

dataProvider: async () => {
    const result = await createKnexDataProvider({
      client: 'mssql',
      //debug: true,
      connection: {
        server: process.env['DBServer'],
        database: process.env['DBDatabase'],
        user: process.env['DBUser'],
        password: process.env['DBPassword'],
        query_timeout: 30000,

noam-honig

/**
 * Checks if a filter contains a specific field
 * @example
 backendPreprocessFilter: async (filter) => {
    // If not specific filter for deletedBy was specified - only show non deleted rows
    if (!filterContains(filter, 'deletedBy')) {
      return {
        ...filter,
        deletedBy: null,
      }

noam-honig

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Firefly.Box;
using Firefly.Box.Data.Advanced;
using ENV.Data.DataProvider;
using Firefly.Box.Data.DataProvider;