@@ -42,7 +42,7 @@ |
||
42 | 42 | } |
43 | 43 | foreach (self::$events[$eventname] as $key => $weight) { |
44 | 44 | foreach ($weight as $callback) { |
45 | - call_user_func_array($callback, $params); |
|
45 | + call_user_func_array($callback, $params); |
|
46 | 46 | } |
47 | 47 | } |
48 | 48 |
@@ -133,7 +133,7 @@ |
||
133 | 133 | try { |
134 | 134 | $this->getTable($table_name); |
135 | 135 | return true; |
136 | - }catch(TableDoesNotExist $e){ |
|
136 | + } catch(TableDoesNotExist $e){ |
|
137 | 137 | return false; |
138 | 138 | } |
139 | 139 | } |
@@ -69,16 +69,16 @@ discard block |
||
69 | 69 | { |
70 | 70 | $table = new Table($model->getName()); |
71 | 71 | if ($this->isUsingUUID) { |
72 | - $table->addColumn('id', 'string', ['length' => 36, 'notnull' => true,'comment' => 'string']); |
|
72 | + $table->addColumn('id', 'string', ['length' => 36, 'notnull' => true, 'comment' => 'string']); |
|
73 | 73 | } else { |
74 | - $table->addColumn('id', 'integer', ['unsigned' => true, 'autoincrement' => true,'comment' => 'integer']); |
|
74 | + $table->addColumn('id', 'integer', ['unsigned' => true, 'autoincrement' => true, 'comment' => 'integer']); |
|
75 | 75 | } |
76 | 76 | $table->setPrimaryKey(array("id")); |
77 | 77 | $types = $model->getTypes(); |
78 | 78 | foreach ($model->getProperties() as $key => $value) { |
79 | 79 | if ($key != 'id') { |
80 | 80 | |
81 | - $table->addColumn($key,$types[$key] , ['notnull' => false, 'comment' => $types[$key]]); |
|
81 | + $table->addColumn($key, $types[$key], ['notnull' => false, 'comment' => $types[$key]]); |
|
82 | 82 | } |
83 | 83 | } |
84 | 84 | return $table; |
@@ -129,7 +129,7 @@ discard block |
||
129 | 129 | try { |
130 | 130 | $this->getTable($table_name); |
131 | 131 | return true; |
132 | - }catch(TableDoesNotExist $e){ |
|
132 | + } catch (TableDoesNotExist $e) { |
|
133 | 133 | return false; |
134 | 134 | } |
135 | 135 | } |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | public static function connect(array $connectionParams): DB |
27 | 27 | { |
28 | 28 | |
29 | - $connection =new Connection($connectionParams); |
|
29 | + $connection = new Connection($connectionParams); |
|
30 | 30 | self::$database = new DB($connection); |
31 | 31 | return self::$database; |
32 | 32 | |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | * @param mixed $id |
68 | 68 | * @return \Scrawler\Arca\Model |
69 | 69 | */ |
70 | - public static function getOne(string $table, mixed $id): Model|null |
|
70 | + public static function getOne(string $table, mixed $id): Model | null |
|
71 | 71 | { |
72 | 72 | return self::getDB()->getOne($table, $id); |
73 | 73 | } |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | * @param string $sql |
78 | 78 | * @return int|numeric-string |
79 | 79 | */ |
80 | - public static function exec(string $sql): int|string |
|
80 | + public static function exec(string $sql): int | string |
|
81 | 81 | { |
82 | 82 | return self::getDB()->exec($sql); |
83 | 83 | } |
@@ -69,16 +69,16 @@ |
||
69 | 69 | } |
70 | 70 | |
71 | 71 | /** |
72 | - * Get single record by id |
|
73 | - * @param string $table |
|
74 | - * @param mixed $id |
|
75 | - */ |
|
72 | + * Get single record by id |
|
73 | + * @param string $table |
|
74 | + * @param mixed $id |
|
75 | + */ |
|
76 | 76 | public function getById(string $table, mixed $id): Model|null |
77 | 77 | { |
78 | 78 | $query = (new QueryBuilder($this->connection,$this->modelManager)) |
79 | - ->select('*') |
|
80 | - ->from($table, 't') |
|
81 | - ->where("t.id = '".$id."'"); |
|
79 | + ->select('*') |
|
80 | + ->from($table, 't') |
|
81 | + ->where("t.id = '".$id."'"); |
|
82 | 82 | return $query->first(); |
83 | 83 | } |
84 | 84 |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | /** |
23 | 23 | * Create RecordManager |
24 | 24 | */ |
25 | - public function __construct(Connection $connection, ModelManager $modelManager,bool $isUsingUUID = false) |
|
25 | + public function __construct(Connection $connection, ModelManager $modelManager, bool $isUsingUUID = false) |
|
26 | 26 | { |
27 | 27 | $this->connection = $connection; |
28 | 28 | $this->isUsingUUID = $isUsingUUID; |
@@ -37,7 +37,7 @@ discard block |
||
37 | 37 | public function insert(Model $model) : mixed |
38 | 38 | { |
39 | 39 | if ($this->isUsingUUID) { |
40 | - $model->set('id',UUID::uuid4()->toString()); |
|
40 | + $model->set('id', UUID::uuid4()->toString()); |
|
41 | 41 | } |
42 | 42 | $this->connection->insert($model->getName(), $model->getProperties()); |
43 | 43 | if ($this->isUsingUUID) { |
@@ -73,9 +73,9 @@ discard block |
||
73 | 73 | * @param string $table |
74 | 74 | * @param mixed $id |
75 | 75 | */ |
76 | - public function getById(string $table, mixed $id): Model|null |
|
76 | + public function getById(string $table, mixed $id): Model | null |
|
77 | 77 | { |
78 | - $query = (new QueryBuilder($this->connection,$this->modelManager)) |
|
78 | + $query = (new QueryBuilder($this->connection, $this->modelManager)) |
|
79 | 79 | ->select('*') |
80 | 80 | ->from($table, 't') |
81 | 81 | ->where("t.id = '".$id."'"); |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | */ |
90 | 90 | public function getAll(string $tableName): Collection |
91 | 91 | { |
92 | - return (new QueryBuilder($this->connection,$this->modelManager)) |
|
92 | + return (new QueryBuilder($this->connection, $this->modelManager)) |
|
93 | 93 | ->select('*') |
94 | 94 | ->from($tableName, 't') |
95 | 95 | ->get(); |
@@ -101,7 +101,7 @@ discard block |
||
101 | 101 | */ |
102 | 102 | public function find(String $name) : QueryBuilder |
103 | 103 | { |
104 | - return (new QueryBuilder($this->connection,$this->modelManager)) |
|
104 | + return (new QueryBuilder($this->connection, $this->modelManager)) |
|
105 | 105 | ->select('*') |
106 | 106 | ->from($name, 't'); |
107 | 107 | } |
@@ -33,7 +33,7 @@ |
||
33 | 33 | */ |
34 | 34 | function setConnection(Connection $connection): void |
35 | 35 | { |
36 | - $this->connection = $connection; |
|
36 | + $this->connection = $connection; |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | } |
40 | 40 | \ No newline at end of file |
@@ -24,7 +24,7 @@ |
||
24 | 24 | */ |
25 | 25 | function create(string $name): Model |
26 | 26 | { |
27 | - return new Model($name,$this->connection); |
|
27 | + return new Model($name, $this->connection); |
|
28 | 28 | } |
29 | 29 | |
30 | 30 | /** |
@@ -15,12 +15,12 @@ discard block |
||
15 | 15 | /** |
16 | 16 | * @var array<string> |
17 | 17 | */ |
18 | - private array $relations= []; |
|
18 | + private array $relations = []; |
|
19 | 19 | |
20 | 20 | private AbstractSchemaManager $SchemaManager; |
21 | 21 | private ModelManager $modelManager; |
22 | 22 | |
23 | - public function __construct(\Doctrine\DBAL\Connection $connection,ModelManager $modelManager) |
|
23 | + public function __construct(\Doctrine\DBAL\Connection $connection, ModelManager $modelManager) |
|
24 | 24 | { |
25 | 25 | $this->modelManager = $modelManager; |
26 | 26 | $this->SchemaManager = $connection->createSchemaManager(); |
@@ -36,12 +36,12 @@ discard block |
||
36 | 36 | public function from($table, $alias = null): QueryBuilder |
37 | 37 | { |
38 | 38 | $this->table = $table; |
39 | - return parent::from($table,$alias); |
|
39 | + return parent::from($table, $alias); |
|
40 | 40 | } |
41 | 41 | |
42 | 42 | public function get(): Collection |
43 | 43 | { |
44 | - if(!$this->SchemaManager->tableExists($this->table)){ |
|
44 | + if (!$this->SchemaManager->tableExists($this->table)) { |
|
45 | 45 | return Collection::fromIterable([]); |
46 | 46 | } |
47 | 47 | $model = $this->modelManager->create($this->table); |
@@ -55,9 +55,9 @@ discard block |
||
55 | 55 | ->map(static fn($value): Model => ($model)->setLoadedProperties($value)->with($relations)->setLoaded()); |
56 | 56 | } |
57 | 57 | |
58 | - public function first(): Model|null |
|
58 | + public function first(): Model | null |
|
59 | 59 | { |
60 | - if(!$this->SchemaManager->tableExists($this->table)){ |
|
60 | + if (!$this->SchemaManager->tableExists($this->table)) { |
|
61 | 61 | return null; |
62 | 62 | } |
63 | 63 | $relations = $this->relations; |
@@ -59,10 +59,10 @@ discard block |
||
59 | 59 | */ |
60 | 60 | public function registerEvents(): void |
61 | 61 | { |
62 | - Event::subscribeTo('__arca.model.save.'.$this->connection->getConnectionId(), function ($model) { |
|
62 | + Event::subscribeTo('__arca.model.save.'.$this->connection->getConnectionId(), function($model) { |
|
63 | 63 | return $this->save($model); |
64 | 64 | }); |
65 | - Event::subscribeTo('__arca.model.delete.'.$this->connection->getConnectionId(), function ($model) { |
|
65 | + Event::subscribeTo('__arca.model.delete.'.$this->connection->getConnectionId(), function($model) { |
|
66 | 66 | return $this->delete($model); |
67 | 67 | }); |
68 | 68 | } |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | * @param array<mixed> $params |
75 | 75 | * @return int|numeric-string |
76 | 76 | */ |
77 | - public function exec(string $sql, array $params=array()): int|string |
|
77 | + public function exec(string $sql, array $params = array()): int | string |
|
78 | 78 | { |
79 | 79 | return $this->connection->executeStatement($sql, $params); |
80 | 80 | } |
@@ -86,7 +86,7 @@ discard block |
||
86 | 86 | * @param array<mixed> $params |
87 | 87 | * @return array<int,array<string,mixed>> |
88 | 88 | */ |
89 | - public function getAll(string $sql, array $params=[]): array |
|
89 | + public function getAll(string $sql, array $params = []): array |
|
90 | 90 | { |
91 | 91 | return $this->connection->executeQuery($sql, $params)->fetchAllAssociative(); |
92 | 92 | } |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | |
120 | 120 | try { |
121 | 121 | $id = $this->createRecords($model); |
122 | - $model->set('id',$id); |
|
122 | + $model->set('id', $id); |
|
123 | 123 | $model->setLoaded(); |
124 | 124 | $this->connection->commit(); |
125 | 125 | } catch (\Exception $e) { |
@@ -293,7 +293,7 @@ discard block |
||
293 | 293 | * @param mixed $id |
294 | 294 | * @return Model |
295 | 295 | */ |
296 | - public function getOne(string $table, mixed $id) : Model|null |
|
296 | + public function getOne(string $table, mixed $id) : Model | null |
|
297 | 297 | { |
298 | 298 | return $this->connection->getRecordManager()->getById($table, $id); |
299 | 299 | } |
@@ -45,7 +45,7 @@ discard block |
||
45 | 45 | * @param string $name |
46 | 46 | * @param Connection $connection |
47 | 47 | */ |
48 | - public function __construct(string $name,Connection $connection) |
|
48 | + public function __construct(string $name, Connection $connection) |
|
49 | 49 | { |
50 | 50 | |
51 | 51 | $this->table = $name; |
@@ -117,12 +117,12 @@ discard block |
||
117 | 117 | ($val) ? $val = 1 : $val = 0; |
118 | 118 | } |
119 | 119 | |
120 | - if($type == 'array' || $type == 'object'){ |
|
120 | + if ($type == 'array' || $type == 'object') { |
|
121 | 121 | $val = Type::getType('json_document')->convertToDatabaseValue($val, $this->connection->getDatabasePlatform()); |
122 | 122 | $type = 'json_document'; |
123 | 123 | } |
124 | 124 | |
125 | - if($type == 'string'){ |
|
125 | + if ($type == 'string') { |
|
126 | 126 | $type = 'text'; |
127 | 127 | } |
128 | 128 | |
@@ -166,20 +166,20 @@ discard block |
||
166 | 166 | $parts = \Safe\preg_split('/(?=[A-Z])/', $key, -1, PREG_SPLIT_NO_EMPTY); |
167 | 167 | if (strtolower($parts[0]) == 'own') { |
168 | 168 | if (strtolower($parts[2]) == 'list') { |
169 | - return $this->connection->getRecordManager()->find(strtolower($parts[1]))->where($this->getName() . '_id = "' . $this->__meta['id'] . '"')->get(); |
|
169 | + return $this->connection->getRecordManager()->find(strtolower($parts[1]))->where($this->getName().'_id = "'.$this->__meta['id'].'"')->get(); |
|
170 | 170 | } |
171 | 171 | } |
172 | 172 | if (strtolower($parts[0]) == 'shared') { |
173 | 173 | if (strtolower($parts[2]) == 'list') { |
174 | - $rel_table = $this->connection->getTableManager()->tableExists($this->table . '_' . strtolower($parts[1])) ? $this->table . '_' . strtolower($parts[1]) : strtolower($parts[1]) . '_' . $this->table; |
|
175 | - $relations = $this->connection->getRecordManager()->find($rel_table)->where($this->getName() . '_id = "' . $this->__meta['id'] . '"')->get(); |
|
174 | + $rel_table = $this->connection->getTableManager()->tableExists($this->table.'_'.strtolower($parts[1])) ? $this->table.'_'.strtolower($parts[1]) : strtolower($parts[1]).'_'.$this->table; |
|
175 | + $relations = $this->connection->getRecordManager()->find($rel_table)->where($this->getName().'_id = "'.$this->__meta['id'].'"')->get(); |
|
176 | 176 | $rel_ids = ''; |
177 | 177 | foreach ($relations as $relation) { |
178 | - $key = strtolower($parts[1]) . '_id'; |
|
179 | - $rel_ids .= "'" . $relation->$key . "',"; |
|
178 | + $key = strtolower($parts[1]).'_id'; |
|
179 | + $rel_ids .= "'".$relation->$key."',"; |
|
180 | 180 | } |
181 | 181 | $rel_ids = substr($rel_ids, 0, -1); |
182 | - return $this->connection->getRecordManager()->find(strtolower($parts[1]))->where('id IN (' . $rel_ids . ')')->get(); |
|
182 | + return $this->connection->getRecordManager()->find(strtolower($parts[1]))->where('id IN ('.$rel_ids.')')->get(); |
|
183 | 183 | } |
184 | 184 | } |
185 | 185 | } |
@@ -189,8 +189,8 @@ discard block |
||
189 | 189 | return $type->convertToPHPValue($this->__properties[$key], $this->connection->getDatabasePlatform()); |
190 | 190 | } |
191 | 191 | |
192 | - if (array_key_exists($key . '_id', $this->__properties)) { |
|
193 | - return $this->connection->getRecordManager()->getById($key, $this->__properties[$key . '_id']); |
|
192 | + if (array_key_exists($key.'_id', $this->__properties)) { |
|
193 | + return $this->connection->getRecordManager()->getById($key, $this->__properties[$key.'_id']); |
|
194 | 194 | } |
195 | 195 | |
196 | 196 | throw new Exception\KeyNotFoundException(); |
@@ -353,7 +353,7 @@ discard block |
||
353 | 353 | */ |
354 | 354 | public function save(): mixed |
355 | 355 | { |
356 | - if($this->__meta['id_error']){ |
|
356 | + if ($this->__meta['id_error']) { |
|
357 | 357 | throw new Exception\InvalidIdException(); |
358 | 358 | } |
359 | 359 | Event::dispatch('__arca.model.save.'.$this->connection->getConnectionId(), [$this]); |