[Lift] Re: Complex primary key
I need a many-to-many intermediary table and i need to add some more fields to it as well. In the question I meant compound primary key because I am creating the intermediary table manually in the mapper model. Is there any way to do many-to-many relationships automatically in the mapper? Thanks, On Oct 13, 2009, at 6:37 PM, David Pollak wrote: I'm sorry, are you trying to do a compound primary key or create a many-to-many intermediary table? On Tue, Oct 13, 2009 at 8:06 AM, David Pollak feeder.of.the.be...@gmail.com wrote: I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
http://scala-tools.org/mvnsites-snapshots/liftweb/lift-mapper/scaladocs/net/liftweb/mapper/ManyToMany.html If you look back in the group there is a thread announcing the addition of the trait and how to use it. Peter Robinett On Oct 14, 10:57 am, GA my_li...@me.com wrote: I need a many-to-many intermediary table and i need to add some more fields to it as well. In the question I meant compound primary key because I am creating the intermediary table manually in the mapper model. Is there any way to do many-to-many relationships automatically in the mapper? Thanks, On Oct 13, 2009, at 6:37 PM, David Pollak wrote: I'm sorry, are you trying to do a compound primary key or create a many-to-many intermediary table? On Tue, Oct 13, 2009 at 8:06 AM, David Pollak feeder.of.the.be...@gmail.com wrote: I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
It is only available in Lift 1.1 right? GA On Oct 14, 2009, at 11:47 AM, Peter Robinett wrote: http://scala-tools.org/mvnsites-snapshots/liftweb/lift-mapper/scaladocs/net/liftweb/mapper/ManyToMany.html If you look back in the group there is a thread announcing the addition of the trait and how to use it. Peter Robinett On Oct 14, 10:57 am, GA my_li...@me.com wrote: I need a many-to-many intermediary table and i need to add some more fields to it as well. In the question I meant compound primary key because I am creating the intermediary table manually in the mapper model. Is there any way to do many-to-many relationships automatically in the mapper? Thanks, On Oct 13, 2009, at 6:37 PM, David Pollak wrote: I'm sorry, are you trying to do a compound primary key or create a many-to-many intermediary table? On Tue, Oct 13, 2009 at 8:06 AM, David Pollak feeder.of.the.be...@gmail.com wrote: I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
Or any one of the milestones yes. The latest milestone is 1.1-M6 Cheers, Tim On 14 Oct 2009, at 14:43, GA wrote: It is only available in Lift 1.1 right? GA On Oct 14, 2009, at 11:47 AM, Peter Robinett wrote: http://scala-tools.org/mvnsites-snapshots/liftweb/lift-mapper/scaladocs/net/liftweb/mapper/ManyToMany.html If you look back in the group there is a thread announcing the addition of the trait and how to use it. Peter Robinett On Oct 14, 10:57 am, GA my_li...@me.com wrote: I need a many-to-many intermediary table and i need to add some more fields to it as well. In the question I meant compound primary key because I am creating the intermediary table manually in the mapper model. Is there any way to do many-to-many relationships automatically in the mapper? Thanks, On Oct 13, 2009, at 6:37 PM, David Pollak wrote: I'm sorry, are you trying to do a compound primary key or create a many-to-many intermediary table? On Tue, Oct 13, 2009 at 8:06 AM, David Pollak feeder.of.the.be...@gmail.com wrote: I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
On Wed, Oct 14, 2009 at 6:43 AM, GA my_li...@me.com wrote: It is only available in Lift 1.1 right? Unless you have a compelling reason, please develop against 1.1. It is stable and being used in production at a number of sites. GA On Oct 14, 2009, at 11:47 AM, Peter Robinett wrote: http://scala-tools.org/mvnsites-snapshots/liftweb/lift-mapper/scaladocs/net/liftweb/mapper/ManyToMany.html If you look back in the group there is a thread announcing the addition of the trait and how to use it. Peter Robinett On Oct 14, 10:57 am, GA my_li...@me.com wrote: I need a many-to-many intermediary table and i need to add some more fields to it as well. In the question I meant compound primary key because I am creating the intermediary table manually in the mapper model. Is there any way to do many-to-many relationships automatically in the mapper? Thanks, On Oct 13, 2009, at 6:37 PM, David Pollak wrote: I'm sorry, are you trying to do a compound primary key or create a many-to-many intermediary table? On Tue, Oct 13, 2009 at 8:06 AM, David Pollak feeder.of.the.be...@gmail.com wrote: I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web frameworkhttp://liftweb.net Beginning Scalahttp://www.apress.com/book/view/1430219890 Follow me:http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
GA, so you want a composite primary key? I'm not sure that's possible in most SQL databases, though a unique composite key definitely is... Peter Robinett On Oct 12, 4:30 pm, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
[Lift] Re: Complex primary key
I'm sorry, are you trying to do a compound primary key or create a many-to-many intermediary table? On Tue, Oct 13, 2009 at 8:06 AM, David Pollak feeder.of.the.be...@gmail.com wrote: I don't think that's possible with mapper. Sorry. You might want to see if JPA supports such a beast. On Mon, Oct 12, 2009 at 7:30 AM, my_li...@me.com wrote: Hello guys, How can I create a mapper with two or more fields as primary key? For instance if we have a table of people with a Long primary key called ID generated by IdPK, and also we have a table of addresses also with a Long primary key called ID generated by IdPK. The idea is to create an association table with both IDs to represent people with many addresses and addresses with multiple people. So both IDs will be primary key of the new table. Thanks in advance, GA -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Lift group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~--~~~~--~~--~--~---
