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

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, 1 month ago) by torben
File length: 10223 byte(s)
Diff to previous 2495

Lav om del debug false

---

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

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, 1 month ago) by torben
File length: 10223 byte(s)
Diff to previous 2490

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, 1 month ago) by torben
File length: 10220 byte(s)
Diff to previous 2489

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, 1 month ago) by torben
File length: 10221 byte(s)
Diff to previous 2488

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, 1 month ago) by torben
File length: 10176 byte(s)
Diff to previous 2487

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, 1 month ago) by torben
File length: 10160 byte(s)
Diff to previous 2457

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, 1 month ago) by torben
File length: 10152 byte(s)
Diff to previous 2442

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

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, 2 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 10052 byte(s)
Diff to previous 2420

Restructure DB error codes

---

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

Restructure DB error codes

---

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

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, 2 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 8898 byte(s)
Diff to previous 2372

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, 2 months ago) by torben
Original Path: dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java
File length: 7795 byte(s)
Diff to previous 2337

Implemented search log to db

---

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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) - [select for diffs]
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