gistfile1.txt

import sqlite3
from optparse import OptionParser

ps2Tables = [
    "libk_player",
    "ps2_itemexpiration",
    "ps2_settings",
    "ps2_plyjoinstreak",
    "ps2_wallet",
    "ps2_itempersistence",
    "ps2_categories",
    "ps2_equipmentslot",
    "ps2_OutfitHatPersistenceMapping",
    "ps2_boosterpersistence",
    "ps2_trailpersistence",
    "inventories",
    "ps2_outfits",
    "ps2_texthatpersistence",
    "ps2_keypersistence",
    "ps2_itemmapping",
    "ps2_instatswitchweaponpersistence",
    "ps2_weaponpersistence",
    "ps2_playermodelpersistence",
    "kinv_items",
    "ps2_cratepersistence",
    "ps2_maskpersistence",
    "ps2_weaponpersistence",
    "ps2_adventcalendaruses",
    "ps2_HatPersistence",
    "ps2_rewarduses",
    "ps2_airdropspots",
    "ps2_servers"
]
def drop_all_not_pointshop_tables(dbname):
    conn = sqlite3.connect(dbname)
    c = conn.cursor()
    names = [x[0] for x in c.execute("select name from sqlite_master where type = 'table';").fetchall()]
    dropNames = [name for name in names if (name not in ps2Tables) and not name.startswith("ps2") and not name.startswith("sqlite")]
    dropStatements = map(lambda name: 'DROP TABLE "{}"'.format(name), dropNames)
    dropped = map(lambda statement: c.execute(statement), dropStatements)

def main():
    op = OptionParser()
    opts, args = op.parse_args()
    drop_all_not_pointshop_tables(args[0])

if __name__ == "__main__":
    main()