Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[NFR] add option for disable and enable foreigh key #11

Closed
olegatro opened this issue Oct 28, 2019 · 4 comments · Fixed by #75
Closed

[NFR] add option for disable and enable foreigh key #11

olegatro opened this issue Oct 28, 2019 · 4 comments · Fixed by #75
Assignees
@Jeckerson
Labels
NFR New Feature Request
Milestone
2.1.x

Comments

@olegatro
Copy link

olegatro commented Oct 28, 2019 •
edited
Loading

When we migrating some tables, we don't control order of this tables.
And if we have foreign keys of that tables, we have errors.

So we should have some mechanic to disable and enable foreign key checks.

SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE ...

SET FOREIGN_KEY_CHECKS=1;
@Jeckerson Jeckerson added the NFR New Feature Request label Nov 12, 2019
@Jeckerson Jeckerson added this to the 1.1 milestone Nov 24, 2019
@Jeckerson Jeckerson self-assigned this Jan 28, 2020
@Jeckerson Jeckerson mentioned this issue Feb 1, 2020
Closed
@Jeckerson Jeckerson modified the milestones: 1.1.x, 1.2.x Feb 2, 2020
@Jeckerson
Copy link
Member

Related #6

@Jeckerson
Copy link
Member

Related #20

@Jeckerson Jeckerson modified the milestones: 1.2.x, 2.0.x Feb 23, 2020
@Jeckerson Jeckerson modified the milestones: 2.0.x, 2.1.x Mar 19, 2020
@Jeckerson
Copy link
Member

@olegatro Could you provide some examples by updating your original post?

@olegatro
Copy link
Author

Updated

Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Implement new option 'skip-foreign-checks'
14128c9
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Implement new Color method: fatal()
88e6644
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Minor refactor
632bfd3
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Fix skipping 'referencedTable' during migration construction
4b3ed4e
@Jeckerson Jeckerson mentioned this issue Mar 22, 2020
Merged
@Jeckerson Jeckerson linked a pull request Mar 22, 2020 that will close this issue
#11 - Added new option to skip foreign checks #75
Merged
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Add initial query with custom 'sql_mode'
d4cb913
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Update initial queries
1064113
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Disable query 'SET FOREIGN_KEY_CHECKS=0'
f0a0a22
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
#11 - Change RunCest tests
630c8e2
Jeckerson added a commit that referenced this issue Mar 22, 2020
@Jeckerson
Merge pull request #75 from phalcon/feature/#11-option-skip-foreign-c…
9ac61ce 
…hecks

#11 - Added new option to skip foreign checks
@niden niden moved this to Released in Phalcon v5 Aug 25, 2022
@niden niden added this to Phalcon v5 Aug 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Jeckerson Jeckerson

Labels
NFR New Feature Request
Projects
Phalcon v5
Archived in project
Milestone
2.1.x
Development

Successfully merging a pull request may close this issue.

#11 - Added new option to skip foreign checks phalcon/migrations
2 participants
@Jeckerson @olegatro