tue/2IOC0-DBL/Datafiller - Fill database with tweets, etc.

Age	Commit message (Collapse)	Author	Files	Lines
2014-05-10	user: Add verified, description, fix coordinates type	Peter Wu	2	-2/+11

2014-05-10	Fix timestamp type	Peter Wu	2	-7/+10
	Without this cast, setTimestamp would complain that a timestamp is expected, but a text type is given.
2014-05-10	Convert String to DateTime (for created_at)	Peter Wu	2	-2/+14
	Extra efforts are done to keep the timezone information.
2014-05-10	More query fixes (incorrect field names, table alias)	Peter Wu	2	-4/+4

2014-05-10	Split url to tweetUrl and userUrl, misc fixes	Peter Wu	2	-21/+15
	* 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-10	NamedPreparedStatement: fix query parameters	Peter Wu	1	-3/+3

2014-05-10	Coordinates is an object with an array	Peter Wu	1	-1/+7
	Ensure that the array is of a fixed length, add tests to check for that.
2014-05-09	Entities can be missing, user.place is not a string	Peter Wu	1	-1/+5
	* User: place is not a string but a Place object. * User: entities is nullable. * Tweet: in_reply_to_user_id, coordinates is nullable. * ValidatingJsonDeserializer: Treat null values as missing fields. * ValidatingJsonDeserializerTest: Test for null values.
2014-05-09	Use upsert queries, convert to named parameter statements	Peter Wu	2	-82/+170
	Get rid of ispostedby, move it to tweet table ("userid")
2014-05-09	Get rid of useless method	Peter Wu	1	-49/+37

2014-05-09	Get rid of DBConnection	Peter Wu	2	-59/+65
	That construct was hiding the Connection instance. Very bad abstraction as I really need it to support transactions. While at it, make the prepared statement objects final such that it is detected when those are not properly initialized. In Main, use try-with-resources, remove a noisy "exit succesfull" [sic] message. Due to the extra try/catch for the db connection (RuntimeException is not OK my friend!), the indentation had to be changed.
2014-05-08	Get rid of unused crap	Peter Wu	1	-173/+0

2014-05-08	Replace JSON by GSON, adding extra validations	Peter Wu	1	-58/+59
	Also change reader method, tweets are not received via an observed but by submitting from the caller. Added TODO WTF here and there, formatted with Alt + Shift + F.
2014-05-07	data querries into database	S129778	1	-13/+103

2014-05-07	Removed the extranous DBQuery and simpel property	Maurice Laveaux	3	-50/+45
	* InputReader reads from Scanner.
2014-05-07	Added classes to refactor the database code.	Maurice Laveaux	4	-0/+285
	* DBConnection creates a persistent conn. * DBQuery resolves and executes queries. * QueryUtils creates sql query text.