Advertisement
Guest User

Untitled

a guest
Feb 25th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. selectWord(){
  2. this.myWords_en=[];
  3. this.myWords_pl=[];
  4.  
  5. var id_translation: Array<Object>;
  6. id_translation=[];
  7. console.log("Id group_selected "+this.id_group_selected);
  8. this.database.executeSql("SELECT * FROM group_translation WHERE id_group='"+ this.id_group_selected +"'",[]).then((data) =>{
  9.  
  10. console.log("Id tłumaczenia z grup_translation "+data.rows.item(0).id);
  11. if(data.rows.length > 0) {
  12. for(let i=0; i<data.rows.length;i++)
  13. {
  14. // console.log(JSON.stringify(data.rows.item(i)));
  15.  
  16. let myGroupTranslation: Group_translation=new Group_translation();
  17. myGroupTranslation.id_translation=data.rows.item(i).id_translation;
  18. myGroupTranslation.id_group=data.rows.item(i).id_group;
  19.  
  20. console.log("Id tłumaczenia z grup_translation "+data.rows.item(i).id_translation);
  21.  
  22. this.database.executeSql("SELECT id_word_en, id_word_pl FROM translation WHERE id='"+data.rows.item(i).id_translation+"'",[]).then((data) =>{
  23. let myTranslation: Translation=new Translation();
  24. myTranslation.id_word_pl=data.rows.item(0).id_word_pl;
  25. myTranslation.id_word_en=data.rows.item(0).id_word_en;
  26.  
  27. console.log("Id słowa polskiego "+data.rows.item(0).id_word_pl);
  28. console.log("Id słowa angielskiego "+data.rows.item(0).id_word_en);
  29.  
  30. this.database.executeSql("SELECT word_en_name FROM word_en WHERE id='"+data.rows.item(0).id_word_en+"'",[]).then((data) =>{
  31. let myWord_en: Word_en=new Word_en();
  32. myWord_en.word_en_name=data.rows.item(0).word_en_name;
  33. this.myWords_en.push(myWord_en);
  34.  
  35. console.log("Słowo angielskie "+data.rows.item(0).word_en_name);
  36.  
  37. },(error) =>{
  38. console.log("Błąd z pobraniem słowa angielskiego ")
  39. });
  40.  
  41. this.database.executeSql("SELECT word_pl_name FROM word_pl WHERE id='"+data.rows.item(0).id_word_pl+"'",[]).then((data) =>{
  42. let myWord_pl: Word_pl=new Word_pl();
  43. myWord_pl.word_pl_name=data.rows.item(0).word_pl_name;
  44. this.myWords_pl.push(myWord_pl);
  45. console.log("Słowo polskie "+data.rows.item(0).word_pl_name);
  46. },(error) =>{
  47. console.log("Błąd z pobraniem słowa polskiego ")
  48. });
  49.  
  50. },(error) => {
  51. console.log("Błąd z pobraniem id_word_en i id_word_pl from translation");
  52. });
  53.  
  54. }
  55.  
  56. }
  57. //
  58.  
  59. }, (error)=>{
  60. console.log("Bład z selectem id_translation"+ JSON.stringify(error.err));
  61. });
  62. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement