Guest User

Untitled

a guest
Nov 21st, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. mysql> DESCRIBE tbl_lists;
  2. +--------------+----------------------+------+-----+---------+----------------+
  3. | Field | Type | Null | Key | Default | Extra |
  4. +--------------+----------------------+------+-----+---------+----------------+
  5. | id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
  6. | name | varchar(100) | NO | | NULL | |
  7. | user_id | smallint(5) unsigned | NO | MUL | NULL | |
  8. +--------------+----------------------+------+-----+---------+----------------+
  9.  
  10. mysql> DESCRIBE tbl_lists_fields;
  11. +---------+-----------------------+------+-----+---------+----------------+
  12. | Field | Type | Null | Key | Default | Extra |
  13. +---------+-----------------------+------+-----+---------+----------------+
  14. | id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment | |
  15. | list_id | smallint(5) unsigned | NO | MUL | NULL | |
  16. +---------+-----------------------+------+-----+---------+----------------+
  17.  
  18. mysql> DESCRIBE tbl_lists_substances_comments;
  19. +--------------+-----------------------+------+-----+-------------------+-----------------------------+
  20. | Field | Type | Null | Key | Default | Extra |
  21. +--------------+-----------------------+------+-----+-------------------+-----------------------------+
  22. | id | bigint(11) unsigned | NO | PRI | NULL | auto_increment |
  23. | list_id | smallint(5) unsigned | NO | MUL | NULL | |
  24. | field_id | mediumint(8) unsigned | NO | MUL | NULL | |
  25. | substance_id | mediumint(8) unsigned | NO | MUL | NULL |
  26. | comment | varchar(3000) | NO | | NULL | | |
  27. +--------------+-----------------------+------+-----+-------------------+-----------------------------+
  28.  
  29. $TblLists = TableRegistry::get('TblLists');
  30. $tbl_lists = $TblLists->find('all')->contain(['TblListsFields'])->where(['user_id' => '1234'])->toArray();
  31. debug($tbl_lists);
  32.  
  33. ->contain(['TblListsFields', 'TblListsSubstancesComments'])->
  34.  
  35. // TblListsTable.php
  36. $this->hasMany('TblListsSubstances', [
  37. 'foreignKey' => 'list_id'
  38. ]);
  39. $this->hasMany('TblListsFields', [
  40. 'foreignKey' => 'list_id'
  41. ]);
  42.  
  43. // TblListsFieldsTable.php
  44. $this->belongsTo('TblLists', [
  45. 'foreignKey' => 'list_id',
  46. 'joinType' => 'INNER'
  47. ]);
  48. $this->belongsTo('TblListsSubstancesComments', [
  49. 'foreignKey' => 'field_id',
  50. 'joinType' => 'INNER'
  51. ]);
  52.  
  53. // TblListsSubstancesCommentsTable.php
  54. $this->belongsTo('TblLists', [
  55. 'foreignKey' => 'list_id',
  56. 'joinType' => 'INNER'
  57. ]);
  58. $this->belongsTo('TblListsFields', [
  59. 'foreignKey' => 'field_id',
  60. 'joinType' => 'INNER'
  61. ]);
  62. $this->belongsTo('Substances', [
  63. 'foreignKey' => 'substance_id',
  64. 'joinType' => 'INNER'
  65. ]);
  66.  
  67. $this->belongsTo('TblListsSubstancesComments', [
  68. 'foreignKey' => 'id',
  69. 'joinType' => 'INNER'
  70. ]);
Add Comment
Please, Sign In to add comment