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.

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

Many2Many declared in mixin and inherited by 2 models #91

Open
jssuzanne opened this issue May 14, 2019 · 0 comments
Open

Many2Many declared in mixin and inherited by 2 models #91

jssuzanne opened this issue May 14, 2019 · 0 comments
Milestone

Comments

@jssuzanne
Copy link
Member

@jssuzanne jssuzanne commented May 14, 2019

sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1005, 'Can't create table anyblok.join_person2_and_address_for_addresses (errno: 121 "Duplicate key on write or update")')
[SQL:
CREATE TABLE join_person2_and_address_for_addresses (
person2_name VARCHAR(64) NOT NULL,
address_id INTEGER NOT NULL,
CONSTRAINT anyblok_pk_join_person2_and_address_for_addresses PRIMARY KEY (person2_name, address_id),
CONSTRAINT anyblok_fk_jpaaf_addresses__address_id FOREIGN KEY(address_id) REFERENCES address (id),
CONSTRAINT anyblok_fk_jpaaf_addresses__person2_name FOREIGN KEY(person2_name) REFERENCES person2 (name)
)

@jssuzanne jssuzanne added this to the MySQL milestone May 14, 2019
jssuzanne added a commit to jssuzanne/AnyBlok that referenced this issue May 14, 2019
jssuzanne added a commit that referenced this issue Jun 21, 2019
* Add python versions

* Updated travis configuration to add mysql

* Refactored constraints name in the case of no name exist

* Fixed configuration for pypy3.5

* Added engine for mysql

* Fixed Automigration: For MySQL Boolean is a Tinyint

* Flake8

* In case of MySQL, the database is droped and created for each DBTestCase

* Skip some unittest when the SGDB is MariaDB or MySQL

* Excluded pythone 3.4 with MySQL

* Added skip unit test for datetime: waiting #87

* Added skip unit test for seuence: waiting #89

* Added skip unit test for CheckConstrain: waiting #90

* Added skip unit test for Many2Many: waiting #91

* Skiped unittest  only for postgres

* Skiped unittest on update on view

* ShareDataTestCase doesn't work

* Exlude tests files for flake8

* Exclude python3.5 and mysql on travis
@jssuzanne jssuzanne changed the title MySQL: Many2Many declared in mixin and inherited by 2 models Many2Many declared in mixin and inherited by 2 models Aug 2, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.