How to merge two tables for select paginate data in peewee?
up vote
1
down vote
favorite
if i have two tables
class Man:
name = CharField()
age = IntegerField()
class Woman:
name = CharField()
age = IntegerField()
I want get result such as
[
{'name':'a', 'age':18, 'sex':'man'},
{'name':'b', 'age':20, 'sex':'man'},
{'name':'c', 'age':20, 'sex':'woman'}
]
I have many many data in tables, so what can I write use peewee like merge(table Man, table Woman).order_by(age).paginate(1,20) to get result.
thx!
python peewee
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
asked Nov 9 at 8:48
lalavila
61
add a comment |
up vote
1
down vote
favorite
if i have two tables
class Man:
name = CharField()
age = IntegerField()
class Woman:
name = CharField()
age = IntegerField()
I want get result such as
[
{'name':'a', 'age':18, 'sex':'man'},
{'name':'b', 'age':20, 'sex':'man'},
{'name':'c', 'age':20, 'sex':'woman'}
]
I have many many data in tables, so what can I write use peewee like merge(table Man, table Woman).order_by(age).paginate(1,20) to get result.
thx!
python peewee
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
asked Nov 9 at 8:48
lalavila
61
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
if i have two tables
class Man:
name = CharField()
age = IntegerField()
class Woman:
name = CharField()
age = IntegerField()
I want get result such as
[
{'name':'a', 'age':18, 'sex':'man'},
{'name':'b', 'age':20, 'sex':'man'},
{'name':'c', 'age':20, 'sex':'woman'}
]
I have many many data in tables, so what can I write use peewee like merge(table Man, table Woman).order_by(age).paginate(1,20) to get result.
thx!
python peewee
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
asked Nov 9 at 8:48
lalavila
61
if i have two tables
class Man:
name = CharField()
age = IntegerField()
class Woman:
name = CharField()
age = IntegerField()
I want get result such as
[
{'name':'a', 'age':18, 'sex':'man'},
{'name':'b', 'age':20, 'sex':'man'},
{'name':'c', 'age':20, 'sex':'woman'}
]
I have many many data in tables, so what can I write use peewee like merge(table Man, table Woman).order_by(age).paginate(1,20) to get result.
thx!
python peewee
python peewee
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
asked Nov 9 at 8:48
lalavila
61
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
asked Nov 9 at 8:48
lalavila
61
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
edited Nov 9 at 8:54
Vineeth Sai
2,22431023
2,22431023
asked Nov 9 at 8:48
lalavila
61
asked Nov 9 at 8:48
lalavila
61
asked Nov 9 at 8:48
lalavila
61
61
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
You can use a UNION:
http://docs.peewee-orm.com/en/latest/peewee/query_examples.html#combining-results-from-multiple-queries
There aren't very many examples of doing unions with Peewee, since there is a bit of a disconnect between querying two different tables and expecting to receive two different model classes.
You could also put the data in a single table and use a column to differentiate gender...might be easier.
answered Nov 9 at 20:02
coleifer
12.9k3148
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
You can use a UNION:
http://docs.peewee-orm.com/en/latest/peewee/query_examples.html#combining-results-from-multiple-queries
There aren't very many examples of doing unions with Peewee, since there is a bit of a disconnect between querying two different tables and expecting to receive two different model classes.
You could also put the data in a single table and use a column to differentiate gender...might be easier.
answered Nov 9 at 20:02
coleifer
12.9k3148
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
add a comment |
up vote
0
down vote
You can use a UNION:
http://docs.peewee-orm.com/en/latest/peewee/query_examples.html#combining-results-from-multiple-queries
There aren't very many examples of doing unions with Peewee, since there is a bit of a disconnect between querying two different tables and expecting to receive two different model classes.
You could also put the data in a single table and use a column to differentiate gender...might be easier.
answered Nov 9 at 20:02
coleifer
12.9k3148
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
add a comment |
up vote
0
down vote
up vote
0
down vote
You can use a UNION:
http://docs.peewee-orm.com/en/latest/peewee/query_examples.html#combining-results-from-multiple-queries
There aren't very many examples of doing unions with Peewee, since there is a bit of a disconnect between querying two different tables and expecting to receive two different model classes.
You could also put the data in a single table and use a column to differentiate gender...might be easier.
answered Nov 9 at 20:02
coleifer
12.9k3148
You can use a UNION:
http://docs.peewee-orm.com/en/latest/peewee/query_examples.html#combining-results-from-multiple-queries
There aren't very many examples of doing unions with Peewee, since there is a bit of a disconnect between querying two different tables and expecting to receive two different model classes.
You could also put the data in a single table and use a column to differentiate gender...might be easier.
answered Nov 9 at 20:02
coleifer
12.9k3148
answered Nov 9 at 20:02
coleifer
12.9k3148
answered Nov 9 at 20:02
coleifer
12.9k3148
answered Nov 9 at 20:02
coleifer
12.9k3148
12.9k3148
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
add a comment |
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
thanks for your answer, because it just a simple example for describe the problem. There are still some different fields between two tables...
– lalavila
Nov 10 at 19:10
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222428%2fhow-to-merge-two-tables-for-select-paginate-data-in-peewee%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
