import { createX } from "@xframework/x";
import { DrizzleAdapter } from "@your-db-adapter/drizzle";
 
const x = createX()
  .asyncAdapter("db", async () => {
    const pool = await createPool();
    return new DrizzleAdapter(pool);
  })
  .build();

import { AsyncAdapter } from "@xframework/x/adapter";
 
// The type parameter is what your adapter will export
export class MyAsyncAdapter extends AsyncAdapter<{ data: string[] }> {
  private connection: Connection;
 
  constructor(connection: Connection) {
    super();
    this.connection = connection;
  }
 
  // Optional: Run async initialization code
  async init() {
    // This runs after the adapter is created
    await this.connection.connect();
  }
 
  // Required: Export your adapter's functionality
  async export() {
    const data = await this.connection.query("SELECT * FROM items");
    return { data };
  }
}

const x = createX()
  .asyncAdapter("my-async", async () => {
    const conn = await createConnection();
    return new MyAsyncAdapter(conn);
  })
  .build();
 
// Access your adapter's exported value
const data = await x["my-async"].data;