[Python + PHP] Insert Datas

한 번에 여러 개의 데이터 셋을 DB서버로 보내서 정해진 테이블에 데이터들을 저장하도록 하는 프로그램 소스 코드

 

[Python Source]

		uploadedItems = []
		for itemCode in itemCodes_S:
			data1 = self.ItemList_D[self.ItemList_D['ItemCode'] == itemCode]
			if not data1.empty: continue
			itemInfo = self.FindItem_d(itemCode, itemList)
			if not itemInfo: continue
			uploadData1 = {
                'ItemCode': itemInfo['ItemCode'],
                'ItemName': itemInfo['ItemName'],
                'DDate': datename0,
                'DataType': 'ba00',
                'Data0': itemInfo['StockCount'],
                #'Data1': itemInfo['listedDate']
            }
			print("Uploading daily data ........................\n", uploadData1)
			uploadedItems.append(uploadData1)

		if not uploadedItems: return None
		if len(uploadedItems) < 1: return None
		tableName = self.GetTablename(itemInfo['Market'])
		param1 = {
			'RequestType': 'InsertDailyData',
			'Tablename': tableName,
			'Datas': json.dumps(uploadedItems)
		}
		res1 = requests.post(self.ServerURL, headers=self.RequestHeader, data=param1, timeout=self.RequestTimeout)

[PHP Source]

		case 'InsertTradeData':
			echo "Inserting DailyData ...<br>";
			$Datas = $_POST['Datas'];
			$DatasJ = json_decode($Datas, true);
			$count1 = 0;
			foreach($DatasJ as $data1){
				$TD1 = new cTradeData();
				$TD1->SetValuesbyJSON($data1);
				$TD1->InsertData($conn0);
				$count1++;
			}
			echo "Insertion succeeded : ".$count1;
			break;