Akcije
Podrška #26028
Zatvoren
FMK2FMK migracija - ubaciti u F18 ?
Dodano od Ernad Husremović prije više od 14 godina. Izmjenjeno prije oko 13 godina.
Početak:
02.01.2012
Završetak:
% završeno:
0%
Procjena vremena:
Izmjenjeno od Ernad Husremović prije više od 14 godina
poziv
upload dbf tabele na aserver
./F18 --dbf2server dbf_dir
Izmjenjeno od Ernad Husremović prije više od 14 godina
- Naslov promijenjeno iz FMK2FMK migracija - ubaciti u F18 u FMK2FMK migracija - ubaciti u F18 ?
zadamo npr. root direktorij
c:/sigma
i on prođe kroz sve module i preuzme podatke
Izmjenjeno od Ernad Husremović prije više od 14 godina
https://github.com/knowhow/F18_knowhow/commit/9ab5aa051fcb298c8170d16d5f7
hernad@macan:~/github/F18_knowhow$ cat F18_test.log
TEST_MIGRATE: /tmp/SIGMA FMK_MIGRATE: /tmp/SIGMA/ADMIN FMK_MIGRATE: /tmp/SIGMA/ADMIN/KUM1 FMK_MIGRATE: /tmp/SIGMA/ADMIN/KUM1/1999 FMK_MIGRATE: /tmp/SIGMA/ADMIN/KUM1/2000 FMK_MIGRATE: /tmp/SIGMA/ADMIN/KUM2 FMK_MIGRATE: /tmp/SIGMA/EPDV FMK_MIGRATE: /tmp/SIGMA/EPDV/KUM1 FMK_MIGRATE: /tmp/SIGMA/EPDV/KUM1/2006 FMK_MIGRATE: /tmp/SIGMA/EPDV/KUM1/2008 ... FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM1/2007 FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM1/2008 FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM1/2009 FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM1/2010 FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM1/POM FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM1/TEMP FMK_MIGRATE: /tmp/SIGMA/FAKT/KUM2 FMK_MIGRATE: /tmp/SIGMA/fin FMK_MIGRATE: /tmp/SIGMA/fin/2009 FMK_MIGRATE: /tmp/SIGMA/fin/2010 FMK_MIGRATE: /tmp/SIGMA/fin/2011 FMK_MIGRATE: /tmp/SIGMA/fin/2011/test FMK_MIGRATE: /tmp/SIGMA/fin/KUM1 /tmp/SIGMA/fin/KUM1/ANAL.DBF=> b_year=2012 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/SUBAN.DBF=> b_year=2012 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/1996 /tmp/SIGMA/fin/KUM1/1996/ANAL.DBF=> b_year=1996 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/1996/SUBAN.DBF=> b_year=1996 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/1997 /tmp/SIGMA/fin/KUM1/1997/ANAL.DBF=> b_year=1997 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/1997/SUBAN.DBF=> b_year=1997 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/1998 /tmp/SIGMA/fin/KUM1/1998/ANAL.DBF=> b_year=1998 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/1998/SUBAN.DBF=> b_year=1998 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/1999 /tmp/SIGMA/fin/KUM1/1999/ANAL.DBF=> b_year=1999 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/1999/SUBAN.DBF=> b_year=1999 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2000 /tmp/SIGMA/fin/KUM1/2000/ANAL.DBF=> b_year=2000 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2000/SUBAN.DBF=> b_year=2000 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2001 /tmp/SIGMA/fin/KUM1/2001/ANAL.DBF=> b_year=2001 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2001/SUBAN.DBF=> b_year=2001 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2002 /tmp/SIGMA/fin/KUM1/2002/ANAL.DBF=> b_year=2002 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2002/SUBAN.DBF=> b_year=2002 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2003 /tmp/SIGMA/fin/KUM1/2003/ANAL.DBF=> b_year=2003 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2003/SUBAN.DBF=> b_year=2003 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2004 /tmp/SIGMA/fin/KUM1/2004/ANAL.DBF=> b_year=2004 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2004/SUBAN.DBF=> b_year=2004 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2005 /tmp/SIGMA/fin/KUM1/2005/ANAL.DBF=> b_year=2005 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2005/SUBAN.DBF=> b_year=2005 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2006 /tmp/SIGMA/fin/KUM1/2006/ANAL.DBF=> b_year=2006 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2006/SUBAN.DBF=> b_year=2006 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2007 /tmp/SIGMA/fin/KUM1/2007/ANAL.DBF=> b_year=2007 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2007/SUBAN.DBF=> b_year=2007 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2008 /tmp/SIGMA/fin/KUM1/2008/ANAL.DBF=> b_year=2008 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2008/SUBAN.DBF=> b_year=2008 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2009 /tmp/SIGMA/fin/KUM1/2009/ANAL.DBF=> b_year=2009 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2009/SUBAN.DBF=> b_year=2009 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/2010 /tmp/SIGMA/fin/KUM1/2010/ANAL.DBF=> b_year=2010 org_id=1 / fin_anal /tmp/SIGMA/fin/KUM1/2010/SUBAN.DBF=> b_year=2010 org_id=1 / fin_suban FMK_MIGRATE: /tmp/SIGMA/fin/KUM1/SQL FMK_MIGRATE: /tmp/SIGMA/fin/KUM2 /tmp/SIGMA/fin/KUM2/ANAL.DBF=> b_year=2012 org_id=2 / fin_anal /tmp/SIGMA/fin/KUM2/SUBAN.DBF=> b_year=2012 org_id=2 / fin_suban FMK_MIGRATE: /tmp/SIGMA/KALK FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/1996 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/1997 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/1998 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/1999 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2000 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2001 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2002 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2003 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2004 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2005 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2006 FMK_MIGRATE: /tmp/SIGMA/KALK/KUM1/2007 F... FMK_MIGRATE: /tmp/SIGMA/LD/KUM1/2006 FMK_MIGRATE: /tmp/SIGMA/LD/KUM1/2007 FMK_MIGRATE: /tmp/SIGMA/LD/KUM1/2008 FMK_MIGRATE: /tmp/SIGMA/LD/KUM2 FMK_MIGRATE: /tmp/SIGMA/NAPLATA FMK_MIGRATE: /tmp/SIGMA/OS FMK_MIGRATE: /tmp/SIGMA/OS/KUM1 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/1996 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/1997 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/1998 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/1999 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/2000 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/2001 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/2002 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/2003 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/2004 FMK_MIGRATE: /tmp/SIGMA/OS/KUM1/2005 .... FMK_MIGRATE: /tmp/SIGMA/SIF1/2010 FMK_MIGRATE: /tmp/SIGMA/SIF1/2011 FMK_MIGRATE: /tmp/SIGMA/SIF2 FMK_MIGRATE: /tmp/SIGMA/SIF2/2007 FMK_MIGRATE: /tmp/SIGMA/SII FMK_MIGRATE: /tmp/SIGMA/SII/KUM1 FMK_MIGRATE: /tmp/SIGMA/SII/KUM1/2005 .. FMK_MIGRATE: /tmp/SIGMA/SII/KUM1/2010 FMK_MIGRATE: /tmp/SIGMA/SII/KUM1/POM FMK_MIGRATE: /tmp/SIGMA/SII/KUM2 FMK_MIGRATE: /tmp/SIGMA/VIRM FMK_MIGRATE: /tmp/SIGMA/VIRM/KUM1 FMK_MIGRATE: /tmp/SIGMA/VIRM/KUM1/1997 FMK_MIGRATE: /tmp/SIGMA/VIRM/KUM1/1998 FMK_MIGRATE: /tmp/SIGMA/VIRM/KUM2
Izmjenjeno od Ernad Husremović prije više od 14 godina
nema šta. ovo treba završiti. time bi se posao migracije sveo na 0 u smislu angažmana servisera.
push procedura treba provjeriti ima li u nekoj tabeli slogova za org_jed / b_year. ako nema pushira se na server ako ima ne radi ništa.
time je procedura migracije idempotentna - može se pokrenuti više puta bez ikakve bojazni od razvaljivanja serverske baze.
Izmjenjeno od Ernad Husremović prije više od 14 godina
- Prioritet promijenjeno iz Normalan u Odmah riješiti
sa ovom inteligentnom migracijom, te podršci više org_id (više firmi jezikom FMK) i više b_year/b_seasson (podrška sezonama jezikom fmk)
obezbjeđuju se svi preduslovi za masovnu migraciju FMK korisnika na F18.
Izmjenjeno od Ernad Husremović prije više od 14 godina
parametrizirati:
- tekuća godina - ako nije urađeno razdvajanje sezona kao sa ovim testnim podacima sezona mora biti -1 (2011) a ne tekuća godina
- root sigma lokacija
Izmjenjeno od Ernad Husremović prije oko 13 godina
- Status promijenjeno iz Dodijeljeno u Odbačeno
Akcije