DT
Drizzle Team•2w ago
phasenull

pushSQLiteSchema with force parameter?

im trying to use pushSQliteSchema function (imported from drizzle-kit/api) but when it tries to push changes i get a warning regarding data loss, which makes sense but is there any way i can skip those warnings and just push my schema (i know its a terrible idea but dont worry about it)?
No description
1 Reply
phasenull
phasenullOP•2w ago
logs in txt 
[⣷] Pulling schema from database...
[✓] Pulling schema from database...
db push result {"hasDataLoss":true,"warnings":["· You're about to delete \u001b[4mbot_config\u001b[24m table with 14 items","· You're about to delete \u001b[4mdatabases\u001b[24m table with 62 items","· You're about to delete \u001b[4mgames\u001b[24m table with 1 items","· You're about to delete \u001b[4mguilds\u001b[24m table with 2 items","· You're about to delete \u001b[4mcommand_logs\u001b[24m table with 93 items","· You're about to delete \u001b[4mbot_logs\u001b[24m table with 17682 items"],"statementsToExecute":["DROP TABLE `bot_config`;","DROP TABLE `cases`;","DROP TABLE `databases`;","DROP TABLE `games`;","DROP TABLE `guilds`;","DROP TABLE `command_logs`;","DROP TABLE `news`;","DROP TABLE `permissions`;","DROP TABLE `transactions`;","DROP TABLE `item_rarities`;","DROP TABLE `bot_logs`;"]}
[⣷] Pulling schema from database...
[✓] Pulling schema from database...
db push result {"hasDataLoss":true,"warnings":["· You're about to delete \u001b[4mbot_config\u001b[24m table with 14 items","· You're about to delete \u001b[4mdatabases\u001b[24m table with 62 items","· You're about to delete \u001b[4mgames\u001b[24m table with 1 items","· You're about to delete \u001b[4mguilds\u001b[24m table with 2 items","· You're about to delete \u001b[4mcommand_logs\u001b[24m table with 93 items","· You're about to delete \u001b[4mbot_logs\u001b[24m table with 17682 items"],"statementsToExecute":["DROP TABLE `bot_config`;","DROP TABLE `cases`;","DROP TABLE `databases`;","DROP TABLE `games`;","DROP TABLE `guilds`;","DROP TABLE `command_logs`;","DROP TABLE `news`;","DROP TABLE `permissions`;","DROP TABLE `transactions`;","DROP TABLE `item_rarities`;","DROP TABLE `bot_logs`;"]}
code used to push schemas 
const push_result = pushSQLiteSchema({ schema }, db).then((result) => {
    console.log("db push result", JSON.stringify(result))
})
const push_result = pushSQLiteSchema({ schema }, db).then((result) => {
    console.log("db push result", JSON.stringify(result))
})
nvm i just created a backdoor on my discord bot hosting service but still it'd be helpful if i get a response

Did you find this page helpful?