How to use set_text method in uiautomator

Best Python code snippet using uiautomator

topman

Source:topman

...246 else:247 s_zahl_0=1248 249 250 devicePageEntry.set_text(str(s_zahl_0))251 self.updateDev()252 def devForward(self, deviceButtonForward):253 devicePageEntry = self.builder.get_object("devicePageEntry")254 print("vor")255 global s_zahl_0256 s_zahl_0=int(devicePageEntry.get_text())257 258 s_zahl_0=s_zahl_0+1259 devicePageEntry.set_text(str(s_zahl_0))260 261 self.updateDev()262 263 def userBack(self, userButtonBack):264 userPageEntry = self.builder.get_object("userPageEntry")265 global s_zahl_1266 s_zahl_0=int(userPageEntry.get_text())267 if (s_zahl_1>2):268 s_zahl_1=s_zahl_1-1269 print('Seite: ',s_zahl_1)270 else:271 s_zahl_1=1272 273 274 userPageEntry.set_text(str(s_zahl_1))275 self.updateUser()276 277 def userForward(self, userButtonForward):278 userPageEntry = self.builder.get_object("userPageEntry")279 print("vor")280 global s_zahl_1281 s_zahl_1=int(userPageEntry.get_text())282 283 s_zahl_1=s_zahl_1+1284 userPageEntry.set_text(str(s_zahl_1))285 self.updateUser()286 287 def getsBack(self, getsButtonBack):288 getsPageEntry = self.builder.get_object("getsPageEntry")289 global s_zahl_2290 s_zahl_2=int(getsPageEntry.get_text())291 if (s_zahl_2>2):292 s_zahl_2=s_zahl_2-1293 print('Seite: ',s_zahl_2)294 else:295 s_zahl_2=1296 297 298 getsPageEntry.set_text(str(s_zahl_2))299 self.updateGets()300 301 def getsForward(self, getsButtonForward):302 getsPageEntry = self.builder.get_object("getsPageEntry")303 print("vor")304 global s_zahl_2305 s_zahl_2=int(getsPageEntry.get_text())306 307 s_zahl_2=s_zahl_2+1308 getsPageEntry.set_text(str(s_zahl_2))309 self.updateGets()310 311 def actUpdate(self, buttonUpdate):312 self.updateDev()313 self.updateUser()314 self.updateGets()315 316 def updateDev(self):317 #Devices318 self.E_0_0 = self.builder.get_object("Id_0")319 self.E_1_0 = self.builder.get_object("Id_1")320 self.E_2_0 = self.builder.get_object("Id_2")321 self.E_3_0 = self.builder.get_object("Id_3")322 self.E_4_0 = self.builder.get_object("Id_4")323 self.E_5_0 = self.builder.get_object("Id_5")324 self.E_6_0 = self.builder.get_object("Id_6")325 self.E_7_0 = self.builder.get_object("Id_7")326 self.E_8_0 = self.builder.get_object("Id_8")327 self.E_9_0 = self.builder.get_object("Id_9")328 329 self.E_0_1 = self.builder.get_object("Brand_0")330 self.E_1_1 = self.builder.get_object("Brand_1")331 self.E_2_1 = self.builder.get_object("Brand_2")332 self.E_3_1 = self.builder.get_object("Brand_3")333 self.E_4_1 = self.builder.get_object("Brand_4")334 self.E_5_1 = self.builder.get_object("Brand_5")335 self.E_6_1 = self.builder.get_object("Brand_6")336 self.E_7_1 = self.builder.get_object("Brand_7")337 self.E_8_1 = self.builder.get_object("Brand_8")338 self.E_9_1 = self.builder.get_object("Brand_9")339 340 self.E_0_2 = self.builder.get_object("Model_0")341 self.E_1_2 = self.builder.get_object("Model_1")342 self.E_2_2 = self.builder.get_object("Model_2")343 self.E_3_2 = self.builder.get_object("Model_3")344 self.E_4_2 = self.builder.get_object("Model_4")345 self.E_5_2 = self.builder.get_object("Model_5")346 self.E_6_2 = self.builder.get_object("Model_6")347 self.E_7_2 = self.builder.get_object("Model_7")348 self.E_8_2 = self.builder.get_object("Model_8")349 self.E_9_2 = self.builder.get_object("Model_9")350 351 self.E_0_3 = self.builder.get_object("OS_0")352 self.E_1_3 = self.builder.get_object("OS_1")353 self.E_2_3 = self.builder.get_object("OS_2")354 self.E_3_3 = self.builder.get_object("OS_3")355 self.E_4_3 = self.builder.get_object("OS_4")356 self.E_5_3 = self.builder.get_object("OS_5")357 self.E_6_3 = self.builder.get_object("OS_6")358 self.E_7_3 = self.builder.get_object("OS_7")359 self.E_8_3 = self.builder.get_object("OS_8")360 self.E_9_3 = self.builder.get_object("OS_9")361 362 self.E_0_4 = self.builder.get_object("Hostname_0")363 self.E_1_4 = self.builder.get_object("Hostname_1")364 self.E_2_4 = self.builder.get_object("Hostname_2")365 self.E_3_4 = self.builder.get_object("Hostname_3")366 self.E_4_4 = self.builder.get_object("Hostname_4")367 self.E_5_4 = self.builder.get_object("Hostname_5")368 self.E_6_4 = self.builder.get_object("Hostname_6")369 self.E_7_4 = self.builder.get_object("Hostname_7")370 self.E_8_4 = self.builder.get_object("Hostname_8")371 self.E_9_4 = self.builder.get_object("Hostname_9")372 373 self.E_0_5 = self.builder.get_object("Status_0")374 self.E_1_5 = self.builder.get_object("Status_1")375 self.E_2_5 = self.builder.get_object("Status_2")376 self.E_3_5 = self.builder.get_object("Status_3")377 self.E_4_5 = self.builder.get_object("Status_4")378 self.E_5_5 = self.builder.get_object("Status_5")379 self.E_6_5 = self.builder.get_object("Status_6")380 self.E_7_5 = self.builder.get_object("Status_7")381 self.E_8_5 = self.builder.get_object("Status_8")382 self.E_9_5 = self.builder.get_object("Status_9")383 384 385 global s_zahl_0386 connection = sqlite3.connect(db)387 cursor= connection.cursor()388 sql = "SELECT * FROM Devices"389 cursor.execute(sql)390 391 text=""392 column_x=[]393 row_x=[]394 395 i=0396 for row in cursor:397 398 r0=str(row[0])399 r1=str(row[1])400 r2=str(row[2])401 r3=str(row[3])402 r4=str(row[4])403 r5=str(row[5])404 405 406 column_x = [(r0, r1, r2, r3, r4, r5)]407 row_x.extend(column_x)408 409 410 connection.commit()411 connection.close()412 print("len(column_x)", len(column_x))413 print("len(row_x)", len(row_x))414 x=len(row_x)415 #Reihe 0416 i=0417 self.E_0_0.set_text("") 418 k=0+(s_zahl_0-1)*10419 x=""420 try:421 x=str(row_x[k][i])422 self.E_0_0.set_text(x)423 print(self.E_0_0.get_text())424 except:425 self.E_0_0.set_text("")426 i=1427 self.E_0_1.set_text("") 428 k=0+(s_zahl_0-1)*10429 x=""430 try:431 x=str(row_x[k][i])432 print("x ",x)433 self.E_0_1.set_text(x)434 except:435 self.E_0_1.set_text("")436 437 i=2438 self.E_0_2.set_text("") 439 k=0+(s_zahl_0-1)*10440 x=""441 try:442 x=str(row_x[k][i])443 self.E_0_2.set_text(x)444 except:445 self.E_0_2.set_text("")446 447 i=3448 self.E_0_3.set_text("") 449 k=0+(s_zahl_0-1)*10450 x=""451 try:452 x=str(row_x[k][i])453 self.E_0_3.set_text(x)454 except:455 self.E_0_3.set_text("")456 i=4457 self.E_0_4.set_text("") 458 k=0+(s_zahl_0-1)*10459 x=""460 try:461 x=str(row_x[k][i])462 self.E_0_4.set_text(x)463 except:464 self.E_0_4.set_text("")465 i=5466 self.E_0_5.set_text("") 467 k=0+(s_zahl_0-1)*10468 x=""469 try:470 x=str(row_x[k][i])471 self.E_0_5.set_text(x)472 except:473 self.E_0_5.set_text("") 474 475 476 477 #Reihe1478 i=0479 self.E_1_0.set_text("") 480 k=1+(s_zahl_0-1)*10481 x=""482 try:483 x=str(row_x[k][i])484 self.E_1_0.set_text(x)485 except:486 self.E_1_0.set_text("")487 i=1488 self.E_1_1.set_text("") 489 k=1+(s_zahl_0-1)*10490 x=""491 try:492 x=str(row_x[k][i])493 print("x ",x)494 self.E_1_1.set_text(x)495 except:496 self.E_1_1.set_text("")497 498 i=2499 self.E_1_2.set_text("") 500 k=1+(s_zahl_0-1)*10501 x=""502 try:503 x=str(row_x[k][i])504 self.E_1_2.set_text(x)505 except:506 self.E_1_2.set_text("")507 508 i=3509 self.E_1_3.set_text("") 510 k=1+(s_zahl_0-1)*10511 x=""512 try:513 x=str(row_x[k][i])514 self.E_1_3.set_text(x)515 except:516 self.E_1_3.set_text("")517 i=4518 self.E_1_4.set_text("") 519 k=1+(s_zahl_0-1)*10520 x=""521 try:522 x=str(row_x[k][i])523 self.E_1_4.set_text(x)524 except:525 self.E_1_4.set_text("")526 527 i=5528 self.E_1_5.set_text("") 529 k=1+(s_zahl_0-1)*10530 x=""531 try:532 x=str(row_x[k][i])533 self.E_1_5.set_text(x)534 except:535 self.E_1_5.set_text("")536 #Reihe2537 i=0538 self.E_2_0.set_text("") 539 k=2+(s_zahl_0-1)*10540 x=""541 try:542 x=str(row_x[k][i])543 self.E_2_0.set_text(x)544 except:545 self.E_2_0.set_text("")546 i=1547 self.E_2_1.set_text("") 548 k=2+(s_zahl_0-1)*10549 x=""550 try:551 x=str(row_x[k][i])552 print("x ",x)553 self.E_2_1.set_text(x)554 except:555 self.E_2_1.set_text("")556 557 i=2558 self.E_2_2.set_text("") 559 k=2+(s_zahl_0-1)*10560 x=""561 try:562 x=str(row_x[k][i])563 self.E_2_2.set_text(x)564 except:565 self.E_2_2.set_text("")566 567 i=3568 self.E_2_3.set_text("") 569 k=2+(s_zahl_0-1)*10570 x=""571 try:572 x=str(row_x[k][i])573 self.E_2_3.set_text(x)574 except:575 self.E_2_3.set_text("")576 i=4577 self.E_2_4.set_text("") 578 k=2+(s_zahl_0-1)*10579 x=""580 try:581 x=str(row_x[k][i])582 self.E_2_4.set_text(x)583 except:584 self.E_2_4.set_text("")585 586 i=5587 self.E_2_5.set_text("") 588 k=2+(s_zahl_0-1)*10589 x=""590 try:591 x=str(row_x[k][i])592 self.E_2_5.set_text(x)593 except:594 self.E_2_5.set_text("")595 #Reihe3596 i=0597 self.E_3_0.set_text("") 598 k=3+(s_zahl_0-1)*10599 x=""600 try:601 x=str(row_x[k][i])602 self.E_3_0.set_text(x)603 except:604 self.E_3_0.set_text("")605 i=1606 self.E_3_1.set_text("") 607 k=3+(s_zahl_0-1)*10608 x=""609 try:610 x=str(row_x[k][i])611 print("x ",x)612 self.E_3_1.set_text(x)613 except:614 self.E_3_1.set_text("")615 616 i=2617 self.E_3_2.set_text("") 618 k=3+(s_zahl_0-1)*10619 x=""620 try:621 x=str(row_x[k][i])622 self.E_3_2.set_text(x)623 except:624 self.E_3_2.set_text("")625 626 i=3627 self.E_3_3.set_text("") 628 k=3+(s_zahl_0-1)*10629 x=""630 try:631 x=str(row_x[k][i])632 self.E_3_3.set_text(x)633 except:634 self.E_3_3.set_text("")635 i=4636 self.E_3_4.set_text("") 637 k=3+(s_zahl_0-1)*10638 x=""639 try:640 x=str(row_x[k][i])641 self.E_3_4.set_text(x)642 except:643 self.E_3_4.set_text("")644 i=5645 self.E_3_5.set_text("") 646 k=3+(s_zahl_0-1)*10647 x=""648 try:649 x=str(row_x[k][i])650 self.E_3_5.set_text(x)651 except:652 self.E_3_5.set_text("")653 654 #Reihe4655 i=0656 self.E_4_0.set_text("") 657 k=4+(s_zahl_0-1)*10658 x=""659 try:660 x=str(row_x[k][i])661 self.E_4_0.set_text(x)662 except:663 self.E_4_0.set_text("")664 i=1665 self.E_4_1.set_text("") 666 k=4+(s_zahl_0-1)*10667 x=""668 try:669 x=str(row_x[k][i])670 print("x ",x)671 self.E_4_1.set_text(x)672 except:673 self.E_4_1.set_text("")674 675 i=2676 self.E_4_2.set_text("") 677 k=4+(s_zahl_0-1)*10678 x=""679 try:680 x=str(row_x[k][i])681 self.E_4_2.set_text(x)682 except:683 self.E_4_2.set_text("")684 685 i=3686 self.E_4_3.set_text("") 687 k=4+(s_zahl_0-1)*10688 x=""689 try:690 x=str(row_x[k][i])691 self.E_4_3.set_text(x)692 except:693 self.E_4_3.set_text("")694 i=4695 self.E_4_4.set_text("") 696 k=4+(s_zahl_0-1)*10697 x=""698 try:699 x=str(row_x[k][i])700 self.E_4_4.set_text(x)701 except:702 self.E_4_4.set_text("")703 704 i=5705 self.E_4_5.set_text("") 706 k=4+(s_zahl_0-1)*10707 x=""708 try:709 x=str(row_x[k][i])710 self.E_4_5.set_text(x)711 except:712 self.E_4_5.set_text("")713 714 #Reihe5715 i=0716 self.E_5_0.set_text("") 717 k=5+(s_zahl_0-1)*10718 x=""719 try:720 x=str(row_x[k][i])721 self.E_5_0.set_text(x)722 except:723 self.E_5_0.set_text("")724 i=1725 self.E_5_1.set_text("") 726 k=5+(s_zahl_0-1)*10727 x=""728 try:729 x=str(row_x[k][i])730 print("x ",x)731 self.E_5_1.set_text(x)732 except:733 self.E_5_1.set_text("")734 735 i=2736 self.E_5_2.set_text("") 737 k=5+(s_zahl_0-1)*10738 x=""739 try:740 x=str(row_x[k][i])741 self.E_5_2.set_text(x)742 except:743 self.E_5_2.set_text("")744 745 i=3746 self.E_5_3.set_text("") 747 k=5+(s_zahl_0-1)*10748 x=""749 try:750 x=str(row_x[k][i])751 self.E_5_3.set_text(x)752 except:753 self.E_5_3.set_text("")754 i=4755 self.E_5_4.set_text("") 756 k=5+(s_zahl_0-1)*10757 x=""758 try:759 x=str(row_x[k][i])760 self.E_5_4.set_text(x)761 except:762 self.E_5_4.set_text("")763 764 i=5765 self.E_5_5.set_text("") 766 k=5+(s_zahl_0-1)*10767 x=""768 try:769 x=str(row_x[k][i])770 self.E_5_5.set_text(x)771 except:772 self.E_5_5.set_text("")773 774 #Reihe6775 i=0776 self.E_6_0.set_text("") 777 k=6+(s_zahl_0-1)*10778 x=""779 try:780 x=str(row_x[k][i])781 self.E_6_0.set_text(x)782 except:783 self.E_6_0.set_text("")784 785 i=1786 self.E_6_1.set_text("") 787 k=6+(s_zahl_0-1)*10788 x=""789 try:790 x=str(row_x[k][i])791 print("x ",x)792 self.E_6_1.set_text(x)793 except:794 self.E_6_1.set_text("")795 796 i=2797 self.E_6_2.set_text("") 798 k=6+(s_zahl_0-1)*10799 x=""800 try:801 x=str(row_x[k][i])802 self.E_6_2.set_text(x)803 except:804 self.E_6_2.set_text("")805 806 i=3807 self.E_6_3.set_text("") 808 k=6+(s_zahl_0-1)*10809 x=""810 try:811 x=str(row_x[k][i])812 self.E_6_3.set_text(x)813 except:814 self.E_6_3.set_text("")815 i=4816 self.E_6_4.set_text("") 817 k=6+(s_zahl_0-1)*10818 x=""819 try:820 x=str(row_x[k][i])821 self.E_6_4.set_text(x)822 except:823 self.E_6_4.set_text("")824 825 i=5826 self.E_6_5.set_text("") 827 k=6+(s_zahl_0-1)*10828 x=""829 try:830 x=str(row_x[k][i])831 self.E_6_5.set_text(x)832 except:833 self.E_6_5.set_text("")834 835 #Reihe7836 i=0837 self.E_7_0.set_text("") 838 k=7+(s_zahl_0-1)*10839 x=""840 try:841 x=str(row_x[k][i])842 self.E_7_0.set_text(x)843 except:844 self.E_7_0.set_text("")845 i=1846 self.E_7_1.set_text("") 847 k=7+(s_zahl_0-1)*10848 x=""849 try:850 x=str(row_x[k][i])851 print("x ",x)852 self.E_7_1.set_text(x)853 except:854 self.E_7_1.set_text("")855 856 i=2857 self.E_7_2.set_text("") 858 k=7+(s_zahl_0-1)*10859 x=""860 try:861 x=str(row_x[k][i])862 self.E_7_2.set_text(x)863 except:864 self.E_7_2.set_text("")865 866 i=3867 self.E_7_3.set_text("") 868 k=7+(s_zahl_0-1)*10869 x=""870 try:871 x=str(row_x[k][i])872 self.E_7_3.set_text(x)873 except:874 self.E_7_3.set_text("")875 i=4876 self.E_7_4.set_text("") 877 k=7+(s_zahl_0-1)*10878 x=""879 try:880 x=str(row_x[k][i])881 self.E_7_4.set_text(x)882 except:883 self.E_7_4.set_text("")884 885 i=5886 self.E_7_5.set_text("") 887 k=7+(s_zahl_0-1)*10888 x=""889 try:890 x=str(row_x[k][i])891 self.E_7_5.set_text(x)892 except:893 self.E_7_5.set_text("")894 #Reihe8895 i=0896 self.E_8_0.set_text("") 897 k=8+(s_zahl_0-1)*10898 x=""899 try:900 x=str(row_x[k][i])901 self.E_8_0.set_text(x)902 except:903 self.E_8_0.set_text("")904 i=1905 self.E_8_1.set_text("") 906 k=8+(s_zahl_0-1)*10907 x=""908 try:909 x=str(row_x[k][i])910 print("x ",x)911 self.E_8_1.set_text(x)912 except:913 self.E_8_1.set_text("")914 915 i=2916 self.E_8_2.set_text("") 917 k=8+(s_zahl_0-1)*10918 x=""919 try:920 x=str(row_x[k][i])921 self.E_8_2.set_text(x)922 except:923 self.E_8_2.set_text("")924 925 i=3926 self.E_8_3.set_text("") 927 k=8+(s_zahl_0-1)*10928 x=""929 try:930 x=str(row_x[k][i])931 self.E_8_3.set_text(x)932 except:933 self.E_8_3.set_text("")934 i=4935 self.E_8_4.set_text("") 936 k=8+(s_zahl_0-1)*10937 x=""938 try:939 x=str(row_x[k][i])940 self.E_8_4.set_text(x)941 except:942 self.E_8_4.set_text("")943 944 i=5945 self.E_8_5.set_text("") 946 k=8+(s_zahl_0-1)*10947 x=""948 try:949 x=str(row_x[k][i])950 self.E_8_5.set_text(x)951 except:952 self.E_8_5.set_text("")953 954 #Reihe9955 i=0956 self.E_9_0.set_text("") 957 k=9+(s_zahl_0-1)*10958 x=""959 try:960 x=str(row_x[k][i])961 self.E_9_0.set_text(x)962 except:963 self.E_9_0.set_text("")964 i=1965 self.E_9_1.set_text("") 966 k=9+(s_zahl_0-1)*10967 x=""968 try:969 x=str(row_x[k][i])970 print("x ",x)971 self.E_9_1.set_text(x)972 except:973 self.E_9_1.set_text("")974 975 i=2976 self.E_9_2.set_text("") 977 k=9+(s_zahl_0-1)*10978 x=""979 try:980 x=str(row_x[k][i])981 self.E_9_2.set_text(x)982 except:983 self.E_9_2.set_text("")984 985 i=3986 self.E_9_3.set_text("") 987 k=9+(s_zahl_0-1)*10988 x=""989 try:990 x=str(row_x[k][i])991 self.E_9_3.set_text(x)992 except:993 self.E_9_3.set_text("")994 i=4995 self.E_9_4.set_text("") 996 k=9+(s_zahl_0-1)*10997 x=""998 try:999 x=str(row_x[k][i])1000 self.E_9_4.set_text(x)1001 except:1002 self.E_9_4.set_text("")1003 i=51004 self.E_9_5.set_text("") 1005 k=9+(s_zahl_0-1)*101006 x=""1007 try:1008 x=str(row_x[k][i])1009 self.E_9_5.set_text(x)1010 except:1011 self.E_9_5.set_text("")1012 1013 def updateUser(self):1014 #Users1015 self.E_0_0 = self.builder.get_object("User_Id_0")1016 self.E_1_0 = self.builder.get_object("User_Id_1")1017 self.E_2_0 = self.builder.get_object("User_Id_2")1018 self.E_3_0 = self.builder.get_object("User_Id_3")1019 self.E_4_0 = self.builder.get_object("User_Id_4")1020 self.E_5_0 = self.builder.get_object("User_Id_5")1021 self.E_6_0 = self.builder.get_object("User_Id_6")1022 self.E_7_0 = self.builder.get_object("User_Id_7")1023 self.E_8_0 = self.builder.get_object("User_Id_8")1024 self.E_9_0 = self.builder.get_object("User_Id_9")1025 1026 self.E_0_1 = self.builder.get_object("User_Name_0")1027 self.E_1_1 = self.builder.get_object("User_Name_1")1028 self.E_2_1 = self.builder.get_object("User_Name_2")1029 self.E_3_1 = self.builder.get_object("User_Name_3")1030 self.E_4_1 = self.builder.get_object("User_Name_4")1031 self.E_5_1 = self.builder.get_object("User_Name_5")1032 self.E_6_1 = self.builder.get_object("User_Name_6")1033 self.E_7_1 = self.builder.get_object("User_Name_7")1034 self.E_8_1 = self.builder.get_object("User_Name_8")1035 self.E_9_1 = self.builder.get_object("User_Name_9")1036 1037 self.E_0_2 = self.builder.get_object("User_Surename_0")1038 self.E_1_2 = self.builder.get_object("User_Surename_1")1039 self.E_2_2 = self.builder.get_object("User_Surename_2")1040 self.E_3_2 = self.builder.get_object("User_Surename_3")1041 self.E_4_2 = self.builder.get_object("User_Surename_4")1042 self.E_5_2 = self.builder.get_object("User_Surename_5")1043 self.E_6_2 = self.builder.get_object("User_Surename_6")1044 self.E_7_2 = self.builder.get_object("User_Surename_7")1045 self.E_8_2 = self.builder.get_object("User_Surename_8")1046 self.E_9_2 = self.builder.get_object("User_Surename_9")1047 1048 self.E_0_3 = self.builder.get_object("User_Class_0")1049 self.E_1_3 = self.builder.get_object("User_Class_1")1050 self.E_2_3 = self.builder.get_object("User_Class_2")1051 self.E_3_3 = self.builder.get_object("User_Class_3")1052 self.E_4_3 = self.builder.get_object("User_Class_4")1053 self.E_5_3 = self.builder.get_object("User_Class_5")1054 self.E_6_3 = self.builder.get_object("User_Class_6")1055 self.E_7_3 = self.builder.get_object("User_Class_7")1056 self.E_8_3 = self.builder.get_object("User_Class_8")1057 self.E_9_3 = self.builder.get_object("User_Class_9")1058 1059 1060 global s_zahl_11061 connection = sqlite3.connect(db)1062 cursor= connection.cursor()1063 sql = "SELECT * FROM Users"1064 cursor.execute(sql)1065 1066 text=""1067 column_x=[]1068 row_x=[]1069 1070 i=01071 for row in cursor:1072 1073 r0=str(row[0])1074 r1=str(row[1])1075 r2=str(row[2])1076 r3=str(row[3])1077 1078 1079 column_x = [(r0, r1, r2, r3)]1080 row_x.extend(column_x)1081 1082 1083 connection.commit()1084 connection.close()1085 print("len(column_x)", len(column_x))1086 print("len(row_x)", len(row_x))1087 x=len(row_x)1088 #Reihe 01089 i=01090 self.E_0_0.set_text("") 1091 k=0+(s_zahl_1-1)*101092 x=""1093 try:1094 x=str(row_x[k][i])1095 self.E_0_0.set_text(x)1096 except:1097 self.E_0_0.set_text("")1098 i=11099 self.E_0_1.set_text("") 1100 k=0+(s_zahl_1-1)*101101 x=""1102 try:1103 x=str(row_x[k][i])1104 print("x ",x)1105 self.E_0_1.set_text(x)1106 except:1107 self.E_0_1.set_text("")1108 1109 i=21110 self.E_0_2.set_text("") 1111 k=0+(s_zahl_1-1)*101112 x=""1113 try:1114 x=str(row_x[k][i])1115 self.E_0_2.set_text(x)1116 except:1117 self.E_0_2.set_text("")1118 1119 i=31120 self.E_0_3.set_text("") 1121 k=0+(s_zahl_1-1)*101122 x=""1123 try:1124 x=str(row_x[k][i])1125 self.E_0_3.set_text(x)1126 except:1127 self.E_0_3.set_text("")1128 #Reihe11129 i=01130 self.E_1_0.set_text("") 1131 k=1+(s_zahl_1-1)*101132 x=""1133 try:1134 x=str(row_x[k][i])1135 self.E_1_0.set_text(x)1136 except:1137 self.E_1_0.set_text("")1138 i=11139 self.E_1_1.set_text("") 1140 k=1+(s_zahl_1-1)*101141 x=""1142 try:1143 x=str(row_x[k][i])1144 print("x ",x)1145 self.E_1_1.set_text(x)1146 except:1147 self.E_1_1.set_text("")1148 1149 i=21150 self.E_1_2.set_text("") 1151 k=1+(s_zahl_1-1)*101152 x=""1153 try:1154 x=str(row_x[k][i])1155 self.E_1_2.set_text(x)1156 except:1157 self.E_1_2.set_text("")1158 1159 i=31160 self.E_1_3.set_text("") 1161 k=1+(s_zahl_1-1)*101162 x=""1163 try:1164 x=str(row_x[k][i])1165 self.E_1_3.set_text(x)1166 except:1167 self.E_1_3.set_text("")1168 #Reihe21169 i=01170 self.E_2_0.set_text("") 1171 k=2+(s_zahl_1-1)*101172 x=""1173 try:1174 x=str(row_x[k][i])1175 self.E_2_0.set_text(x)1176 except:1177 self.E_2_0.set_text("")1178 i=11179 self.E_2_1.set_text("") 1180 k=2+(s_zahl_1-1)*101181 x=""1182 try:1183 x=str(row_x[k][i])1184 print("x ",x)1185 self.E_2_1.set_text(x)1186 except:1187 self.E_2_1.set_text("")1188 1189 i=21190 self.E_2_2.set_text("") 1191 k=2+(s_zahl_1-1)*101192 x=""1193 try:1194 x=str(row_x[k][i])1195 self.E_2_2.set_text(x)1196 except:1197 self.E_2_2.set_text("")1198 1199 i=31200 self.E_2_3.set_text("") 1201 k=2+(s_zahl_1-1)*101202 x=""1203 try:1204 x=str(row_x[k][i])1205 self.E_2_3.set_text(x)1206 except:1207 self.E_2_3.set_text("")1208 #Reihe31209 i=01210 self.E_3_0.set_text("") 1211 k=3+(s_zahl_1-1)*101212 x=""1213 try:1214 x=str(row_x[k][i])1215 self.E_3_0.set_text(x)1216 except:1217 self.E_3_0.set_text("")1218 i=11219 self.E_3_1.set_text("") 1220 k=3+(s_zahl_1-1)*101221 x=""1222 try:1223 x=str(row_x[k][i])1224 print("x ",x)1225 self.E_3_1.set_text(x)1226 except:1227 self.E_3_1.set_text("")1228 1229 i=21230 self.E_3_2.set_text("") 1231 k=3+(s_zahl_1-1)*101232 x=""1233 try:1234 x=str(row_x[k][i])1235 self.E_3_2.set_text(x)1236 except:1237 self.E_3_2.set_text("")1238 1239 i=31240 self.E_3_3.set_text("") 1241 k=3+(s_zahl_1-1)*101242 x=""1243 try:1244 x=str(row_x[k][i])1245 self.E_3_3.set_text(x)1246 except:1247 self.E_3_3.set_text("")1248 1249 #Reihe41250 i=01251 self.E_4_0.set_text("") 1252 k=4+(s_zahl_1-1)*101253 x=""1254 try:1255 x=str(row_x[k][i])1256 self.E_4_0.set_text(x)1257 except:1258 self.E_4_0.set_text("")1259 i=11260 self.E_4_1.set_text("") 1261 k=4+(s_zahl_1-1)*101262 x=""1263 try:1264 x=str(row_x[k][i])1265 print("x ",x)1266 self.E_4_1.set_text(x)1267 except:1268 self.E_4_1.set_text("")1269 1270 i=21271 self.E_4_2.set_text("") 1272 k=4+(s_zahl_1-1)*101273 x=""1274 try:1275 x=str(row_x[k][i])1276 self.E_4_2.set_text(x)1277 except:1278 self.E_4_2.set_text("")1279 1280 i=31281 self.E_4_3.set_text("") 1282 k=4+(s_zahl_1-1)*101283 x=""1284 try:1285 x=str(row_x[k][i])1286 self.E_4_3.set_text(x)1287 except:1288 self.E_4_3.set_text("")1289 1290 #Reihe51291 i=01292 self.E_5_0.set_text("") 1293 k=5+(s_zahl_1-1)*101294 x=""1295 try:1296 x=str(row_x[k][i])1297 self.E_5_0.set_text(x)1298 except:1299 self.E_5_0.set_text("")1300 i=11301 self.E_5_1.set_text("") 1302 k=5+(s_zahl_1-1)*101303 x=""1304 try:1305 x=str(row_x[k][i])1306 print("x ",x)1307 self.E_5_1.set_text(x)1308 except:1309 self.E_5_1.set_text("")1310 1311 i=21312 self.E_5_2.set_text("") 1313 k=5+(s_zahl_1-1)*101314 x=""1315 try:1316 x=str(row_x[k][i])1317 self.E_5_2.set_text(x)1318 except:1319 self.E_5_2.set_text("")1320 1321 i=31322 self.E_5_3.set_text("") 1323 k=5+(s_zahl_1-1)*101324 x=""1325 try:1326 x=str(row_x[k][i])1327 self.E_5_3.set_text(x)1328 except:1329 self.E_5_3.set_text("")1330 #Reihe61331 i=01332 self.E_6_0.set_text("") 1333 k=6+(s_zahl_1-1)*101334 x=""1335 try:1336 x=str(row_x[k][i])1337 self.E_6_0.set_text(x)1338 except:1339 self.E_6_0.set_text("")1340 1341 i=11342 self.E_6_1.set_text("") 1343 k=6+(s_zahl_1-1)*101344 x=""1345 try:1346 x=str(row_x[k][i])1347 print("x ",x)1348 self.E_6_1.set_text(x)1349 except:1350 self.E_6_1.set_text("")1351 1352 i=21353 self.E_6_2.set_text("") 1354 k=6+(s_zahl_1-1)*101355 x=""1356 try:1357 x=str(row_x[k][i])1358 self.E_6_2.set_text(x)1359 except:1360 self.E_6_2.set_text("")1361 1362 i=31363 self.E_6_3.set_text("") 1364 k=6+(s_zahl_1-1)*101365 x=""1366 try:1367 x=str(row_x[k][i])1368 self.E_6_3.set_text(x)1369 except:1370 self.E_6_3.set_text("")1371 #Reihe71372 i=01373 self.E_7_0.set_text("") 1374 k=7+(s_zahl_1-1)*101375 x=""1376 try:1377 x=str(row_x[k][i])1378 self.E_7_0.set_text(x)1379 except:1380 self.E_7_0.set_text("")1381 i=11382 self.E_7_1.set_text("") 1383 k=7+(s_zahl_1-1)*101384 x=""1385 try:1386 x=str(row_x[k][i])1387 print("x ",x)1388 self.E_7_1.set_text(x)1389 except:1390 self.E_7_1.set_text("")1391 1392 i=21393 self.E_7_2.set_text("") 1394 k=7+(s_zahl_1-1)*101395 x=""1396 try:1397 x=str(row_x[k][i])1398 self.E_7_2.set_text(x)1399 except:1400 self.E_7_2.set_text("")1401 1402 i=31403 self.E_7_3.set_text("") 1404 k=7+(s_zahl_1-1)*101405 x=""1406 try:1407 x=str(row_x[k][i])1408 self.E_7_3.set_text(x)1409 except:1410 self.E_7_3.set_text("")1411 #Reihe81412 i=01413 self.E_8_0.set_text("") 1414 k=8+(s_zahl_1-1)*101415 x=""1416 try:1417 x=str(row_x[k][i])1418 self.E_8_0.set_text(x)1419 except:1420 self.E_8_0.set_text("")1421 i=11422 self.E_8_1.set_text("") 1423 k=8+(s_zahl_1-1)*101424 x=""1425 try:1426 x=str(row_x[k][i])1427 print("x ",x)1428 self.E_8_1.set_text(x)1429 except:1430 self.E_8_1.set_text("")1431 1432 i=21433 self.E_8_2.set_text("") 1434 k=8+(s_zahl_1-1)*101435 x=""1436 try:1437 x=str(row_x[k][i])1438 self.E_8_2.set_text(x)1439 except:1440 self.E_8_2.set_text("")1441 1442 i=31443 self.E_8_3.set_text("") 1444 k=8+(s_zahl_1-1)*101445 x=""1446 try:1447 x=str(row_x[k][i])1448 self.E_8_3.set_text(x)1449 except:1450 self.E_8_3.set_text("")1451 #Reihe91452 i=01453 self.E_9_0.set_text("") 1454 k=9+(s_zahl_1-1)*101455 x=""1456 try:1457 x=str(row_x[k][i])1458 self.E_9_0.set_text(x)1459 except:1460 self.E_9_0.set_text("")1461 i=11462 self.E_9_1.set_text("") 1463 k=9+(s_zahl_1-1)*101464 x=""1465 try:1466 x=str(row_x[k][i])1467 print("x ",x)1468 self.E_9_1.set_text(x)1469 except:1470 self.E_9_1.set_text("")1471 1472 i=21473 self.E_9_2.set_text("") 1474 k=9+(s_zahl_1-1)*101475 x=""1476 try:1477 x=str(row_x[k][i])1478 self.E_9_2.set_text(x)1479 except:1480 self.E_9_2.set_text("")1481 1482 i=31483 self.E_9_3.set_text("") 1484 k=9+(s_zahl_1-1)*101485 x=""1486 try:1487 x=str(row_x[k][i])1488 self.E_9_3.set_text(x)1489 except:1490 self.E_9_3.set_text("")1491 def updateGets(self):1492 #Gets1493 self.E_0_0 = self.builder.get_object("Get_Id_0")1494 self.E_1_0 = self.builder.get_object("Get_Id_1")1495 self.E_2_0 = self.builder.get_object("Get_Id_2")1496 self.E_3_0 = self.builder.get_object("Get_Id_3")1497 self.E_4_0 = self.builder.get_object("Get_Id_4")1498 self.E_5_0 = self.builder.get_object("Get_Id_5")1499 self.E_6_0 = self.builder.get_object("Get_Id_6")1500 self.E_7_0 = self.builder.get_object("Get_Id_7")1501 self.E_8_0 = self.builder.get_object("Get_Id_8")1502 self.E_9_0 = self.builder.get_object("Get_Id_9")1503 1504 self.E_0_1 = self.builder.get_object("Get_NSC_0")1505 self.E_1_1 = self.builder.get_object("Get_NSC_1")1506 self.E_2_1 = self.builder.get_object("Get_NSC_2")1507 self.E_3_1 = self.builder.get_object("Get_NSC_3")1508 self.E_4_1 = self.builder.get_object("Get_NSC_4")1509 self.E_5_1 = self.builder.get_object("Get_NSC_5")1510 self.E_6_1 = self.builder.get_object("Get_NSC_6")1511 self.E_7_1 = self.builder.get_object("Get_NSC_7")1512 self.E_8_1 = self.builder.get_object("Get_NSC_8")1513 self.E_9_1 = self.builder.get_object("Get_NSC_9")1514 1515 self.E_0_2 = self.builder.get_object("Get_UserId_0")1516 self.E_1_2 = self.builder.get_object("Get_UserId_1")1517 self.E_2_2 = self.builder.get_object("Get_UserId_2")1518 self.E_3_2 = self.builder.get_object("Get_UserId_3")1519 self.E_4_2 = self.builder.get_object("Get_UserId_4")1520 self.E_5_2 = self.builder.get_object("Get_UserId_5")1521 self.E_6_2 = self.builder.get_object("Get_UserId_6")1522 self.E_7_2 = self.builder.get_object("Get_UserId_7")1523 self.E_8_2 = self.builder.get_object("Get_UserId_8")1524 self.E_9_2 = self.builder.get_object("Get_UserId_9")1525 1526 self.E_0_3 = self.builder.get_object("Get_DevId_0")1527 self.E_1_3 = self.builder.get_object("Get_DevId_1")1528 self.E_2_3 = self.builder.get_object("Get_DevId_2")1529 self.E_3_3 = self.builder.get_object("Get_DevId_3")1530 self.E_4_3 = self.builder.get_object("Get_DevId_4")1531 self.E_5_3 = self.builder.get_object("Get_DevId_5")1532 self.E_6_3 = self.builder.get_object("Get_DevId_6")1533 self.E_7_3 = self.builder.get_object("Get_DevId_7")1534 self.E_8_3 = self.builder.get_object("Get_DevId_8")1535 self.E_9_3 = self.builder.get_object("Get_DevId_9")1536 1537 self.E_0_4 = self.builder.get_object("Get_Date_0")1538 self.E_1_4 = self.builder.get_object("Get_Date_1")1539 self.E_2_4 = self.builder.get_object("Get_Date_2")1540 self.E_3_4 = self.builder.get_object("Get_Date_3")1541 self.E_4_4 = self.builder.get_object("Get_Date_4")1542 self.E_5_4 = self.builder.get_object("Get_Date_5")1543 self.E_6_4 = self.builder.get_object("Get_Date_6")1544 self.E_7_4 = self.builder.get_object("Get_Date_7")1545 self.E_8_4 = self.builder.get_object("Get_Date_8")1546 self.E_9_4 = self.builder.get_object("Get_Date_9")1547 1548 1549 1550 global s_zahl_21551 connection = sqlite3.connect(db)1552 cursor= connection.cursor()1553 sql = "SELECT * FROM Gets"1554 cursor.execute(sql)1555 1556 text=""1557 column_x=[]1558 row_x=[]1559 1560 i=01561 for row in cursor:1562 1563 r0=str(row[0])1564 r1=str(row[1])1565 r2=str(row[2])1566 r3=str(row[3])1567 r4=str(row[4])1568 1569 1570 column_x = [(r0, r1, r2, r3, r4)]1571 row_x.extend(column_x)1572 1573 1574 connection.commit()1575 connection.close()1576 print("len(column_x)", len(column_x))1577 print("len(row_x)", len(row_x))1578 x=len(row_x)1579 #Reihe 01580 i=01581 self.E_0_0.set_text("") 1582 k=0+(s_zahl_2-1)*101583 x=""1584 try:1585 x=str(row_x[k][i])1586 self.E_0_0.set_text(x)1587 except:1588 self.E_0_0.set_text("")1589 i=11590 self.E_0_1.set_text("") 1591 k=0+(s_zahl_2-1)*101592 x=""1593 try:1594 x=str(row_x[k][i])1595 print("x ",x)1596 self.E_0_1.set_text(x)1597 except:1598 self.E_0_1.set_text("")1599 1600 i=21601 self.E_0_2.set_text("") 1602 k=0+(s_zahl_2-1)*101603 x=""1604 try:1605 x=str(row_x[k][i])1606 self.E_0_2.set_text(x)1607 except:1608 self.E_0_2.set_text("")1609 1610 i=31611 self.E_0_3.set_text("") 1612 k=0+(s_zahl_2-1)*101613 x=""1614 try:1615 x=str(row_x[k][i])1616 self.E_0_3.set_text(x)1617 except:1618 self.E_0_3.set_text("")1619 i=41620 self.E_0_4.set_text("") 1621 k=0+(s_zahl_2-1)*101622 x=""1623 try:1624 x=str(row_x[k][i])1625 self.E_0_4.set_text(x)1626 except:1627 self.E_0_4.set_text("")1628 #Reihe11629 i=01630 self.E_1_0.set_text("") 1631 k=1+(s_zahl_2-1)*101632 x=""1633 try:1634 x=str(row_x[k][i])1635 self.E_1_0.set_text(x)1636 except:1637 self.E_1_0.set_text("")1638 i=11639 self.E_1_1.set_text("") 1640 k=1+(s_zahl_2-1)*101641 x=""1642 try:1643 x=str(row_x[k][i])1644 print("x ",x)1645 self.E_1_1.set_text(x)1646 except:1647 self.E_1_1.set_text("")1648 1649 i=21650 self.E_1_2.set_text("") 1651 k=1+(s_zahl_2-1)*101652 x=""1653 try:1654 x=str(row_x[k][i])1655 self.E_1_2.set_text(x)1656 except:1657 self.E_1_2.set_text("")1658 1659 i=31660 self.E_1_3.set_text("") 1661 k=1+(s_zahl_2-1)*101662 x=""1663 try:1664 x=str(row_x[k][i])1665 self.E_1_3.set_text(x)1666 except:1667 self.E_1_3.set_text("")1668 i=41669 self.E_1_4.set_text("") 1670 k=1+(s_zahl_2-1)*101671 x=""1672 try:1673 x=str(row_x[k][i])1674 self.E_1_4.set_text(x)1675 except:1676 self.E_1_4.set_text("")1677 1678 #Reihe21679 i=01680 self.E_2_0.set_text("") 1681 k=2+(s_zahl_2-1)*101682 x=""1683 try:1684 x=str(row_x[k][i])1685 self.E_2_0.set_text(x)1686 except:1687 self.E_2_0.set_text("")1688 i=11689 self.E_2_1.set_text("") 1690 k=2+(s_zahl_2-1)*101691 x=""1692 try:1693 x=str(row_x[k][i])1694 print("x ",x)1695 self.E_2_1.set_text(x)1696 except:1697 self.E_2_1.set_text("")1698 1699 i=21700 self.E_2_2.set_text("") 1701 k=2+(s_zahl_2-1)*101702 x=""1703 try:1704 x=str(row_x[k][i])1705 self.E_2_2.set_text(x)1706 except:1707 self.E_2_2.set_text("")1708 1709 i=31710 self.E_2_3.set_text("") 1711 k=2+(s_zahl_2-1)*101712 x=""1713 try:1714 x=str(row_x[k][i])1715 self.E_2_3.set_text(x)1716 except:1717 self.E_2_3.set_text("")1718 i=41719 self.E_2_4.set_text("") 1720 k=2+(s_zahl_2-1)*101721 x=""1722 try:1723 x=str(row_x[k][i])1724 self.E_2_4.set_text(x)1725 except:1726 self.E_2_4.set_text("")1727 1728 #Reihe31729 i=01730 self.E_3_0.set_text("") 1731 k=3+(s_zahl_2-1)*101732 x=""1733 try:1734 x=str(row_x[k][i])1735 self.E_3_0.set_text(x)1736 except:1737 self.E_3_0.set_text("")1738 i=11739 self.E_3_1.set_text("") 1740 k=3+(s_zahl_2-1)*101741 x=""1742 try:1743 x=str(row_x[k][i])1744 print("x ",x)1745 self.E_3_1.set_text(x)1746 except:1747 self.E_3_1.set_text("")1748 1749 i=21750 self.E_3_2.set_text("") 1751 k=3+(s_zahl_2-1)*101752 x=""1753 try:1754 x=str(row_x[k][i])1755 self.E_3_2.set_text(x)1756 except:1757 self.E_3_2.set_text("")1758 1759 i=31760 self.E_3_3.set_text("") 1761 k=3+(s_zahl_2-1)*101762 x=""1763 try:1764 x=str(row_x[k][i])1765 self.E_3_3.set_text(x)1766 except:1767 self.E_3_3.set_text("")1768 i=41769 self.E_3_4.set_text("") 1770 k=3+(s_zahl_2-1)*101771 x=""1772 try:1773 x=str(row_x[k][i])1774 self.E_3_4.set_text(x)1775 except:1776 self.E_3_4.set_text("")1777 #Reihe41778 i=01779 self.E_4_0.set_text("") 1780 k=4+(s_zahl_2-1)*101781 x=""1782 try:1783 x=str(row_x[k][i])1784 self.E_4_0.set_text(x)1785 except:1786 self.E_4_0.set_text("")1787 i=11788 self.E_4_1.set_text("") 1789 k=4+(s_zahl_2-1)*101790 x=""1791 try:1792 x=str(row_x[k][i])1793 print("x ",x)1794 self.E_4_1.set_text(x)1795 except:1796 self.E_4_1.set_text("")1797 1798 i=21799 self.E_4_2.set_text("") 1800 k=4+(s_zahl_2-1)*101801 x=""1802 try:1803 x=str(row_x[k][i])1804 self.E_4_2.set_text(x)1805 except:1806 self.E_4_2.set_text("")1807 1808 i=31809 self.E_4_3.set_text("") 1810 k=4+(s_zahl_2-1)*101811 x=""1812 try:1813 x=str(row_x[k][i])1814 self.E_4_3.set_text(x)1815 except:1816 self.E_4_3.set_text("")1817 i=41818 self.E_4_4.set_text("") 1819 k=4+(s_zahl_2-1)*101820 x=""1821 try:1822 x=str(row_x[k][i])1823 self.E_4_4.set_text(x)1824 except:1825 self.E_4_4.set_text("")1826 1827 #Reihe51828 i=01829 self.E_5_0.set_text("") 1830 k=5+(s_zahl_2-1)*101831 x=""1832 try:1833 x=str(row_x[k][i])1834 self.E_5_0.set_text(x)1835 except:1836 self.E_5_0.set_text("")1837 i=11838 self.E_5_1.set_text("") 1839 k=5+(s_zahl_2-1)*101840 x=""1841 try:1842 x=str(row_x[k][i])1843 print("x ",x)1844 self.E_5_1.set_text(x)1845 except:1846 self.E_5_1.set_text("")1847 1848 i=21849 self.E_5_2.set_text("") 1850 k=5+(s_zahl_2-1)*101851 x=""1852 try:1853 x=str(row_x[k][i])1854 self.E_5_2.set_text(x)1855 except:1856 self.E_5_2.set_text("")1857 1858 i=31859 self.E_5_3.set_text("") 1860 k=5+(s_zahl_2-1)*101861 x=""1862 try:1863 x=str(row_x[k][i])1864 self.E_5_3.set_text(x)1865 except:1866 self.E_5_3.set_text("")1867 i=41868 self.E_5_4.set_text("") 1869 k=5+(s_zahl_2-1)*101870 x=""1871 try:1872 x=str(row_x[k][i])1873 self.E_5_4.set_text(x)1874 except:1875 self.E_5_4.set_text("")1876 1877 #Reihe61878 i=01879 self.E_6_0.set_text("") 1880 k=6+(s_zahl_2-1)*101881 x=""1882 try:1883 x=str(row_x[k][i])1884 self.E_6_0.set_text(x)1885 except:1886 self.E_6_0.set_text("")1887 1888 i=11889 self.E_6_1.set_text("") 1890 k=6+(s_zahl_2-1)*101891 x=""1892 try:1893 x=str(row_x[k][i])1894 print("x ",x)1895 self.E_6_1.set_text(x)1896 except:1897 self.E_6_1.set_text("")1898 1899 i=21900 self.E_6_2.set_text("") 1901 k=6+(s_zahl_2-1)*101902 x=""1903 try:1904 x=str(row_x[k][i])1905 self.E_6_2.set_text(x)1906 except:1907 self.E_6_2.set_text("")1908 1909 i=31910 self.E_6_3.set_text("") 1911 k=6+(s_zahl_2-1)*101912 x=""1913 try:1914 x=str(row_x[k][i])1915 self.E_6_3.set_text(x)1916 except:1917 self.E_6_3.set_text("")1918 i=41919 self.E_6_4.set_text("") 1920 k=6+(s_zahl_2-1)*101921 x=""1922 try:1923 x=str(row_x[k][i])1924 self.E_6_4.set_text(x)1925 except:1926 self.E_6_4.set_text("")1927 1928 #Reihe71929 i=01930 self.E_7_0.set_text("") 1931 k=7+(s_zahl_2-1)*101932 x=""1933 try:1934 x=str(row_x[k][i])1935 self.E_7_0.set_text(x)1936 except:1937 self.E_7_0.set_text("")1938 i=11939 self.E_7_1.set_text("") 1940 k=7+(s_zahl_2-1)*101941 x=""1942 try:1943 x=str(row_x[k][i])1944 print("x ",x)1945 self.E_7_1.set_text(x)1946 except:1947 self.E_7_1.set_text("")1948 1949 i=21950 self.E_7_2.set_text("") 1951 k=7+(s_zahl_2-1)*101952 x=""1953 try:1954 x=str(row_x[k][i])1955 self.E_7_2.set_text(x)1956 except:1957 self.E_7_2.set_text("")1958 1959 i=31960 self.E_7_3.set_text("") 1961 k=7+(s_zahl_2-1)*101962 x=""1963 try:1964 x=str(row_x[k][i])1965 self.E_7_3.set_text(x)1966 except:1967 self.E_7_3.set_text("")1968 i=41969 self.E_7_4.set_text("") 1970 k=7+(s_zahl_2-1)*101971 x=""1972 try:1973 x=str(row_x[k][i])1974 self.E_7_4.set_text(x)1975 except:1976 self.E_7_4.set_text("")1977 1978 #Reihe81979 i=01980 self.E_8_0.set_text("") 1981 k=8+(s_zahl_2-1)*101982 x=""1983 try:1984 x=str(row_x[k][i])1985 self.E_8_0.set_text(x)1986 except:1987 self.E_8_0.set_text("")1988 i=11989 self.E_8_1.set_text("") 1990 k=8+(s_zahl_2-1)*101991 x=""1992 try:1993 x=str(row_x[k][i])1994 print("x ",x)1995 self.E_8_1.set_text(x)1996 except:1997 self.E_8_1.set_text("")1998 1999 i=22000 self.E_8_2.set_text("") 2001 k=8+(s_zahl_2-1)*102002 x=""2003 try:2004 x=str(row_x[k][i])2005 self.E_8_2.set_text(x)2006 except:2007 self.E_8_2.set_text("")2008 2009 i=32010 self.E_8_3.set_text("") 2011 k=8+(s_zahl_2-1)*102012 x=""2013 try:2014 x=str(row_x[k][i])2015 self.E_8_3.set_text(x)2016 except:2017 self.E_8_3.set_text("")2018 i=42019 self.E_8_4.set_text("") 2020 k=8+(s_zahl_2-1)*102021 x=""2022 try:2023 x=str(row_x[k][i])2024 self.E_8_4.set_text(x)2025 except:2026 self.E_8_4.set_text("")2027 2028 #Reihe92029 i=02030 self.E_9_0.set_text("") 2031 k=9+(s_zahl_2-1)*102032 x=""2033 try:2034 x=str(row_x[k][i])2035 self.E_9_0.set_text(x)2036 except:2037 self.E_9_0.set_text("")2038 i=12039 self.E_9_1.set_text("") 2040 k=9+(s_zahl_2-1)*102041 x=""2042 try:2043 x=str(row_x[k][i])2044 print("x ",x)2045 self.E_9_1.set_text(x)2046 except:2047 self.E_9_1.set_text("")2048 2049 i=22050 self.E_9_2.set_text("") 2051 k=9+(s_zahl_2-1)*102052 x=""2053 try:2054 x=str(row_x[k][i])2055 self.E_9_2.set_text(x)2056 except:2057 self.E_9_2.set_text("")2058 2059 i=32060 self.E_9_3.set_text("") 2061 k=9+(s_zahl_2-1)*102062 x=""2063 try:2064 x=str(row_x[k][i])2065 self.E_9_3.set_text(x)2066 except:2067 self.E_9_3.set_text("")2068 i=42069 self.E_9_4.set_text("") 2070 k=9+(s_zahl_2-1)*102071 x=""2072 try:2073 x=str(row_x[k][i])2074 self.E_9_4.set_text(x)2075 except:2076 self.E_9_4.set_text("")2077def main():2078 if os.path.exists("/usr/local/share/topman/database.db") == False:2079 connection = sqlite3.connect(db)2080 cursor = connection.cursor()2081 cursor.execute('''CREATE TABLE Devices(devId INTEGER PRIMARY KEY,devBrand TEXT,devModel TEXT,devOS,devHost,devState INTEGER)''')2082 cursor.execute('''CREATE TABLE Users(userId INTEGER PRIMARY KEY,userName TEXT,userSurename TEXT,userClass TEXT)''')2083 cursor.execute('''CREATE TABLE Gets(getId INTEGER PRIMARY KEY,getUser TEXT,getUserId INTEGER,getDevId INTEGER,getDate TEXT)''')2084 connection.commit()2085 connection.close()2086 app = Handler()2087 2088 Gtk.main()2089 2090if __name__ == "__main__":...

