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
