Randomly stopped being able to generate migrations (MySQL)
Hey! Been trying things out the past day and everything was going great - until I deleted my 
I've killed-off all of my schema, except for one simple table, and ran
So at the very least, the paths I'm giving seem to work fine, as it can transpile the schema + outputs a journal with zero
migrationsmigrations folder, attempted to re-generate migrations, and was met with 0 tables0 tables I've killed-off all of my schema, except for one simple table, and ran
generate:mysqlgenerate:mysql with DEBUGDEBUG;> drizzle-kit "generate:mysql" "--schema" "orm/src/schema" "--out" "orm/migrations"
drizzle-kit: v0.17.1
drizzle-orm: v0.23.2
esbuild-register compiled /home/oyed/sites/teris/orm/src/schema/index.ts +0ms
esbuild-register const __esbuild_register_import_meta_url__ = require('url').pathToFileURL(__filename).href;
var __defProp = Object.defineProperty;
var __getOwnPropDesc = Object.getOwnPropertyDescriptor;
var __getOwnPropNames = Object.getOwnPropertyNames;
var __hasOwnProp = Object.prototype.hasOwnProperty;
var __export = (target, all) => {
for (var name in all)
__defProp(target, name, { get: all[name], enumerable: true });
};
var __copyProps = (to, from, except, desc) => {
if (from && typeof from === "object" || typeof from === "function") {
for (let key of __getOwnPropNames(from))
if (!__hasOwnProp.call(to, key) && key !== except)
__defProp(to, key, { get: () => from[key], enumerable: !(desc = __getOwnPropDesc(from, key)) || desc.enumerable });
}
return to;
};
var __toCommonJS = (mod) => __copyProps(__defProp({}, "__esModule", { value: true }), mod);
var schema_exports = {};
__export(schema_exports, {
guilds: () => guilds
});
module.exports = __toCommonJS(schema_exports);
var import_mysql_core = require("drizzle-orm/mysql-core");
const guilds = (0, import_mysql_core.mysqlTable)("guilds", {
id: (0, import_mysql_core.serial)("id").primaryKey(),
faction_id: (0, import_mysql_core.serial)("faction_id").notNull(),
user_id: (0, import_mysql_core.serial)("user_id").notNull(),
name: (0, import_mysql_core.varchar)("name", { length: 256 }).notNull(),
ticker: (0, import_mysql_core.varchar)("ticker", { length: 3 }).notNull(),
created_at: (0, import_mysql_core.timestamp)("created_at").defaultNow()
}, (table) => ({
factionIdIdx: (0, import_mysql_core.index)("faction_id_idx").on(table.faction_id),
userIdIdx: (0, import_mysql_core.uniqueIndex)("user_id_idx").on(table.user_id),
tickerIdx: (0, import_mysql_core.uniqueIndex)("ticker_idx").on(table.ticker)
}));
//# sourceMappingURL=[redacted so discord will let me post this in-line]
+1ms
0 tables
No schema changes, nothing to migrate 😴> drizzle-kit "generate:mysql" "--schema" "orm/src/schema" "--out" "orm/migrations"
drizzle-kit: v0.17.1
drizzle-orm: v0.23.2
esbuild-register compiled /home/oyed/sites/teris/orm/src/schema/index.ts +0ms
esbuild-register const __esbuild_register_import_meta_url__ = require('url').pathToFileURL(__filename).href;
var __defProp = Object.defineProperty;
var __getOwnPropDesc = Object.getOwnPropertyDescriptor;
var __getOwnPropNames = Object.getOwnPropertyNames;
var __hasOwnProp = Object.prototype.hasOwnProperty;
var __export = (target, all) => {
for (var name in all)
__defProp(target, name, { get: all[name], enumerable: true });
};
var __copyProps = (to, from, except, desc) => {
if (from && typeof from === "object" || typeof from === "function") {
for (let key of __getOwnPropNames(from))
if (!__hasOwnProp.call(to, key) && key !== except)
__defProp(to, key, { get: () => from[key], enumerable: !(desc = __getOwnPropDesc(from, key)) || desc.enumerable });
}
return to;
};
var __toCommonJS = (mod) => __copyProps(__defProp({}, "__esModule", { value: true }), mod);
var schema_exports = {};
__export(schema_exports, {
guilds: () => guilds
});
module.exports = __toCommonJS(schema_exports);
var import_mysql_core = require("drizzle-orm/mysql-core");
const guilds = (0, import_mysql_core.mysqlTable)("guilds", {
id: (0, import_mysql_core.serial)("id").primaryKey(),
faction_id: (0, import_mysql_core.serial)("faction_id").notNull(),
user_id: (0, import_mysql_core.serial)("user_id").notNull(),
name: (0, import_mysql_core.varchar)("name", { length: 256 }).notNull(),
ticker: (0, import_mysql_core.varchar)("ticker", { length: 3 }).notNull(),
created_at: (0, import_mysql_core.timestamp)("created_at").defaultNow()
}, (table) => ({
factionIdIdx: (0, import_mysql_core.index)("faction_id_idx").on(table.faction_id),
userIdIdx: (0, import_mysql_core.uniqueIndex)("user_id_idx").on(table.user_id),
tickerIdx: (0, import_mysql_core.uniqueIndex)("ticker_idx").on(table.ticker)
}));
//# sourceMappingURL=[redacted so discord will let me post this in-line]
+1ms
0 tables
No schema changes, nothing to migrate 😴So at the very least, the paths I'm giving seem to work fine, as it can transpile the schema + outputs a journal with zero
entriesentries under the migrations path