dialect_sqlite_numbered.go

// SPDX-FileCopyrightText: 2026 The DMorph contributors.
// SPDX-License-Identifier: MPL-2.0

package dmorph

// DialectSQLiteNumbered returns a Dialect configured for SQLite databases with numbered parameters.
// This is mainly used for tests, but nothing speaks against it being used otherwise.
//
//nolint:goconst
func DialectSQLiteNumbered() NumberedParamsDialect {
	return NumberedParamsDialect{
		NamedParamsDialect: NamedParamsDialect{
			CreateTemplate: `
			CREATE TABLE IF NOT EXISTS "%s" (
				id        VARCHAR(255) NOT NULL,
				mgroup    VARCHAR(255) NOT NULL,
				create_ts TIMESTAMP DEFAULT current_timestamp,
			    PRIMARY KEY (id, mgroup)
			)`,
			AppliedTemplate: `
			SELECT id
			FROM   "%s"
			WHERE  mgroup = ?
	        ORDER BY create_ts ASC`,
			RegisterTemplate: `
			INSERT INTO "%s" (id, mgroup)
	        VALUES(?, ?)`,
		},
		AppliedMigrationsParamsOrder: []ParamName{ParamNameMGroup},
		RegisterMigrationParamsOrder: []ParamName{ParamNameID, ParamNameMGroup},
	}
}