echo "CREATE TABLE info(id INTEGER , name VARCHAR(50), about VARCHAR(100));" > service.sql && sed -r "s/([a-zA-Z0-9]+)[^0-9]+([0-9]+)\/[a-z]+[^#]*#?[^a-zA-Z]*(.*)/INSERT IGNORE INTO info VALUES(\2, '\1', '\3');/" service.txt >> service.sql && sqlite3 -init service.sql service.db

#!/usr/bin/python
from pysqlite2 import dbapi2 as sqlite
data = open("/home/oxyg3n/Desktop/service.txt")
lines = data.readlines()
for line in lines :
  [COLOR=Red]  dbconnect = sqlite.connect("/home/oxyg3n/port.sqlite")[/COLOR]
    cursor = dbconnect.cursor()
    line = line.split()
    port = line[1].split("/")
    sql = 'INSERT IGNORE INTO info VALUES("%s","%s","%s")'%(line[0], line[1][0],line[1][1:])
    cursor.execute(sql)
    dbconnect.commit()
    print "Done"
cursor.close()

CREATE TABLE info(name VARCHAR(50),id INTEGER [COLOR=Red]PRIMARY KEY[/COLOR],about VARCHAR(100))

#!/usr/bin/python
import sqlite3
import os.path
data = open("service.txt")
lines = data.readlines()
dbfile='port.sqlite'
if os.path.exists(dbfile): os.remove(dbfile)
conn=sqlite3.connect(dbfile)
conn.execute("CREATE TABLE info(name VARCHAR(50),id INTEGER,about VARCHAR(100));")
for line in lines :
    line = line.split()
    sql = 'INSERT IGNORE INTO info VALUES("%s","%s","%s")'%(line[0], line[1][0],line[1][1:])
    conn.execute(sql)
conn.commit()
conn.close()
print "Done"