IronPython WPF program closing after SQLite DB is created

NameUnknown · 11-18-2019, 01:59 PM

I am creating an IronPython WPF application in Visual Studio 2019 that also integrates an SQLite database. The issue I am having is that the GUI closes immediately with a return code of 1 after it executes the python script that creates the SQLite database. The script includes some test data that should load into the DB but that doesn't happen either. If I remove the call to the file, it will run without issue but its just a GUI at that point.

Below is the code for the WPF load and GUI interaction. Don't mind the silliness, some of it was done at 2am and I was a bit slap happy and tired. As you can see, in my current iteration it uses execfile to run the other python script to create the DB and load it. You can also see where I imported it to try calling it and the SQLClass too but that also did not work properly.

Spoiler!

This is the code for the SQLite DB creation and test data load.

Spoiler!

Code:

import sqlite3

class SQLclass:     

    conn = sqlite3.connect('C:\ProgramData\GNS3.db')
    c = conn.cursor()

    # Create tables
    c.execute('''create table routers(ID integer primary key, interface text, type text, clockrate text, encapsulation text, ip text, gateway text, protocol text)''')
    c.execute('''create table networks(ID integer primary key, networks text)''')
    c.execute('''create table switches(ID integer primary key, interface text, type text, switchport text,duplex text, speed text)''')
    c.execute('''create table asas(ID integer primary key, interface text, type text, zone text,security text, ip text, gateway text)''')
    c.execute('''create table devices(ID integer primary key, Name text, Type text, model text, config text)''')
    c.execute('''create table vlans(ID integer primary key, number integer, name text, state text, intlist text)''') #show vlan-switch brief
    c.execute('''create table computers(ID integer, type text, ip text)''')
    
    # Load test data
    c.execute('''insert into devices('1','CNC-Edge','Router','c3725', 'So much text that its hard to believe.  So much text that its hard to believe.  
    So much text that its hard to believe.  So much text that its hard to believe.  So much text that its hard to believe.  
    So much text that its hard to believe.  So much text that its hard to believe.  So much text that its hard to believe.  
    So much text that its hard to believe.  So much text that its hard to believe.  So much text that its hard to believe.  
    So much text that its hard to believe.  So much text that its hard to believe.  So much text that its hard to believe.  
    So much text that its hard to believe.  So much text that its hard to believe.  So much text that its hard to believe.')''')
    c.execute("""insert into routers('1','fa0/1','fast ethernet','N/A','N/A','192.168.2.2','255.255.255.252','OSPF',')""")
    c.execute("""insert into computers('1', 'Server', '10.2.34.65')""")
    c.execute("""insert into computers('2', 'PC', '10.109.4.65')""")
    c.execute("""insert into computers('3', 'Server', '10.54.34.65')""")

    # Save changes
    conn.commit()
    
    # Close cursor
    c.close()

This is the output field in Visual Studio after running the application and having it immediately close

Spoiler!

NameUnknown · 11-20-2019, 08:13 AM

Bumping for renewed attention...Really need some assistance with this issue.

NameUnknown · 11-21-2019, 08:27 AM

I think I may be on to something with this. If I run the file that creates the SQLite DB from the console without the app being involved, I get a syntax error at the end of the first line of the insert command. I am going to change this to work with a tuple and see if that helps.

also....bump

NameUnknown · 11-21-2019, 12:26 PM

Using Tuples was the solution. I was able to implement them in a console version of the file without issue and then importing that version in my application allows it to create the file and load the test data without issue. Consider this portion of the application resolved....However I keep running into roadblocks everywhere I turn so I am sure I will be back with more problems and thus likely keep updating with issues here.

For instance, when I query the database I can print to a console but not save to a variable??

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Show Printable Version Email this Page Email this Page

Posting Rules
You may post new threads You may post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

vBulletin Message

Cancel Changes

Premium Vendor Showcase

IronPython WPF program closing after SQLite DB is created

Ever Evolving

CPU

Motherboard

GPU

GPU

RAM

Hard Drive

Hard Drive

Hard Drive

Optical Drive

Power Supply

Cooling

Cooling

Cooling

Case

Operating System

Monitor

Keyboard

Mouse

Ever Evolving

CPU

Motherboard

GPU

GPU

RAM

Hard Drive

Hard Drive

Hard Drive

Optical Drive

Power Supply

Cooling

Cooling

Cooling

Case

Operating System

Monitor

Keyboard

Mouse

Ever Evolving

CPU

Motherboard

GPU

GPU

RAM

Hard Drive

Hard Drive

Hard Drive

Optical Drive

Power Supply

Cooling

Cooling

Cooling

Case

Operating System

Monitor

Keyboard

Mouse

Ever Evolving

CPU

Motherboard

GPU

GPU

RAM

Hard Drive

Hard Drive

Hard Drive

Optical Drive

Power Supply

Cooling

Cooling

Cooling

Case

Operating System

Monitor

Keyboard

Mouse

Register Now

Log-in