def __init__(self, sID, onePiece):
today = datetime.date.today()
self.sID = sID
self.opp = onePiece
self.historyDB = Base("F://alfStock//"+"alf123"+'.history')
self.currentDB = Base("F://alfStock//"+"alf123"+'.current')
self.historyDB.open()
self.currentDB.open()
db = Base("F://alfStock//"+str(today)+'.db')
impactDB = Base("F://alfStock//"+str(today)+'.yv')
if db.exists():
db.open()
recs = [ r for r in db if r['sid'] == self.sID ]
if len(recs) > 0:
self.history = recs[0]['history']
self.sCurrent = recs[0]['current']
else:
print "already existed: ", len(db)
self.insertHistory(db)
else:
db.create('sid','history', 'current')
self.insertHistory(db)
if impactDB.exists():
self.idb = impactDB
else:
impactDB.create('sid','UpOrDown')# U:up; D:down
impactDB.open()
impactDB.commit()
self.idb = impactDB
def resetHisDB():
historyDB = Base("F://alfStock//" + "alf123" + '.history')
historyDB.create('sid', 'Edate',
'length') #Edate := started day not end day
historyDB.open()
historyDB.commit()
currentDB = Base("F://alfStock//" + "alf123" + '.current')
currentDB.create('sid', 'Edate', 'length')
currentDB.open()
currentDB.commit()
def reset(self):
if not self.tags:
self.tags = Base(DB_FILE_TAGS)
self.tags.create('realpath', 'category', 'tag', mode='override')
self.tags.create_index('realpath')
self.tags.create_index('category')
Organizer.reset(self)
def reset(self):
if not self.transformed:
self.transformed = Base(DB_TRANSFORMED)
self.transformed.create('realpath', 'path', 'dirname', mode='override')
self.transformed.create_index('realpath')
self.transformed.create_index('path')
self.transformed.create_index('dirname')
self.cache.reset()
Cacheable.reset(self)
def makeDB(read, write, startTime = "2010-01-01 00:00:00", \
endTime = "2010-01-01 00:10:00"):
db = Base(write)
startTime = calc.datetonumber(startTime)
endTime = calc.datetonumber(endTime)
#Day comes from day of the week. It is a number from 0 to 6.
#0 = Monday 6 = Sunday.
db.create('sensor', 'date', 'weekday', 'index', mode="override")
db.open()
allData = {}
for i in range(len(bbdata.allSensors)):
s = bbdata.allSensors[i]
data = []
print "Parsing sensor " + str(s)
try:
sString = read + "sensor" + str(s) + ".txt"
f = open(sString).readlines()
oldD = None
for timeLine in f:
tmp = timeLine.split()
tmp = tmp[1] + " " + tmp[2]
#tmp = tmp[0] + " " + tmp[1]
d = datetime.datetime.strptime(tmp, "%Y-%m-%d %H:%M:%S")
foo = calc.datetonumber(d)
if foo >= startTime and foo <= endTime:
data.append(calc.datetonumber(d))
if d.toordinal() != oldD:
#Add to database
db.insert(s, d.toordinal(), d.weekday(), len(data) - 1)
oldD = d.toordinal()
print " " + str(d)
except Exception, e:
print "Except:" + str(e)
pass
allData[s] = data
def __init__(self, directory=None):
if not directory:
directory = os.path.join(os.path.expanduser("~"),
".kde/share/apps/kopete/logs")
self.messages = Base('kopete.db') # Database stuff - Initializing...
self.messages.create('protocol',
'date',
'time',
'msgfrom',
'msgto',
'sender',
'inbound',
'nick',
'message',
mode='override')
for file in self.searchLogs(directory):
self.feedDatabase(file)
"""
If the page database doesn't exist, create it
Initialize the variable db
"""
from PyDbLite import Base
db = Base('pages.pdl').create('name','content','admin',
'nbvisits','created','version','lastmodif',mode="open")
from PyDbLite import Base
db = Base()
db.create("Acc", "Gyro")
db.insert(Acc="136", Gyro="162")
print(db)
testfile = str(sys.argv[1])
jarfile = 'ark-tweet-nlp-0.3.2.jar'
logging.basicConfig(format='%(asctime)s : %(levelname)s : %(message)s',
level=logging.INFO)
service_url = 'https://www.googleapis.com/freebase/v1/search'
unnecessary = [
'sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday',
'saturday', 'january', 'february', 'march', 'april', 'may', 'june', 'july',
'august', 'september', 'october', 'november', 'december', 'it'
]
freebase_link = 'http://www.freebase.com'
model1 = word2vec.Word2Vec.load_word2vec_format(
'freebase-vectors-skipgram1000-en.bin.gz', binary=True)
chant = enchant.Dict("en_US")
bcluster = Base('bcluster.pdl')
bcluster.open()
api_key = 'AIzaSyAW9RPEnSFbJfGsuVXSiTV_xbMySmJfGMw'
mslink = 'http://weblm.research.microsoft.com/rest.svc/bing-body/2013-12/3/jp?u=4e9af3bb-4cd3-4e29-a10b-e15754d454cb'
#Tokenize and Tag individual tokens using Owoputi et al. tagger
def tokenize():
cmd = 'java -XX:ParallelGCThreads=2 -Xmx500m -jar ' + jarfile + ' \"' + testfile + '\"'
process = subprocess.Popen(cmd,
stdout=subprocess.PIPE,
stderr=subprocess.STDOUT,
shell=True)
return iter(process.stdout.readline, b'')
from selenium import webdriver
from selenium.webdriver.support.ui import Select
from PyDbLite import Base
from facepy import *
import time
import winsound
import getpass
db = Base('grades.db')
db.create('grade', 'course', mode='open')
graph = GraphAPI("my_facebook_api_key")
username = raw_input("Username: "******"Password: "******"http://ent.unr-runn.fr/uPortal/")
select = Select(driver.find_element_by_name('user_idp'))
select.select_by_visible_text('ENSICAEN')
driver.find_element_by_id('IdPList').submit()
driver.find_element_by_id('username').send_keys(username)
driver.find_element_by_id('password').send_keys(password)
ln = random.randint(1, m)
for i in range(ln):
res += random.choice(string.letters)
return res
def sentence(n, m):
ln = random.randint(1, n)
res = []
for i in range(ln):
res.append(word(m))
return ' '.join(res)
os.remove('blog')
db = Base('blog').create('parent', 'title', 'author', 'text', 'date')
db.create_index('parent')
nbthreads = 200
for i in range(nbthreads):
# generate thread
author = 'pierre'
title = sentence(10, 10)
text = sentence(100, 10)
date = datetime.datetime(random.randint(2004, 2006), random.randint(1, 12),
random.randint(1, 28), random.randint(0, 23),
random.randint(0, 59), random.randint(0, 59))
thread_id = db.insert(parent=-1,
author=author,
title=title,
text=text,
def __init__(self, dbfile, mode = 'open', autocommit = False):
self.db = Base(dbfile)
self.db.create(*Article.TO_SAVE, **{'mode': mode})
self.db.create_index(*INDEX_ON)
self.autocommit = autocommit
def reset(self):
self.files = self.files or Base(DB_FILES)
self.files.create('realpath', mode='override')
self.files.create_index('realpath')
Cacheable.reset(self)
import os
from PyDbLite import Base
db = {
'users': Base(os.path.join(os.getcwd(), 'data', 'users')),
'news': Base(os.path.join(os.getcwd(), 'data', 'news'))
}
db['users'].create('login', 'password', 'bgcolor', 'fontfamily', mode="open")
db['news'].create('login', 'title', 'body', 'date', mode="open")
from PyDbLite import Base
db = {}
try:
db['chansons'] = Base('chansons.skl').open()
except IOError:
import createSongBase
createSongBase.createBase()
db['chansons'] = Base('chansons.skl').open()
db['recueils'] = Base('recueils.skl').open()
db['dialectes'] = Base('dialectes.skl').open()
db['genres'] = Base('genres.skl').open()
db['chansons_par_recueil'] = Base('chansons_par_recueil.skl').open()
db['chansons_par_dialecte'] = Base('chansons_par_dialecte.skl').open()
def createBase():
for path in ('chansons','recueils','dialectes',
'genres','chansons_par_dialecte',
'chansons_par_recueil'):
try:
os.remove(path+'.skl')
except OSError:
pass
db_genres = Base('genres.skl').create('nom')
db_chansons = Base('chansons.skl').create('url','breton',
'francais','prix','genre')
db_recueils = Base('recueils.skl').create('nom')
db_dialectes = Base('dialectes.skl').create('nom')
db_ch_par_dial = Base('chansons_par_dialecte.skl').create(
'chanson','dialecte')
db_ch_par_rec = Base('chansons_par_recueil.skl').create(
'chanson','recueil')
chansons=open("base.txt").readlines()
l_chansons=[]
id_chanson = 0
l_recueils=[]
l_dialectes=[]
l_genres=[]
chansonsParRecueil=[]
chansonsParGenre=[]
chansonsParDialecte=[]
for line in chansons:
[url,breton,francais,recueils,genre,dialectes,enreg]=line.strip().split("#")
if not genre in l_genres:
l_genres.append(genre)
id_genre = l_genres.index(genre)
prix=random.randrange(200,400)
l_chansons.append([url,breton,francais,prix,id_genre])
recs=recueils.split(";")
for rec in recs:
if not rec in l_recueils:
l_recueils.append(rec)
id_recueil = l_recueils.index(rec)
chansonsParRecueil.append([id_chanson,id_recueil])
dials=dialectes.split(";")
for dial in dials:
if not dial in l_dialectes:
l_dialectes.append(dial)
id_dialecte = l_dialectes.index(dial)
chansonsParDialecte.append([id_chanson, id_dialecte])
id_chanson += 1
for g in l_genres:
db_genres.insert(nom=g)
for d in l_dialectes:
db_dialectes.insert(nom=d)
for r in l_recueils:
db_recueils.insert(nom=r)
for ch in l_chansons:
print ch
db_chansons.insert(**dict(zip(db_chansons.fields,ch)))
for ch_d in chansonsParDialecte:
db_ch_par_dial.insert(chanson = ch_d[0],
dialecte = ch_d[1])
for ch_r in chansonsParRecueil:
db_ch_par_rec.insert(chanson = ch_r[0],
recueil = ch_r[1])
for db in (db_genres,db_dialectes,db_recueils,db_chansons,
db_ch_par_dial,db_ch_par_rec):
db.commit()
