avatar

610

First steps towards using the auction identifier as the effective primary key into the auctions table.

by mrs, 17 Aug, 2008 11:47 PM
jbidwatcher/trunk/src/com/jbidwatcher/auction/AuctionEntry.java diff
603 610  
15361536       if(aid != null && aid.length() != 0) {
15371537         mAuction = AuctionInfo.findFirstBy("id", aid);
15381538       }
1539       if(mAuction == null && getString("identifier") != null) {
1540         mAuction = AuctionInfo.findByIdentifier(getString("identifier"));
1541       }
15391542     }
1543     if(mAuction != null & getString("identifier")==null) {
1544       setString("identifier", mAuction.getIdentifier());
1545       saveDB();
1546     }
15401547     return mAuction;
15411548   }
15421549 
jbidwatcher/trunk/src/com/jbidwatcher/auction/AuctionInfo.java diff
536 610  
519519     return (AuctionInfo) ActiveRecord.findFirstBy(AuctionInfo.class, key, value);
520520   }
521521 
522   public static AuctionInfo findByIdentifier(String identifier) {
523     return (AuctionInfo) ActiveRecord.findFirstBySQL(AuctionInfo.class, "SELECT * FROM auctions WHERE id IN (SELECT Max(id) FROM auctions WHERE identifier = '" + identifier + "')");
524   }
525 
522526   public static int precache() {
523527     return ActiveRecordCache.precacheBySQL(AuctionInfo.class, "SELECT * FROM auctions WHERE id IN (SELECT auction_id FROM entries)", "id", "identifier");
524528   }