#!/usr/bin/python
# -*- coding: utf8 -*-
#======================================================================
#Basisverzeichnis der Library-Dateien hier einstellen.
#Es MUSS als Unterverzeichnis im Pfad des Server-Verzeichnisses liegen.
Librarybase = u'/home/strubi/pcb/kicad/lib' # Am Ende muss ein '/' stehen.
#======================================================================
import os
import zipfile
import cgi
import sqlite3
import sys
sys.path.append("/home/strubi/doc/develop/components")
import partdb
f = cgi.FieldStorage()
cmd = f.getfirst('cmd', None)
showimg = f.getfirst('showimg', False)
if showimg: showimg = True
db = sqlite3.connect('KiCad.sqlite3')
c = db.cursor()
c.execute('CREATE TABLE IF NOT EXISTS symbols (filename TEXT, datetime TEXT, symbol TEXT)')
print """Content-type: text/html
KiCad Library-Verwaltung
KiCad Library-Verwaltung
"""
print "Server-Basisverzeichnis: %s
Library-Basisverzeichnis: %s
" % (os.getcwd(), Librarybase)
print 'Befehle:'
print 'Dateien anzeigen (mit Bildern)'
print "
"
print ' - Library-Dateien nach Symbolnamen abscannen'
print "
"
print ' - Module-Dateien nach Symbolnamen abscannen'
#print ' - In DB eingelesene Library-Dateien auflisten'
#print ' - Symbole in DB auflisten'
print "
"
# Get the symbol names of the lib file
def scan_lib(fname, f, symbollist):
print len(f), 'Bytes'
for line in f.split('\n'):
if line.startswith('DEF '):
symbolname = line.split(' ')[1]
if symbolname not in symbollist:
symbollist[symbolname] = [fname]
else:
symbollist[symbolname].append(fname)
print '-', '', symbolname, ''
return symbollist
# Get the symbol names of the mod file
def scan_mod(fname, f, symbollist):
print len(f), 'Bytes'
for line in f.split('\n'):
if line.startswith('$MODULE '):
symbolname = line.split(' ')[1]
if symbolname not in symbollist:
symbollist[symbolname] = [fname]
else:
symbollist[symbolname].append(fname)
print '-', '', symbolname, ''
return symbollist
#hack to circumvent filename codings in zip files which create problems
def sanitized(s):
try:
s2 = s.encode('utf8')
except:
s2 = ''
for c in s:
if c.isalpha():
s2 += c
else:
s2 += '?'
return s2
def list_syms(symlist):
print 'Gefundene Symbole:
'
print 'Anzahl Symbole: %i
' % len(symlist)
print 'Liste:
'
for i,s in enumerate(sorted(symlist)):
print s, '|',
print '
'
print 'Dateizuordnung:
'
for i,s in enumerate(sorted(symlist)):
print '- ', s, '',
if len(symlist[s]) > 0: #Set to one to get only double occurences
print '(' + ' - '.join(symlist[s]) + ')'
print '
'
print '
'
def scan_files(filext, handler):
symlist = {}
for root, dirs, files in os.walk(Librarybase):
for f in files:
fname = root + '/' + f
if f.endswith(filext):
print root + '/' + f, ''
print 'OK' if handler(fname, open(fname).read(), symlist) else 'Error'
print '
'
elif f.endswith('.zip'):
print root + '/' + f, '
'
print ''
z = zipfile.ZipFile(fname, 'r')
for m in z.namelist():
if m.endswith(filext):
ms = sanitized(m)
print '- ', ms, ''
print 'OK' if handler(fname + '/' + ms, z.read(m), symlist) else 'Error'
print '
'
print '
'
return symlist
#Selector for user commands
if cmd == 'show':
for root, dirs, files in os.walk(Librarybase):
for f in files:
print root + '/' + f, '
'
if showimg and (f.endswith('.png') or f.endswith('.jpg')):
print '
'
elif f.endswith('.zip'):
print ''
for m in zipfile.ZipFile(root + '/' + f, 'r').namelist():
print '- ', m, '
'
print '
'
if cmd == 'scan':
print 'Scanning...
'
libsyms = scan_files(".lib", scan_lib)
list_syms(libsyms)
p = partdb.PartDB()
try:
p.add_parts(libsyms)
print 'Added parts to part-db'
except:
print 'Failed to add parts to part-db'
print 'Error: %s
' % sys.exc_info()[1]
elif cmd == 'scanmod':
print 'Scanning...
'
modsyms = scan_files(".mod", scan_mod)
list_syms(modsyms)
p = partdb.PartDB()
try:
p.add_footprints(modsyms)
print 'Added footprints to part-db'
except:
print 'Failed to add footprints to part-db'
print 'Error: %s
' % sys.exc_info()[1]
elif cmd == 'listfiles':
pass #Not implemented
elif cmd == 'listsymbols':
pass #Not implemented
print """
"""