Exemplo n.º 1
0
    create_tables($sqlite_db);
    setup_params($sqlite_db, $date, "FULL");
    $sqlite_db->query("DROP TABLE tables");
    $sqlite_db->query("DROP TABLE dir0");
    $sqlite_db->query("DROP TABLE ref0");
    $sqlite_db->query("CREATE TABLE dir0(code INTEGER PRIMARY KEY, name, info, parent INTEGER NOT NULL)");
    $sqlite_db->query("CREATE TABLE ref0(code INTEGER, book INTEGER, PRIMARY KEY(code, book))");
    $sqlite_db->query("CREATE INDEX dir0_parent ON dir0(parent)");
    $sqlite_db->query("CREATE INDEX ref0_book ON ref0(book)");
    $sqlite_db->query("CREATE TABLE tables(id INTEGER PRIMARY KEY AUTOINCREMENT,title,\n\tdir_file,dir_data,dir_type,dir_code,dir_name,dir_info,dir_prnt,\n\tref_file,ref_data,ref_type,ref_code,ref_book,fb2_code)");
    $sqlite_db->query("INSERT INTO tables(title,dir_data,dir_type,dir_code,dir_name,dir_prnt,ref_data,ref_type,ref_code,ref_book)\n\tVALUES ('Тематический рубрикатор','dir0','INTEGER','code','name','parent','ref0','id','code','book')");
    convert_books($mysql_db, $sqlite_db);
    convert_auth($mysql_db, $sqlite_db);
    convert_dates($mysql_db, $sqlite_db);
    convert_topics($mysql_db, $sqlite_db);
    create_indexes($sqlite_db);
}
$mysql_srvr = 'localhost';
$mysql_user = '******';
$mysql_pass = '******';
$mysql_base = 'bookwarrior';
$sqlitefile = 'myrulib.db';
include 'settings.php';
$sqlite_db = new PDO('sqlite:./myrulib.db');
$mysql_db = new mysqli($mysql_srvr, $mysql_user, $mysql_pass, $mysql_base);
$mysql_db->query("SET NAMES utf8");
$date = date('Ymd');
echo "Today: " . $date . "\n";
InitDatabase($mysql_db);
FullImport($mysql_db, $sqlitefile, $date);
system("zip genesis.db.zip {$sqlitefile}");
Exemplo n.º 2
0
    $sqlite_db->query("INSERT INTO params(id,text)  VALUES (21, '{$type}');");
    $sqlite_db->query("commit;");
}
function FullImport($file, $date)
{
    $sqlite_db = new PDO('sqlite:./' . $file);
    create_tables($sqlite_db);
    setup_params($sqlite_db, $date, "FULL");
    convert_auth($sqlite_db, 0);
    convert_book($sqlite_db, 0);
    convert_seqn($sqlite_db, 0);
    convert_date($sqlite_db, 0);
    convert_genr($sqlite_db, 0);
    convert_info($sqlite_db, 0);
    create_indexes($sqlite_db);
    /*
      convert_sequences($mysql_db, $sqlite_db, 0);
      convert_dates($mysql_db, $sqlite_db, 0);
      
      convert_zips($mysql_db, $sqlite_db, 0);
      convert_files($mysql_db, $sqlite_db, 0, 0);
    */
}
$sqlitefile = 'myrulib.db';
$date = date('Ymd');
echo "Today: " . $date . "\n";
system("rm {$sqlitefile}");
$sqlite_db = new PDO('sqlite:' . $sqlitefile);
FullImport($sqlitefile, $date);
system("rm traumepub.db.zip");
system("zip traumepub.db.zip {$sqlitefile}");