redis_import_dict.php 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. <?php
  2. require_once "../path.php";
  3. require_once "../install/filelist.php";
  4. require_once "../redis/function.php";
  5. if (PHP_SAPI == "cli") {
  6. if ($argc >= 2) {
  7. $list = $argv[1];
  8. $redis = redis_connect();
  9. if ($redis == false) {
  10. echo "no redis connect\n";
  11. exit;
  12. }
  13. $count=0;
  14. $taskList = json_decode(file_get_contents(__DIR__."/".$list));
  15. $dir = dirname(__DIR__."/".$list);
  16. foreach ($taskList as $key => $task) {
  17. # code...
  18. $redis->del($task->rediskey);
  19. foreach ($task->csv as $csv) {
  20. $csvfile = $dir."/".$csv;
  21. if (($fp = fopen($csvfile, "r")) !== false) {
  22. echo "单词表load {$csvfile}\n";
  23. while (($data = fgets($fp)) !== false) {
  24. $data1 = explode(",",$data);
  25. if(count($data1)>1){
  26. $old = $redis->hGet($task->rediskey,$data1[$task->keycol]);
  27. $new = array();
  28. if($old){
  29. $new = json_decode($old,true);
  30. array_push($new,$data1);
  31. }
  32. else{
  33. $new[] = $data1;
  34. }
  35. $redis->hSet($task->rediskey,$data1[$task->keycol],json_encode($new, JSON_UNESCAPED_UNICODE));
  36. }
  37. $count++;
  38. if($count%10000==0){
  39. sleep(1);
  40. echo $count."\n";
  41. }
  42. }
  43. fclose($fp);
  44. } else {
  45. echo "can not open csv file. ";
  46. }
  47. }
  48. }
  49. }
  50. }
  51. ?>