← All changes | src/TestData/Framework/MetaRepository.php +34 -38 4.16.4 → 2.11.0 View file →

		@@ -1,51 +1,47 @@
1	1	<?php
2	2
3	3	namespace Give\TestData\Framework;
4	4
5		-class MetaRepository
6		-{
	5	+class MetaRepository {
7	6
8		- /** @var string */
9		- protected $tableName;
	7	+ /** @var string */
	8	+ protected $tableName;
10	9
11		- /** @var string */
12		- protected $relationshipColumnName;
	10	+ /** @var string */
	11	+ protected $relationshipColumnName;
13	12
14		- /**
15		- * @param string $relationshipColumnName
16		- */
17		- public function __construct($tableName, $relationshipColumnName)
18		- {
19		- global $wpdb;
20		- $this->wpdb = $wpdb;
21		- $this->tableName = $wpdb->prefix . $tableName;
22		- $this->relationshipColumnName = $relationshipColumnName;
23		- }
	13	+ /**
	14	+ * @param string $relationshipColumnName
	15	+ */
	16	+ public function __construct( $tableName, $relationshipColumnName ) {
	17	+ global $wpdb;
	18	+ $this->wpdb = $wpdb;
	19	+ $this->tableName = $wpdb->prefix . $tableName;
	20	+ $this->relationshipColumnName = $relationshipColumnName;
	21	+ }
24	22
25		- public function persist($relationshipID, $metaData)
26		- {
27		- $values = array_map(
28		- function ($metaKey, $metaValue) use ($relationshipID) {
29		- return sprintf("( %s, '%s', '%s' )", $relationshipID, esc_sql($metaKey), esc_sql($metaValue));
30		- },
31		- array_keys($metaData),
32		- $metaData
33		- );
	23	+ public function persist( $relationshipID, $metaData ) {
34	24
35		- $this->wpdb->query(
36		- $this->getSql($values)
37		- );
38		- }
	25	+ $values = array_map(
	26	+ function ( $metaKey, $metaValue ) use ( $relationshipID ) {
	27	+ return sprintf( "( %s, '%s', '%s' )", $relationshipID, esc_sql( $metaKey ), esc_sql( $metaValue ) );
	28	+ },
	29	+ array_keys( $metaData ),
	30	+ $metaData
	31	+ );
39	32
40		- protected function getSql($values)
41		- {
42		- $format = "INSERT INTO $this->tableName {$this->getColumns()} VALUES %s";
	33	+ $this->wpdb->query(
	34	+ $this->getSql( $values )
	35	+ );
	36	+ }
43	37
44		- return sprintf($format, implode(',', $values));
45		- }
	38	+ protected function getSql( $values ) {
	39	+ $format = "INSERT INTO $this->tableName {$this->getColumns()} VALUES %s";
46	40
47		- protected function getColumns()
48		- {
49		- return sprintf('( %s, meta_key, meta_value )', $this->relationshipColumnName);
50		- }
	41	+ return sprintf( $format, implode( ',', $values ) );
	42	+ }
	43	+
	44	+ protected function getColumns() {
	45	+ return sprintf( '( %s, meta_key, meta_value )', $this->relationshipColumnName );
	46	+ }
51	47	}