| # |
Mar 13th 2018, 19:10 |
inoas |
grml.. cordova, typescript, ionic, angular, java, objective c, ... so much "stuff" :( |
| # |
Mar 13th 2018, 19:09 |
inoas |
hmm :( too much magic for me - I think |
| # |
Mar 13th 2018, 19:08 |
inoas |
steinkel let me take a look instead of reinventing the wheel all time ;) |
| # |
Mar 13th 2018, 18:56 |
madrid988 |
Also for testing, we would need to populate the test database with the records before running the test, so it would be simpler to have a hard coded static array. There are no associations. |
| # |
Mar 13th 2018, 18:54 |
madrid988 |
The data starts off as a hard coded array so it is simpler to use that same static array instead of creating a database table and populating the database. We will simply store the records as an array in the model and set useTable=false |
| # |
Mar 13th 2018, 18:46 |
 dereuromark |
why do you want to? just cache and you are done. Even that is not necessary, the overhead of change outweighs any benefit |
| # |
Mar 13th 2018, 18:44 |
steinkel |
we use cakedc/cakephp-api like every day :slightly_smiling_face: |
| # |
Mar 13th 2018, 17:29 |
madrid988 |
I have a table used to store about 50 records which never change, the data is static. What is the best way to store this as an array in Cake instead of a database? Where do I store the file? Many thanks for any help. |
| # |
Mar 13th 2018, 17:17 |
jojomartius |
looks good ;) i'm trying to do it... thanks |
| # |
Mar 13th 2018, 17:15 |
cnizzardini |
@jojomartius https://book.cakephp.org/3.0/en/orm/query-builder.html#passing-conditions-to-contain |
| # |
Mar 13th 2018, 17:15 |
cnizzardini |
You can do conditions on the contains |
| # |
Mar 13th 2018, 17:13 |
jojomartius |
hey guys.. trying to play a bit with cake3's models and querys... i found in the docu a simple has many example $query = $articles->find('all')->contain(['Comments']);.. whats the best way to find only articles where the comment is cmming from a specifc user or all articels the user hasnt commented yet ;) |
| # |
Mar 13th 2018, 17:12 |
dereuromark |
istvan: not a long term thing probably, not too performant |
| # |
Mar 13th 2018, 17:12 |
cnizzardini |
Looks like I use removeBehavior() now? |
| # |
Mar 13th 2018, 17:12 |
bakro.istvan |
What about views? A view which aggregates the multiple table accounts; used only for authentication |
| # |
Mar 13th 2018, 17:11 |
dereuromark |
not sure why though |
| # |
Mar 13th 2018, 17:11 |
dereuromark |
even earlier maybe, the behavior has to exist to be unloaded() afaik |
| # |
Mar 13th 2018, 17:10 |
cnizzardini |
Were there any changes from 3.4 to 3.5 with loading/unloading behaviors dynamically? I am getting "Behavior class TimestampBehavior could not be found. in [vendor/cakephp/cakephp/src/ORM/BehaviorRegistry.php, line 127]" when calling $ModelName->behaviors()->unload('Timestamp'); |
| # |
Mar 13th 2018, 17:09 |
neon1024 |
@willem Then you must refactor from `belongsToMany` to `hasMany` imho |
| # |
Mar 13th 2018, 17:08 |
neon1024 |
Oh, just one thought before I vanish. Do check DebugKit, to ensure that in the SQL tab it doesn’t say ‘An instance was created using Cake\ORM\Table’ because if it does, then you’ve probably got a typo |
| # |
Mar 13th 2018, 17:08 |
willem |
``` $this->belongsTo('FieldsOfStudies', [ 'foreignKey' => 'fields_of_study_id', 'joinType' => 'INNER' ]); ``` is extra in the applicantsDegreesTable, which you do not have |
| # |
Mar 13th 2018, 17:07 |
willem |
yes that is how it is set up and it is workgin, but in the join table i have more keys to link to other tables. and i would also like to see the actual content from that table and not only the ID (which i get now) |
| # |
Mar 13th 2018, 17:06 |
neon1024 |
Anyway, good luck. That’s the end of my day :slightly_smiling_face: |
| # |
Mar 13th 2018, 17:06 |
neon1024 |
Perhaps it’s as simple as clearing your orm cache!? |
| # |
Mar 13th 2018, 17:04 |
neon1024 |
So this is how you’ve got your associations setup right? |
| # |
Mar 13th 2018, 17:04 |
neon1024 |
https://github.com/davidyell/FFBE-Helper/blob/master/src/Model/Table/SpecialisationsTable.php#L42-L44 |
| # |
Mar 13th 2018, 17:03 |
neon1024 |
https://github.com/davidyell/FFBE-Helper/blob/master/src/Model/Table/PractisesTable.php#L39-L46 |
| # |
Mar 13th 2018, 17:03 |
neon1024 |
https://github.com/davidyell/FFBE-Helper/blob/master/src/Model/Table/UnitsTable.php#L99-L101 |
| # |
Mar 13th 2018, 17:03 |
neon1024 |
Ah, bad example I’ve not normalised that :P |
| # |
Mar 13th 2018, 17:02 |
neon1024 |
Let’s try a Unit which Practises a Specialisation |
| # |
Mar 13th 2018, 17:02 |
neon1024 |
Perhaps a code example will help |
| # |
Mar 13th 2018, 17:01 |
willem |
well, i think because my association in the ApplicantTable is named ‘Degree’ instead of ‘ApplicantsDegrees’ ? |
| # |
Mar 13th 2018, 17:01 |
neon1024 |
At least, that’s how I see it |
| # |
Mar 13th 2018, 17:01 |
neon1024 |
The problem is what your Table class associations |
| # |
Mar 13th 2018, 17:00 |
neon1024 |
If it did, why are you getting an exception for a missing association? |
| # |
Mar 13th 2018, 17:00 |
willem |
i understand, but when i read this and check my db and classes it looks exactly like that |
| # |
Mar 13th 2018, 17:00 |
neon1024 |
As it’s pretty key to database design and software design |
| # |
Mar 13th 2018, 16:59 |
neon1024 |
This is important to learn |
| # |
Mar 13th 2018, 16:59 |
neon1024 |
I feel it’s better to teach you why than tell you what code changes to make |
| # |
Mar 13th 2018, 16:59 |
willem |
euh kinda, but i have all those table classes already? only ``` $this->belongsToMany('Degrees', [ 'foreignKey' => 'applicant_id', 'targetForeignKey' => 'degree_id', 'joinTable' => 'applicants_degrees' ]); ``` you say this should be hasMany ? |
| # |
Mar 13th 2018, 16:58 |
neon1024 |
Does that make sense? :slightly_smiling_face: |