Find Jobs
Hire Freelancers

complete_script_db_update

$30-5000 USD

已完成
已发布将近 19 年前

$30-5000 USD

货到付款
[login to view URL] provides links to stock groups, we have scripts that download this data and place it in a mysql database. Stocks belong to groups and groups belong to sectors. We have decided to farm out the last part of a script that updates the database. This script is called [login to view URL], and it keeps track of changes to sectors, groups and stocks (changes between yahoo and our current DB state). But it lacks a complete management of Stock Membership changes. Bear in mind a stock can change not only its symbol, company name, url locations, but could also leave and reenter a group as well as be moved from one group to another. Symbol changes are being tracked and updated. 4 letter symbols could have a fifth letter added, and then removed, and any symbol (1-5 letters) can have a .ob or .pk added or removed anytime, and many times. These changes are being handled. But when that happens the Group membership table "GroupStocks" would need to be updated to reflect the change. This DB holds information from multiple sources, these sources are differentiated by sectorroot_id, but stocks are unique and can belong to none, one or more sectorroot_id. If a Stock name changes, all sectorroot_ids in GroupStocks must be updated. in sumary: The GroupStocks table has the group memberships, and the Log table logs the changes for historical purposes, so these two tables need to be updated. These are the changes I anticipate: -Symbols could have been renamed. -Symbols could move from one group to another. -Symbols could get dropped from a group. -Symbols could get added to a group. -If a symbol changes its name, the change needs to be reflected in the GroupStocks table. Please see [login to view URL] in the attached zip for all project requirements. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Linux
项目 ID: 3764065

关于此项目

1条提案
远程项目
活跃19 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$212.50 USD 在29天之内
3.0 (3条评论)
3.9
3.9

关于客户

UNITED STATES的国旗
Rocky Hil, United States
5.0
37
付款方式已验证
会员自6月 7, 2004起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。