import { createDb, seedAll } from 'inflow-get';
import { createClient } from 'inflow-client';

// Create database at your chosen path
const db = createDb('./my-inventory.db');

// Create API client with your credentials
const client = createClient({
  apiKey: process.env.INFLOW_API_KEY,
  companyId: process.env.INFLOW_COMPANY_ID,
});

// Seed all data (one-time)
await seedAll({ db, client });

// Now query your data with full type safety
import { products, salesOrders, customers } from 'inflow-get';
import { eq } from 'drizzle-orm';

const activeProducts = db
  .select()
  .from(products)
  .where(eq(products.isActive, true))
  .all();

import { createDb, products, customers, salesOrders } from 'inflow-get';
import { eq } from 'drizzle-orm';

// Create database
const db = createDb('./my-data.db');

// Import tables and use with Drizzle ORM
// Full TypeScript support - IDE shows all columns
const results = db.select().from(products).all();
//    ^? Array<{ productId: string, name: string, sku: string, ... }>

// Joins work with full type inference
const ordersWithCustomers = db
  .select({
    orderNumber: salesOrders.orderNumber,
    customerName: customers.name,
    total: salesOrders.total,
  })
  .from(salesOrders)
  .leftJoin(customers, eq(salesOrders.customerId, customers.customerId))
  .all();

import { createDb, seedAllReference, seedProducts, seedVendors } from 'inflow-get';
import { createClient } from 'inflow-client';

const db = createDb('./inventory.db');
const client = createClient({ apiKey: '...', companyId: '...' });

// Seed only what you need
await seedAllReference({ db, client });  // Categories, locations, etc.
await seedProducts({ db, client });       // Products with prices, inventory
await seedVendors({ db, client });        // Vendors with vendor items

// Database factory
import { createDb } from 'inflow-get';

// Seed functions
import {
  seedAll,              // Everything
  seedAllReference,     // Reference tables only
  seedProducts,         // Products + nested tables
  seedVendors,          // Vendors + vendor items
  seedCustomers,        // Customers
  seedAllOrders,        // PO, SO, MO
  seedAllTransactions,  // Transfers, adjustments
  seedAllStockCounts,   // Stock counts
  seedAllCustomFields,  // Custom field definitions
  seedProductSummary,   // Inventory metrics (opt-in)
} from 'inflow-get';

// Schema tables (for querying)
import {
  // Reference
  categories, locations, currencies, pricingSchemes,
  paymentTerms, taxCodes, taxingSchemes, operationTypes,
  adjustmentReasons, teamMembers,

  // Custom Fields
  customFieldDefinitions, customFieldDropdownOptions, customFields,

  // Products
  products, productPrices, productBarcodes, inventoryLines,
  itemBoms, productOperations, reorderSettings,

  // Vendors & Customers
  vendors, vendorItems, customers,

  // Orders
  purchaseOrders, purchaseOrderLines,
  salesOrders, salesOrderLines,
  manufacturingOrders,

  // Transactions
  stockTransfers, stockTransferLines,
  stockAdjustments, stockAdjustmentLines,
  productCostAdjustments, productCostAdjustmentLines,

  // Inventory Operations
  stockCounts, countSheets, countSheetLines,

  // Reporting
  productSummary,
} from 'inflow-get';

// Types
import type { SeedContext, InflowDb } from 'inflow-get';