script.py

#!/usr/bin/env python

#Copyright Doris Precup
#GPL v2.0

import sys
import os
import shutil
import sqlite3
import subprocess
import string
import platform

filename="equo.db"
new_filename="equo_backup.db"
path="/var/lib/entropy/client/database/"
processor = ""

def check():
    if ( platform.machine() == 'x86_64'):
        print "amd64"
        return "amd64"
    elif ( platform.machine()== 'i686'):
        print "x86"
        return "x86"

def rename(var):
    if ( os.path.isfile(var+filename)==True ):
        print "fine"
        os.rename(var+filename,var+new_filename)
    else:
        print "The given file "+var+filename+" does not exist"

def create_new_file(var):
    with open(var+filename,'a'):
        os.utime(var+filename,None)

def permissions(var):
    subprocess.call("chgrp entropy "+var+filename, shell=True)
    subprocess.call("ls -l "+var+filename,shell=True)  

def insert_sql(var):
    conn = sqlite3.connect(var+filename)
    c = conn.cursor()

    if ( processor =="amd64"):
        c.executescript("""
    BEGIN TRANSACTION;
    CREATE TABLE IF NOT EXISTS baseinfo (
                    idpackage INTEGER PRIMARY KEY AUTOINCREMENT,
                    atom VARCHAR,
                    category VARCHAR,
                    name VARCHAR,
                    version VARCHAR,
                    versiontag VARCHAR,
                    revision INTEGER,
                    branch VARCHAR,
                    slot VARCHAR,
                    license VARCHAR,
                    etpapi INTEGER,
                    trigger INTEGER
                );
    CREATE TABLE IF NOT EXISTS extrainfo (
                    idpackage INTEGER PRIMARY KEY,
                    description VARCHAR,
                    homepage VARCHAR,
                    download VARCHAR,
                    size VARCHAR,
                    chost VARCHAR,
                    cflags VARCHAR,
                    cxxflags VARCHAR,
                    digest VARCHAR,
                    datecreation VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS content (
                    idpackage INTEGER,
                    file VARCHAR,
                    type VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS contentsafety (
                    idpackage INTEGER,
                    file VARCHAR,
                    mtime FLOAT,
                    sha256 VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS provide (
                    idpackage INTEGER,
                    atom VARCHAR,
                    is_default INTEGER DEFAULT 0,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS dependencies (
                    idpackage INTEGER,
                    iddependency INTEGER,
                    type INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS dependenciesreference (
                    iddependency INTEGER PRIMARY KEY AUTOINCREMENT,
                    dependency VARCHAR
                );
    CREATE TABLE IF NOT EXISTS conflicts (
                    idpackage INTEGER,
                    conflict VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS mirrorlinks (
                    mirrorname VARCHAR,
                    mirrorlink VARCHAR
                );
    CREATE TABLE IF NOT EXISTS sources (
                    idpackage INTEGER,
                    idsource INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS sourcesreference (
                    idsource INTEGER PRIMARY KEY AUTOINCREMENT,
                    source VARCHAR
                );
    CREATE TABLE IF NOT EXISTS useflags (
                    idpackage INTEGER,
                    idflag INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS useflagsreference (
                    idflag INTEGER PRIMARY KEY AUTOINCREMENT,
                    flagname VARCHAR
                );
    CREATE TABLE IF NOT EXISTS keywords (
                    idpackage INTEGER,
                    idkeyword INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS keywordsreference (
                    idkeyword INTEGER PRIMARY KEY AUTOINCREMENT,
                    keywordname VARCHAR
                );
    CREATE TABLE IF NOT EXISTS configprotect (
                    idpackage INTEGER PRIMARY KEY,
                    idprotect INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS configprotectmask (
                    idpackage INTEGER PRIMARY KEY,
                    idprotect INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS configprotectreference (
                    idprotect INTEGER PRIMARY KEY AUTOINCREMENT,
                    protect VARCHAR
                );
    CREATE TABLE IF NOT EXISTS systempackages (
                    idpackage INTEGER PRIMARY KEY,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS injected (
                    idpackage INTEGER PRIMARY KEY,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS installedtable (
                    idpackage INTEGER PRIMARY KEY,
                    repositoryname VARCHAR,
                    source INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS sizes (
                    idpackage INTEGER PRIMARY KEY,
                    size INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS counters (
                    counter INTEGER,
                    idpackage INTEGER,
                    branch VARCHAR,
                    PRIMARY KEY(idpackage,branch),
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS trashedcounters (
                    counter INTEGER
                );
    CREATE TABLE IF NOT EXISTS needed_libs (
                    idpackage INTEGER,
                    lib_user_path VARCHAR,
                    lib_user_soname VARCHAR,
                    soname VARCHAR,
                    elfclass INTEGER,
                    rpath VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS provided_libs (
                    idpackage INTEGER,
                    library VARCHAR,
                    path VARCHAR,
                    elfclass INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS treeupdates (
                    repository VARCHAR PRIMARY KEY,
                    digest VARCHAR
                );
    CREATE TABLE IF NOT EXISTS treeupdatesactions (
                    idupdate INTEGER PRIMARY KEY AUTOINCREMENT,
                    repository VARCHAR,
                    command VARCHAR,
                    branch VARCHAR,
                    date VARCHAR
                );
    CREATE TABLE IF NOT EXISTS licensedata (
                    licensename VARCHAR UNIQUE,
                    text BLOB,
                    compressed INTEGER
                );
    CREATE TABLE IF NOT EXISTS licenses_accepted (
                    licensename VARCHAR UNIQUE
                );
    CREATE TABLE IF NOT EXISTS triggers (
                    idpackage INTEGER PRIMARY KEY,
                    data BLOB,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS entropy_misc_counters (
                    idtype INTEGER PRIMARY KEY,
                    counter INTEGER
                );
    CREATE TABLE IF NOT EXISTS categoriesdescription (
                    category VARCHAR,
                    locale VARCHAR,
                    description VARCHAR
                );
    CREATE TABLE IF NOT EXISTS packagesets (
                    setname VARCHAR,
                    dependency VARCHAR
                );
    CREATE TABLE IF NOT EXISTS packagechangelogs (
                    category VARCHAR,
                    name VARCHAR,
                    changelog BLOB,
                    PRIMARY KEY (category, name)
                );
    CREATE TABLE IF NOT EXISTS automergefiles (
                    idpackage INTEGER,
                    configfile VARCHAR,
                    md5 VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagedesktopmime (
                    idpackage INTEGER,
                    name VARCHAR,
                    mimetype VARCHAR,
                    executable VARCHAR,
                    icon VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagedownloads (
                    idpackage INTEGER,
                    download VARCHAR,
                    type VARCHAR,
                    size INTEGER,
                    disksize INTEGER,
                    md5 VARCHAR,
                    sha1 VARCHAR,
                    sha256 VARCHAR,
                    sha512 VARCHAR,
                    gpg BLOB,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS provided_mime (
                    mimetype VARCHAR,
                    idpackage INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagesignatures (
                    idpackage INTEGER PRIMARY KEY,
                    sha1 VARCHAR,
                    sha256 VARCHAR,
                    sha512 VARCHAR,
                    gpg BLOB,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagespmphases (
                    idpackage INTEGER PRIMARY KEY,
                    phases VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagespmrepository (
                    idpackage INTEGER PRIMARY KEY,
                    repository VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS entropy_branch_migration (
                    repository VARCHAR,
                    from_branch VARCHAR,
                    to_branch VARCHAR,
                    post_migration_md5sum VARCHAR,
                    post_upgrade_md5sum VARCHAR,
                    PRIMARY KEY (repository, from_branch, to_branch)
                );
    CREATE TABLE IF NOT EXISTS preserved_libs (
                    library VARCHAR,
                    elfclass INTEGER,
                    path VARCHAR,
                    atom VARCHAR,
                    PRIMARY KEY (library, path, elfclass)
                );
    CREATE TABLE IF NOT EXISTS xpakdata (
                    idpackage INTEGER PRIMARY KEY,
                    data BLOB
                );
    CREATE TABLE IF NOT EXISTS settings (
                    setting_name VARCHAR,
                    setting_value VARCHAR,
                    PRIMARY KEY(setting_name)
                );
    INSERT INTO \"settings\" VALUES('arch','amd64');
    INSERT INTO \"settings\" VALUES('on_delete_cascade', '1');
    INSERT INTO \"settings\" VALUES('_baseinfo_extrainfo_2010', '1');
    INSERT INTO \"settings\" VALUES('schema_revision', '6');
    COMMIT;""")
    
    elif ( processor == "x86") :
        c.executescript("""
    BEGIN TRANSACTION;
    CREATE TABLE IF NOT EXISTS baseinfo (
                    idpackage INTEGER PRIMARY KEY AUTOINCREMENT,
                    atom VARCHAR,
                    category VARCHAR,
                    name VARCHAR,
                    version VARCHAR,
                    versiontag VARCHAR,
                    revision INTEGER,
                    branch VARCHAR,
                    slot VARCHAR,
                    license VARCHAR,
                    etpapi INTEGER,
                    trigger INTEGER
                );
    CREATE TABLE IF NOT EXISTS extrainfo (
                    idpackage INTEGER PRIMARY KEY,
                    description VARCHAR,
                    homepage VARCHAR,
                    download VARCHAR,
                    size VARCHAR,
                    chost VARCHAR,
                    cflags VARCHAR,
                    cxxflags VARCHAR,
                    digest VARCHAR,
                    datecreation VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS content (
                    idpackage INTEGER,
                    file VARCHAR,
                    type VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS contentsafety (
                    idpackage INTEGER,
                    file VARCHAR,
                    mtime FLOAT,
                    sha256 VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS provide (
                    idpackage INTEGER,
                    atom VARCHAR,
                    is_default INTEGER DEFAULT 0,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS dependencies (
                    idpackage INTEGER,
                    iddependency INTEGER,
                    type INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS dependenciesreference (
                    iddependency INTEGER PRIMARY KEY AUTOINCREMENT,
                    dependency VARCHAR
                );
    CREATE TABLE IF NOT EXISTS conflicts (
                    idpackage INTEGER,
                    conflict VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS mirrorlinks (
                    mirrorname VARCHAR,
                    mirrorlink VARCHAR
                );
    CREATE TABLE IF NOT EXISTS sources (
                    idpackage INTEGER,
                    idsource INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS sourcesreference (
                    idsource INTEGER PRIMARY KEY AUTOINCREMENT,
                    source VARCHAR
                );
    CREATE TABLE IF NOT EXISTS useflags (
                    idpackage INTEGER,
                    idflag INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS useflagsreference (
                    idflag INTEGER PRIMARY KEY AUTOINCREMENT,
                    flagname VARCHAR
                );
    CREATE TABLE IF NOT EXISTS keywords (
                    idpackage INTEGER,
                    idkeyword INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS keywordsreference (
                    idkeyword INTEGER PRIMARY KEY AUTOINCREMENT,
                    keywordname VARCHAR
                );
    CREATE TABLE IF NOT EXISTS configprotect (
                    idpackage INTEGER PRIMARY KEY,
                    idprotect INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS configprotectmask (
                    idpackage INTEGER PRIMARY KEY,
                    idprotect INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS configprotectreference (
                    idprotect INTEGER PRIMARY KEY AUTOINCREMENT,
                    protect VARCHAR
                );
    CREATE TABLE IF NOT EXISTS systempackages (
                    idpackage INTEGER PRIMARY KEY,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS injected (
                    idpackage INTEGER PRIMARY KEY,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS installedtable (
                    idpackage INTEGER PRIMARY KEY,
                    repositoryname VARCHAR,
                    source INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS sizes (
                    idpackage INTEGER PRIMARY KEY,
                    size INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS counters (
                    counter INTEGER,
                    idpackage INTEGER,
                    branch VARCHAR,
                    PRIMARY KEY(idpackage,branch),
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS trashedcounters (
                    counter INTEGER
                );
    CREATE TABLE IF NOT EXISTS needed_libs (
                    idpackage INTEGER,
                    lib_user_path VARCHAR,
                    lib_user_soname VARCHAR,
                    soname VARCHAR,
                    elfclass INTEGER,
                    rpath VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS provided_libs (
                    idpackage INTEGER,
                    library VARCHAR,
                    path VARCHAR,
                    elfclass INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS treeupdates (
                    repository VARCHAR PRIMARY KEY,
                    digest VARCHAR
                );
    CREATE TABLE IF NOT EXISTS treeupdatesactions (
                    idupdate INTEGER PRIMARY KEY AUTOINCREMENT,
                    repository VARCHAR,
                    command VARCHAR,
                    branch VARCHAR,
                    date VARCHAR
                );
    CREATE TABLE IF NOT EXISTS licensedata (
                    licensename VARCHAR UNIQUE,
                    text BLOB,
                    compressed INTEGER
                );
    CREATE TABLE IF NOT EXISTS licenses_accepted (
                    licensename VARCHAR UNIQUE
                );
    CREATE TABLE IF NOT EXISTS triggers (
                    idpackage INTEGER PRIMARY KEY,
                    data BLOB,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS entropy_misc_counters (
                    idtype INTEGER PRIMARY KEY,
                    counter INTEGER
                );
    CREATE TABLE IF NOT EXISTS categoriesdescription (
                    category VARCHAR,
                    locale VARCHAR,
                    description VARCHAR
                );
    CREATE TABLE IF NOT EXISTS packagesets (
                    setname VARCHAR,
                    dependency VARCHAR
                );
    CREATE TABLE IF NOT EXISTS packagechangelogs (
                    category VARCHAR,
                    name VARCHAR,
                    changelog BLOB,
                    PRIMARY KEY (category, name)
                );
    CREATE TABLE IF NOT EXISTS automergefiles (
                    idpackage INTEGER,
                    configfile VARCHAR,
                    md5 VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagedesktopmime (
                    idpackage INTEGER,
                    name VARCHAR,
                    mimetype VARCHAR,
                    executable VARCHAR,
                    icon VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagedownloads (
                    idpackage INTEGER,
                    download VARCHAR,
                    type VARCHAR,
                    size INTEGER,
                    disksize INTEGER,
                    md5 VARCHAR,
                    sha1 VARCHAR,
                    sha256 VARCHAR,
                    sha512 VARCHAR,
                    gpg BLOB,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS provided_mime (
                    mimetype VARCHAR,
                    idpackage INTEGER,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagesignatures (
                    idpackage INTEGER PRIMARY KEY,
                    sha1 VARCHAR,
                    sha256 VARCHAR,
                    sha512 VARCHAR,
                    gpg BLOB,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagespmphases (
                    idpackage INTEGER PRIMARY KEY,
                    phases VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS packagespmrepository (
                    idpackage INTEGER PRIMARY KEY,
                    repository VARCHAR,
                    FOREIGN KEY(idpackage)
                        REFERENCES baseinfo(idpackage) ON DELETE CASCADE
                );
    CREATE TABLE IF NOT EXISTS entropy_branch_migration (
                    repository VARCHAR,
                    from_branch VARCHAR,
                    to_branch VARCHAR,
                    post_migration_md5sum VARCHAR,
                    post_upgrade_md5sum VARCHAR,
                    PRIMARY KEY (repository, from_branch, to_branch)
                );
    CREATE TABLE IF NOT EXISTS preserved_libs (
                    library VARCHAR,
                    elfclass INTEGER,
                    path VARCHAR,
                    atom VARCHAR,
                    PRIMARY KEY (library, path, elfclass)
                );
    CREATE TABLE IF NOT EXISTS xpakdata (
                    idpackage INTEGER PRIMARY KEY,
                    data BLOB
                );
    CREATE TABLE IF NOT EXISTS settings (
                    setting_name VARCHAR,
                    setting_value VARCHAR,
                    PRIMARY KEY(setting_name)
                );
    INSERT INTO \"settings\" VALUES('arch','x86');
    INSERT INTO \"settings\" VALUES('on_delete_cascade', '1');
    INSERT INTO \"settings\" VALUES('_baseinfo_extrainfo_2010', '1');
    INSERT INTO \"settings\" VALUES('schema_revision', '6');
    COMMIT;""")

    c.close()
    conn.close()

def rescue():
    subprocess.call("equo rescue spmsync",shell=True)

processor=check()
path+=processor+"/"
rename(path)
create_new_file(path)
permissions(path)
insert_sql(path)
rescue()