Хранилища Subversion apt-scan

#!/usr/bin/env python2.5

import sqlalchemy.orm

import optparse

import pkg.entities

from pkg.entities import Distr, Codename, Suite, Path

import pkg.scanner

cmd_parser = optparse.OptionParser(usage = "usage: %prog [options] scan_dir",

        description="%prog - scans scan_dir and finds all repos",

        version = "0.0.1")

cmd_parser.add_option("--create-db", action="store_true", dest="create_db", default=False,

        help = "create a database, does not effect if database already exists",)

cmd_parser.add_option("--tbl-prefix", type="string", action="store", dest="sql_tbl_prfx",

        help = "this prefix will be used during creation database`s tables" )

cmd_parser.add_option("--connect-str", type="string", action="store", dest="sql_connect_str", default="sqlite:///repo.db",

        help = "this option set current sql-engine and additionally username and password." +

        "For more instructions see \"sqlalchemy\" 'create_engine'`s references manual. default value is 'sqlite:///repo.db'")

cmd_parser.add_option("--fill-tbls", action="store_true", dest="verbose", dest="fill_tbls", default=False,

        help = "fill main tables with persist information");

cmd_parser.add_option("-v", "--verbose", action="store_true", dest="verbose", default=False);

(options, args) = cmd_parser.parse_args()

if len(args) != 1:

    cmd_parser.error("incorrect number of arguments")

if options.verbose:

    pkg.entities.Base.metadata.bind.echo=True

if options.create_db:

    pkg.entities.Base.metadata.create_all()

else:

    if options.sql_tbl_prfx != None:

        cmd_parser.error("incorrect syntax: --tbl-prefix can be used only with --create-db")

sess = sqlalchemy.orm.scoped_session(sqlalchemy.orm.sessionmaker(bind=pkg.entities.Base.metadata.bind))

if options.fill_tbls:

    ub = Distr('ubuntu')

    ub.codenames = [Codename("intrepid")]

    deb = Distr('debian')

    deb.codenames = [Codename("etch"), Codename("lenny")]

    sess.add_all([ub, deb])

    sess.commit()

scan_inf = pkg.scanner.start(args[0])

cns_r = dict([ [cn.caption, cn] for cn in sess.query(Codename).order_by(Codename.id) ])

for cn_l in scan_inf:

    if cn_l in cns_r:

        sts_r = dict([ [st_r.caption, st_r] for st_r in cns_r[cn_l].suites ])

        for st_l in scan_inf[cn_l]:

            if st_l in sts_r:

                print (sts_r[st_l].pathes, '<<---')

            else:

                cns_r[cn_l].suites.append(Suite(st_l))

                sts_r[st_l] = Suite(st_l)

                sts_r[st_l].codename = cns_r[cn_l]

print (sess.dirty)

sess.commit()

#        print (cns_r[cn_l], cns_r[cn_l].distr)

#for dn_r in dst_inf:

    #cn_inf = dict([[cn.caption, cn] for cn in dst_inf[dn_r].codenames])

    #print (scan_inf | cn_inf)

    #for cn_l in scan_inf:

        #if cn_l in cn_inf:

            #print (cn_l, "in", dn_r)

#    d = dict([(cn.caption, cn) for cn in dst_inf[dn].codenames])

#    print 

#    for cn in scan_inf:

#        print (cn, "in", dn)

#for cn in repoinf:

    #print (cn)

    #for st in repoinf[cn]:

        #print ("====", st)

        #for p in repoinf[cn][st]:

            #print ("========", p)

#distr = ents.Distr('ubuntu')

#sess.add(distr)

#sess.commit()