public static function getMedoo() { if (self::$medoo == null) { $params = (require_once BASE_PATH . '/data/db.inc.php'); self::$medoo = new medoo($params); } return self::$medoo; }
public function import_data($qid, $title, $content, $createtime, $reply1, $reply2, $department, $age, $sex, $tableName) { $insertID = 0; $sexInt = 0; $sexInt = $sex == '' ? 0 : ($sex == '男' ? 1 : 2); $datas = array('qid' => $qid, 'title' => $title, 'content' => $content, 'ctime' => $createtime, 'reply1' => trim($reply1), 'reply2' => trim($reply2), 'department' => $department, 'age' => $age, 'sex' => $sexInt); //$insertID = $this->medoo->insert("wd_120answer", $datas); $insertID = Medoos::getMedoo()->insert($tableName, $datas); //$insertID = Medoos::getMedoo()->insert("wd_xyanswer", $datas); //$insertID = $this->medoo->insert("wd_xyanswer", $datas); return $insertID; }
<?php defined("CURRENT_PATH") or define("CURRENT_PATH", dirname(__FILE__)); require_once CURRENT_PATH . '/MatchData.php'; require_once CURRENT_PATH . '/Medoos.php'; require_once CURRENT_PATH . '/SNSMedoos.php'; require_once CURRENT_PATH . '/special_handler/BJPSpecialHandle.php'; //初始化 $testMedoo 数据库连接对象 $testMedoo = Medoos::getMedoo(); //初始化 $snsMedoo 数据库连接对象 $snsMedoo = SNSMedoos::getMedoo(); $wdKeshiTable = "wd_120answer_keshi"; //$wdKeshiTable = "wd_xyanswer_keshi"; //$wdKeshiTable = "wd_xyanswer_keshi"; $matchData = new MatchData($testMedoo, $snsMedoo, $wdKeshiTable); //心理诊所 => 心理科 特殊关键词处理操作 //$specialHandle = new BJPSpecialHandle(); //$matchData->addSpecialHandle($specialHandle); $seconds = 0; $count = 62; for ($i = 1; $i <= $count; $i++) { $num = 1000; $isEnd = $matchData->matchData($num); sleep($seconds); if ($isEnd) { break; } }
/** * 得到提问问题集 * @author gaoqing * @date 2016-08-11 * @param string $table_name 表名 * @param array $conditions 查询条件 * @return array 提问问题集 */ function get_tiwen_datas($table_name, $conditions) { $db = Medoos::getMedoo(); return $db->select($table_name, ['id', 'department'], $conditions); }
function executeImport() { require_once CURRENT_PATH . '/Medoos.php'; $medoo = Medoos::getMedoo(); //1、从 wd_120answer_keshi 中,获取指定数量 ($num = 1000 )的问答信息 $initAskArr $num = 1000; $preInsertCount = 50; $sleepSeconds = 1; $importCount = 0; $count = 30; for ($k = 0; $k < $count; $k++) { $initAskArr = getInitAsk($medoo, $num); if (!empty($initAskArr)) { //2、循环 $initAskArr 中的问答信息,匹配插入到 wd_120answer_temp 表中 $importCount += importData($initAskArr, $preInsertCount, $medoo, $sleepSeconds); } else { break; } } return $importCount; }