@@ -54,10 +54,10 @@ discard block |
||
54 | 54 | public function load($id) |
55 | 55 | { |
56 | 56 | $rows = $this->db->table($this->eventStoreTableName) |
57 | - ->select(['uuid', 'playhead', 'metadata', 'payload', 'recorded_on']) |
|
58 | - ->where('uuid', $id) |
|
59 | - ->orderBy('playhead', 'asc') |
|
60 | - ->get(); |
|
57 | + ->select(['uuid', 'playhead', 'metadata', 'payload', 'recorded_on']) |
|
58 | + ->where('uuid', $id) |
|
59 | + ->orderBy('playhead', 'asc') |
|
60 | + ->get(); |
|
61 | 61 | $events = []; |
62 | 62 | |
63 | 63 | foreach ($rows as $row) { |
@@ -155,12 +155,12 @@ discard block |
||
155 | 155 | public function getEventsByType($eventTypes, $skip, $take) |
156 | 156 | { |
157 | 157 | $rows = $this->db->table($this->eventStoreTableName) |
158 | - ->select(['uuid', 'playhead', 'metadata', 'payload', 'recorded_on']) |
|
159 | - ->whereIn('type', $eventTypes) |
|
160 | - ->skip($skip) |
|
161 | - ->take($take) |
|
162 | - ->orderBy('id') |
|
163 | - ->get(); |
|
158 | + ->select(['uuid', 'playhead', 'metadata', 'payload', 'recorded_on']) |
|
159 | + ->whereIn('type', $eventTypes) |
|
160 | + ->skip($skip) |
|
161 | + ->take($take) |
|
162 | + ->orderBy('id') |
|
163 | + ->get(); |
|
164 | 164 | $events = []; |
165 | 165 | |
166 | 166 | foreach ($rows as $row) { |
@@ -49,8 +49,8 @@ discard block |
||
49 | 49 | public function handle() |
50 | 50 | { |
51 | 51 | if ($this->option('force') == 'true' || $this->confirm("Are you sure you want to make a new table '{$this->config->get('cqrses.eventstore_table')}'" |
52 | - . " on connection '{$this->config->get('cqrses.eventstore_connection')}'" |
|
53 | - . " Do you wish to continue?") |
|
52 | + . " on connection '{$this->config->get('cqrses.eventstore_connection')}'" |
|
53 | + . " Do you wish to continue?") |
|
54 | 54 | ) { |
55 | 55 | try { |
56 | 56 | return $this->buildEventStoreTable(); |
@@ -67,18 +67,18 @@ discard block |
||
67 | 67 | protected function buildEventStoreTable() |
68 | 68 | { |
69 | 69 | Schema::connection($this->config->get('cqrses.eventstore_connection')) |
70 | - ->create($this->config->get('cqrses.eventstore_table'), |
|
71 | - function (Blueprint $table) { |
|
72 | - $table->increments('id'); |
|
73 | - $table->string('uuid', 56); |
|
74 | - $table->integer('playhead')->unsigned(); |
|
75 | - $table->text('metadata'); |
|
76 | - $table->longText('payload'); |
|
77 | - $table->timestamp('recorded_on')->nullable()->index(); |
|
78 | - $table->string('type', 255)->index(); |
|
79 | - $table->unique(['uuid', 'playhead']); |
|
70 | + ->create($this->config->get('cqrses.eventstore_table'), |
|
71 | + function (Blueprint $table) { |
|
72 | + $table->increments('id'); |
|
73 | + $table->string('uuid', 56); |
|
74 | + $table->integer('playhead')->unsigned(); |
|
75 | + $table->text('metadata'); |
|
76 | + $table->longText('payload'); |
|
77 | + $table->timestamp('recorded_on')->nullable()->index(); |
|
78 | + $table->string('type', 255)->index(); |
|
79 | + $table->unique(['uuid', 'playhead']); |
|
80 | 80 | |
81 | - $table->index(['id','type']); |
|
82 | - }); |
|
81 | + $table->index(['id','type']); |
|
82 | + }); |
|
83 | 83 | } |
84 | 84 | } |
85 | 85 | \ No newline at end of file |