summaryrefslogtreecommitdiff
path: root/src/database/NamedPreparedStatement.java
AgeCommit message (Collapse)AuthorFilesLines
2014-05-10Convert long to int where possible, fix retweetidPeter Wu1-6/+15
If there is no retweet, the retweetid must really be NULL, not 0. In order to better match the database, convert some types to integers too.
2014-05-10user: Add verified, description, fix coordinates typePeter Wu1-0/+6
2014-05-10Fix timestamp typePeter Wu1-2/+2
Without this cast, setTimestamp would complain that a timestamp is expected, but a text type is given.
2014-05-10Convert String to DateTime (for created_at)Peter Wu1-0/+12
Extra efforts are done to keep the timezone information.
2014-05-10More query fixes (incorrect field names, table alias)Peter Wu1-0/+1
2014-05-10Split url to tweetUrl and userUrl, misc fixesPeter Wu1-0/+10
* Insert User URLs. * Fix hash insertion query (copy/paste error...). * Split url to tweetUrl and userUrl as there is no "url" table anymore. * Do not execute queries directly via getStmt(), but execute them via NamedPreparedStatement such that faulty queries can be printed. * Fix buildQuery for more than two primary keys. * Drop comments from prepared statements members in DataFiller, there is nothing that you cannot learn from the variable name. Besides there was a copy/paste error for mentions. * Change order of insertion to ensure consistency. * Inline setting parameters for queries, it is now more transparant.
2014-05-10NamedPreparedStatement: fix query parametersPeter Wu1-3/+3
2014-05-09Use upsert queries, convert to named parameter statementsPeter Wu1-0/+69
Get rid of ispostedby, move it to tweet table ("userid")