export const cryptoToken = pgTable("crypto_token", {
  id: integer("id").primaryKey(),
  rank: integer("rank"),
  name: text("name").notNull(),
  symbol: text("symbol").notNull(),
  slug: text("slug").notNull(),
  is_active: integer("is_active").notNull(),
  first_historical_data: text("first_historical_data"),
  last_historical_data: text("last_historical_data"),
});

type TokenPlatform = {
  id: number;
  contract_address: string;
};

export const platform = pgTable("platform", {
  id: integer("id").unique().primaryKey(),
  name: text("name"),
  slug: text("slug"),
  symbol: text("symbol"),
  tokens: jsonb("tokens").$type<TokenPlatform[]>(),
});

export const cryptoToken = pgTable("crypto_token", {
  id: integer("id").primaryKey(),
  rank: integer("rank"),
  name: text("name").notNull(),
  symbol: text("symbol").notNull(),
  slug: text("slug").notNull(),
  is_active: integer("is_active").notNull(),
  first_historical_data: text("first_historical_data"),
  last_historical_data: text("last_historical_data"),
});

type TokenPlatform = {
  id: number;
  contract_address: string;
};

export const platform = pgTable("platform", {
  id: integer("id").unique().primaryKey(),
  name: text("name"),
  slug: text("slug"),
  symbol: text("symbol"),
  tokens: jsonb("tokens").$type<TokenPlatform[]>(),
});

export type CMCCryptoMap = {
  id: number;
  rank: number;
  name: string;
  symbol: string;
  slug: string;
  is_active: number;
  first_historical_data: string;
  last_historical_data: string;
  platform?: Platform;
};

export type Platform = {
  id: number;
  name: string;
  symbol: string;
  slug: string;
  token_address: string;
  tokenId: number;
};

export type CMCCryptoMap = {
  id: number;
  rank: number;
  name: string;
  symbol: string;
  slug: string;
  is_active: number;
  first_historical_data: string;
  last_historical_data: string;
  platform?: Platform;
};

export type Platform = {
  id: number;
  name: string;
  symbol: string;
  slug: string;
  token_address: string;
  tokenId: number;
};

  searchTerm = searchTerm.replace(
    /(\d+)([a-zA-Z]+)|\s+/g,
    function (match, p1, p2) {
      return p1 ? "%" + p1 + "%" + p2 : "%";
    }
  );

  const selectResult = await db
    .select({
      id: productsInformation.id,
      name: productsInformation.name,
      retailPrice: products.retailPrice,
      inShopsPrice: products.inShopsPrice,
      wholesalePrice: products.wholesalePrice,
    })
    .from(productsInformation)
    .where(ilike(productsInformation.name, "%" + searchTerm + "%"))
    .leftJoin(products, eq(products.sku, productsInformation.sku));

  searchTerm = searchTerm.replace(
    /(\d+)([a-zA-Z]+)|\s+/g,
    function (match, p1, p2) {
      return p1 ? "%" + p1 + "%" + p2 : "%";
    }
  );

  const selectResult = await db
    .select({
      id: productsInformation.id,
      name: productsInformation.name,
      retailPrice: products.retailPrice,
      inShopsPrice: products.inShopsPrice,
      wholesalePrice: products.wholesalePrice,
    })
    .from(productsInformation)
    .where(ilike(productsInformation.name, "%" + searchTerm + "%"))
    .leftJoin(products, eq(products.sku, productsInformation.sku));