import { type MigrateDirection, type MigrationDefinition, type MigrationRecord, type SqlDependency } from "../core/mod.ts";
/**
 * A record in a postgres database containing information about a migration that has been run.
 *
 * ```js
 * const record = {
 *   name: '001-add-users-table.js',
 *   created: new Date()
 * }
 * ```
 */
export interface PostgresMigrationRecord {
    name: string;
    created: Date;
}
/**
 * Query the postgres database to find migrations that have already been performed.
 * Returning an array of `PostgresMigrationRecord`.
 *
 * ```js
 * const sql // SqlDependency
 * const records = await getPostgresMigrations(sql)
 * ```
 */
export declare function getPostgresMigrations(sql: SqlDependency): Promise<MigrationRecord[]>;
/**
 * Perform either the **up** or **down** postgres migration and record what happened.
 * This will first start a transaction, so if anything goes wrong the whole operation is aborted.
 * Within the transaction, it attempts the run the action (either **up** or **down**) as specified.
 *
 * After the action is ran, it will follow up with updating the migration records.
 * For an **up** action, it will create a new `PostgresMigrationRecord`
 * and insert it into the database.
 * For a **down** action, it will remove the corresponding `PostgresMigrationRecord`.
 *
 * > There is an edge case where it will not remove the record if running the `postgresBootstrapMigration` action,
 * > because that migration deletes the migration table itself so would be pointless.
 *
 * ```js
 * const sql // SqlDependency
 * const definition = definePostgresMigration(...)
 *
 * await executePostgresMigration(definition, "up", sql)
 * ```
 */
export declare function executePostgresMigration(def: MigrationDefinition<SqlDependency>, direction: MigrateDirection, sql: SqlDependency): Promise<void>;
/**
 * This is a `MigrationDefinition` to bootstrap postgres migrations.
 * It sets up the initial "migrations" table that all other
 * migrations will be recorded in.
 */
export declare const postgresBootstrapMigration: import("../core/migrator.ts").MigrationOptions<SqlDependency>;
/**
 * A typed version of `defineMigration` that specalizes for a ` PostgresService`.
 * This is mostly useful to get a strongly typed `sql` parameter.
 *
 * ```js
 * import { definePostgresMigration } from "gruber"
 *
 * export default definePostgresMigration({
 *   async up(sql) {
 *     await sql.execute`
 *       CREATE TABLE users ...
 *     `
 *   },
 *   async down(sql) {
 *     await sql.execute`
 *       DROP TABLE users
 *     `
 *   }
 * })
 * ```
 */
export declare const definePostgresMigration: (options: import("../core/migrator.ts").MigrationOptions<SqlDependency>) => import("../core/migrator.ts").MigrationOptions<SqlDependency>;
//# sourceMappingURL=postgres-migrator.d.ts.map