[#BCNT-240] Migrate Database over to equal length and equivalent data fields.

BeanCounter

Migrate Database over to equal length and equivalent data fields.

Created: 18/Mar/09 10:34 AM Updated: 14/Aug/09 01:51 AM

Component/s:

Other

Affects Version/s:

None

Fix Version/s:

None

Issue Links:

Blocks

This issue blocks:

~~BCNT-239~~ Add ability to track and search for Neutral Auctionhouse auctions separately

~~BCNT-238~~ Ability to search BeanCounter data for different servers

Description

« Hide

Move all storage tables to use the same data layout and length. Currently each database stores its data in a unique legth string.
By making all data fields same order we can eliminate trash table usage when splitting transaction strings as well as making it easier to add new data fields.

Example:
local uStack, uMoney, uDeposit , uFee, uBuyout , uBid, uSeller, uTime, uReason, uLocation = private.unpackString(text)

Will work with completedBids, completedAuctions, failedbids and failed auctions data sets

All

Comments

Change History

Transitions

FishEye

Crucible

Sort Order:

[ Permalink | « Hide ]

William (Kandoko) added a comment - 18/Mar/09 10:36 AM

Current commits to this ticket will be to the //branches/BeanCounter_Storage/

[ Permalink | « Hide ]

William (Kandoko) added a comment - 18/Mar/09 04:53 PM

r4118
Failed bids now store seller and stack info. Will properly remove matched postedDB entries.
Fixes display bug with auction house frame

[ Permalink | « Hide ]

William (Kandoko) added a comment - 01/Apr/09 05:27 PM

r4130
Changes the way we store itemLinks in the itemNameArray. This saves space and improves the speed of the string.finds. Adds 2 new API's to be used to add itemLink to array or turn array back to an itemLink.
lib.API.createItemLinkFromArray(itemKey)--itemKey == "itemID:Suffix"
lib.API.storeItemLinkToArray(itemLink)

[ Permalink | « Hide ]

William (Kandoko) added a comment - 07/Apr/09 12:18 PM

Merges all changes made in Branch related to ~~BCNT-240~~
***Warning backup, this may or may not destroy your data, kick your dog, and taunt you a second time***
Move all storage tables to use the same data layout and length, simplifying storage and re-trivial. Adds NEW FIELD to store which auction house trxn took place at. A, H, N
Changes the way we store itemLinks in the itemNameArray. This saves space and improves the speed of the string.finds()
Updates Search API to allow MULTIPLE server search results (max 4). in settings table pass a named list of servers{"name", "name2"}

[ Permalink | « Hide ]

William (Kandoko) added a comment - 07/Apr/09 12:26 PM

corrects global variable: serverName at line 132

[ Permalink | « Hide ]

dinesh added a comment - 14/Aug/09 01:51 AM

let's just pretend I code reviewed this. it seems to work in production, anyway.