我把一些数据从一个数据库移至另一个数据库,而生产数据则意外地在测试数据库中终结。
It is typical a relational database centered around a single User table.
created and updated columns.我一直通过一个SOAP层与数据库连接,因为它是“麻醉”的方法。 然而,我确实有使用这些数据库的机器的行政渠道。
你们是否有任何方法、任何建议、帮助我实现我的目标的任何要点? 也许与,实际上是什么。
<>1>。 首先支持所有数据。 说这句话永远不会受到伤害!
2. Establish a reasonable sample size, i.e. how many records are you willing to look at in details, partly based on your time/money and the value of corrected accurate data.
<>3>。 编制这些记录的表格。
<>4>。 如果你能够(外部)确定哪些是真实的,则可能使用电子邮件地址或其他领域与其他数据进行比较。
<>5>。 寻找模式。 是否有任何个领域:即:补贴、日期、用户_id等,视其是否有助于了解哪些记录是好的? 看看价值模式、低/高幅度、重复抽样数据(许多记录一栏的同值)、没有时间的日期、有孤儿的外国身份证的记录、你可以检查的几件事!
<>6>。 确定你们的最后宽容——你们是否寻求100%? 或者,有99.94%的固定为ok(well,然后是!) 用户?
7. Look at those duplicates you mentioned. For those records, can you apply any rule such as older record or newer record or low ID number to at least eliminate them?
我希望这一帮助!
Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...
I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...
Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...
Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...
I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...
Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...
Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...
I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...