You're right about the uuid... I can't remember why it's even there and it doesn't make sense for what I'm looking to do.
And your solution worked! Thank you. I don't know why I didn't see that. David On Monday, April 8, 2013 4:59:24 PM UTC-4, Cliff Kachinske wrote: > > db(db.table1.col1 == db.table2.col1).select( > db.table1.col2, > db.table1.col3, > db.table1.col4, > db.table1.col5, > db.table2.col6, > db.table2.col7 > ) > > What's the purpose of the uuid? If they are identical between > corresponding rows of the two tables, it defeats the purpose of uuid. > > uuid = Universally Unique IDentifier. Each instance should be unique. > > If you want to guarantee that each record in a table a primary key is > sufficient for that. > > Answers to these questions and many more can be found in the Web2py Manual > here: http://web2py.com/books/default/chapter/29/06. > > On Monday, April 8, 2013 4:29:35 PM UTC-4, David S wrote: >> >> I have three tables, db.table1 db.table2 and db.table3. They are >> identical except for the information stored in each. table3 is blank and >> after running some code should contain the combination of the values in >> table1 and table2. >> >> An example (<uuid> is generated by web2py_uuid()): >> >> db.table1: >> col1 col2 col3 col4 col5 col6 col7 col8 >> 1 A Z x x <uuid> >> 2 B Y x x <uuid> >> 3 C X x x <uuid> >> 4 D W x x <uuid> >> >> db.table2: >> col1 col2 col3 col4 col5 col6 col7 col8 >> 1 A Z y y <uuid> >> 2 B Y y y <uuid> >> 3 C X y y <uuid> >> 4 D W y y <uuid> >> >> After merging, db.table3 should look like this: >> >> db.table3: >> col1 col2 col3 col4 col5 col6 col7 col8 >> 1 A Z x x y y <uuid> >> 2 B Y x x y y <uuid> >> 3 C X x x y y <uuid> >> 4 D W x x y y <uuid> >> >> After some research, I found that exporting table1 and table2 to separate >> .csv files and then importing them into table3 should be an easy way to do >> this, however it does not seem to be working for me. Below is the code I've >> tried to use: >> >> rows = db(db.table1).select() >> rows.export_to_csv_file(open('table1.csv','wb')) >> db.table3.import_from_csv_file(open('table1.csv','rb'),unique='col1') >> >> rows = db(db.table2).select() >> rows.export_to_csv_file(open('table2.csv','wb')) >> db.table3.import_from_csv_file(open('table2.csv','rb'),unique='col1') >> >> The problem I'm having is only the values from table2 are showing in >> table3. >> >> I've also tried using a join like this: >> >> db(db.table1.col1 == db.table2.col1).select() >> >> But it creates something which looks like this: >> >> col1 col2 col3 col4 col5 col6 col7 col8 col1 col2 col3 col4 col5 col6 >> col7 col8 >> 1 A Z x x <uuid> 1 A Z y >> y <uuid> >> 2 B Y x x <uuid> 2 B Y y >> y <uuid> >> 3 C X x x <uuid> 3 C X y >> y <uuid> >> 4 D W x x <uuid> 4 D W y >> y <uuid> >> >> Is there another way of doing the join which would produce table3 how I'd >> like it formatted? >> >> Anyone have a suggestion or better way to do this? >> >> Thanks, >> David >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
