Example #1
0
<?php

if (strtolower(basename(__DIR__)) === 'powerorm') {
    require 'Application.php';
} else {
    require __DIR__ . '/application/libraries/powerorm/Application.php';
}
Application::consoleRun(['baseDir' => __DIR__]);
     * @param int $campaignId
     * @param int $userId
     * @param string $giftbagCode
     */
    private function insertMapping($campaignId, $userId, $giftbagCode)
    {
        $campaignId = (int) $campaignId;
        $userId = (int) $userId;
        $giftbagCode = addslashes($giftbagCode);
        $this->mappingValues[] = "{$campaignId},{$userId},'{$giftbagCode}'";
        if (count($this->mappingValues) > 1000) {
            $this->insertMappingFlush();
        }
    }
    /**
     * 批量插入 giftbag code - campaign - user的mapping的最终操作
     */
    private function insertMappingFlush()
    {
        if (empty($this->mappingValues) == false) {
            $db = DatabaseFactory::open();
            $db->createCommand('
				INSERT INTO g_campaign_mapping_giftbag (campaignId,userId, giftbagCode)
				VALUES (' . implode('),(', $this->mappingValues) . ')
			')->execute();
            $this->mappingValues = array();
        }
    }
}
Application::consoleRun();