Thursday, March 5, 2020

MM32 microcontroller specification in tkinter in python


from tkinter import *
import pymysql

def create_table():
    #uart,i2c,spi,adc,eeprom,pack,dac,,usb,can,sdio,comp,aes,trng
    mycursor.execute("CREATE TABLE MM32 (id INT AUTO_INCREMENT PRIMARY KEY, PartNo VARCHAR(255),ARMVer VARCHAR(255), MaxSpeed VARCHAR(255),Flash VARCHAR(255),RAM VARCHAR(255),GPIO VARCHAR(255),AdvTimer VARCHAR(255),GPTM VARCHAR(255),WDG VARCHAR(255),RTC VARCHAR(255),UART VARCHAR(255),I2C VARCHAR(255),SPI VARCHAR(255),ADC VARCHAR(255),EEPROM VARCHAR(255),PACK VARCHAR(255),DAC VARCHAR(255),USB VARCHAR(255),CAN VARCHAR(255),SDIO VARCHAR(255),COMP VARCHAR(255),AES VARCHAR(255),TRNG VARCHAR(255) )")
    print("Table created")

def View_table():
    mycursor.execute("SELECT * FROM MM32")
    row = mycursor.fetchone() 
    while row is not None:
        print(row)
        row = mycursor.fetchone()

conn=pymysql.connect(host="localhost",user="root",password="",db="my_python")
mycursor=conn.cursor()


#main code start here
print("\n1.create a table")
print("\n2.insert into table")
print("\n3.View  table")
x=int(input("enter your choice:::"))
if x==1:
    create_table()
elif x==3:
    View_table()
 
elif x==2:
    sql = "INSERT INTO MM32 (PartNo, ARMVer, MaxSpeed,Flash,RAM,GPIO,AdvTimer,GPTM,WDG,RTC,UART,I2C,SPI,ADC,EEPROM,PACK,DAC,USB,CAN,SDIO,COMP,AES,TRNG) VALUES (%s, %s ,%s,%s, %s ,%s,%s,%s, %s ,%s,%s, %s ,%s,%s,%s,%s,%s,%s, %s ,%s,%s, %s ,%s)"
    PartNo=input("enter mm32 part")
    ARMVer=input("enter your arm_version")
    MaxSpeed=input("enter your MaxSpeed")
    Flash=input("enter your Flash")
    RAM=input("enter your RAM")
    GPIO=input("enter your GPIO")
    AdvTimer=input("enter your AdvTimer")
    GPTM=input("enter your GPTM")
    WDG=input("enter your WDG")
    RTC=input("enter your RTC")
    UART=input("enter your UART")
    I2C=input("enter your I2C")
    SPI=input("enter your SPI")
    ADC=input("enter your ADC")
    EEPROM=input("enter your EEPROM")
    PACK=input("enter your PACK")
    DAC=input("enter your DAC")
    USB=input("enter your USB")
    CAN=input("enter your CAN")
    SDIO=input("enter your SDIO")#COMP,AES,TRNG
    COMP=input("enter your COMP")
    AES=input("enter your AES")
    TRNG=input("enter your TRNG")
    val = (PartNo, ARMVer,MaxSpeed,Flash,RAM,GPIO,AdvTimer,GPTM,WDG,RTC,UART,I2C,SPI,ADC,EEPROM,PACK,DAC,USB,CAN,SDIO,COMP,AES,TRNG)
    mycursor.execute(sql, val)
    print(mycursor.rowcount, "record inserted.")
#mycursor.execute(sql, val1)
else :
    print("please enter above options only")

conn.commit()

output:

1.create a table

2.insert into table

3.View  table

enter your choice:::3
(1, 'MM32F003TW', 'CORTEX-M0', '48Mhz', '16Kbytes', '2Kbytes', '16', '1', '5', '2', '-', '1', '1', '1', '8x12-bit', '-', 'TSSOP20', '-', '-', '-', '-', '-', '-', '-')
(2, 'MM32F003NW', 'CORTEX-M0', '48MHZ', '16kbytes', '2kbytes', '16', '1', '5', '2', '-', '1', '1', '1', '8x12-bit ', '-', 'QFN20', '-', '-', '-', '-', '-', '-', '-')

No comments:

Post a Comment

python class topic video