def setup_db(): """Method used to build a database""" engine = config["pylons.app_globals"].sa_engine model.init_model(engine) model.metadata.create_all(engine)
import ConfigParser from sqlalchemy import create_engine from genshi.template import MarkupTemplate, TemplateLoader import tg from twisted.internet.protocol import DatagramProtocol from twisted.internet import reactor from squid.model import init_model from squid.lib.ProxyParser import ProxyParser config = ConfigParser.ConfigParser( { 'here' : os.getcwd() } ) config.read(os.path.join(os.getcwd(), 'development.ini')) sqlalchemy_url = config.get('app:main', 'sqlalchemy.url') engine = create_engine(sqlalchemy_url, echo = False) init_model(engine) parser = ProxyParser() class ProxyUDPLog(DatagramProtocol): def datagramReceived(self, data, (host, port)): for line in data.split('\n'): if len(line) == 0: continue print line parser.parse(line) file = sys.argv[1] if file.startswith('udp:'): port = file.split(':')[1]