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}");
$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}");