| # |
May 26th 2016, 12:02 |
bernat1 |
the=then |
| # |
May 26th 2016, 12:02 |
bernat1 |
In that case I'd use a manual query. |
| # |
May 26th 2016, 12:02 |
bernat1 |
the problem is that Phinx will first set auto-increment the add the index |
| # |
May 26th 2016, 12:02 |
frzrr |
doesn't work either |
| # |
May 26th 2016, 12:01 |
frzrr |
yea, trying to set an index on the column with type of key |
| # |
May 26th 2016, 12:01 |
bernat1 |
maybe having an index on that column is enough. |
| # |
May 26th 2016, 12:00 |
frzrr |
lol.... |
| # |
May 26th 2016, 12:00 |
frzrr |
or not, only worked in the sql client |
| # |
May 26th 2016, 11:59 |
frzrr |
column only needs to be int and it works fine. |
| # |
May 26th 2016, 11:59 |
frzrr |
works fine when altering the table manually |
| # |
May 26th 2016, 11:59 |
frzrr |
nope |
| # |
May 26th 2016, 11:59 |
bernat1 |
frzrr: I think autoincrement can be set only on primary key fields when using MySQL. |
| # |
May 26th 2016, 11:51 |
frzrr |
should be the same though |
| # |
May 26th 2016, 11:51 |
frzrr |
ah this is non shell |
| # |
May 26th 2016, 11:50 |
frzrr |
"autoIncrement" is not a valid column option. |
| # |
May 26th 2016, 11:49 |
Neon1024x |
Yeah Cake wraps some of the Phinx methods |
| # |
May 26th 2016, 11:49 |
frzrr |
hmm, see some new functions here though |
| # |
May 26th 2016, 11:48 |
frzrr |
thats exactly what i've done except through phinx |
| # |
May 26th 2016, 11:48 |
frzrr |
yep |
| # |
May 26th 2016, 11:46 |
Neon1024x |
http://book.cakephp.org/3.0/en/migrations.html#creating-custom-primary-keys |
| # |
May 26th 2016, 11:45 |
frzrr |
using* |
| # |
May 26th 2016, 11:44 |
frzrr |
i'm UUIDS so they are not auto incremented |
| # |
May 26th 2016, 11:44 |
frzrr |
https://gist.github.com/anonymous/a7c8b148752eb32b58ddb500280874de |
| # |
May 26th 2016, 11:44 |
Neon1024x |
I believe that Phinx assumes an id field is auto-increment, it is customisable though |
| # |
May 26th 2016, 11:43 |
frzrr |
dont have any auto incremented column, only id as PK should work |
| # |
May 26th 2016, 11:43 |
frzrr |
Anyone familiar with phinx? Trying to add a auto incremented column with identity but i get this error: Incorrect table definition; there can be only one auto colu mn and it must be defined as a key |
| # |
May 26th 2016, 11:42 |
sab-cakefest |
Do we get the complete code for the session this morning? Or all the sessions? |
| # |
May 26th 2016, 11:40 |
makallio85 |
Should it be fixed in cake or in deployer? I guess proper namespacing would be the correct way to fix it |
| # |
May 26th 2016, 11:40 |
makallio85 |
Hi. What is policy with global functions and conflicts with other libraries? It seems that deployer/deployer is having conflict with cakephp env() function as you can see from this issue https://github.com/deployphp/deployer/issues/669 |
| # |
May 26th 2016, 11:38 |
bernat1 |
Thinking more about it, even with my proposed solution I guess I would be using whatever internal mechanism CakePHP uses when checking that a row exists before insert or update. I'll have to check the source code and do that myself. |
| # |
May 26th 2016, 11:35 |
bernat1 |
thanks anyway Neon1024x |
| # |
May 26th 2016, 11:34 |
Neon1024x |
I don't know databases in enough detail to know about that, sorry |
| # |
May 26th 2016, 11:34 |
Neon1024x |
Sounds a little more like a datasource solution |
| # |
May 26th 2016, 11:34 |
bernat1 |
yes |
| # |
May 26th 2016, 11:34 |
Neon1024x |
So concurrent writing |
| # |
May 26th 2016, 11:33 |
bernat1 |
I could block the table between the check and the insertion, but I'd prefer to not use locks and use the mechanism I described above. |
| # |
May 26th 2016, 11:33 |
bernat1 |
my idea might seem a bit convoluted but in short, I want to use a table as a storage pool, several threads can be inserting into that pool, I use hashes to avoid duplicates and check it doesn't exists before inserting a new one. |
| # |
May 26th 2016, 11:31 |
Neon1024x |
Sounds identical to me |
| # |
May 26th 2016, 11:31 |
bernat1 |
thanks Neon1024x, that looks useful, but I think it's not the same that I need. |
| # |
May 26th 2016, 11:23 |
Neon1024x |
bernat1, https://github.com/dereuromark/cakephp-hashid |
| # |
May 26th 2016, 11:17 |
bernat1 |
I'd like CakePHP to use the fake primary key, but use the real primary key (the hash field) when saving new entities, and check the entity already exists based on this hash field. |