topman~

Source:topman~

...235 else:236 s_zahl_0=1237 238 239 devicePageEntry.set_text(str(s_zahl_0))240 self.updateDev()241 devicePageEntry.show() 242 def devForward(self, deviceButtonForward):243 devicePageEntry = builder.get_object("devicePageEntry")244 print("vor")245 global s_zahl_0246 s_zahl_0=int(devicePageEntry.get_text())247 248 s_zahl_0=s_zahl_0+1249 devicePageEntry.set_text(str(s_zahl_0))250 251 self.updateDev()252 253 def userBack(self, userButtonBack):254 userPageEntry = builder.get_object("userPageEntry")255 global s_zahl_1256 s_zahl_0=int(userPageEntry.get_text())257 if (s_zahl_1>2):258 s_zahl_1=s_zahl_1-1259 print('Seite: ',s_zahl_1)260 else:261 s_zahl_1=1262 263 264 userPageEntry.set_text(str(s_zahl_1))265 self.updateUser()266 267 def userForward(self, userButtonForward):268 userPageEntry = builder.get_object("userPageEntry")269 print("vor")270 global s_zahl_1271 s_zahl_1=int(userPageEntry.get_text())272 273 s_zahl_1=s_zahl_1+1274 userPageEntry.set_text(str(s_zahl_1))275 self.updateUser()276 277 def getsBack(self, getsButtonBack):278 getsPageEntry = builder.get_object("getsPageEntry")279 global s_zahl_2280 s_zahl_2=int(getsPageEntry.get_text())281 if (s_zahl_2>2):282 s_zahl_2=s_zahl_2-1283 print('Seite: ',s_zahl_2)284 else:285 s_zahl_2=1286 287 288 getsPageEntry.set_text(str(s_zahl_2))289 self.updateGets()290 291 def getsForward(self, getsButtonForward):292 getsPageEntry = builder.get_object("getsPageEntry")293 print("vor")294 global s_zahl_2295 s_zahl_2=int(getsPageEntry.get_text())296 297 s_zahl_2=s_zahl_2+1298 getsPageEntry.set_text(str(s_zahl_2))299 self.updateGets()300 301 def actUpdate(self, buttonUpdate):302 self.updateDev()303 self.updateUser()304 self.updateGets()305 306 def updateDev(self):307 #Devices308 E_0_0 = builder.get_object("Id_0")309 E_1_0 = builder.get_object("Id_1")310 E_2_0 = builder.get_object("Id_2")311 E_3_0 = builder.get_object("Id_3")312 E_4_0 = builder.get_object("Id_4")313 E_5_0 = builder.get_object("Id_5")314 E_6_0 = builder.get_object("Id_6")315 E_7_0 = builder.get_object("Id_7")316 E_8_0 = builder.get_object("Id_8")317 E_9_0 = builder.get_object("Id_9")318 319 E_0_1 = builder.get_object("Brand_0")320 E_1_1 = builder.get_object("Brand_1")321 E_2_1 = builder.get_object("Brand_2")322 E_3_1 = builder.get_object("Brand_3")323 E_4_1 = builder.get_object("Brand_4")324 E_5_1 = builder.get_object("Brand_5")325 E_6_1 = builder.get_object("Brand_6")326 E_7_1 = builder.get_object("Brand_7")327 E_8_1 = builder.get_object("Brand_8")328 E_9_1 = builder.get_object("Brand_9")329 330 E_0_2 = builder.get_object("Model_0")331 E_1_2 = builder.get_object("Model_1")332 E_2_2 = builder.get_object("Model_2")333 E_3_2 = builder.get_object("Model_3")334 E_4_2 = builder.get_object("Model_4")335 E_5_2 = builder.get_object("Model_5")336 E_6_2 = builder.get_object("Model_6")337 E_7_2 = builder.get_object("Model_7")338 E_8_2 = builder.get_object("Model_8")339 E_9_2 = builder.get_object("Model_9")340 341 E_0_3 = builder.get_object("OS_0")342 E_1_3 = builder.get_object("OS_1")343 E_2_3 = builder.get_object("OS_2")344 E_3_3 = builder.get_object("OS_3")345 E_4_3 = builder.get_object("OS_4")346 E_5_3 = builder.get_object("OS_5")347 E_6_3 = builder.get_object("OS_6")348 E_7_3 = builder.get_object("OS_7")349 E_8_3 = builder.get_object("OS_8")350 E_9_3 = builder.get_object("OS_9")351 352 E_0_4 = builder.get_object("Hostname_0")353 E_1_4 = builder.get_object("Hostname_1")354 E_2_4 = builder.get_object("Hostname_2")355 E_3_4 = builder.get_object("Hostname_3")356 E_4_4 = builder.get_object("Hostname_4")357 E_5_4 = builder.get_object("Hostname_5")358 E_6_4 = builder.get_object("Hostname_6")359 E_7_4 = builder.get_object("Hostname_7")360 E_8_4 = builder.get_object("Hostname_8")361 E_9_4 = builder.get_object("Hostname_9")362 363 E_0_5 = builder.get_object("Status_0")364 E_1_5 = builder.get_object("Status_1")365 E_2_5 = builder.get_object("Status_2")366 E_3_5 = builder.get_object("Status_3")367 E_4_5 = builder.get_object("Status_4")368 E_5_5 = builder.get_object("Status_5")369 E_6_5 = builder.get_object("Status_6")370 E_7_5 = builder.get_object("Status_7")371 E_8_5 = builder.get_object("Status_8")372 E_9_5 = builder.get_object("Status_9")373 374 375 global s_zahl_0376 connection = sqlite3.connect(db)377 cursor= connection.cursor()378 sql = "SELECT * FROM Devices"379 cursor.execute(sql)380 381 text=""382 column_x=[]383 row_x=[]384 385 i=0386 for row in cursor:387 388 r0=str(row[0])389 r1=str(row[1])390 r2=str(row[2])391 r3=str(row[3])392 r4=str(row[4])393 r5=str(row[5])394 395 396 column_x = [(r0, r1, r2, r3, r4, r5)]397 row_x.extend(column_x)398 399 400 connection.commit()401 connection.close()402 print("len(column_x)", len(column_x))403 print("len(row_x)", len(row_x))404 x=len(row_x)405 #Reihe 0406 i=0407 E_0_0.set_text("") 408 k=0+(s_zahl_0-1)*10409 x=""410 try:411 x=str(row_x[k][i])412 E_0_0.set_text(x)413 print("elf")414 except:415 E_0_0.set_text("")416 i=1417 E_0_1.set_text("") 418 k=0+(s_zahl_0-1)*10419 x=""420 try:421 x=str(row_x[k][i])422 print("x ",x)423 E_0_1.set_text(x)424 except:425 E_0_1.set_text("")426 427 i=2428 E_0_2.set_text("") 429 k=0+(s_zahl_0-1)*10430 x=""431 try:432 x=str(row_x[k][i])433 E_0_2.set_text(x)434 except:435 E_0_2.set_text("")436 437 i=3438 E_0_3.set_text("") 439 k=0+(s_zahl_0-1)*10440 x=""441 try:442 x=str(row_x[k][i])443 E_0_3.set_text(x)444 except:445 E_0_3.set_text("")446 i=4447 E_0_4.set_text("") 448 k=0+(s_zahl_0-1)*10449 x=""450 try:451 x=str(row_x[k][i])452 E_0_4.set_text(x)453 except:454 E_0_4.set_text("")455 i=5456 E_0_5.set_text("") 457 k=0+(s_zahl_0-1)*10458 x=""459 try:460 x=str(row_x[k][i])461 E_0_5.set_text(x)462 except:463 E_0_5.set_text("") 464 465 466 467 #Reihe1468 i=0469 E_1_0.set_text("") 470 k=1+(s_zahl_0-1)*10471 x=""472 try:473 x=str(row_x[k][i])474 E_1_0.set_text(x)475 except:476 E_1_0.set_text("")477 i=1478 E_1_1.set_text("") 479 k=1+(s_zahl_0-1)*10480 x=""481 try:482 x=str(row_x[k][i])483 print("x ",x)484 E_1_1.set_text(x)485 except:486 E_1_1.set_text("")487 488 i=2489 E_1_2.set_text("") 490 k=1+(s_zahl_0-1)*10491 x=""492 try:493 x=str(row_x[k][i])494 E_1_2.set_text(x)495 except:496 E_1_2.set_text("")497 498 i=3499 E_1_3.set_text("") 500 k=1+(s_zahl_0-1)*10501 x=""502 try:503 x=str(row_x[k][i])504 E_1_3.set_text(x)505 except:506 E_1_3.set_text("")507 i=4508 E_1_4.set_text("") 509 k=1+(s_zahl_0-1)*10510 x=""511 try:512 x=str(row_x[k][i])513 E_1_4.set_text(x)514 except:515 E_1_4.set_text("")516 517 i=5518 E_1_5.set_text("") 519 k=1+(s_zahl_0-1)*10520 x=""521 try:522 x=str(row_x[k][i])523 E_1_5.set_text(x)524 except:525 E_1_5.set_text("")526 #Reihe2527 i=0528 E_2_0.set_text("") 529 k=2+(s_zahl_0-1)*10530 x=""531 try:532 x=str(row_x[k][i])533 E_2_0.set_text(x)534 except:535 E_2_0.set_text("")536 i=1537 E_2_1.set_text("") 538 k=2+(s_zahl_0-1)*10539 x=""540 try:541 x=str(row_x[k][i])542 print("x ",x)543 E_2_1.set_text(x)544 except:545 E_2_1.set_text("")546 547 i=2548 E_2_2.set_text("") 549 k=2+(s_zahl_0-1)*10550 x=""551 try:552 x=str(row_x[k][i])553 E_2_2.set_text(x)554 except:555 E_2_2.set_text("")556 557 i=3558 E_2_3.set_text("") 559 k=2+(s_zahl_0-1)*10560 x=""561 try:562 x=str(row_x[k][i])563 E_2_3.set_text(x)564 except:565 E_2_3.set_text("")566 i=4567 E_2_4.set_text("") 568 k=2+(s_zahl_0-1)*10569 x=""570 try:571 x=str(row_x[k][i])572 E_2_4.set_text(x)573 except:574 E_2_4.set_text("")575 576 i=5577 E_2_5.set_text("") 578 k=2+(s_zahl_0-1)*10579 x=""580 try:581 x=str(row_x[k][i])582 E_2_5.set_text(x)583 except:584 E_2_5.set_text("")585 #Reihe3586 i=0587 E_3_0.set_text("") 588 k=3+(s_zahl_0-1)*10589 x=""590 try:591 x=str(row_x[k][i])592 E_3_0.set_text(x)593 except:594 E_3_0.set_text("")595 i=1596 E_3_1.set_text("") 597 k=3+(s_zahl_0-1)*10598 x=""599 try:600 x=str(row_x[k][i])601 print("x ",x)602 E_3_1.set_text(x)603 except:604 E_3_1.set_text("")605 606 i=2607 E_3_2.set_text("") 608 k=3+(s_zahl_0-1)*10609 x=""610 try:611 x=str(row_x[k][i])612 E_3_2.set_text(x)613 except:614 E_3_2.set_text("")615 616 i=3617 E_3_3.set_text("") 618 k=3+(s_zahl_0-1)*10619 x=""620 try:621 x=str(row_x[k][i])622 E_3_3.set_text(x)623 except:624 E_3_3.set_text("")625 i=4626 E_3_4.set_text("") 627 k=3+(s_zahl_0-1)*10628 x=""629 try:630 x=str(row_x[k][i])631 E_3_4.set_text(x)632 except:633 E_3_4.set_text("")634 i=5635 E_3_5.set_text("") 636 k=3+(s_zahl_0-1)*10637 x=""638 try:639 x=str(row_x[k][i])640 E_3_5.set_text(x)641 except:642 E_3_5.set_text("")643 644 #Reihe4645 i=0646 E_4_0.set_text("") 647 k=4+(s_zahl_0-1)*10648 x=""649 try:650 x=str(row_x[k][i])651 E_4_0.set_text(x)652 except:653 E_4_0.set_text("")654 i=1655 E_4_1.set_text("") 656 k=4+(s_zahl_0-1)*10657 x=""658 try:659 x=str(row_x[k][i])660 print("x ",x)661 E_4_1.set_text(x)662 except:663 E_4_1.set_text("")664 665 i=2666 E_4_2.set_text("") 667 k=4+(s_zahl_0-1)*10668 x=""669 try:670 x=str(row_x[k][i])671 E_4_2.set_text(x)672 except:673 E_4_2.set_text("")674 675 i=3676 E_4_3.set_text("") 677 k=4+(s_zahl_0-1)*10678 x=""679 try:680 x=str(row_x[k][i])681 E_4_3.set_text(x)682 except:683 E_4_3.set_text("")684 i=4685 E_4_4.set_text("") 686 k=4+(s_zahl_0-1)*10687 x=""688 try:689 x=str(row_x[k][i])690 E_4_4.set_text(x)691 except:692 E_4_4.set_text("")693 694 i=5695 E_4_5.set_text("") 696 k=4+(s_zahl_0-1)*10697 x=""698 try:699 x=str(row_x[k][i])700 E_4_5.set_text(x)701 except:702 E_4_5.set_text("")703 704 #Reihe5705 i=0706 E_5_0.set_text("") 707 k=5+(s_zahl_0-1)*10708 x=""709 try:710 x=str(row_x[k][i])711 E_5_0.set_text(x)712 except:713 E_5_0.set_text("")714 i=1715 E_5_1.set_text("") 716 k=5+(s_zahl_0-1)*10717 x=""718 try:719 x=str(row_x[k][i])720 print("x ",x)721 E_5_1.set_text(x)722 except:723 E_5_1.set_text("")724 725 i=2726 E_5_2.set_text("") 727 k=5+(s_zahl_0-1)*10728 x=""729 try:730 x=str(row_x[k][i])731 E_5_2.set_text(x)732 except:733 E_5_2.set_text("")734 735 i=3736 E_5_3.set_text("") 737 k=5+(s_zahl_0-1)*10738 x=""739 try:740 x=str(row_x[k][i])741 E_5_3.set_text(x)742 except:743 E_5_3.set_text("")744 i=4745 E_5_4.set_text("") 746 k=5+(s_zahl_0-1)*10747 x=""748 try:749 x=str(row_x[k][i])750 E_5_4.set_text(x)751 except:752 E_5_4.set_text("")753 754 i=5755 E_5_5.set_text("") 756 k=5+(s_zahl_0-1)*10757 x=""758 try:759 x=str(row_x[k][i])760 E_5_5.set_text(x)761 except:762 E_5_5.set_text("")763 764 #Reihe6765 i=0766 E_6_0.set_text("") 767 k=6+(s_zahl_0-1)*10768 x=""769 try:770 x=str(row_x[k][i])771 E_6_0.set_text(x)772 except:773 E_6_0.set_text("")774 775 i=1776 E_6_1.set_text("") 777 k=6+(s_zahl_0-1)*10778 x=""779 try:780 x=str(row_x[k][i])781 print("x ",x)782 E_6_1.set_text(x)783 except:784 E_6_1.set_text("")785 786 i=2787 E_6_2.set_text("") 788 k=6+(s_zahl_0-1)*10789 x=""790 try:791 x=str(row_x[k][i])792 E_6_2.set_text(x)793 except:794 E_6_2.set_text("")795 796 i=3797 E_6_3.set_text("") 798 k=6+(s_zahl_0-1)*10799 x=""800 try:801 x=str(row_x[k][i])802 E_6_3.set_text(x)803 except:804 E_6_3.set_text("")805 i=4806 E_6_4.set_text("") 807 k=6+(s_zahl_0-1)*10808 x=""809 try:810 x=str(row_x[k][i])811 E_6_4.set_text(x)812 except:813 E_6_4.set_text("")814 815 i=5816 E_6_5.set_text("") 817 k=6+(s_zahl_0-1)*10818 x=""819 try:820 x=str(row_x[k][i])821 E_6_5.set_text(x)822 except:823 E_6_5.set_text("")824 825 #Reihe7826 i=0827 E_7_0.set_text("") 828 k=7+(s_zahl_0-1)*10829 x=""830 try:831 x=str(row_x[k][i])832 E_7_0.set_text(x)833 except:834 E_7_0.set_text("")835 i=1836 E_7_1.set_text("") 837 k=7+(s_zahl_0-1)*10838 x=""839 try:840 x=str(row_x[k][i])841 print("x ",x)842 E_7_1.set_text(x)843 except:844 E_7_1.set_text("")845 846 i=2847 E_7_2.set_text("") 848 k=7+(s_zahl_0-1)*10849 x=""850 try:851 x=str(row_x[k][i])852 E_7_2.set_text(x)853 except:854 E_7_2.set_text("")855 856 i=3857 E_7_3.set_text("") 858 k=7+(s_zahl_0-1)*10859 x=""860 try:861 x=str(row_x[k][i])862 E_7_3.set_text(x)863 except:864 E_7_3.set_text("")865 i=4866 E_7_4.set_text("") 867 k=7+(s_zahl_0-1)*10868 x=""869 try:870 x=str(row_x[k][i])871 E_7_4.set_text(x)872 except:873 E_7_4.set_text("")874 875 i=5876 E_7_5.set_text("") 877 k=7+(s_zahl_0-1)*10878 x=""879 try:880 x=str(row_x[k][i])881 E_7_5.set_text(x)882 except:883 E_7_5.set_text("")884 #Reihe8885 i=0886 E_8_0.set_text("") 887 k=8+(s_zahl_0-1)*10888 x=""889 try:890 x=str(row_x[k][i])891 E_8_0.set_text(x)892 except:893 E_8_0.set_text("")894 i=1895 E_8_1.set_text("") 896 k=8+(s_zahl_0-1)*10897 x=""898 try:899 x=str(row_x[k][i])900 print("x ",x)901 E_8_1.set_text(x)902 except:903 E_8_1.set_text("")904 905 i=2906 E_8_2.set_text("") 907 k=8+(s_zahl_0-1)*10908 x=""909 try:910 x=str(row_x[k][i])911 E_8_2.set_text(x)912 except:913 E_8_2.set_text("")914 915 i=3916 E_8_3.set_text("") 917 k=8+(s_zahl_0-1)*10918 x=""919 try:920 x=str(row_x[k][i])921 E_8_3.set_text(x)922 except:923 E_8_3.set_text("")924 i=4925 E_8_4.set_text("") 926 k=8+(s_zahl_0-1)*10927 x=""928 try:929 x=str(row_x[k][i])930 E_8_4.set_text(x)931 except:932 E_8_4.set_text("")933 934 i=5935 E_8_5.set_text("") 936 k=8+(s_zahl_0-1)*10937 x=""938 try:939 x=str(row_x[k][i])940 E_8_5.set_text(x)941 except:942 E_8_5.set_text("")943 944 #Reihe9945 i=0946 E_9_0.set_text("") 947 k=9+(s_zahl_0-1)*10948 x=""949 try:950 x=str(row_x[k][i])951 E_9_0.set_text(x)952 except:953 E_9_0.set_text("")954 i=1955 E_9_1.set_text("") 956 k=9+(s_zahl_0-1)*10957 x=""958 try:959 x=str(row_x[k][i])960 print("x ",x)961 E_9_1.set_text(x)962 except:963 E_9_1.set_text("")964 965 i=2966 E_9_2.set_text("") 967 k=9+(s_zahl_0-1)*10968 x=""969 try:970 x=str(row_x[k][i])971 E_9_2.set_text(x)972 except:973 E_9_2.set_text("")974 975 i=3976 E_9_3.set_text("") 977 k=9+(s_zahl_0-1)*10978 x=""979 try:980 x=str(row_x[k][i])981 E_9_3.set_text(x)982 except:983 E_9_3.set_text("")984 i=4985 E_9_4.set_text("") 986 k=9+(s_zahl_0-1)*10987 x=""988 try:989 x=str(row_x[k][i])990 E_9_4.set_text(x)991 except:992 E_9_4.set_text("")993 i=5994 E_9_5.set_text("") 995 k=9+(s_zahl_0-1)*10996 x=""997 try:998 x=str(row_x[k][i])999 E_9_5.set_text(x)1000 except:1001 E_9_5.set_text("")1002 E_0_0.show_all()1003 1004 def updateUser(self):1005 #Users1006 E_0_0 = builder.get_object("User_Id_0")1007 E_1_0 = builder.get_object("User_Id_1")1008 E_2_0 = builder.get_object("User_Id_2")1009 E_3_0 = builder.get_object("User_Id_3")1010 E_4_0 = builder.get_object("User_Id_4")1011 E_5_0 = builder.get_object("User_Id_5")1012 E_6_0 = builder.get_object("User_Id_6")1013 E_7_0 = builder.get_object("User_Id_7")1014 E_8_0 = builder.get_object("User_Id_8")1015 E_9_0 = builder.get_object("User_Id_9")1016 1017 E_0_1 = builder.get_object("User_Name_0")1018 E_1_1 = builder.get_object("User_Name_1")1019 E_2_1 = builder.get_object("User_Name_2")1020 E_3_1 = builder.get_object("User_Name_3")1021 E_4_1 = builder.get_object("User_Name_4")1022 E_5_1 = builder.get_object("User_Name_5")1023 E_6_1 = builder.get_object("User_Name_6")1024 E_7_1 = builder.get_object("User_Name_7")1025 E_8_1 = builder.get_object("User_Name_8")1026 E_9_1 = builder.get_object("User_Name_9")1027 1028 E_0_2 = builder.get_object("User_Surename_0")1029 E_1_2 = builder.get_object("User_Surename_1")1030 E_2_2 = builder.get_object("User_Surename_2")1031 E_3_2 = builder.get_object("User_Surename_3")1032 E_4_2 = builder.get_object("User_Surename_4")1033 E_5_2 = builder.get_object("User_Surename_5")1034 E_6_2 = builder.get_object("User_Surename_6")1035 E_7_2 = builder.get_object("User_Surename_7")1036 E_8_2 = builder.get_object("User_Surename_8")1037 E_9_2 = builder.get_object("User_Surename_9")1038 1039 E_0_3 = builder.get_object("User_Class_0")1040 E_1_3 = builder.get_object("User_Class_1")1041 E_2_3 = builder.get_object("User_Class_2")1042 E_3_3 = builder.get_object("User_Class_3")1043 E_4_3 = builder.get_object("User_Class_4")1044 E_5_3 = builder.get_object("User_Class_5")1045 E_6_3 = builder.get_object("User_Class_6")1046 E_7_3 = builder.get_object("User_Class_7")1047 E_8_3 = builder.get_object("User_Class_8")1048 E_9_3 = builder.get_object("User_Class_9")1049 1050 1051 global s_zahl_11052 connection = sqlite3.connect(db)1053 cursor= connection.cursor()1054 sql = "SELECT * FROM Users"1055 cursor.execute(sql)1056 1057 text=""1058 column_x=[]1059 row_x=[]1060 1061 i=01062 for row in cursor:1063 1064 r0=str(row[0])1065 r1=str(row[1])1066 r2=str(row[2])1067 r3=str(row[3])1068 1069 1070 column_x = [(r0, r1, r2, r3)]1071 row_x.extend(column_x)1072 1073 1074 connection.commit()1075 connection.close()1076 print("len(column_x)", len(column_x))1077 print("len(row_x)", len(row_x))1078 x=len(row_x)1079 #Reihe 01080 i=01081 E_0_0.set_text("") 1082 k=0+(s_zahl_1-1)*101083 x=""1084 try:1085 x=str(row_x[k][i])1086 E_0_0.set_text(x)1087 except:1088 E_0_0.set_text("")1089 i=11090 E_0_1.set_text("") 1091 k=0+(s_zahl_1-1)*101092 x=""1093 try:1094 x=str(row_x[k][i])1095 print("x ",x)1096 E_0_1.set_text(x)1097 except:1098 E_0_1.set_text("")1099 1100 i=21101 E_0_2.set_text("") 1102 k=0+(s_zahl_1-1)*101103 x=""1104 try:1105 x=str(row_x[k][i])1106 E_0_2.set_text(x)1107 except:1108 E_0_2.set_text("")1109 1110 i=31111 E_0_3.set_text("") 1112 k=0+(s_zahl_1-1)*101113 x=""1114 try:1115 x=str(row_x[k][i])1116 E_0_3.set_text(x)1117 except:1118 E_0_3.set_text("")1119 #Reihe11120 i=01121 E_1_0.set_text("") 1122 k=1+(s_zahl_1-1)*101123 x=""1124 try:1125 x=str(row_x[k][i])1126 E_1_0.set_text(x)1127 except:1128 E_1_0.set_text("")1129 i=11130 E_1_1.set_text("") 1131 k=1+(s_zahl_1-1)*101132 x=""1133 try:1134 x=str(row_x[k][i])1135 print("x ",x)1136 E_1_1.set_text(x)1137 except:1138 E_1_1.set_text("")1139 1140 i=21141 E_1_2.set_text("") 1142 k=1+(s_zahl_1-1)*101143 x=""1144 try:1145 x=str(row_x[k][i])1146 E_1_2.set_text(x)1147 except:1148 E_1_2.set_text("")1149 1150 i=31151 E_1_3.set_text("") 1152 k=1+(s_zahl_1-1)*101153 x=""1154 try:1155 x=str(row_x[k][i])1156 E_1_3.set_text(x)1157 except:1158 E_1_3.set_text("")1159 #Reihe21160 i=01161 E_2_0.set_text("") 1162 k=2+(s_zahl_1-1)*101163 x=""1164 try:1165 x=str(row_x[k][i])1166 E_2_0.set_text(x)1167 except:1168 E_2_0.set_text("")1169 i=11170 E_2_1.set_text("") 1171 k=2+(s_zahl_1-1)*101172 x=""1173 try:1174 x=str(row_x[k][i])1175 print("x ",x)1176 E_2_1.set_text(x)1177 except:1178 E_2_1.set_text("")1179 1180 i=21181 E_2_2.set_text("") 1182 k=2+(s_zahl_1-1)*101183 x=""1184 try:1185 x=str(row_x[k][i])1186 E_2_2.set_text(x)1187 except:1188 E_2_2.set_text("")1189 1190 i=31191 E_2_3.set_text("") 1192 k=2+(s_zahl_1-1)*101193 x=""1194 try:1195 x=str(row_x[k][i])1196 E_2_3.set_text(x)1197 except:1198 E_2_3.set_text("")1199 #Reihe31200 i=01201 E_3_0.set_text("") 1202 k=3+(s_zahl_1-1)*101203 x=""1204 try:1205 x=str(row_x[k][i])1206 E_3_0.set_text(x)1207 except:1208 E_3_0.set_text("")1209 i=11210 E_3_1.set_text("") 1211 k=3+(s_zahl_1-1)*101212 x=""1213 try:1214 x=str(row_x[k][i])1215 print("x ",x)1216 E_3_1.set_text(x)1217 except:1218 E_3_1.set_text("")1219 1220 i=21221 E_3_2.set_text("") 1222 k=3+(s_zahl_1-1)*101223 x=""1224 try:1225 x=str(row_x[k][i])1226 E_3_2.set_text(x)1227 except:1228 E_3_2.set_text("")1229 1230 i=31231 E_3_3.set_text("") 1232 k=3+(s_zahl_1-1)*101233 x=""1234 try:1235 x=str(row_x[k][i])1236 E_3_3.set_text(x)1237 except:1238 E_3_3.set_text("")1239 1240 #Reihe41241 i=01242 E_4_0.set_text("") 1243 k=4+(s_zahl_1-1)*101244 x=""1245 try:1246 x=str(row_x[k][i])1247 E_4_0.set_text(x)1248 except:1249 E_4_0.set_text("")1250 i=11251 E_4_1.set_text("") 1252 k=4+(s_zahl_1-1)*101253 x=""1254 try:1255 x=str(row_x[k][i])1256 print("x ",x)1257 E_4_1.set_text(x)1258 except:1259 E_4_1.set_text("")1260 1261 i=21262 E_4_2.set_text("") 1263 k=4+(s_zahl_1-1)*101264 x=""1265 try:1266 x=str(row_x[k][i])1267 E_4_2.set_text(x)1268 except:1269 E_4_2.set_text("")1270 1271 i=31272 E_4_3.set_text("") 1273 k=4+(s_zahl_1-1)*101274 x=""1275 try:1276 x=str(row_x[k][i])1277 E_4_3.set_text(x)1278 except:1279 E_4_3.set_text("")1280 1281 #Reihe51282 i=01283 E_5_0.set_text("") 1284 k=5+(s_zahl_1-1)*101285 x=""1286 try:1287 x=str(row_x[k][i])1288 E_5_0.set_text(x)1289 except:1290 E_5_0.set_text("")1291 i=11292 E_5_1.set_text("") 1293 k=5+(s_zahl_1-1)*101294 x=""1295 try:1296 x=str(row_x[k][i])1297 print("x ",x)1298 E_5_1.set_text(x)1299 except:1300 E_5_1.set_text("")1301 1302 i=21303 E_5_2.set_text("") 1304 k=5+(s_zahl_1-1)*101305 x=""1306 try:1307 x=str(row_x[k][i])1308 E_5_2.set_text(x)1309 except:1310 E_5_2.set_text("")1311 1312 i=31313 E_5_3.set_text("") 1314 k=5+(s_zahl_1-1)*101315 x=""1316 try:1317 x=str(row_x[k][i])1318 E_5_3.set_text(x)1319 except:1320 E_5_3.set_text("")1321 #Reihe61322 i=01323 E_6_0.set_text("") 1324 k=6+(s_zahl_1-1)*101325 x=""1326 try:1327 x=str(row_x[k][i])1328 E_6_0.set_text(x)1329 except:1330 E_6_0.set_text("")1331 1332 i=11333 E_6_1.set_text("") 1334 k=6+(s_zahl_1-1)*101335 x=""1336 try:1337 x=str(row_x[k][i])1338 print("x ",x)1339 E_6_1.set_text(x)1340 except:1341 E_6_1.set_text("")1342 1343 i=21344 E_6_2.set_text("") 1345 k=6+(s_zahl_1-1)*101346 x=""1347 try:1348 x=str(row_x[k][i])1349 E_6_2.set_text(x)1350 except:1351 E_6_2.set_text("")1352 1353 i=31354 E_6_3.set_text("") 1355 k=6+(s_zahl_1-1)*101356 x=""1357 try:1358 x=str(row_x[k][i])1359 E_6_3.set_text(x)1360 except:1361 E_6_3.set_text("")1362 #Reihe71363 i=01364 E_7_0.set_text("") 1365 k=7+(s_zahl_1-1)*101366 x=""1367 try:1368 x=str(row_x[k][i])1369 E_7_0.set_text(x)1370 except:1371 E_7_0.set_text("")1372 i=11373 E_7_1.set_text("") 1374 k=7+(s_zahl_1-1)*101375 x=""1376 try:1377 x=str(row_x[k][i])1378 print("x ",x)1379 E_7_1.set_text(x)1380 except:1381 E_7_1.set_text("")1382 1383 i=21384 E_7_2.set_text("") 1385 k=7+(s_zahl_1-1)*101386 x=""1387 try:1388 x=str(row_x[k][i])1389 E_7_2.set_text(x)1390 except:1391 E_7_2.set_text("")1392 1393 i=31394 E_7_3.set_text("") 1395 k=7+(s_zahl_1-1)*101396 x=""1397 try:1398 x=str(row_x[k][i])1399 E_7_3.set_text(x)1400 except:1401 E_7_3.set_text("")1402 #Reihe81403 i=01404 E_8_0.set_text("") 1405 k=8+(s_zahl_1-1)*101406 x=""1407 try:1408 x=str(row_x[k][i])1409 E_8_0.set_text(x)1410 except:1411 E_8_0.set_text("")1412 i=11413 E_8_1.set_text("") 1414 k=8+(s_zahl_1-1)*101415 x=""1416 try:1417 x=str(row_x[k][i])1418 print("x ",x)1419 E_8_1.set_text(x)1420 except:1421 E_8_1.set_text("")1422 1423 i=21424 E_8_2.set_text("") 1425 k=8+(s_zahl_1-1)*101426 x=""1427 try:1428 x=str(row_x[k][i])1429 E_8_2.set_text(x)1430 except:1431 E_8_2.set_text("")1432 1433 i=31434 E_8_3.set_text("") 1435 k=8+(s_zahl_1-1)*101436 x=""1437 try:1438 x=str(row_x[k][i])1439 E_8_3.set_text(x)1440 except:1441 E_8_3.set_text("")1442 #Reihe91443 i=01444 E_9_0.set_text("") 1445 k=9+(s_zahl_1-1)*101446 x=""1447 try:1448 x=str(row_x[k][i])1449 E_9_0.set_text(x)1450 except:1451 E_9_0.set_text("")1452 i=11453 E_9_1.set_text("") 1454 k=9+(s_zahl_1-1)*101455 x=""1456 try:1457 x=str(row_x[k][i])1458 print("x ",x)1459 E_9_1.set_text(x)1460 except:1461 E_9_1.set_text("")1462 1463 i=21464 E_9_2.set_text("") 1465 k=9+(s_zahl_1-1)*101466 x=""1467 try:1468 x=str(row_x[k][i])1469 E_9_2.set_text(x)1470 except:1471 E_9_2.set_text("")1472 1473 i=31474 E_9_3.set_text("") 1475 k=9+(s_zahl_1-1)*101476 x=""1477 try:1478 x=str(row_x[k][i])1479 E_9_3.set_text(x)1480 except:1481 E_9_3.set_text("")1482 def updateGets(self):1483 #Gets1484 E_0_0 = builder.get_object("Get_Id_0")1485 E_1_0 = builder.get_object("Get_Id_1")1486 E_2_0 = builder.get_object("Get_Id_2")1487 E_3_0 = builder.get_object("Get_Id_3")1488 E_4_0 = builder.get_object("Get_Id_4")1489 E_5_0 = builder.get_object("Get_Id_5")1490 E_6_0 = builder.get_object("Get_Id_6")1491 E_7_0 = builder.get_object("Get_Id_7")1492 E_8_0 = builder.get_object("Get_Id_8")1493 E_9_0 = builder.get_object("Get_Id_9")1494 1495 E_0_1 = builder.get_object("Get_NSC_0")1496 E_1_1 = builder.get_object("Get_NSC_1")1497 E_2_1 = builder.get_object("Get_NSC_2")1498 E_3_1 = builder.get_object("Get_NSC_3")1499 E_4_1 = builder.get_object("Get_NSC_4")1500 E_5_1 = builder.get_object("Get_NSC_5")1501 E_6_1 = builder.get_object("Get_NSC_6")1502 E_7_1 = builder.get_object("Get_NSC_7")1503 E_8_1 = builder.get_object("Get_NSC_8")1504 E_9_1 = builder.get_object("Get_NSC_9")1505 1506 E_0_2 = builder.get_object("Get_UserId_0")1507 E_1_2 = builder.get_object("Get_UserId_1")1508 E_2_2 = builder.get_object("Get_UserId_2")1509 E_3_2 = builder.get_object("Get_UserId_3")1510 E_4_2 = builder.get_object("Get_UserId_4")1511 E_5_2 = builder.get_object("Get_UserId_5")1512 E_6_2 = builder.get_object("Get_UserId_6")1513 E_7_2 = builder.get_object("Get_UserId_7")1514 E_8_2 = builder.get_object("Get_UserId_8")1515 E_9_2 = builder.get_object("Get_UserId_9")1516 1517 E_0_3 = builder.get_object("Get_DevId_0")1518 E_1_3 = builder.get_object("Get_DevId_1")1519 E_2_3 = builder.get_object("Get_DevId_2")1520 E_3_3 = builder.get_object("Get_DevId_3")1521 E_4_3 = builder.get_object("Get_DevId_4")1522 E_5_3 = builder.get_object("Get_DevId_5")1523 E_6_3 = builder.get_object("Get_DevId_6")1524 E_7_3 = builder.get_object("Get_DevId_7")1525 E_8_3 = builder.get_object("Get_DevId_8")1526 E_9_3 = builder.get_object("Get_DevId_9")1527 1528 E_0_4 = builder.get_object("Get_Date_0")1529 E_1_4 = builder.get_object("Get_Date_1")1530 E_2_4 = builder.get_object("Get_Date_2")1531 E_3_4 = builder.get_object("Get_Date_3")1532 E_4_4 = builder.get_object("Get_Date_4")1533 E_5_4 = builder.get_object("Get_Date_5")1534 E_6_4 = builder.get_object("Get_Date_6")1535 E_7_4 = builder.get_object("Get_Date_7")1536 E_8_4 = builder.get_object("Get_Date_8")1537 E_9_4 = builder.get_object("Get_Date_9")1538 1539 1540 1541 global s_zahl_21542 connection = sqlite3.connect(db)1543 cursor= connection.cursor()1544 sql = "SELECT * FROM Gets"1545 cursor.execute(sql)1546 1547 text=""1548 column_x=[]1549 row_x=[]1550 1551 i=01552 for row in cursor:1553 1554 r0=str(row[0])1555 r1=str(row[1])1556 r2=str(row[2])1557 r3=str(row[3])1558 r4=str(row[4])1559 1560 1561 column_x = [(r0, r1, r2, r3, r4)]1562 row_x.extend(column_x)1563 1564 1565 connection.commit()1566 connection.close()1567 print("len(column_x)", len(column_x))1568 print("len(row_x)", len(row_x))1569 x=len(row_x)1570 #Reihe 01571 i=01572 E_0_0.set_text("") 1573 k=0+(s_zahl_2-1)*101574 x=""1575 try:1576 x=str(row_x[k][i])1577 E_0_0.set_text(x)1578 except:1579 E_0_0.set_text("")1580 i=11581 E_0_1.set_text("") 1582 k=0+(s_zahl_2-1)*101583 x=""1584 try:1585 x=str(row_x[k][i])1586 print("x ",x)1587 E_0_1.set_text(x)1588 except:1589 E_0_1.set_text("")1590 1591 i=21592 E_0_2.set_text("") 1593 k=0+(s_zahl_2-1)*101594 x=""1595 try:1596 x=str(row_x[k][i])1597 E_0_2.set_text(x)1598 except:1599 E_0_2.set_text("")1600 1601 i=31602 E_0_3.set_text("") 1603 k=0+(s_zahl_2-1)*101604 x=""1605 try:1606 x=str(row_x[k][i])1607 E_0_3.set_text(x)1608 except:1609 E_0_3.set_text("")1610 i=41611 E_0_4.set_text("") 1612 k=0+(s_zahl_2-1)*101613 x=""1614 try:1615 x=str(row_x[k][i])1616 E_0_4.set_text(x)1617 except:1618 E_0_4.set_text("")1619 #Reihe11620 i=01621 E_1_0.set_text("") 1622 k=1+(s_zahl_2-1)*101623 x=""1624 try:1625 x=str(row_x[k][i])1626 E_1_0.set_text(x)1627 except:1628 E_1_0.set_text("")1629 i=11630 E_1_1.set_text("") 1631 k=1+(s_zahl_2-1)*101632 x=""1633 try:1634 x=str(row_x[k][i])1635 print("x ",x)1636 E_1_1.set_text(x)1637 except:1638 E_1_1.set_text("")1639 1640 i=21641 E_1_2.set_text("") 1642 k=1+(s_zahl_2-1)*101643 x=""1644 try:1645 x=str(row_x[k][i])1646 E_1_2.set_text(x)1647 except:1648 E_1_2.set_text("")1649 1650 i=31651 E_1_3.set_text("") 1652 k=1+(s_zahl_2-1)*101653 x=""1654 try:1655 x=str(row_x[k][i])1656 E_1_3.set_text(x)1657 except:1658 E_1_3.set_text("")1659 i=41660 E_1_4.set_text("") 1661 k=1+(s_zahl_2-1)*101662 x=""1663 try:1664 x=str(row_x[k][i])1665 E_1_4.set_text(x)1666 except:1667 E_1_4.set_text("")1668 1669 #Reihe21670 i=01671 E_2_0.set_text("") 1672 k=2+(s_zahl_2-1)*101673 x=""1674 try:1675 x=str(row_x[k][i])1676 E_2_0.set_text(x)1677 except:1678 E_2_0.set_text("")1679 i=11680 E_2_1.set_text("") 1681 k=2+(s_zahl_2-1)*101682 x=""1683 try:1684 x=str(row_x[k][i])1685 print("x ",x)1686 E_2_1.set_text(x)1687 except:1688 E_2_1.set_text("")1689 1690 i=21691 E_2_2.set_text("") 1692 k=2+(s_zahl_2-1)*101693 x=""1694 try:1695 x=str(row_x[k][i])1696 E_2_2.set_text(x)1697 except:1698 E_2_2.set_text("")1699 1700 i=31701 E_2_3.set_text("") 1702 k=2+(s_zahl_2-1)*101703 x=""1704 try:1705 x=str(row_x[k][i])1706 E_2_3.set_text(x)1707 except:1708 E_2_3.set_text("")1709 i=41710 E_2_4.set_text("") 1711 k=2+(s_zahl_2-1)*101712 x=""1713 try:1714 x=str(row_x[k][i])1715 E_2_4.set_text(x)1716 except:1717 E_2_4.set_text("")1718 1719 #Reihe31720 i=01721 E_3_0.set_text("") 1722 k=3+(s_zahl_2-1)*101723 x=""1724 try:1725 x=str(row_x[k][i])1726 E_3_0.set_text(x)1727 except:1728 E_3_0.set_text("")1729 i=11730 E_3_1.set_text("") 1731 k=3+(s_zahl_2-1)*101732 x=""1733 try:1734 x=str(row_x[k][i])1735 print("x ",x)1736 E_3_1.set_text(x)1737 except:1738 E_3_1.set_text("")1739 1740 i=21741 E_3_2.set_text("") 1742 k=3+(s_zahl_2-1)*101743 x=""1744 try:1745 x=str(row_x[k][i])1746 E_3_2.set_text(x)1747 except:1748 E_3_2.set_text("")1749 1750 i=31751 E_3_3.set_text("") 1752 k=3+(s_zahl_2-1)*101753 x=""1754 try:1755 x=str(row_x[k][i])1756 E_3_3.set_text(x)1757 except:1758 E_3_3.set_text("")1759 i=41760 E_3_4.set_text("") 1761 k=3+(s_zahl_2-1)*101762 x=""1763 try:1764 x=str(row_x[k][i])1765 E_3_4.set_text(x)1766 except:1767 E_3_4.set_text("")1768 #Reihe41769 i=01770 E_4_0.set_text("") 1771 k=4+(s_zahl_2-1)*101772 x=""1773 try:1774 x=str(row_x[k][i])1775 E_4_0.set_text(x)1776 except:1777 E_4_0.set_text("")1778 i=11779 E_4_1.set_text("") 1780 k=4+(s_zahl_2-1)*101781 x=""1782 try:1783 x=str(row_x[k][i])1784 print("x ",x)1785 E_4_1.set_text(x)1786 except:1787 E_4_1.set_text("")1788 1789 i=21790 E_4_2.set_text("") 1791 k=4+(s_zahl_2-1)*101792 x=""1793 try:1794 x=str(row_x[k][i])1795 E_4_2.set_text(x)1796 except:1797 E_4_2.set_text("")1798 1799 i=31800 E_4_3.set_text("") 1801 k=4+(s_zahl_2-1)*101802 x=""1803 try:1804 x=str(row_x[k][i])1805 E_4_3.set_text(x)1806 except:1807 E_4_3.set_text("")1808 i=41809 E_4_4.set_text("") 1810 k=4+(s_zahl_2-1)*101811 x=""1812 try:1813 x=str(row_x[k][i])1814 E_4_4.set_text(x)1815 except:1816 E_4_4.set_text("")1817 1818 #Reihe51819 i=01820 E_5_0.set_text("") 1821 k=5+(s_zahl_2-1)*101822 x=""1823 try:1824 x=str(row_x[k][i])1825 E_5_0.set_text(x)1826 except:1827 E_5_0.set_text("")1828 i=11829 E_5_1.set_text("") 1830 k=5+(s_zahl_2-1)*101831 x=""1832 try:1833 x=str(row_x[k][i])1834 print("x ",x)1835 E_5_1.set_text(x)1836 except:1837 E_5_1.set_text("")1838 1839 i=21840 E_5_2.set_text("") 1841 k=5+(s_zahl_2-1)*101842 x=""1843 try:1844 x=str(row_x[k][i])1845 E_5_2.set_text(x)1846 except:1847 E_5_2.set_text("")1848 1849 i=31850 E_5_3.set_text("") 1851 k=5+(s_zahl_2-1)*101852 x=""1853 try:1854 x=str(row_x[k][i])1855 E_5_3.set_text(x)1856 except:1857 E_5_3.set_text("")1858 i=41859 E_5_4.set_text("") 1860 k=5+(s_zahl_2-1)*101861 x=""1862 try:1863 x=str(row_x[k][i])1864 E_5_4.set_text(x)1865 except:1866 E_5_4.set_text("")1867 1868 #Reihe61869 i=01870 E_6_0.set_text("") 1871 k=6+(s_zahl_2-1)*101872 x=""1873 try:1874 x=str(row_x[k][i])1875 E_6_0.set_text(x)1876 except:1877 E_6_0.set_text("")1878 1879 i=11880 E_6_1.set_text("") 1881 k=6+(s_zahl_2-1)*101882 x=""1883 try:1884 x=str(row_x[k][i])1885 print("x ",x)1886 E_6_1.set_text(x)1887 except:1888 E_6_1.set_text("")1889 1890 i=21891 E_6_2.set_text("") 1892 k=6+(s_zahl_2-1)*101893 x=""1894 try:1895 x=str(row_x[k][i])1896 E_6_2.set_text(x)1897 except:1898 E_6_2.set_text("")1899 1900 i=31901 E_6_3.set_text("") 1902 k=6+(s_zahl_2-1)*101903 x=""1904 try:1905 x=str(row_x[k][i])1906 E_6_3.set_text(x)1907 except:1908 E_6_3.set_text("")1909 i=41910 E_6_4.set_text("") 1911 k=6+(s_zahl_2-1)*101912 x=""1913 try:1914 x=str(row_x[k][i])1915 E_6_4.set_text(x)1916 except:1917 E_6_4.set_text("")1918 1919 #Reihe71920 i=01921 E_7_0.set_text("") 1922 k=7+(s_zahl_2-1)*101923 x=""1924 try:1925 x=str(row_x[k][i])1926 E_7_0.set_text(x)1927 except:1928 E_7_0.set_text("")1929 i=11930 E_7_1.set_text("") 1931 k=7+(s_zahl_2-1)*101932 x=""1933 try:1934 x=str(row_x[k][i])1935 print("x ",x)1936 E_7_1.set_text(x)1937 except:1938 E_7_1.set_text("")1939 1940 i=21941 E_7_2.set_text("") 1942 k=7+(s_zahl_2-1)*101943 x=""1944 try:1945 x=str(row_x[k][i])1946 E_7_2.set_text(x)1947 except:1948 E_7_2.set_text("")1949 1950 i=31951 E_7_3.set_text("") 1952 k=7+(s_zahl_2-1)*101953 x=""1954 try:1955 x=str(row_x[k][i])1956 E_7_3.set_text(x)1957 except:1958 E_7_3.set_text("")1959 i=41960 E_7_4.set_text("") 1961 k=7+(s_zahl_2-1)*101962 x=""1963 try:1964 x=str(row_x[k][i])1965 E_7_4.set_text(x)1966 except:1967 E_7_4.set_text("")1968 1969 #Reihe81970 i=01971 E_8_0.set_text("") 1972 k=8+(s_zahl_2-1)*101973 x=""1974 try:1975 x=str(row_x[k][i])1976 E_8_0.set_text(x)1977 except:1978 E_8_0.set_text("")1979 i=11980 E_8_1.set_text("") 1981 k=8+(s_zahl_2-1)*101982 x=""1983 try:1984 x=str(row_x[k][i])1985 print("x ",x)1986 E_8_1.set_text(x)1987 except:1988 E_8_1.set_text("")1989 1990 i=21991 E_8_2.set_text("") 1992 k=8+(s_zahl_2-1)*101993 x=""1994 try:1995 x=str(row_x[k][i])1996 E_8_2.set_text(x)1997 except:1998 E_8_2.set_text("")1999 2000 i=32001 E_8_3.set_text("") 2002 k=8+(s_zahl_2-1)*102003 x=""2004 try:2005 x=str(row_x[k][i])2006 E_8_3.set_text(x)2007 except:2008 E_8_3.set_text("")2009 i=42010 E_8_4.set_text("") 2011 k=8+(s_zahl_2-1)*102012 x=""2013 try:2014 x=str(row_x[k][i])2015 E_8_4.set_text(x)2016 except:2017 E_8_4.set_text("")2018 2019 #Reihe92020 i=02021 E_9_0.set_text("") 2022 k=9+(s_zahl_2-1)*102023 x=""2024 try:2025 x=str(row_x[k][i])2026 E_9_0.set_text(x)2027 except:2028 E_9_0.set_text("")2029 i=12030 E_9_1.set_text("") 2031 k=9+(s_zahl_2-1)*102032 x=""2033 try:2034 x=str(row_x[k][i])2035 print("x ",x)2036 E_9_1.set_text(x)2037 except:2038 E_9_1.set_text("")2039 2040 i=22041 E_9_2.set_text("") 2042 k=9+(s_zahl_2-1)*102043 x=""2044 try:2045 x=str(row_x[k][i])2046 E_9_2.set_text(x)2047 except:2048 E_9_2.set_text("")2049 2050 i=32051 E_9_3.set_text("") 2052 k=9+(s_zahl_2-1)*102053 x=""2054 try:2055 x=str(row_x[k][i])2056 E_9_3.set_text(x)2057 except:2058 E_9_3.set_text("")2059 i=42060 E_9_4.set_text("") 2061 k=9+(s_zahl_2-1)*102062 x=""2063 try:2064 x=str(row_x[k][i])2065 E_9_4.set_text(x)2066 except:2067 E_9_4.set_text("")2068def main():2069 if os.path.exists("/usr/local/share/topman/database.db") == False:2070 connection = sqlite3.connect(db)2071 cursor = connection.cursor()2072 cursor.execute('''CREATE TABLE Devices(devId INTEGER PRIMARY KEY,devBrand TEXT,devModel TEXT,devOS,devHost,devState INTEGER)''')2073 cursor.execute('''CREATE TABLE Users(userId INTEGER PRIMARY KEY,userName TEXT,userSurename TEXT,userClass TEXT)''')2074 cursor.execute('''CREATE TABLE Gets(getId INTEGER PRIMARY KEY,getUser TEXT,getUserId INTEGER,getDevId INTEGER,getDate TEXT)''')2075 connection.commit()2076 connection.close()2077 builder = Gtk.Builder()2078 builder.add_from_file(UI_FILE)2079 window = builder.get_object('mainWindow')2080 Handler.updateDev(Handler)2081 Handler.updateUser(Handler)...

