Log of /dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayer.java

---

Revision 2539 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 11 08:05:01 2015 UTC (9 years ago) by torben
File length: 10225 byte(s)
Diff to previous 2496 , to selected 2274

Postnr skal selvfølgelig være short i aliasbean

---

Revision 2496 - (view) (download) (annotate) - [select for diffs]
Modified Wed Mar 25 04:20:44 2015 UTC (9 years, 2 months ago) by torben
File length: 10223 byte(s)
Diff to previous 2495 , to selected 2274

Lav om del debug false

---

Revision 2495 - (view) (download) (annotate) - [select for diffs]
Modified Wed Mar 25 04:18:49 2015 UTC (9 years, 2 months ago) by torben
File length: 10222 byte(s)
Diff to previous 2492 , to selected 2274

Implementer naturlig sortering for husnr i DataInspector

---

Revision 2492 - (view) (download) (annotate) - [select for diffs]
Modified Tue Mar 24 20:33:35 2015 UTC (9 years, 2 months ago) by torben
File length: 10223 byte(s)
Diff to previous 2490 , to selected 2274

Fix 100% dækning efter at postnr gemmes som short istedet for int

---

Revision 2490 - (view) (download) (annotate) - [select for diffs]
Modified Tue Mar 24 12:38:21 2015 UTC (9 years, 2 months ago) by torben
File length: 10220 byte(s)
Diff to previous 2489 , to selected 2274

Gadeident kan godt være i en 32bit int

---

Revision 2489 - (view) (download) (annotate) - [select for diffs]
Modified Tue Mar 24 11:05:24 2015 UTC (9 years, 2 months ago) by torben
File length: 10221 byte(s)
Diff to previous 2488 , to selected 2274

For some address vars, a 16bit short is more than enough

---

Revision 2488 - (view) (download) (annotate) - [select for diffs]
Modified Tue Mar 24 10:59:46 2015 UTC (9 years, 2 months ago) by torben
File length: 10176 byte(s)
Diff to previous 2487 , to selected 2274

Latitude / longitude doesn't require double precision (cuts 8 bytes from each Adresse instance)

---

Revision 2487 - (view) (download) (annotate) - [select for diffs]
Modified Tue Mar 24 10:47:26 2015 UTC (9 years, 2 months ago) by torben
File length: 10160 byte(s)
Diff to previous 2457 , to selected 2274

float er rigeligt til at gemme afstanden med

---

Revision 2457 - (view) (download) (annotate) - [select for diffs]
Modified Fri Mar 20 13:57:47 2015 UTC (9 years, 2 months ago) by torben
File length: 10152 byte(s)
Diff to previous 2442 , to selected 2274

switch to maven

---

Revision 2442 - (view) (download) (annotate) - [select for diffs]
Modified Fri Mar 13 12:57:01 2015 UTC (9 years, 2 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 10152 byte(s)
Diff to previous 2421 , to selected 2274

1) Træk Latitude/longitude på adressen helt med ud til resultatet
2) Ret en NPE fejl ved injectIntoBk

---

Revision 2421 - (view) (download) (annotate) - [select for diffs]
Modified Mon Mar 2 10:23:59 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 10052 byte(s)
Diff to previous 2420 , to selected 2274

Restructure DB error codes

---

Revision 2420 - (view) (download) (annotate) - [select for diffs]
Modified Mon Mar 2 10:23:35 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 10052 byte(s)
Diff to previous 2395 , to selected 2274

Restructure DB error codes

---

Revision 2395 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 27 09:39:05 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 9955 byte(s)
Diff to previous 2384 , to selected 2274

1) simplify helper code
2) read alias table from database and use 

---

Revision 2384 - (view) (download) (annotate) - [select for diffs]
Modified Thu Feb 26 13:11:45 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 8898 byte(s)
Diff to previous 2372 , to selected 2274

CSV udtraæk der sammenligner gl og ny service

---

Revision 2372 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 24 20:38:56 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 7795 byte(s)
Diff to previous 2337 , to selected 2274

Implemented search log to db

---

Revision 2337 - (view) (download) (annotate) - [select for diffs]
Modified Mon Feb 23 12:30:41 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5685 byte(s)
Diff to previous 2323 , to selected 2274

First version of admin page and data reload

---

Revision 2323 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 17 09:17:40 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5394 byte(s)
Diff to previous 2320 , to selected 2274

yet another deduplication

---

Revision 2320 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 17 08:58:41 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5279 byte(s)
Diff to previous 2319 , to selected 2274

Use deduplication in a more concistent way

---

Revision 2319 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 17 08:37:30 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5442 byte(s)
Diff to previous 2318 , to selected 2274

Even more deduplication

---

Revision 2318 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 17 08:27:13 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5557 byte(s)
Diff to previous 2317 , to selected 2274

Deduplicate transporttype ved udvidet dækning

---

Revision 2317 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 17 08:19:16 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5361 byte(s)
Diff to previous 2316 , to selected 2274

A bit more de-duplication

---

Revision 2316 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 17 07:38:24 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 5164 byte(s)
Diff to previous 2308 , to selected 2274

Implement deduplication for distributorer

---

Revision 2308 - (view) (download) (annotate) - [select for diffs]
Modified Mon Feb 16 09:51:24 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4890 byte(s)
Diff to previous 2297 , to selected 2274

1) Optimize DB read by forcing mysql to read 1 row at a time
2) Cache road names and there by forcing them to use a shared reference to the various strings - reducing memory consumption by ~100MB

---

Revision 2297 - (view) (download) (annotate) - [select for diffs]
Modified Sun Feb 15 10:14:07 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4461 byte(s)
Diff to previous 2296 , to selected 2274

Remove debug statements

---

Revision 2296 - (view) (download) (annotate) - [select for diffs]
Modified Sun Feb 15 10:11:13 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4527 byte(s)
Diff to previous 2285 , to selected 2274

Tag kun adresser ud hvor vi har en gadeident

---

Revision 2285 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 15:58:36 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4424 byte(s)
Diff to previous 2283 , to selected 2274

1) Sørg for at data strukturerne har en fornuftig initial Capacity for an undgå for mange udvidelser under start
2) da vi ikke bruger idAdresseMap efter indlæsningen er der der ingen grund til at gemme disse data på objekt niveau

---

Revision 2283 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 15:45:24 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4361 byte(s)
Diff to previous 2282 , to selected 2274

Korrekt håndtering af BK udvidet dækning + lad MySQL lave case konvertering for at undgå en masse ekstra String objekter under opbygningen.

---

Revision 2282 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 15:15:13 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4467 byte(s)
Diff to previous 2281 , to selected 2274

Flyt alle bean typer ned i sin egen package

---

Revision 2281 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 15:12:28 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4449 byte(s)
Diff to previous 2279 , to selected 2274

Ingen grund til at gemme vasketVejnavn i adresse POJO'en da det bare kræver mere hukommelse

---

Revision 2279 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 14:38:59 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 4477 byte(s)
Diff to previous 2276 , to selected 2274

Implementer 100pct dækning

---

Revision 2276 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 13:48:09 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 3392 byte(s)
Diff to previous 2275 , to selected 2274

Implementer udvidet dækning i DAO & BK

---

Revision 2275 - (view) (download) (annotate) - [select for diffs]
Modified Fri Feb 13 11:52:33 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 1855 byte(s)
Diff to previous 2274

Tilføj odder til test postnumre

---

Revision 2274 - (view) (download) (annotate) - [selected]
Added Fri Feb 13 11:48:23 2015 UTC (9 years, 3 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 1840 byte(s)

First functioning edition