[mirrors/SokoMan.git] / assistants / migrations.inc.php

<pre>
<h1>-- populate barcode table</h1><?php
$data = $this->db->safe_query_fetch('SELECT model_id as id, model_barcode as bar FROM model;');
//print_r($data);
echo("UPDATE item SET barcode_id=model_id;\n");
echo("INSERT INTO barcode (barcode_id,model_id,barcode_name) VALUES\n");
foreach($data as $line) echo("('".$line['id']."','".$line['id']."','".$line['bar']."'),\n");
?>
<h1>-- populate columns item_date_bought and item_date_sold</h1><?php
$data = $this->db->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS min,MAX(item_valid_from) AS max FROM item GROUP BY item_id;');
//print_r($data);
echo("START TRANSACTION;\n");
foreach($data as $line) echo("UPDATE item SET item_date_bought='".$line['min']."',item_date_sold='".$line['max']."' WHERE item_id=".$line['item_id'].";\n");
echo("COMMIT;\n");
?>
</pre>
Commit	Line	Data
a12d11db	1	<pre>
ea921a95 TM	2	<h1>-- populate barcode table</h1><?php
	3	$data = $this->db->safe_query_fetch('SELECT model_id as id, model_barcode as bar FROM model;');
	4	//print_r($data);
	5	echo("UPDATE item SET barcode_id=model_id;\n");
	6	echo("INSERT INTO barcode (barcode_id,model_id,barcode_name) VALUES\n");
	7	foreach($data as $line) echo("('".$line['id']."','".$line['id']."','".$line['bar']."'),\n");
	8	?>
f7740b1c	9	<h1>-- populate columns item_date_bought and item_date_sold</h1><?php
a12d11db	10	$data = $this->db->safe_query_fetch('SELECT item_id,MIN(item_valid_from) AS min,MAX(item_valid_from) AS max FROM item GROUP BY item_id;');
79cc0871 TM	11	//print_r($data);
79cc0871 TM	12	echo("START TRANSACTION;\n");
a12d11db	13	foreach($data as $line) echo("UPDATE item SET item_date_bought='".$line['min']."',item_date_sold='".$line['max']."' WHERE item_id=".$line['item_id'].";\n");
79cc0871	14	echo("COMMIT;\n");
a12d11db	15	?>
f7740b1c	16	</pre>