topman.py~

Source:topman.py~

...234 else:235 s_zahl_0=1236 237 238 devicePageEntry.set_text(str(s_zahl_0))239 self.updateDev()240 241 def devForward(self, deviceButtonForward):242 devicePageEntry = builder.get_object("devicePageEntry")243 print("vor")244 global s_zahl_0245 s_zahl_0=int(devicePageEntry.get_text())246 247 s_zahl_0=s_zahl_0+1248 devicePageEntry.set_text(str(s_zahl_0))249 self.updateDev()250 251 def userBack(self, userButtonBack):252 userPageEntry = builder.get_object("userPageEntry")253 global s_zahl_1254 s_zahl_0=int(userPageEntry.get_text())255 if (s_zahl_1>2):256 s_zahl_1=s_zahl_1-1257 print('Seite: ',s_zahl_1)258 else:259 s_zahl_1=1260 261 262 userPageEntry.set_text(str(s_zahl_1))263 self.updateUser()264 265 def userForward(self, userButtonForward):266 userPageEntry = builder.get_object("userPageEntry")267 print("vor")268 global s_zahl_1269 s_zahl_1=int(userPageEntry.get_text())270 271 s_zahl_1=s_zahl_1+1272 userPageEntry.set_text(str(s_zahl_1))273 self.updateUser()274 275 def getsBack(self, getsButtonBack):276 getsPageEntry = builder.get_object("getsPageEntry")277 global s_zahl_2278 s_zahl_2=int(getsPageEntry.get_text())279 if (s_zahl_2>2):280 s_zahl_2=s_zahl_2-1281 print('Seite: ',s_zahl_2)282 else:283 s_zahl_2=1284 285 286 getsPageEntry.set_text(str(s_zahl_2))287 self.updateGets()288 289 def getsForward(self, getsButtonForward):290 getsPageEntry = builder.get_object("getsPageEntry")291 print("vor")292 global s_zahl_2293 s_zahl_2=int(getsPageEntry.get_text())294 295 s_zahl_2=s_zahl_2+1296 getsPageEntry.set_text(str(s_zahl_2))297 self.updateGets()298 299 def actUpdate(self, buttonUpdate):300 self.updateDev()301 self.updateUser()302 self.updateGets()303 304 def updateDev(self):305 #Devices306 E_0_0 = builder.get_object("Id_0")307 E_1_0 = builder.get_object("Id_1")308 E_2_0 = builder.get_object("Id_2")309 E_3_0 = builder.get_object("Id_3")310 E_4_0 = builder.get_object("Id_4")311 E_5_0 = builder.get_object("Id_5")312 E_6_0 = builder.get_object("Id_6")313 E_7_0 = builder.get_object("Id_7")314 E_8_0 = builder.get_object("Id_8")315 E_9_0 = builder.get_object("Id_9")316 317 E_0_1 = builder.get_object("Brand_0")318 E_1_1 = builder.get_object("Brand_1")319 E_2_1 = builder.get_object("Brand_2")320 E_3_1 = builder.get_object("Brand_3")321 E_4_1 = builder.get_object("Brand_4")322 E_5_1 = builder.get_object("Brand_5")323 E_6_1 = builder.get_object("Brand_6")324 E_7_1 = builder.get_object("Brand_7")325 E_8_1 = builder.get_object("Brand_8")326 E_9_1 = builder.get_object("Brand_9")327 328 E_0_2 = builder.get_object("Model_0")329 E_1_2 = builder.get_object("Model_1")330 E_2_2 = builder.get_object("Model_2")331 E_3_2 = builder.get_object("Model_3")332 E_4_2 = builder.get_object("Model_4")333 E_5_2 = builder.get_object("Model_5")334 E_6_2 = builder.get_object("Model_6")335 E_7_2 = builder.get_object("Model_7")336 E_8_2 = builder.get_object("Model_8")337 E_9_2 = builder.get_object("Model_9")338 339 E_0_3 = builder.get_object("OS_0")340 E_1_3 = builder.get_object("OS_1")341 E_2_3 = builder.get_object("OS_2")342 E_3_3 = builder.get_object("OS_3")343 E_4_3 = builder.get_object("OS_4")344 E_5_3 = builder.get_object("OS_5")345 E_6_3 = builder.get_object("OS_6")346 E_7_3 = builder.get_object("OS_7")347 E_8_3 = builder.get_object("OS_8")348 E_9_3 = builder.get_object("OS_9")349 350 E_0_4 = builder.get_object("Hostname_0")351 E_1_4 = builder.get_object("Hostname_1")352 E_2_4 = builder.get_object("Hostname_2")353 E_3_4 = builder.get_object("Hostname_3")354 E_4_4 = builder.get_object("Hostname_4")355 E_5_4 = builder.get_object("Hostname_5")356 E_6_4 = builder.get_object("Hostname_6")357 E_7_4 = builder.get_object("Hostname_7")358 E_8_4 = builder.get_object("Hostname_8")359 E_9_4 = builder.get_object("Hostname_9")360 361 E_0_5 = builder.get_object("Status_0")362 E_1_5 = builder.get_object("Status_1")363 E_2_5 = builder.get_object("Status_2")364 E_3_5 = builder.get_object("Status_3")365 E_4_5 = builder.get_object("Status_4")366 E_5_5 = builder.get_object("Status_5")367 E_6_5 = builder.get_object("Status_6")368 E_7_5 = builder.get_object("Status_7")369 E_8_5 = builder.get_object("Status_8")370 E_9_5 = builder.get_object("Status_9")371 372 373 global s_zahl_0374 connection = sqlite3.connect(db)375 cursor= connection.cursor()376 sql = "SELECT * FROM Devices"377 cursor.execute(sql)378 379 text=""380 column_x=[]381 row_x=[]382 383 i=0384 for row in cursor:385 386 r0=str(row[0])387 r1=str(row[1])388 r2=str(row[2])389 r3=str(row[3])390 r4=str(row[4])391 r5=str(row[5])392 393 394 column_x = [(r0, r1, r2, r3, r4, r5)]395 row_x.extend(column_x)396 397 398 connection.commit()399 connection.close()400 print("len(column_x)", len(column_x))401 print("len(row_x)", len(row_x))402 x=len(row_x)403 #Reihe 0404 i=0405 E_0_0.set_text("") 406 k=0+(s_zahl_0-1)*10407 x=""408 try:409 x=str(row_x[k][i])410 E_0_0.set_text(x)411 except:412 E_0_0.set_text("")413 i=1414 E_0_1.set_text("") 415 k=0+(s_zahl_0-1)*10416 x=""417 try:418 x=str(row_x[k][i])419 print("x ",x)420 E_0_1.set_text(x)421 except:422 E_0_1.set_text("")423 424 i=2425 E_0_2.set_text("") 426 k=0+(s_zahl_0-1)*10427 x=""428 try:429 x=str(row_x[k][i])430 E_0_2.set_text(x)431 except:432 E_0_2.set_text("")433 434 i=3435 E_0_3.set_text("") 436 k=0+(s_zahl_0-1)*10437 x=""438 try:439 x=str(row_x[k][i])440 E_0_3.set_text(x)441 except:442 E_0_3.set_text("")443 i=4444 E_0_4.set_text("") 445 k=0+(s_zahl_0-1)*10446 x=""447 try:448 x=str(row_x[k][i])449 E_0_4.set_text(x)450 except:451 E_0_4.set_text("")452 i=5453 E_0_5.set_text("") 454 k=0+(s_zahl_0-1)*10455 x=""456 try:457 x=str(row_x[k][i])458 E_0_5.set_text(x)459 except:460 E_0_5.set_text("") 461 462 463 464 #Reihe1465 i=0466 E_1_0.set_text("") 467 k=1+(s_zahl_0-1)*10468 x=""469 try:470 x=str(row_x[k][i])471 E_1_0.set_text(x)472 except:473 E_1_0.set_text("")474 i=1475 E_1_1.set_text("") 476 k=1+(s_zahl_0-1)*10477 x=""478 try:479 x=str(row_x[k][i])480 print("x ",x)481 E_1_1.set_text(x)482 except:483 E_1_1.set_text("")484 485 i=2486 E_1_2.set_text("") 487 k=1+(s_zahl_0-1)*10488 x=""489 try:490 x=str(row_x[k][i])491 E_1_2.set_text(x)492 except:493 E_1_2.set_text("")494 495 i=3496 E_1_3.set_text("") 497 k=1+(s_zahl_0-1)*10498 x=""499 try:500 x=str(row_x[k][i])501 E_1_3.set_text(x)502 except:503 E_1_3.set_text("")504 i=4505 E_1_4.set_text("") 506 k=1+(s_zahl_0-1)*10507 x=""508 try:509 x=str(row_x[k][i])510 E_1_4.set_text(x)511 except:512 E_1_4.set_text("")513 514 i=5515 E_1_5.set_text("") 516 k=1+(s_zahl_0-1)*10517 x=""518 try:519 x=str(row_x[k][i])520 E_1_5.set_text(x)521 except:522 E_1_5.set_text("")523 #Reihe2524 i=0525 E_2_0.set_text("") 526 k=2+(s_zahl_0-1)*10527 x=""528 try:529 x=str(row_x[k][i])530 E_2_0.set_text(x)531 except:532 E_2_0.set_text("")533 i=1534 E_2_1.set_text("") 535 k=2+(s_zahl_0-1)*10536 x=""537 try:538 x=str(row_x[k][i])539 print("x ",x)540 E_2_1.set_text(x)541 except:542 E_2_1.set_text("")543 544 i=2545 E_2_2.set_text("") 546 k=2+(s_zahl_0-1)*10547 x=""548 try:549 x=str(row_x[k][i])550 E_2_2.set_text(x)551 except:552 E_2_2.set_text("")553 554 i=3555 E_2_3.set_text("") 556 k=2+(s_zahl_0-1)*10557 x=""558 try:559 x=str(row_x[k][i])560 E_2_3.set_text(x)561 except:562 E_2_3.set_text("")563 i=4564 E_2_4.set_text("") 565 k=2+(s_zahl_0-1)*10566 x=""567 try:568 x=str(row_x[k][i])569 E_2_4.set_text(x)570 except:571 E_2_4.set_text("")572 573 i=5574 E_2_5.set_text("") 575 k=2+(s_zahl_0-1)*10576 x=""577 try:578 x=str(row_x[k][i])579 E_2_5.set_text(x)580 except:581 E_2_5.set_text("")582 #Reihe3583 i=0584 E_3_0.set_text("") 585 k=3+(s_zahl_0-1)*10586 x=""587 try:588 x=str(row_x[k][i])589 E_3_0.set_text(x)590 except:591 E_3_0.set_text("")592 i=1593 E_3_1.set_text("") 594 k=3+(s_zahl_0-1)*10595 x=""596 try:597 x=str(row_x[k][i])598 print("x ",x)599 E_3_1.set_text(x)600 except:601 E_3_1.set_text("")602 603 i=2604 E_3_2.set_text("") 605 k=3+(s_zahl_0-1)*10606 x=""607 try:608 x=str(row_x[k][i])609 E_3_2.set_text(x)610 except:611 E_3_2.set_text("")612 613 i=3614 E_3_3.set_text("") 615 k=3+(s_zahl_0-1)*10616 x=""617 try:618 x=str(row_x[k][i])619 E_3_3.set_text(x)620 except:621 E_3_3.set_text("")622 i=4623 E_3_4.set_text("") 624 k=3+(s_zahl_0-1)*10625 x=""626 try:627 x=str(row_x[k][i])628 E_3_4.set_text(x)629 except:630 E_3_4.set_text("")631 i=5632 E_3_5.set_text("") 633 k=3+(s_zahl_0-1)*10634 x=""635 try:636 x=str(row_x[k][i])637 E_3_5.set_text(x)638 except:639 E_3_5.set_text("")640 641 #Reihe4642 i=0643 E_4_0.set_text("") 644 k=4+(s_zahl_0-1)*10645 x=""646 try:647 x=str(row_x[k][i])648 E_4_0.set_text(x)649 except:650 E_4_0.set_text("")651 i=1652 E_4_1.set_text("") 653 k=4+(s_zahl_0-1)*10654 x=""655 try:656 x=str(row_x[k][i])657 print("x ",x)658 E_4_1.set_text(x)659 except:660 E_4_1.set_text("")661 662 i=2663 E_4_2.set_text("") 664 k=4+(s_zahl_0-1)*10665 x=""666 try:667 x=str(row_x[k][i])668 E_4_2.set_text(x)669 except:670 E_4_2.set_text("")671 672 i=3673 E_4_3.set_text("") 674 k=4+(s_zahl_0-1)*10675 x=""676 try:677 x=str(row_x[k][i])678 E_4_3.set_text(x)679 except:680 E_4_3.set_text("")681 i=4682 E_4_4.set_text("") 683 k=4+(s_zahl_0-1)*10684 x=""685 try:686 x=str(row_x[k][i])687 E_4_4.set_text(x)688 except:689 E_4_4.set_text("")690 691 i=5692 E_4_5.set_text("") 693 k=4+(s_zahl_0-1)*10694 x=""695 try:696 x=str(row_x[k][i])697 E_4_5.set_text(x)698 except:699 E_4_5.set_text("")700 701 #Reihe5702 i=0703 E_5_0.set_text("") 704 k=5+(s_zahl_0-1)*10705 x=""706 try:707 x=str(row_x[k][i])708 E_5_0.set_text(x)709 except:710 E_5_0.set_text("")711 i=1712 E_5_1.set_text("") 713 k=5+(s_zahl_0-1)*10714 x=""715 try:716 x=str(row_x[k][i])717 print("x ",x)718 E_5_1.set_text(x)719 except:720 E_5_1.set_text("")721 722 i=2723 E_5_2.set_text("") 724 k=5+(s_zahl_0-1)*10725 x=""726 try:727 x=str(row_x[k][i])728 E_5_2.set_text(x)729 except:730 E_5_2.set_text("")731 732 i=3733 E_5_3.set_text("") 734 k=5+(s_zahl_0-1)*10735 x=""736 try:737 x=str(row_x[k][i])738 E_5_3.set_text(x)739 except:740 E_5_3.set_text("")741 i=4742 E_5_4.set_text("") 743 k=5+(s_zahl_0-1)*10744 x=""745 try:746 x=str(row_x[k][i])747 E_5_4.set_text(x)748 except:749 E_5_4.set_text("")750 751 i=5752 E_5_5.set_text("") 753 k=5+(s_zahl_0-1)*10754 x=""755 try:756 x=str(row_x[k][i])757 E_5_5.set_text(x)758 except:759 E_5_5.set_text("")760 761 #Reihe6762 i=0763 E_6_0.set_text("") 764 k=6+(s_zahl_0-1)*10765 x=""766 try:767 x=str(row_x[k][i])768 E_6_0.set_text(x)769 except:770 E_6_0.set_text("")771 772 i=1773 E_6_1.set_text("") 774 k=6+(s_zahl_0-1)*10775 x=""776 try:777 x=str(row_x[k][i])778 print("x ",x)779 E_6_1.set_text(x)780 except:781 E_6_1.set_text("")782 783 i=2784 E_6_2.set_text("") 785 k=6+(s_zahl_0-1)*10786 x=""787 try:788 x=str(row_x[k][i])789 E_6_2.set_text(x)790 except:791 E_6_2.set_text("")792 793 i=3794 E_6_3.set_text("") 795 k=6+(s_zahl_0-1)*10796 x=""797 try:798 x=str(row_x[k][i])799 E_6_3.set_text(x)800 except:801 E_6_3.set_text("")802 i=4803 E_6_4.set_text("") 804 k=6+(s_zahl_0-1)*10805 x=""806 try:807 x=str(row_x[k][i])808 E_6_4.set_text(x)809 except:810 E_6_4.set_text("")811 812 i=5813 E_6_5.set_text("") 814 k=6+(s_zahl_0-1)*10815 x=""816 try:817 x=str(row_x[k][i])818 E_6_5.set_text(x)819 except:820 E_6_5.set_text("")821 822 #Reihe7823 i=0824 E_7_0.set_text("") 825 k=7+(s_zahl_0-1)*10826 x=""827 try:828 x=str(row_x[k][i])829 E_7_0.set_text(x)830 except:831 E_7_0.set_text("")832 i=1833 E_7_1.set_text("") 834 k=7+(s_zahl_0-1)*10835 x=""836 try:837 x=str(row_x[k][i])838 print("x ",x)839 E_7_1.set_text(x)840 except:841 E_7_1.set_text("")842 843 i=2844 E_7_2.set_text("") 845 k=7+(s_zahl_0-1)*10846 x=""847 try:848 x=str(row_x[k][i])849 E_7_2.set_text(x)850 except:851 E_7_2.set_text("")852 853 i=3854 E_7_3.set_text("") 855 k=7+(s_zahl_0-1)*10856 x=""857 try:858 x=str(row_x[k][i])859 E_7_3.set_text(x)860 except:861 E_7_3.set_text("")862 i=4863 E_7_4.set_text("") 864 k=7+(s_zahl_0-1)*10865 x=""866 try:867 x=str(row_x[k][i])868 E_7_4.set_text(x)869 except:870 E_7_4.set_text("")871 872 i=5873 E_7_5.set_text("") 874 k=7+(s_zahl_0-1)*10875 x=""876 try:877 x=str(row_x[k][i])878 E_7_5.set_text(x)879 except:880 E_7_5.set_text("")881 #Reihe8882 i=0883 E_8_0.set_text("") 884 k=8+(s_zahl_0-1)*10885 x=""886 try:887 x=str(row_x[k][i])888 E_8_0.set_text(x)889 except:890 E_8_0.set_text("")891 i=1892 E_8_1.set_text("") 893 k=8+(s_zahl_0-1)*10894 x=""895 try:896 x=str(row_x[k][i])897 print("x ",x)898 E_8_1.set_text(x)899 except:900 E_8_1.set_text("")901 902 i=2903 E_8_2.set_text("") 904 k=8+(s_zahl_0-1)*10905 x=""906 try:907 x=str(row_x[k][i])908 E_8_2.set_text(x)909 except:910 E_8_2.set_text("")911 912 i=3913 E_8_3.set_text("") 914 k=8+(s_zahl_0-1)*10915 x=""916 try:917 x=str(row_x[k][i])918 E_8_3.set_text(x)919 except:920 E_8_3.set_text("")921 i=4922 E_8_4.set_text("") 923 k=8+(s_zahl_0-1)*10924 x=""925 try:926 x=str(row_x[k][i])927 E_8_4.set_text(x)928 except:929 E_8_4.set_text("")930 931 i=5932 E_8_5.set_text("") 933 k=8+(s_zahl_0-1)*10934 x=""935 try:936 x=str(row_x[k][i])937 E_8_5.set_text(x)938 except:939 E_8_5.set_text("")940 941 #Reihe9942 i=0943 E_9_0.set_text("") 944 k=9+(s_zahl_0-1)*10945 x=""946 try:947 x=str(row_x[k][i])948 E_9_0.set_text(x)949 except:950 E_9_0.set_text("")951 i=1952 E_9_1.set_text("") 953 k=9+(s_zahl_0-1)*10954 x=""955 try:956 x=str(row_x[k][i])957 print("x ",x)958 E_9_1.set_text(x)959 except:960 E_9_1.set_text("")961 962 i=2963 E_9_2.set_text("") 964 k=9+(s_zahl_0-1)*10965 x=""966 try:967 x=str(row_x[k][i])968 E_9_2.set_text(x)969 except:970 E_9_2.set_text("")971 972 i=3973 E_9_3.set_text("") 974 k=9+(s_zahl_0-1)*10975 x=""976 try:977 x=str(row_x[k][i])978 E_9_3.set_text(x)979 except:980 E_9_3.set_text("")981 i=4982 E_9_4.set_text("") 983 k=9+(s_zahl_0-1)*10984 x=""985 try:986 x=str(row_x[k][i])987 E_9_4.set_text(x)988 except:989 E_9_4.set_text("")990 i=5991 E_9_5.set_text("") 992 k=9+(s_zahl_0-1)*10993 x=""994 try:995 x=str(row_x[k][i])996 E_9_5.set_text(x)997 except:998 E_9_5.set_text("")999 1000 def updateUser(self):1001 #Users1002 E_0_0 = builder.get_object("User_Id_0")1003 E_1_0 = builder.get_object("User_Id_1")1004 E_2_0 = builder.get_object("User_Id_2")1005 E_3_0 = builder.get_object("User_Id_3")1006 E_4_0 = builder.get_object("User_Id_4")1007 E_5_0 = builder.get_object("User_Id_5")1008 E_6_0 = builder.get_object("User_Id_6")1009 E_7_0 = builder.get_object("User_Id_7")1010 E_8_0 = builder.get_object("User_Id_8")1011 E_9_0 = builder.get_object("User_Id_9")1012 1013 E_0_1 = builder.get_object("User_Name_0")1014 E_1_1 = builder.get_object("User_Name_1")1015 E_2_1 = builder.get_object("User_Name_2")1016 E_3_1 = builder.get_object("User_Name_3")1017 E_4_1 = builder.get_object("User_Name_4")1018 E_5_1 = builder.get_object("User_Name_5")1019 E_6_1 = builder.get_object("User_Name_6")1020 E_7_1 = builder.get_object("User_Name_7")1021 E_8_1 = builder.get_object("User_Name_8")1022 E_9_1 = builder.get_object("User_Name_9")1023 1024 E_0_2 = builder.get_object("User_Surename_0")1025 E_1_2 = builder.get_object("User_Surename_1")1026 E_2_2 = builder.get_object("User_Surename_2")1027 E_3_2 = builder.get_object("User_Surename_3")1028 E_4_2 = builder.get_object("User_Surename_4")1029 E_5_2 = builder.get_object("User_Surename_5")1030 E_6_2 = builder.get_object("User_Surename_6")1031 E_7_2 = builder.get_object("User_Surename_7")1032 E_8_2 = builder.get_object("User_Surename_8")1033 E_9_2 = builder.get_object("User_Surename_9")1034 1035 E_0_3 = builder.get_object("User_Class_0")1036 E_1_3 = builder.get_object("User_Class_1")1037 E_2_3 = builder.get_object("User_Class_2")1038 E_3_3 = builder.get_object("User_Class_3")1039 E_4_3 = builder.get_object("User_Class_4")1040 E_5_3 = builder.get_object("User_Class_5")1041 E_6_3 = builder.get_object("User_Class_6")1042 E_7_3 = builder.get_object("User_Class_7")1043 E_8_3 = builder.get_object("User_Class_8")1044 E_9_3 = builder.get_object("User_Class_9")1045 1046 1047 global s_zahl_11048 connection = sqlite3.connect(db)1049 cursor= connection.cursor()1050 sql = "SELECT * FROM Users"1051 cursor.execute(sql)1052 1053 text=""1054 column_x=[]1055 row_x=[]1056 1057 i=01058 for row in cursor:1059 1060 r0=str(row[0])1061 r1=str(row[1])1062 r2=str(row[2])1063 r3=str(row[3])1064 1065 1066 column_x = [(r0, r1, r2, r3)]1067 row_x.extend(column_x)1068 1069 1070 connection.commit()1071 connection.close()1072 print("len(column_x)", len(column_x))1073 print("len(row_x)", len(row_x))1074 x=len(row_x)1075 #Reihe 01076 i=01077 E_0_0.set_text("") 1078 k=0+(s_zahl_1-1)*101079 x=""1080 try:1081 x=str(row_x[k][i])1082 E_0_0.set_text(x)1083 except:1084 E_0_0.set_text("")1085 i=11086 E_0_1.set_text("") 1087 k=0+(s_zahl_1-1)*101088 x=""1089 try:1090 x=str(row_x[k][i])1091 print("x ",x)1092 E_0_1.set_text(x)1093 except:1094 E_0_1.set_text("")1095 1096 i=21097 E_0_2.set_text("") 1098 k=0+(s_zahl_1-1)*101099 x=""1100 try:1101 x=str(row_x[k][i])1102 E_0_2.set_text(x)1103 except:1104 E_0_2.set_text("")1105 1106 i=31107 E_0_3.set_text("") 1108 k=0+(s_zahl_1-1)*101109 x=""1110 try:1111 x=str(row_x[k][i])1112 E_0_3.set_text(x)1113 except:1114 E_0_3.set_text("")1115 #Reihe11116 i=01117 E_1_0.set_text("") 1118 k=1+(s_zahl_1-1)*101119 x=""1120 try:1121 x=str(row_x[k][i])1122 E_1_0.set_text(x)1123 except:1124 E_1_0.set_text("")1125 i=11126 E_1_1.set_text("") 1127 k=1+(s_zahl_1-1)*101128 x=""1129 try:1130 x=str(row_x[k][i])1131 print("x ",x)1132 E_1_1.set_text(x)1133 except:1134 E_1_1.set_text("")1135 1136 i=21137 E_1_2.set_text("") 1138 k=1+(s_zahl_1-1)*101139 x=""1140 try:1141 x=str(row_x[k][i])1142 E_1_2.set_text(x)1143 except:1144 E_1_2.set_text("")1145 1146 i=31147 E_1_3.set_text("") 1148 k=1+(s_zahl_1-1)*101149 x=""1150 try:1151 x=str(row_x[k][i])1152 E_1_3.set_text(x)1153 except:1154 E_1_3.set_text("")1155 #Reihe21156 i=01157 E_2_0.set_text("") 1158 k=2+(s_zahl_1-1)*101159 x=""1160 try:1161 x=str(row_x[k][i])1162 E_2_0.set_text(x)1163 except:1164 E_2_0.set_text("")1165 i=11166 E_2_1.set_text("") 1167 k=2+(s_zahl_1-1)*101168 x=""1169 try:1170 x=str(row_x[k][i])1171 print("x ",x)1172 E_2_1.set_text(x)1173 except:1174 E_2_1.set_text("")1175 1176 i=21177 E_2_2.set_text("") 1178 k=2+(s_zahl_1-1)*101179 x=""1180 try:1181 x=str(row_x[k][i])1182 E_2_2.set_text(x)1183 except:1184 E_2_2.set_text("")1185 1186 i=31187 E_2_3.set_text("") 1188 k=2+(s_zahl_1-1)*101189 x=""1190 try:1191 x=str(row_x[k][i])1192 E_2_3.set_text(x)1193 except:1194 E_2_3.set_text("")1195 #Reihe31196 i=01197 E_3_0.set_text("") 1198 k=3+(s_zahl_1-1)*101199 x=""1200 try:1201 x=str(row_x[k][i])1202 E_3_0.set_text(x)1203 except:1204 E_3_0.set_text("")1205 i=11206 E_3_1.set_text("") 1207 k=3+(s_zahl_1-1)*101208 x=""1209 try:1210 x=str(row_x[k][i])1211 print("x ",x)1212 E_3_1.set_text(x)1213 except:1214 E_3_1.set_text("")1215 1216 i=21217 E_3_2.set_text("") 1218 k=3+(s_zahl_1-1)*101219 x=""1220 try:1221 x=str(row_x[k][i])1222 E_3_2.set_text(x)1223 except:1224 E_3_2.set_text("")1225 1226 i=31227 E_3_3.set_text("") 1228 k=3+(s_zahl_1-1)*101229 x=""1230 try:1231 x=str(row_x[k][i])1232 E_3_3.set_text(x)1233 except:1234 E_3_3.set_text("")1235 1236 #Reihe41237 i=01238 E_4_0.set_text("") 1239 k=4+(s_zahl_1-1)*101240 x=""1241 try:1242 x=str(row_x[k][i])1243 E_4_0.set_text(x)1244 except:1245 E_4_0.set_text("")1246 i=11247 E_4_1.set_text("") 1248 k=4+(s_zahl_1-1)*101249 x=""1250 try:1251 x=str(row_x[k][i])1252 print("x ",x)1253 E_4_1.set_text(x)1254 except:1255 E_4_1.set_text("")1256 1257 i=21258 E_4_2.set_text("") 1259 k=4+(s_zahl_1-1)*101260 x=""1261 try:1262 x=str(row_x[k][i])1263 E_4_2.set_text(x)1264 except:1265 E_4_2.set_text("")1266 1267 i=31268 E_4_3.set_text("") 1269 k=4+(s_zahl_1-1)*101270 x=""1271 try:1272 x=str(row_x[k][i])1273 E_4_3.set_text(x)1274 except:1275 E_4_3.set_text("")1276 1277 #Reihe51278 i=01279 E_5_0.set_text("") 1280 k=5+(s_zahl_1-1)*101281 x=""1282 try:1283 x=str(row_x[k][i])1284 E_5_0.set_text(x)1285 except:1286 E_5_0.set_text("")1287 i=11288 E_5_1.set_text("") 1289 k=5+(s_zahl_1-1)*101290 x=""1291 try:1292 x=str(row_x[k][i])1293 print("x ",x)1294 E_5_1.set_text(x)1295 except:1296 E_5_1.set_text("")1297 1298 i=21299 E_5_2.set_text("") 1300 k=5+(s_zahl_1-1)*101301 x=""1302 try:1303 x=str(row_x[k][i])1304 E_5_2.set_text(x)1305 except:1306 E_5_2.set_text("")1307 1308 i=31309 E_5_3.set_text("") 1310 k=5+(s_zahl_1-1)*101311 x=""1312 try:1313 x=str(row_x[k][i])1314 E_5_3.set_text(x)1315 except:1316 E_5_3.set_text("")1317 #Reihe61318 i=01319 E_6_0.set_text("") 1320 k=6+(s_zahl_1-1)*101321 x=""1322 try:1323 x=str(row_x[k][i])1324 E_6_0.set_text(x)1325 except:1326 E_6_0.set_text("")1327 1328 i=11329 E_6_1.set_text("") 1330 k=6+(s_zahl_1-1)*101331 x=""1332 try:1333 x=str(row_x[k][i])1334 print("x ",x)1335 E_6_1.set_text(x)1336 except:1337 E_6_1.set_text("")1338 1339 i=21340 E_6_2.set_text("") 1341 k=6+(s_zahl_1-1)*101342 x=""1343 try:1344 x=str(row_x[k][i])1345 E_6_2.set_text(x)1346 except:1347 E_6_2.set_text("")1348 1349 i=31350 E_6_3.set_text("") 1351 k=6+(s_zahl_1-1)*101352 x=""1353 try:1354 x=str(row_x[k][i])1355 E_6_3.set_text(x)1356 except:1357 E_6_3.set_text("")1358 #Reihe71359 i=01360 E_7_0.set_text("") 1361 k=7+(s_zahl_1-1)*101362 x=""1363 try:1364 x=str(row_x[k][i])1365 E_7_0.set_text(x)1366 except:1367 E_7_0.set_text("")1368 i=11369 E_7_1.set_text("") 1370 k=7+(s_zahl_1-1)*101371 x=""1372 try:1373 x=str(row_x[k][i])1374 print("x ",x)1375 E_7_1.set_text(x)1376 except:1377 E_7_1.set_text("")1378 1379 i=21380 E_7_2.set_text("") 1381 k=7+(s_zahl_1-1)*101382 x=""1383 try:1384 x=str(row_x[k][i])1385 E_7_2.set_text(x)1386 except:1387 E_7_2.set_text("")1388 1389 i=31390 E_7_3.set_text("") 1391 k=7+(s_zahl_1-1)*101392 x=""1393 try:1394 x=str(row_x[k][i])1395 E_7_3.set_text(x)1396 except:1397 E_7_3.set_text("")1398 #Reihe81399 i=01400 E_8_0.set_text("") 1401 k=8+(s_zahl_1-1)*101402 x=""1403 try:1404 x=str(row_x[k][i])1405 E_8_0.set_text(x)1406 except:1407 E_8_0.set_text("")1408 i=11409 E_8_1.set_text("") 1410 k=8+(s_zahl_1-1)*101411 x=""1412 try:1413 x=str(row_x[k][i])1414 print("x ",x)1415 E_8_1.set_text(x)1416 except:1417 E_8_1.set_text("")1418 1419 i=21420 E_8_2.set_text("") 1421 k=8+(s_zahl_1-1)*101422 x=""1423 try:1424 x=str(row_x[k][i])1425 E_8_2.set_text(x)1426 except:1427 E_8_2.set_text("")1428 1429 i=31430 E_8_3.set_text("") 1431 k=8+(s_zahl_1-1)*101432 x=""1433 try:1434 x=str(row_x[k][i])1435 E_8_3.set_text(x)1436 except:1437 E_8_3.set_text("")1438 #Reihe91439 i=01440 E_9_0.set_text("") 1441 k=9+(s_zahl_1-1)*101442 x=""1443 try:1444 x=str(row_x[k][i])1445 E_9_0.set_text(x)1446 except:1447 E_9_0.set_text("")1448 i=11449 E_9_1.set_text("") 1450 k=9+(s_zahl_1-1)*101451 x=""1452 try:1453 x=str(row_x[k][i])1454 print("x ",x)1455 E_9_1.set_text(x)1456 except:1457 E_9_1.set_text("")1458 1459 i=21460 E_9_2.set_text("") 1461 k=9+(s_zahl_1-1)*101462 x=""1463 try:1464 x=str(row_x[k][i])1465 E_9_2.set_text(x)1466 except:1467 E_9_2.set_text("")1468 1469 i=31470 E_9_3.set_text("") 1471 k=9+(s_zahl_1-1)*101472 x=""1473 try:1474 x=str(row_x[k][i])1475 E_9_3.set_text(x)1476 except:1477 E_9_3.set_text("")1478 def updateGets(self):1479 #Gets1480 E_0_0 = builder.get_object("Get_Id_0")1481 E_1_0 = builder.get_object("Get_Id_1")1482 E_2_0 = builder.get_object("Get_Id_2")1483 E_3_0 = builder.get_object("Get_Id_3")1484 E_4_0 = builder.get_object("Get_Id_4")1485 E_5_0 = builder.get_object("Get_Id_5")1486 E_6_0 = builder.get_object("Get_Id_6")1487 E_7_0 = builder.get_object("Get_Id_7")1488 E_8_0 = builder.get_object("Get_Id_8")1489 E_9_0 = builder.get_object("Get_Id_9")1490 1491 E_0_1 = builder.get_object("Get_NSC_0")1492 E_1_1 = builder.get_object("Get_NSC_1")1493 E_2_1 = builder.get_object("Get_NSC_2")1494 E_3_1 = builder.get_object("Get_NSC_3")1495 E_4_1 = builder.get_object("Get_NSC_4")1496 E_5_1 = builder.get_object("Get_NSC_5")1497 E_6_1 = builder.get_object("Get_NSC_6")1498 E_7_1 = builder.get_object("Get_NSC_7")1499 E_8_1 = builder.get_object("Get_NSC_8")1500 E_9_1 = builder.get_object("Get_NSC_9")1501 1502 E_0_2 = builder.get_object("Get_UserId_0")1503 E_1_2 = builder.get_object("Get_UserId_1")1504 E_2_2 = builder.get_object("Get_UserId_2")1505 E_3_2 = builder.get_object("Get_UserId_3")1506 E_4_2 = builder.get_object("Get_UserId_4")1507 E_5_2 = builder.get_object("Get_UserId_5")1508 E_6_2 = builder.get_object("Get_UserId_6")1509 E_7_2 = builder.get_object("Get_UserId_7")1510 E_8_2 = builder.get_object("Get_UserId_8")1511 E_9_2 = builder.get_object("Get_UserId_9")1512 1513 E_0_3 = builder.get_object("Get_DevId_0")1514 E_1_3 = builder.get_object("Get_DevId_1")1515 E_2_3 = builder.get_object("Get_DevId_2")1516 E_3_3 = builder.get_object("Get_DevId_3")1517 E_4_3 = builder.get_object("Get_DevId_4")1518 E_5_3 = builder.get_object("Get_DevId_5")1519 E_6_3 = builder.get_object("Get_DevId_6")1520 E_7_3 = builder.get_object("Get_DevId_7")1521 E_8_3 = builder.get_object("Get_DevId_8")1522 E_9_3 = builder.get_object("Get_DevId_9")1523 1524 E_0_4 = builder.get_object("Get_Date_0")1525 E_1_4 = builder.get_object("Get_Date_1")1526 E_2_4 = builder.get_object("Get_Date_2")1527 E_3_4 = builder.get_object("Get_Date_3")1528 E_4_4 = builder.get_object("Get_Date_4")1529 E_5_4 = builder.get_object("Get_Date_5")1530 E_6_4 = builder.get_object("Get_Date_6")1531 E_7_4 = builder.get_object("Get_Date_7")1532 E_8_4 = builder.get_object("Get_Date_8")1533 E_9_4 = builder.get_object("Get_Date_9")1534 1535 1536 1537 global s_zahl_21538 connection = sqlite3.connect(db)1539 cursor= connection.cursor()1540 sql = "SELECT * FROM Gets"1541 cursor.execute(sql)1542 1543 text=""1544 column_x=[]1545 row_x=[]1546 1547 i=01548 for row in cursor:1549 1550 r0=str(row[0])1551 r1=str(row[1])1552 r2=str(row[2])1553 r3=str(row[3])1554 r4=str(row[4])1555 1556 1557 column_x = [(r0, r1, r2, r3, r4)]1558 row_x.extend(column_x)1559 1560 1561 connection.commit()1562 connection.close()1563 print("len(column_x)", len(column_x))1564 print("len(row_x)", len(row_x))1565 x=len(row_x)1566 #Reihe 01567 i=01568 E_0_0.set_text("") 1569 k=0+(s_zahl_2-1)*101570 x=""1571 try:1572 x=str(row_x[k][i])1573 E_0_0.set_text(x)1574 except:1575 E_0_0.set_text("")1576 i=11577 E_0_1.set_text("") 1578 k=0+(s_zahl_2-1)*101579 x=""1580 try:1581 x=str(row_x[k][i])1582 print("x ",x)1583 E_0_1.set_text(x)1584 except:1585 E_0_1.set_text("")1586 1587 i=21588 E_0_2.set_text("") 1589 k=0+(s_zahl_2-1)*101590 x=""1591 try:1592 x=str(row_x[k][i])1593 E_0_2.set_text(x)1594 except:1595 E_0_2.set_text("")1596 1597 i=31598 E_0_3.set_text("") 1599 k=0+(s_zahl_2-1)*101600 x=""1601 try:1602 x=str(row_x[k][i])1603 E_0_3.set_text(x)1604 except:1605 E_0_3.set_text("")1606 i=41607 E_0_4.set_text("") 1608 k=0+(s_zahl_2-1)*101609 x=""1610 try:1611 x=str(row_x[k][i])1612 E_0_4.set_text(x)1613 except:1614 E_0_4.set_text("")1615 #Reihe11616 i=01617 E_1_0.set_text("") 1618 k=1+(s_zahl_2-1)*101619 x=""1620 try:1621 x=str(row_x[k][i])1622 E_1_0.set_text(x)1623 except:1624 E_1_0.set_text("")1625 i=11626 E_1_1.set_text("") 1627 k=1+(s_zahl_2-1)*101628 x=""1629 try:1630 x=str(row_x[k][i])1631 print("x ",x)1632 E_1_1.set_text(x)1633 except:1634 E_1_1.set_text("")1635 1636 i=21637 E_1_2.set_text("") 1638 k=1+(s_zahl_2-1)*101639 x=""1640 try:1641 x=str(row_x[k][i])1642 E_1_2.set_text(x)1643 except:1644 E_1_2.set_text("")1645 1646 i=31647 E_1_3.set_text("") 1648 k=1+(s_zahl_2-1)*101649 x=""1650 try:1651 x=str(row_x[k][i])1652 E_1_3.set_text(x)1653 except:1654 E_1_3.set_text("")1655 i=41656 E_1_4.set_text("") 1657 k=1+(s_zahl_2-1)*101658 x=""1659 try:1660 x=str(row_x[k][i])1661 E_1_4.set_text(x)1662 except:1663 E_1_4.set_text("")1664 1665 #Reihe21666 i=01667 E_2_0.set_text("") 1668 k=2+(s_zahl_2-1)*101669 x=""1670 try:1671 x=str(row_x[k][i])1672 E_2_0.set_text(x)1673 except:1674 E_2_0.set_text("")1675 i=11676 E_2_1.set_text("") 1677 k=2+(s_zahl_2-1)*101678 x=""1679 try:1680 x=str(row_x[k][i])1681 print("x ",x)1682 E_2_1.set_text(x)1683 except:1684 E_2_1.set_text("")1685 1686 i=21687 E_2_2.set_text("") 1688 k=2+(s_zahl_2-1)*101689 x=""1690 try:1691 x=str(row_x[k][i])1692 E_2_2.set_text(x)1693 except:1694 E_2_2.set_text("")1695 1696 i=31697 E_2_3.set_text("") 1698 k=2+(s_zahl_2-1)*101699 x=""1700 try:1701 x=str(row_x[k][i])1702 E_2_3.set_text(x)1703 except:1704 E_2_3.set_text("")1705 i=41706 E_2_4.set_text("") 1707 k=2+(s_zahl_2-1)*101708 x=""1709 try:1710 x=str(row_x[k][i])1711 E_2_4.set_text(x)1712 except:1713 E_2_4.set_text("")1714 1715 #Reihe31716 i=01717 E_3_0.set_text("") 1718 k=3+(s_zahl_2-1)*101719 x=""1720 try:1721 x=str(row_x[k][i])1722 E_3_0.set_text(x)1723 except:1724 E_3_0.set_text("")1725 i=11726 E_3_1.set_text("") 1727 k=3+(s_zahl_2-1)*101728 x=""1729 try:1730 x=str(row_x[k][i])1731 print("x ",x)1732 E_3_1.set_text(x)1733 except:1734 E_3_1.set_text("")1735 1736 i=21737 E_3_2.set_text("") 1738 k=3+(s_zahl_2-1)*101739 x=""1740 try:1741 x=str(row_x[k][i])1742 E_3_2.set_text(x)1743 except:1744 E_3_2.set_text("")1745 1746 i=31747 E_3_3.set_text("") 1748 k=3+(s_zahl_2-1)*101749 x=""1750 try:1751 x=str(row_x[k][i])1752 E_3_3.set_text(x)1753 except:1754 E_3_3.set_text("")1755 i=41756 E_3_4.set_text("") 1757 k=3+(s_zahl_2-1)*101758 x=""1759 try:1760 x=str(row_x[k][i])1761 E_3_4.set_text(x)1762 except:1763 E_3_4.set_text("")1764 #Reihe41765 i=01766 E_4_0.set_text("") 1767 k=4+(s_zahl_2-1)*101768 x=""1769 try:1770 x=str(row_x[k][i])1771 E_4_0.set_text(x)1772 except:1773 E_4_0.set_text("")1774 i=11775 E_4_1.set_text("") 1776 k=4+(s_zahl_2-1)*101777 x=""1778 try:1779 x=str(row_x[k][i])1780 print("x ",x)1781 E_4_1.set_text(x)1782 except:1783 E_4_1.set_text("")1784 1785 i=21786 E_4_2.set_text("") 1787 k=4+(s_zahl_2-1)*101788 x=""1789 try:1790 x=str(row_x[k][i])1791 E_4_2.set_text(x)1792 except:1793 E_4_2.set_text("")1794 1795 i=31796 E_4_3.set_text("") 1797 k=4+(s_zahl_2-1)*101798 x=""1799 try:1800 x=str(row_x[k][i])1801 E_4_3.set_text(x)1802 except:1803 E_4_3.set_text("")1804 i=41805 E_4_4.set_text("") 1806 k=4+(s_zahl_2-1)*101807 x=""1808 try:1809 x=str(row_x[k][i])1810 E_4_4.set_text(x)1811 except:1812 E_4_4.set_text("")1813 1814 #Reihe51815 i=01816 E_5_0.set_text("") 1817 k=5+(s_zahl_2-1)*101818 x=""1819 try:1820 x=str(row_x[k][i])1821 E_5_0.set_text(x)1822 except:1823 E_5_0.set_text("")1824 i=11825 E_5_1.set_text("") 1826 k=5+(s_zahl_2-1)*101827 x=""1828 try:1829 x=str(row_x[k][i])1830 print("x ",x)1831 E_5_1.set_text(x)1832 except:1833 E_5_1.set_text("")1834 1835 i=21836 E_5_2.set_text("") 1837 k=5+(s_zahl_2-1)*101838 x=""1839 try:1840 x=str(row_x[k][i])1841 E_5_2.set_text(x)1842 except:1843 E_5_2.set_text("")1844 1845 i=31846 E_5_3.set_text("") 1847 k=5+(s_zahl_2-1)*101848 x=""1849 try:1850 x=str(row_x[k][i])1851 E_5_3.set_text(x)1852 except:1853 E_5_3.set_text("")1854 i=41855 E_5_4.set_text("") 1856 k=5+(s_zahl_2-1)*101857 x=""1858 try:1859 x=str(row_x[k][i])1860 E_5_4.set_text(x)1861 except:1862 E_5_4.set_text("")1863 1864 #Reihe61865 i=01866 E_6_0.set_text("") 1867 k=6+(s_zahl_2-1)*101868 x=""1869 try:1870 x=str(row_x[k][i])1871 E_6_0.set_text(x)1872 except:1873 E_6_0.set_text("")1874 1875 i=11876 E_6_1.set_text("") 1877 k=6+(s_zahl_2-1)*101878 x=""1879 try:1880 x=str(row_x[k][i])1881 print("x ",x)1882 E_6_1.set_text(x)1883 except:1884 E_6_1.set_text("")1885 1886 i=21887 E_6_2.set_text("") 1888 k=6+(s_zahl_2-1)*101889 x=""1890 try:1891 x=str(row_x[k][i])1892 E_6_2.set_text(x)1893 except:1894 E_6_2.set_text("")1895 1896 i=31897 E_6_3.set_text("") 1898 k=6+(s_zahl_2-1)*101899 x=""1900 try:1901 x=str(row_x[k][i])1902 E_6_3.set_text(x)1903 except:1904 E_6_3.set_text("")1905 i=41906 E_6_4.set_text("") 1907 k=6+(s_zahl_2-1)*101908 x=""1909 try:1910 x=str(row_x[k][i])1911 E_6_4.set_text(x)1912 except:1913 E_6_4.set_text("")1914 1915 #Reihe71916 i=01917 E_7_0.set_text("") 1918 k=7+(s_zahl_2-1)*101919 x=""1920 try:1921 x=str(row_x[k][i])1922 E_7_0.set_text(x)1923 except:1924 E_7_0.set_text("")1925 i=11926 E_7_1.set_text("") 1927 k=7+(s_zahl_2-1)*101928 x=""1929 try:1930 x=str(row_x[k][i])1931 print("x ",x)1932 E_7_1.set_text(x)1933 except:1934 E_7_1.set_text("")1935 1936 i=21937 E_7_2.set_text("") 1938 k=7+(s_zahl_2-1)*101939 x=""1940 try:1941 x=str(row_x[k][i])1942 E_7_2.set_text(x)1943 except:1944 E_7_2.set_text("")1945 1946 i=31947 E_7_3.set_text("") 1948 k=7+(s_zahl_2-1)*101949 x=""1950 try:1951 x=str(row_x[k][i])1952 E_7_3.set_text(x)1953 except:1954 E_7_3.set_text("")1955 i=41956 E_7_4.set_text("") 1957 k=7+(s_zahl_2-1)*101958 x=""1959 try:1960 x=str(row_x[k][i])1961 E_7_4.set_text(x)1962 except:1963 E_7_4.set_text("")1964 1965 #Reihe81966 i=01967 E_8_0.set_text("") 1968 k=8+(s_zahl_2-1)*101969 x=""1970 try:1971 x=str(row_x[k][i])1972 E_8_0.set_text(x)1973 except:1974 E_8_0.set_text("")1975 i=11976 E_8_1.set_text("") 1977 k=8+(s_zahl_2-1)*101978 x=""1979 try:1980 x=str(row_x[k][i])1981 print("x ",x)1982 E_8_1.set_text(x)1983 except:1984 E_8_1.set_text("")1985 1986 i=21987 E_8_2.set_text("") 1988 k=8+(s_zahl_2-1)*101989 x=""1990 try:1991 x=str(row_x[k][i])1992 E_8_2.set_text(x)1993 except:1994 E_8_2.set_text("")1995 1996 i=31997 E_8_3.set_text("") 1998 k=8+(s_zahl_2-1)*101999 x=""2000 try:2001 x=str(row_x[k][i])2002 E_8_3.set_text(x)2003 except:2004 E_8_3.set_text("")2005 i=42006 E_8_4.set_text("") 2007 k=8+(s_zahl_2-1)*102008 x=""2009 try:2010 x=str(row_x[k][i])2011 E_8_4.set_text(x)2012 except:2013 E_8_4.set_text("")2014 2015 #Reihe92016 i=02017 E_9_0.set_text("") 2018 k=9+(s_zahl_2-1)*102019 x=""2020 try:2021 x=str(row_x[k][i])2022 E_9_0.set_text(x)2023 except:2024 E_9_0.set_text("")2025 i=12026 E_9_1.set_text("") 2027 k=9+(s_zahl_2-1)*102028 x=""2029 try:2030 x=str(row_x[k][i])2031 print("x ",x)2032 E_9_1.set_text(x)2033 except:2034 E_9_1.set_text("")2035 2036 i=22037 E_9_2.set_text("") 2038 k=9+(s_zahl_2-1)*102039 x=""2040 try:2041 x=str(row_x[k][i])2042 E_9_2.set_text(x)2043 except:2044 E_9_2.set_text("")2045 2046 i=32047 E_9_3.set_text("") 2048 k=9+(s_zahl_2-1)*102049 x=""2050 try:2051 x=str(row_x[k][i])2052 E_9_3.set_text(x)2053 except:2054 E_9_3.set_text("")2055 i=42056 E_9_4.set_text("") 2057 k=9+(s_zahl_2-1)*102058 x=""2059 try:2060 x=str(row_x[k][i])2061 E_9_4.set_text(x)2062 except:2063 E_9_4.set_text("")2064def main():2065 Handler.updateDev(Handler)2066 Handler.updateUser(Handler)2067 Handler.updateGets(Handler)2068 builder.connect_signals(Handler())2069 window.show_all()2070 Gtk.main()2071 2072if __name__ == "__main__":...

