def easy_connect(): global local_conn, chart_conn, customloc_conn dbfile = "./db/local.db" local_conn = sqlite3.connect(str(dbfile)) local_conn.create_collation('westcoll', westerncollate) dbfile = path.joinpath(path.expanduser(path('~')),".astronex/charts.db") chart_conn = sqlite3.connect(dbfile) chart_conn.create_collation('westcoll', westerncollate) dbfile = path.joinpath(path.expanduser(path('~')),".astronex/customloc.db") sql = "attach database '%s' as custom" % (dbfile) local_conn.execute(sql)
def connect(app): global local_conn, chart_conn, customloc_conn dbfile = path.joinpath(app.appath,"astronex/db/local.db") local_conn = sqlite3.connect(str(dbfile)) local_conn.create_collation('westcoll', westerncollate) dbfile = path.joinpath(app.home_dir,"charts.db") chart_conn = sqlite3.connect(dbfile) chart_conn.create_collation('westcoll', westerncollate) dbfile = path.joinpath(app.home_dir,"customloc.db") #customloc_conn = sqlite3.connect(str(dbfile)) sql = "attach database '%s' as custom" % (dbfile) local_conn.execute(sql)
def save_couples(self,app): if len(self.couples) == 0: return file = path.joinpath(app.home_dir,'coups.pkl') output = open(file, 'wb') pickle.dump(self.couples, output,-1) output.close()
def save_pool(self,app): if len(self.pool) == 0: return file = path.joinpath(app.home_dir,'mruch.pkl') output = open(file, 'wb') pickle.dump(self.pool, output,-1) output.close()
def init(self,app): self.datab.connect(app) self.epheflag = 4 self.country = '' self.usa = False self.orbs = [] self.peorbs = [] self.transits = [] self.master = chart.Chart('master') self.click = chart.Chart('click') self.now = chart.Chart('now') self.now.first = _('Momento actual') self.calc = chart.Chart('calc') self.loc = Locality() self.date = NeXDate(self) self.calcdt = NeXDate(self) self.person = PersonInfo() self.charts = { 'master' : self.master, 'click' : self.click, 'now' : self.now, 'calc' : self.calc } self.curr_chart = None self.curr_click = None self.crossed = True # False! self.opmode = 'simple' self.curr_op = 'draw_nat' self.opright = 'draw_house' self.opleft = 'draw_nat' self.opup = 'draw_nat' self.clickmode = 'master' self.curr_list = opdouble self.pool = deque([]) file = path.joinpath(app.home_dir,'mruch.pkl') if path.exists(file): input = open(file,"rb") self.pool = pickle.load(input) self.couples = [] self.coup_ix = 0 file = path.joinpath(app.home_dir,'coups.pkl') if path.exists(file): input = open(file,"rb") self.couples = pickle.load(input) self.fav = [] self.fav_ix = 0
def __init__(self, appath): gtk.Window.__init__(self, gtk.WINDOW_POPUP) self.set_default_size(400, 250) self.set_position(gtk.WIN_POS_CENTER) vbox = gtk.VBox() img = gtk.Image() splashimg = path.joinpath(appath, "astronex/resources/splash.png") img.set_from_pixbuf(gtk.gdk.pixbuf_new_from_file(splashimg)) vbox.pack_start(img) self.add(vbox)
def check_home_dir(appath): """Set home dir, copying needed files""" global home_dir, ephe_flag default_home = path.joinpath(path.expanduser(path("~")), home_dir) if not path.exists(default_home): path.mkdir(default_home) ephepath = path.joinpath(default_home, ephe_path) if not path.exists(ephepath): path.mkdir(path.joinpath(default_home, ephe_path)) path.copy(path.joinpath(appath, "astronex/resources/README"), ephepath) if ephepath.glob("*.se1"): ephe_flag = 2 if not path.exists(path.joinpath(default_home, default_db)): path.copy(path.joinpath(appath, "astronex/resources/charts.db"), default_home) home_dir = default_home
def reload_config(conf,boss): global cfgcols opts = boss.opts state = boss.state ephepath = path.joinpath(opts.home_dir,opts.ephepath) from pysw import setpath setpath(str(ephepath)) if opts.favourites: try: tbl = opts.favourites nfav = int(opts.nfav) favs = state.datab.get_favlist(tbl,nfav,state.newchart()) state.fav = favs except: pass popts = {} for k in conf.keys(): popts.update(conf[k]) opts.__dict__.update(popts) for keyc in default_colors.keys(): val = getattr(opts,keyc) cfgcols[keyc] = ''.join(['#',val]) from chart import orbs as ch_orbs orbs = [opts.lum,opts.normal,opts.short,opts.far,opts.useless] for l in orbs: state.orbs.append(map(float,l)) ch_orbs.append(map(float,l)) peorbs = [opts.pelum,opts.penormal,opts.peshort,opts.pefar,opts.peuseless] for l in peorbs: state.peorbs.append(map(float,l)) for l in opts.transits: state.transits.append(float(l)) opts.discard = [ int(x) for x in opts.discard ]
def read_config(homedir): global cfgcols cfgfile = path.joinpath(homedir,'cfg.ini') conf = ConfigObj(cfgfile) popts = {} for k in conf.keys(): popts.update(conf[k]) if popts.has_key('transits') and not isinstance(popts['transits'],list): del popts['transits'] opts = NexConf() opts.__dict__.update(popts) for keyc in default_colors.keys(): val = getattr(opts,keyc) cfgcols[keyc] = ''.join(['#',val]) if not path.exists(cfgfile) or len(opts.__dict__) != popts: opts.opts_to_config(conf) conf.write() return opts
def init_config(homedir, opts, state): ephepath = path.joinpath(homedir, opts.ephepath) from pysw import setpath setpath(str(ephepath)) state.country = opts.country state.usa = {"false": False, "true": True}[opts.usa] state.database = opts.database state.setloc(opts.locality, opts.region) state.init_nowchart() state.curr_chart = state.now state.epheflag = ephe_flag opts.epheflag = ephe_flag if opts.favourites: try: tbl = opts.favourites nfav = int(opts.nfav) favs = state.datab.get_favlist(tbl, nfav, state.newchart()) state.fav = favs except: pass from chart import orbs as ch_orbs orbs = [opts.lum, opts.normal, opts.short, opts.far, opts.useless] for l in orbs: state.orbs.append(map(float, l)) ch_orbs.append(map(float, l)) peorbs = [opts.pelum, opts.penormal, opts.peshort, opts.pefar, opts.peuseless] for l in peorbs: state.peorbs.append(map(float, l)) for l in opts.transits: state.transits.append(float(l)) opts.discard = [int(x) for x in opts.discard]
date,_,time = chart.date.partition('T') date = ".".join(reversed([d.lstrip('0') for d in date.split('-')])) time = time[:5] country = ccodes[datab.get_code_from_name(chart.country)] achunk = ",".join([a93,fname,sex,date,time,place,country]) return achunk def export_table(table): chlist = datab.get_chartlist(table) chart = Chart() chunks = [] for id,_,_ in chlist: datab.load_chart(tname, id, chart) chunks.append(export_chart(chart)) return chunks if __name__ == '__main__': datab.easy_connect() tname = 'personal' chunks = export_table(tname) aafile = path.joinpath(path.expanduser(path('~')),"%s.aaf" % tname) f = open(aafile,'w') for ch in chunks: f.write(ch.encode('utf-8')) f.write('\n') f.close() #print chunks