| # |
May 26th 2016, 12:03 |
frzrr |
ah, good idea i'll try that |
| # |
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 |