change_matrix.py

Source:change_matrix.py

...32 0,0,0,1]33 '''34 35 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nNo colors inverting, nothing change.\nThe image should appear like it was.")36 instance.button_matrix_red_red_label.set_text("1")37 instance.button_matrix_red_red_button.set_data("value","1")38 39 instance.button_matrix_red_green_label.set_text("0")40 instance.button_matrix_red_green_button.set_data("value","0")41 42 instance.button_matrix_red_blue_label.set_text("0")43 instance.button_matrix_red_blue_button.set_data("value","0")44 45 46 instance.button_matrix_green_red_label.set_text("0")47 instance.button_matrix_green_red_button.set_data("value","0")48 49 instance.button_matrix_green_green_label.set_text("1")50 instance.button_matrix_green_green_button.set_data("value","1")51 52 instance.button_matrix_green_blue_label.set_text("0")53 instance.button_matrix_green_blue_button.set_data("value","0")54 55 instance.button_matrix_blue_red_label.set_text("0")56 instance.button_matrix_blue_red_button.set_data("value","0")57 58 instance.button_matrix_blue_green_label.set_text("0")59 instance.button_matrix_blue_green_button.set_data("value","0")60 61 instance.button_matrix_blue_blue_label.set_text("1")62 instance.button_matrix_blue_blue_button.set_data("value","1") 63 64 def matrix01(self,instance) :65 ''' Suppress red and let the grenn and blue values unchanged. 66 The image should appear without his red tone.67 matrix = [0,0,0,0,68 0,1,0,0,69 0,0,1,0,70 0,0,0,1]71 '''72 73 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress red and let the green and blue values unchanged.\nThe image should appear without his red tone.")74 instance.button_matrix_red_red_label.set_text("0")75 instance.button_matrix_red_red_button.set_data("value","0")76 77 instance.button_matrix_red_green_label.set_text("0")78 instance.button_matrix_red_green_button.set_data("value","0")79 80 instance.button_matrix_red_blue_label.set_text("0")81 instance.button_matrix_red_blue_button.set_data("value","0")82 83 84 instance.button_matrix_green_red_label.set_text("0")85 instance.button_matrix_green_red_button.set_data("value","0")86 87 instance.button_matrix_green_green_label.set_text("1")88 instance.button_matrix_green_green_button.set_data("value","1")89 90 instance.button_matrix_green_blue_label.set_text("0")91 instance.button_matrix_green_blue_button.set_data("value","0")92 93 94 instance.button_matrix_blue_red_label.set_text("0")95 instance.button_matrix_blue_red_button.set_data("value","0")96 97 instance.button_matrix_blue_green_label.set_text("0")98 instance.button_matrix_blue_green_button.set_data("value","0")99 100 instance.button_matrix_blue_blue_label.set_text("1")101 instance.button_matrix_blue_blue_button.set_data("value","1")102 103 def matrix02(self,instance) :104 ''' Suppress green and let the red and blue values unchanged. 105 The image should appear without his green tone.106 matrix = [1,0,0,0,107 0,0,0,0,108 0,0,1,0,109 0,0,0,1]110 '''111 112 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress green tone and let the red and blue values unchanged.\nThe image should appear without his green tone.")113 instance.button_matrix_red_red_label.set_text("1")114 instance.button_matrix_red_red_button.set_data("value","1")115 116 instance.button_matrix_red_green_label.set_text("0")117 instance.button_matrix_red_green_button.set_data("value","0")118 119 instance.button_matrix_red_blue_label.set_text("0")120 instance.button_matrix_red_blue_button.set_data("value","0")121 122 123 instance.button_matrix_green_red_label.set_text("0")124 instance.button_matrix_green_red_button.set_data("value","0")125 126 instance.button_matrix_green_green_label.set_text("0")127 instance.button_matrix_green_green_button.set_data("value","0")128 129 instance.button_matrix_green_blue_label.set_text("0")130 instance.button_matrix_green_blue_button.set_data("value","0")131 132 instance.button_matrix_blue_red_label.set_text("0")133 instance.button_matrix_blue_red_button.set_data("value","0")134 135 instance.button_matrix_blue_green_label.set_text("0")136 instance.button_matrix_blue_green_button.set_data("value","0")137 138 instance.button_matrix_blue_blue_label.set_text("1")139 instance.button_matrix_blue_blue_button.set_data("value","1") 140 141 def matrix03(self,instance) :142 ''' Suppress blue and let the red and green values unchanged. 143 The image should appear without his blue tone.144 matrix = [1,0,0,0,145 0,1,0,0,146 0,0,0,0,147 0,0,0,1]148 '''149 150 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress blue tone and let the red and green values unchanged.\nThe image should appear without his blue tone.")151 instance.button_matrix_red_red_label.set_text("1")152 instance.button_matrix_red_red_button.set_data("value","1")153 154 instance.button_matrix_red_green_label.set_text("0")155 instance.button_matrix_red_green_button.set_data("value","0")156 157 instance.button_matrix_red_blue_label.set_text("0")158 instance.button_matrix_red_blue_button.set_data("value","0")159 160 161 instance.button_matrix_green_red_label.set_text("0")162 instance.button_matrix_green_red_button.set_data("value","0")163 164 instance.button_matrix_green_green_label.set_text("1")165 instance.button_matrix_green_green_button.set_data("value","1")166 167 instance.button_matrix_green_blue_label.set_text("0")168 instance.button_matrix_green_blue_button.set_data("value","0")169 170 171 instance.button_matrix_blue_red_label.set_text("0")172 instance.button_matrix_blue_red_button.set_data("value","0")173 174 instance.button_matrix_blue_green_label.set_text("0")175 instance.button_matrix_blue_green_button.set_data("value","0")176 177 instance.button_matrix_blue_blue_label.set_text("0")178 instance.button_matrix_blue_blue_button.set_data("value","0") 179 180 def matrix04(self,instance) :181 ''' Suppress green and blue and let the red value unchanged.182 The image should appear red tones and black.183 matrix = [1,0,0,0,184 0,0,0,0,185 0,0,0,0,186 0,0,0,1]187 '''188 189 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress the green and blue tone and let red value unchanged.\nThe image should appear red tones and black.")190 instance.button_matrix_red_red_label.set_text("1")191 instance.button_matrix_red_red_button.set_data("value","1")192 193 instance.button_matrix_red_green_label.set_text("0")194 instance.button_matrix_red_green_button.set_data("value","0")195 196 instance.button_matrix_red_blue_label.set_text("0")197 instance.button_matrix_red_blue_button.set_data("value","0")198 199 200 instance.button_matrix_green_red_label.set_text("0")201 instance.button_matrix_green_red_button.set_data("value","0")202 203 instance.button_matrix_green_green_label.set_text("0")204 instance.button_matrix_green_green_button.set_data("value","0")205 206 instance.button_matrix_green_blue_label.set_text("0")207 instance.button_matrix_green_blue_button.set_data("value","0")208 209 210 instance.button_matrix_blue_red_label.set_text("0")211 instance.button_matrix_blue_red_button.set_data("value","0")212 213 instance.button_matrix_blue_green_label.set_text("0")214 instance.button_matrix_blue_green_button.set_data("value","0")215 216 instance.button_matrix_blue_blue_label.set_text("0")217 instance.button_matrix_blue_blue_button.set_data("value","0") 218 219 def matrix05(self,instance) :220 ''' Suppress red and blue and let the green value unchanged.221 The image should appear in green tones and black.222 matrix = [0,0,0,0,223 0,1,0,0,224 0,0,0,0,225 0,0,0,1]226 '''227 228 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress the red tone and the blue tone and let green value unchanged.\nThe image should appear in green tones and black.")229 instance.button_matrix_red_red_label.set_text("0")230 instance.button_matrix_red_red_button.set_data("value","0")231 232 instance.button_matrix_red_green_label.set_text("0")233 instance.button_matrix_red_green_button.set_data("value","0")234 235 instance.button_matrix_red_blue_label.set_text("0")236 instance.button_matrix_red_blue_button.set_data("value","0")237 238 239 instance.button_matrix_green_red_label.set_text("0")240 instance.button_matrix_green_red_button.set_data("value","0")241 242 instance.button_matrix_green_green_label.set_text("1")243 instance.button_matrix_green_green_button.set_data("value","1")244 245 instance.button_matrix_green_blue_label.set_text("0")246 instance.button_matrix_green_blue_button.set_data("value","0")247 248 249 instance.button_matrix_blue_red_label.set_text("0")250 instance.button_matrix_blue_red_button.set_data("value","0")251 252 instance.button_matrix_blue_green_label.set_text("0")253 instance.button_matrix_blue_green_button.set_data("value","0")254 255 instance.button_matrix_blue_blue_label.set_text("0")256 instance.button_matrix_blue_blue_button.set_data("value","0") 257 258 def matrix06(self,instance) :259 ''' Suppress red and green and let the blue value unchanged.260 The image should appear in blue tones and black.261 matrix = [0,0,0,0,262 0,0,0,0,263 0,0,1,0,264 0,0,0,1]265 '''266 267 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress the red tone and the green tone and let blue value unchanged.\nThe image should appear in blue tones and black.")268 instance.button_matrix_red_red_label.set_text("0")269 instance.button_matrix_red_red_button.set_data("value","0")270 271 instance.button_matrix_red_green_label.set_text("0")272 instance.button_matrix_red_green_button.set_data("value","0")273 274 instance.button_matrix_red_blue_label.set_text("0")275 instance.button_matrix_red_blue_button.set_data("value","0")276 277 278 instance.button_matrix_green_red_label.set_text("0")279 instance.button_matrix_green_red_button.set_data("value","0")280 281 instance.button_matrix_green_green_label.set_text("0")282 instance.button_matrix_green_green_button.set_data("value","0")283 284 instance.button_matrix_green_blue_label.set_text("0")285 instance.button_matrix_green_blue_button.set_data("value","0")286 287 288 instance.button_matrix_blue_red_label.set_text("0")289 instance.button_matrix_blue_red_button.set_data("value","0")290 291 instance.button_matrix_blue_green_label.set_text("0")292 instance.button_matrix_blue_green_button.set_data("value","0")293 294 instance.button_matrix_blue_blue_label.set_text("1")295 instance.button_matrix_blue_blue_button.set_data("value","1") 296 297 def matrix07(self,instance) :298 ''' Suppress red and green and blue.299 The image should appear in black.300 matrix = [0,0,0,0,301 0,0,0,0,302 0,0,0,0,303 0,0,0,1]304 '''305 306 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nsupress the red tone and the green tone and the blue tone.\nThe image should appear in black.")307 instance.button_matrix_red_red_label.set_text("0")308 instance.button_matrix_red_red_button.set_data("value","0")309 310 instance.button_matrix_red_green_label.set_text("0")311 instance.button_matrix_red_green_button.set_data("value","0")312 313 instance.button_matrix_red_blue_label.set_text("0")314 instance.button_matrix_red_blue_button.set_data("value","0")315 316 317 instance.button_matrix_green_red_label.set_text("0")318 instance.button_matrix_green_red_button.set_data("value","0")319 320 instance.button_matrix_green_green_label.set_text("0")321 instance.button_matrix_green_green_button.set_data("value","0")322 323 instance.button_matrix_green_blue_label.set_text("0")324 instance.button_matrix_green_blue_button.set_data("value","0")325 326 327 instance.button_matrix_blue_red_label.set_text("0")328 instance.button_matrix_blue_red_button.set_data("value","0")329 330 instance.button_matrix_blue_green_label.set_text("0")331 instance.button_matrix_blue_green_button.set_data("value","0")332 333 instance.button_matrix_blue_blue_label.set_text("0")334 instance.button_matrix_blue_blue_button.set_data("value","0")335 336 def matrix08(self,instance) :337 ''' Set all tones (red,green,blue) on the red value from every pixel.338 The image should appear in grayscale based on the red pixel value.339 matrix = [1,0,0,0,340 1,0,0,0,341 1,0,0,0,342 0,0,0,1]343 '''344 345 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nSet all tones (red,green,blue) on the red value from every pixel.\nThe image should appear in grayscale based on the red pixel value.")346 instance.button_matrix_red_red_label.set_text("1")347 instance.button_matrix_red_red_button.set_data("value","1")348 349 instance.button_matrix_red_green_label.set_text("0")350 instance.button_matrix_red_green_button.set_data("value","0")351 352 instance.button_matrix_red_blue_label.set_text("0")353 instance.button_matrix_red_blue_button.set_data("value","0")354 355 356 instance.button_matrix_green_red_label.set_text("1")357 instance.button_matrix_green_red_button.set_data("value","1")358 359 instance.button_matrix_green_green_label.set_text("0")360 instance.button_matrix_green_green_button.set_data("value","0")361 362 instance.button_matrix_green_blue_label.set_text("0")363 instance.button_matrix_green_blue_button.set_data("value","0")364 365 instance.button_matrix_blue_red_label.set_text("1")366 instance.button_matrix_blue_red_button.set_data("value","1")367 368 instance.button_matrix_blue_green_label.set_text("0")369 instance.button_matrix_blue_green_button.set_data("value","0")370 371 instance.button_matrix_blue_blue_label.set_text("0")372 instance.button_matrix_blue_blue_button.set_data("value","0") 373 374 def matrix09(self,instance) :375 ''' Set all tones (red,green,blue) on the green value from every pixel.376 The image should appear in grayscale based on the green pixel value.377 matrix = [0,1,0,0,378 0,1,0,0,379 0,1,0,0,380 0,0,0,1]381 '''382 383 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nSet all tones (red,green,blue) on the green value from every pixel.\nThe image should appear in grayscale based on the green pixel value.")384 instance.button_matrix_red_red_label.set_text("0")385 instance.button_matrix_red_red_button.set_data("value","0")386 387 instance.button_matrix_red_green_label.set_text("1")388 instance.button_matrix_red_green_button.set_data("value","1")389 390 instance.button_matrix_red_blue_label.set_text("0")391 instance.button_matrix_red_blue_button.set_data("value","0")392 393 394 instance.button_matrix_green_red_label.set_text("0")395 instance.button_matrix_green_red_button.set_data("value","0")396 397 instance.button_matrix_green_green_label.set_text("1")398 instance.button_matrix_green_green_button.set_data("value","1")399 400 instance.button_matrix_green_blue_label.set_text("0")401 instance.button_matrix_green_blue_button.set_data("value","0")402 403 instance.button_matrix_blue_red_label.set_text("0")404 instance.button_matrix_blue_red_button.set_data("value","0")405 406 instance.button_matrix_blue_green_label.set_text("1")407 instance.button_matrix_blue_green_button.set_data("value","1")408 409 instance.button_matrix_blue_blue_label.set_text("0")410 instance.button_matrix_blue_blue_button.set_data("value","0") 411 412 def matrix10(self,instance) :413 ''' Set all tones (red,green,blue) on the blue value from every pixel.414 The image should appear in grayscale based on the blue pixel value.415 matrix = [0,0,1,0,416 0,0,1,0,417 0,0,1,0,418 0,0,0,1]419 '''420 421 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nSet all tones (red,green,blue) on the blue value from every pixel.\nThe image should appear in grayscale based on the blue pixel value.")422 instance.button_matrix_red_red_label.set_text("0")423 instance.button_matrix_red_red_button.set_data("value","0")424 425 instance.button_matrix_red_green_label.set_text("0")426 instance.button_matrix_red_green_button.set_data("value","0")427 428 instance.button_matrix_red_blue_label.set_text("1")429 instance.button_matrix_red_blue_button.set_data("value","1")430 431 432 instance.button_matrix_green_red_label.set_text("0")433 instance.button_matrix_green_red_button.set_data("value","0")434 435 instance.button_matrix_green_green_label.set_text("0")436 instance.button_matrix_green_green_button.set_data("value","0")437 438 instance.button_matrix_green_blue_label.set_text("1")439 instance.button_matrix_green_blue_button.set_data("value","1")440 441 instance.button_matrix_blue_red_label.set_text("0")442 instance.button_matrix_blue_red_button.set_data("value","0")443 444 instance.button_matrix_blue_green_label.set_text("0")445 instance.button_matrix_blue_green_button.set_data("value","0")446 447 instance.button_matrix_blue_blue_label.set_text("1")448 instance.button_matrix_blue_blue_button.set_data("value","1") 449 450 def matrix11(self,instance) :451 ''' Invert red and blue values and let the green value unchanged.452 The image should appear red-blue tones inversed.453 matrix = [0,0,1,0,454 0,1,0,0,455 1,0,0,0,456 0,0,0,1]457 '''458 459 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and blue values and let the green value unchanged.\nThe image should appear red-blue tones inversed.")460 instance.button_matrix_red_red_label.set_text("0")461 instance.button_matrix_red_red_button.set_data("value","0")462 463 instance.button_matrix_red_green_label.set_text("0")464 instance.button_matrix_red_green_button.set_data("value","0")465 466 instance.button_matrix_red_blue_label.set_text("1")467 instance.button_matrix_red_blue_button.set_data("value","1")468 469 470 instance.button_matrix_green_red_label.set_text("0")471 instance.button_matrix_green_red_button.set_data("value","0")472 473 instance.button_matrix_green_green_label.set_text("1")474 instance.button_matrix_green_green_button.set_data("value","1")475 476 instance.button_matrix_green_blue_label.set_text("0")477 instance.button_matrix_green_blue_button.set_data("value","0")478 479 instance.button_matrix_blue_red_label.set_text("1")480 instance.button_matrix_blue_red_button.set_data("value","1")481 482 instance.button_matrix_blue_green_label.set_text("0")483 instance.button_matrix_blue_green_button.set_data("value","0")484 485 instance.button_matrix_blue_blue_label.set_text("0")486 instance.button_matrix_blue_blue_button.set_data("value","0") 487 488 def matrix12(self,instance) :489 ''' Invert red and blue values and remove the green tones.490 The image should appear red-blue tones inversed without green tones.491 matrix = [0,0,1,0,492 0,0,0,0,493 1,0,0,0,494 0,0,0,1]495 '''496 497 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and blue values and remove the green tones.\nThe image should appear red-blue tones inversed without green tones.")498 instance.button_matrix_red_red_label.set_text("0")499 instance.button_matrix_red_red_button.set_data("value","0")500 501 instance.button_matrix_red_green_label.set_text("0")502 instance.button_matrix_red_green_button.set_data("value","0")503 504 instance.button_matrix_red_blue_label.set_text("1")505 instance.button_matrix_red_blue_button.set_data("value","1")506 507 508 instance.button_matrix_green_red_label.set_text("0")509 instance.button_matrix_green_red_button.set_data("value","0")510 511 instance.button_matrix_green_green_label.set_text("0")512 instance.button_matrix_green_green_button.set_data("value","0")513 514 instance.button_matrix_green_blue_label.set_text("0")515 instance.button_matrix_green_blue_button.set_data("value","0")516 517 instance.button_matrix_blue_red_label.set_text("1")518 instance.button_matrix_blue_red_button.set_data("value","1")519 520 instance.button_matrix_blue_green_label.set_text("0")521 instance.button_matrix_blue_green_button.set_data("value","0")522 523 instance.button_matrix_blue_blue_label.set_text("0")524 instance.button_matrix_blue_blue_button.set_data("value","0") 525 526 def matrix13(self,instance) :527 ''' Invert red and blue values and set green on blue value to form an yellow tone.528 The image should appear yellow toned with red-blue color inversion.529 matrix = [0,0,1,0,530 0,0,1,0,531 1,0,0,0,532 0,0,0,1]533 '''534 535 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and blue values and set green on blue value to form an yellow tone.\nThe image should appear yellow toned with red-blue color inversion.")536 instance.button_matrix_red_red_label.set_text("0")537 instance.button_matrix_red_red_button.set_data("value","0")538 539 instance.button_matrix_red_green_label.set_text("0")540 instance.button_matrix_red_green_button.set_data("value","0")541 542 instance.button_matrix_red_blue_label.set_text("1")543 instance.button_matrix_red_blue_button.set_data("value","1")544 545 546 instance.button_matrix_green_red_label.set_text("0")547 instance.button_matrix_green_red_button.set_data("value","0")548 549 instance.button_matrix_green_green_label.set_text("0")550 instance.button_matrix_green_green_button.set_data("value","0")551 552 instance.button_matrix_green_blue_label.set_text("1")553 instance.button_matrix_green_blue_button.set_data("value","1")554 555 instance.button_matrix_blue_red_label.set_text("1")556 instance.button_matrix_blue_red_button.set_data("value","1")557 558 instance.button_matrix_blue_green_label.set_text("0")559 instance.button_matrix_blue_green_button.set_data("value","0")560 561 instance.button_matrix_blue_blue_label.set_text("0")562 instance.button_matrix_blue_blue_button.set_data("value","0") 563 564 def matrix14(self,instance) :565 ''' Invert red and blue values and set green on red value to form an turkish tone.566 The image should appear turkish toned with red-blue color inversion.567 matrix = [0,0,1,0,568 1,0,0,0,569 1,0,0,0,570 0,0,0,1]571 '''572 573 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and blue values and set green on red value to form an turkish tone.\nThe image should appear turkish toned with red-blue color inversion.")574 instance.button_matrix_red_red_label.set_text("0")575 instance.button_matrix_red_red_button.set_data("value","0")576 577 instance.button_matrix_red_green_label.set_text("0")578 instance.button_matrix_red_green_button.set_data("value","0")579 580 instance.button_matrix_red_blue_label.set_text("1")581 instance.button_matrix_red_blue_button.set_data("value","1")582 583 584 instance.button_matrix_green_red_label.set_text("1")585 instance.button_matrix_green_red_button.set_data("value","1")586 587 instance.button_matrix_green_green_label.set_text("0")588 instance.button_matrix_green_green_button.set_data("value","0")589 590 instance.button_matrix_green_blue_label.set_text("0")591 instance.button_matrix_green_blue_button.set_data("value","0")592 593 instance.button_matrix_blue_red_label.set_text("1")594 instance.button_matrix_blue_red_button.set_data("value","1")595 596 instance.button_matrix_blue_green_label.set_text("0")597 instance.button_matrix_blue_green_button.set_data("value","0")598 599 instance.button_matrix_blue_blue_label.set_text("0")600 instance.button_matrix_blue_blue_button.set_data("value","0") 601 602 def matrix15(self,instance) :603 ''' Invert red and blue values (red take the blue values) and remove green and blue tones.604 The image should appear red toned and black.605 matrix = [0,0,1,0,606 0,0,0,0,607 0,0,0,0,608 0,0,0,1]609 '''610 611 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and blue values (red take the blue values) and remove green and blue tones.\nThe image should appear red toned and black.")612 instance.button_matrix_red_red_label.set_text("0")613 instance.button_matrix_red_red_button.set_data("value","0")614 615 instance.button_matrix_red_green_label.set_text("0")616 instance.button_matrix_red_green_button.set_data("value","0")617 618 instance.button_matrix_red_blue_label.set_text("1")619 instance.button_matrix_red_blue_button.set_data("value","1")620 621 622 instance.button_matrix_green_red_label.set_text("1")623 instance.button_matrix_green_red_button.set_data("value","1")624 625 instance.button_matrix_green_green_label.set_text("0")626 instance.button_matrix_green_green_button.set_data("value","0")627 628 instance.button_matrix_green_blue_label.set_text("0")629 instance.button_matrix_green_blue_button.set_data("value","0")630 631 instance.button_matrix_blue_red_label.set_text("0")632 instance.button_matrix_blue_red_button.set_data("value","0")633 634 instance.button_matrix_blue_green_label.set_text("0")635 instance.button_matrix_blue_green_button.set_data("value","0")636 637 instance.button_matrix_blue_blue_label.set_text("0")638 instance.button_matrix_blue_blue_button.set_data("value","0") 639 640 def matrix16(self,instance) :641 ''' Invert red and blue values (blue take the red values) and remove green and red tones.642 The image should appear blue toned and black.643 matrix = [0,0,0,0,644 0,0,0,0,645 1,0,0,0,646 0,0,0,1]647 '''648 649 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and blue values (blue take the red values) and remove green and red tones.\nThe image should appear blue toned and black.")650 instance.button_matrix_red_red_label.set_text("0")651 instance.button_matrix_red_red_button.set_data("value","0")652 653 instance.button_matrix_red_green_label.set_text("0")654 instance.button_matrix_red_green_button.set_data("value","0")655 656 instance.button_matrix_red_blue_label.set_text("0")657 instance.button_matrix_red_blue_button.set_data("value","0")658 659 660 instance.button_matrix_green_red_label.set_text("0")661 instance.button_matrix_green_red_button.set_data("value","0")662 663 instance.button_matrix_green_green_label.set_text("0")664 instance.button_matrix_green_green_button.set_data("value","0")665 666 instance.button_matrix_green_blue_label.set_text("0")667 instance.button_matrix_green_blue_button.set_data("value","0")668 669 instance.button_matrix_blue_red_label.set_text("1")670 instance.button_matrix_blue_red_button.set_data("value","1")671 672 instance.button_matrix_blue_green_label.set_text("0")673 instance.button_matrix_blue_green_button.set_data("value","0")674 675 instance.button_matrix_blue_blue_label.set_text("0")676 instance.button_matrix_blue_blue_button.set_data("value","0") 677 678 def matrix17(self,instance) :679 ''' Invert red and green values and remove the blue tone.680 The image should appear red-green toned inversed without blue tones.681 matrix = [0,1,0,0,682 1,0,0,0,683 0,0,0,0,684 0,0,0,1]685 '''686 687 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and green values and remove the blue tone.\nThe image should appear red-green toned inversed without blue tones.")688 instance.button_matrix_red_red_label.set_text("0")689 instance.button_matrix_red_red_button.set_data("value","0")690 691 instance.button_matrix_red_green_label.set_text("1")692 instance.button_matrix_red_green_button.set_data("value","1")693 694 instance.button_matrix_red_blue_label.set_text("0")695 instance.button_matrix_red_blue_button.set_data("value","0")696 697 698 instance.button_matrix_green_red_label.set_text("1")699 instance.button_matrix_green_red_button.set_data("value","1")700 701 instance.button_matrix_green_green_label.set_text("0")702 instance.button_matrix_green_green_button.set_data("value","0")703 704 instance.button_matrix_green_blue_label.set_text("0")705 instance.button_matrix_green_blue_button.set_data("value","0")706 707 instance.button_matrix_blue_red_label.set_text("0")708 instance.button_matrix_blue_red_button.set_data("value","0")709 710 instance.button_matrix_blue_green_label.set_text("0")711 instance.button_matrix_blue_green_button.set_data("value","0")712 713 instance.button_matrix_blue_blue_label.set_text("0")714 instance.button_matrix_blue_blue_button.set_data("value","0") 715 716 def matrix18(self,instance) :717 ''' Invert red and green-blue values to form an turkish tone.718 The image should appear red-(green-blue) toned inversed with an turkish tone.719 matrix = [0,1,0,0,720 1,0,0,0,721 1,0,0,0,722 0,0,0,1]723 '''724 725 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and green-blue values to form an turkish tone.\nThe image should appear red-(green-blue) toned inversed with an turkish tone.")726 instance.button_matrix_red_red_label.set_text("0")727 instance.button_matrix_red_red_button.set_data("value","0")728 729 instance.button_matrix_red_green_label.set_text("1")730 instance.button_matrix_red_green_button.set_data("value","1")731 732 instance.button_matrix_red_blue_label.set_text("0")733 instance.button_matrix_red_blue_button.set_data("value","0")734 735 736 instance.button_matrix_green_red_label.set_text("1")737 instance.button_matrix_green_red_button.set_data("value","1")738 739 instance.button_matrix_green_green_label.set_text("0")740 instance.button_matrix_green_green_button.set_data("value","0")741 742 instance.button_matrix_green_blue_label.set_text("0")743 instance.button_matrix_green_blue_button.set_data("value","0")744 745 instance.button_matrix_blue_red_label.set_text("1")746 instance.button_matrix_blue_red_button.set_data("value","1")747 748 instance.button_matrix_blue_green_label.set_text("0")749 instance.button_matrix_blue_green_button.set_data("value","0")750 751 instance.button_matrix_blue_blue_label.set_text("0")752 instance.button_matrix_blue_blue_button.set_data("value","0") 753 754 def matrix19(self,instance) :755 ''' Invert red and green values and set blue on the green pixel value to form an pink tone.756 The image should appear red-green inversed with an pink tone.757 matrix = [0,1,0,0,758 1,0,0,0,759 0,1,0,0,760 0,0,0,1]761 '''762 763 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and green values and set blue on the green pixel value to form an pink tone.\nThe image should appear red-green inversed with an pink tone.")764 instance.button_matrix_red_red_label.set_text("0")765 instance.button_matrix_red_red_button.set_data("value","0")766 767 instance.button_matrix_red_green_label.set_text("1")768 instance.button_matrix_red_green_button.set_data("value","1")769 770 instance.button_matrix_red_blue_label.set_text("0")771 instance.button_matrix_red_blue_button.set_data("value","0")772 773 774 instance.button_matrix_green_red_label.set_text("1")775 instance.button_matrix_green_red_button.set_data("value","1")776 777 instance.button_matrix_green_green_label.set_text("0")778 instance.button_matrix_green_green_button.set_data("value","0")779 780 instance.button_matrix_green_blue_label.set_text("0")781 instance.button_matrix_green_blue_button.set_data("value","0")782 783 instance.button_matrix_blue_red_label.set_text("0")784 instance.button_matrix_blue_red_button.set_data("value","0")785 786 instance.button_matrix_blue_green_label.set_text("1")787 instance.button_matrix_blue_green_button.set_data("value","1")788 789 instance.button_matrix_blue_blue_label.set_text("0")790 instance.button_matrix_blue_blue_button.set_data("value","0") 791 792 def matrix20(self,instance) :793 ''' Invert red and green values and let the blue value unchanged.794 The image should appear red-green inversed without blue tone change.795 matrix = [0,1,0,0,796 1,0,0,0,797 0,0,1,0,798 0,0,0,1]799 '''800 801 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert red and green values and let the blue value unchanged.\nThe image should appear red-green inversed without blue tone change.")802 instance.button_matrix_red_red_label.set_text("0")803 instance.button_matrix_red_red_button.set_data("value","0")804 805 instance.button_matrix_red_green_label.set_text("1")806 instance.button_matrix_red_green_button.set_data("value","1")807 808 instance.button_matrix_red_blue_label.set_text("0")809 instance.button_matrix_red_blue_button.set_data("value","0")810 811 812 instance.button_matrix_green_red_label.set_text("1")813 instance.button_matrix_green_red_button.set_data("value","1")814 815 instance.button_matrix_green_green_label.set_text("0")816 instance.button_matrix_green_green_button.set_data("value","0")817 818 instance.button_matrix_green_blue_label.set_text("0")819 instance.button_matrix_green_blue_button.set_data("value","0")820 821 instance.button_matrix_blue_red_label.set_text("0")822 instance.button_matrix_blue_red_button.set_data("value","0")823 824 instance.button_matrix_blue_green_label.set_text("0")825 instance.button_matrix_blue_green_button.set_data("value","0")826 827 instance.button_matrix_blue_blue_label.set_text("1")828 instance.button_matrix_blue_blue_button.set_data("value","1") 829 830 def matrix21(self,instance) :831 ''' Invert green and blue values and remove the red tone.832 The image should appear green-blue inversed without red tone.833 matrix = [0,0,0,0,834 0,0,1,0,835 0,1,0,0,836 0,0,0,1]837 '''838 839 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert green and blue values and remove the red tone.\nThe image should appear green-blue inversed without red tone.")840 instance.button_matrix_red_red_label.set_text("0")841 instance.button_matrix_red_red_button.set_data("value","0")842 843 instance.button_matrix_red_green_label.set_text("0")844 instance.button_matrix_red_green_button.set_data("value","0")845 846 instance.button_matrix_red_blue_label.set_text("0")847 instance.button_matrix_red_blue_button.set_data("value","0")848 849 850 instance.button_matrix_green_red_label.set_text("0")851 instance.button_matrix_green_red_button.set_data("value","0")852 853 instance.button_matrix_green_green_label.set_text("0")854 instance.button_matrix_green_green_button.set_data("value","0")855 856 instance.button_matrix_green_blue_label.set_text("1")857 instance.button_matrix_green_blue_button.set_data("value","1")858 859 instance.button_matrix_blue_red_label.set_text("0")860 instance.button_matrix_blue_red_button.set_data("value","0")861 862 instance.button_matrix_blue_green_label.set_text("1")863 instance.button_matrix_blue_green_button.set_data("value","1")864 865 instance.button_matrix_blue_blue_label.set_text("0")866 instance.button_matrix_blue_blue_button.set_data("value","0") 867 868 def matrix22(self,instance) :869 ''' Invert green and blue values and let the red tone unchanged.870 The image should appear green-blue inversed without red tone changing.871 matrix = [1,0,0,0,872 0,0,1,0,873 0,1,0,0,874 0,0,0,1]875 '''876 877 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert green and blue values and let the red tone unchanged.\nThe image should appear green-blue inversed without red tone changing.")878 instance.button_matrix_red_red_label.set_text("1")879 instance.button_matrix_red_red_button.set_data("value","1")880 881 instance.button_matrix_red_green_label.set_text("0")882 instance.button_matrix_red_green_button.set_data("value","0")883 884 instance.button_matrix_red_blue_label.set_text("0")885 instance.button_matrix_red_blue_button.set_data("value","0")886 887 888 instance.button_matrix_green_red_label.set_text("0")889 instance.button_matrix_green_red_button.set_data("value","0")890 891 instance.button_matrix_green_green_label.set_text("0")892 instance.button_matrix_green_green_button.set_data("value","0")893 894 instance.button_matrix_green_blue_label.set_text("1")895 instance.button_matrix_green_blue_button.set_data("value","1")896 897 instance.button_matrix_blue_red_label.set_text("0")898 instance.button_matrix_blue_red_button.set_data("value","0")899 900 instance.button_matrix_blue_green_label.set_text("1")901 instance.button_matrix_blue_green_button.set_data("value","1")902 903 instance.button_matrix_blue_blue_label.set_text("0")904 instance.button_matrix_blue_blue_button.set_data("value","0") 905 906 def matrix23(self,instance) :907 ''' Invert green and blue values and set the red tone on green value to form an pink tone.908 The image should appear green-blue inversed with an pink tone.909 matrix = [0,1,0,0,910 0,0,1,0,911 0,1,0,0,912 0,0,0,1]913 '''914 915 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert green and blue values and set the red tone on green value to form an pink tone.\nThe image should appear green-blue inversed with an pink tone.")916 instance.button_matrix_red_red_label.set_text("0")917 instance.button_matrix_red_red_button.set_data("value","0")918 919 instance.button_matrix_red_green_label.set_text("1")920 instance.button_matrix_red_green_button.set_data("value","1")921 922 instance.button_matrix_red_blue_label.set_text("0")923 instance.button_matrix_red_blue_button.set_data("value","0")924 925 926 instance.button_matrix_green_red_label.set_text("0")927 instance.button_matrix_green_red_button.set_data("value","0")928 929 instance.button_matrix_green_green_label.set_text("0")930 instance.button_matrix_green_green_button.set_data("value","0")931 932 instance.button_matrix_green_blue_label.set_text("1")933 instance.button_matrix_green_blue_button.set_data("value","1")934 935 instance.button_matrix_blue_red_label.set_text("0")936 instance.button_matrix_blue_red_button.set_data("value","0")937 938 instance.button_matrix_blue_green_label.set_text("1")939 instance.button_matrix_blue_green_button.set_data("value","1")940 941 instance.button_matrix_blue_blue_label.set_text("0")942 instance.button_matrix_blue_blue_button.set_data("value","0") 943 944 def matrix24(self,instance) :945 ''' Invert green and blue values and set the red tone on blue value to form an yellow tone.946 The image should appear green-blue inversed with an yellow tone.947 matrix = [0,0,1,0,948 0,0,1,0,949 0,1,0,0,950 0,0,0,1]951 '''952 953 instance.frame_matrix_filters.set_tooltip_text("Predefine matrix:\nInvert green and blue values and set the red tone on blue value to form an yellow tone.\nThe image should appear green-blue inversed with an yellow tone.")954 instance.button_matrix_red_red_label.set_text("0")955 instance.button_matrix_red_red_button.set_data("value","0")956 957 instance.button_matrix_red_green_label.set_text("0")958 instance.button_matrix_red_green_button.set_data("value","0")959 960 instance.button_matrix_red_blue_label.set_text("1")961 instance.button_matrix_red_blue_button.set_data("value","1")962 963 964 instance.button_matrix_green_red_label.set_text("0")965 instance.button_matrix_green_red_button.set_data("value","0")966 967 instance.button_matrix_green_green_label.set_text("0")968 instance.button_matrix_green_green_button.set_data("value","0")969 970 instance.button_matrix_green_blue_label.set_text("1")971 instance.button_matrix_green_blue_button.set_data("value","1")972 973 instance.button_matrix_blue_red_label.set_text("0")974 instance.button_matrix_blue_red_button.set_data("value","0")975 976 instance.button_matrix_blue_green_label.set_text("1")977 instance.button_matrix_blue_green_button.set_data("value","1")978 979 instance.button_matrix_blue_blue_label.set_text("0")980 instance.button_matrix_blue_blue_button.set_data("value","0") 981 982 983 ...

Show more

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.

LambdaTest Learning Hubs:

• JUnit Tutorial
• TestNG Tutorial
• Webdriver Tutorial
• WebDriverIO Tutorial
• Protractor Tutorial
• Selenium 4 Tutorial
• Jenkins Tutorial
• NUnit Tutorial
• Jest Tutorial
• Playwright Tutorial
• Cypress Tutorial
• PyTest Tutorial

YouTube

You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.

Run uiautomator automation tests on LambdaTest cloud grid

Perform automation testing on 3000+ real desktop and mobile devices online.

View sample repo View DocumentationSign up Free

›

_