def make_up():
images = [
'http://matplotlib.org/_images/errorbar_demo_features.png',
'http://matplotlib.org/_images/scatter_demo1.png',
'http://matplotlib.org/_images/streamplot_demo_masking.png',
'http://matplotlib.org/_images/spines_demo_bounds.png',
'http://matplotlib.org/_images/scatter_hist1.png',
'http://freedownloads.last.fm/download/414521506/Heartbeat.mp3',
'http://www.auby.no/files/video_tests/h264_720p_hp_5.1_6mbps_ac3_planet.mp4'
]
formulas = [
r'\( \sum_i \frac{i(i+1)}{2} \)',
r'\( \int _a ^b \sin(x) \cos^3(x) dx \)',
r'\( B^{\ast} \rightarrow B^0 + \pi^{+} \)',
r'\( \pi^0 \rightarrow \gamma + \gamma \)'
]
import random
from gluon.contrib.populate import populate, IUP, Learner
db(db.forum).delete()
db(db.thread).delete()
db(db.post).delete()
ell = Learner()
ell.loadd(IUP)
def random_body():
n = random.choice((20, 25, 50, 100, 200))
body = body = ell.generate(n, prefix=None)
if random.random() < 0.3:
body += '\n' + random.choice(images)
elif random.random() < 0.3:
body += '\n' + random.choice(formulas)
return body
for nforum in range(20):
forum = db.forum.insert(name=ell.generate(4, prefix=None),
body=random_body())
for nthread in range(5):
tid = db.thread.insert(forum=forum,
name=ell.generate(8, prefix=None))
id = None
for k in range(random.randint(5, 10)):
id = db.post.insert(thread=tid,
parent_id=id,
body=random_body())
if random.choice((0, 1)): id = None
db.commit()
def make_up():
images = ['http://matplotlib.org/_images/errorbar_demo_features.png',
'http://matplotlib.org/_images/scatter_demo1.png',
'http://matplotlib.org/_images/streamplot_demo_masking.png',
'http://matplotlib.org/_images/spines_demo_bounds.png',
'http://matplotlib.org/_images/scatter_hist1.png',
'http://freedownloads.last.fm/download/414521506/Heartbeat.mp3',
'http://www.auby.no/files/video_tests/h264_720p_hp_5.1_6mbps_ac3_planet.mp4']
formulas = [r'\( \sum_i \frac{i(i+1)}{2} \)',
r'\( \int _a ^b \sin(x) \cos^3(x) dx \)',
r'\( B^{\ast} \rightarrow B^0 + \pi^{+} \)',
r'\( \pi^0 \rightarrow \gamma + \gamma \)']
import random
from gluon.contrib.populate import populate, IUP, Learner
db(db.forum).delete()
db(db.thread).delete()
db(db.post).delete()
ell = Learner()
ell.loadd(IUP)
def random_body():
n = random.choice((20,25,50,100,200))
body = body=ell.generate(n, prefix=None)
if random.random()<0.3:
body += '\n'+random.choice(images)
elif random.random() <0.3:
body += '\n'+random.choice(formulas)
return body
for nforum in range(20):
forum = db.forum.insert(name=ell.generate(4, prefix=None),body=random_body())
for nthread in range(5):
tid = db.thread.insert(forum=forum, name=ell.generate(8, prefix=None))
id = None
for k in range(random.randint(5,10)):
id = db.post.insert(thread=tid,parent_id=id, body=random_body())
if random.choice((0,1)): id = None
db.commit()
def populate(table, n, default=True, values=None):
"""
Custom population function, for web2cms
:param table: Table to populate
:param n: Amount of records to generate
:param default: Whether to use default value if one specified, or not
:param values: A list to be used to populate fields. It can be:
- a fixed value, used directly
- callable: will be called with (table, fieldname) and the
return value used as field value
"""
ell = Learner()
#ell.learn(open('20417.txt','r').read())
#ell.save('frequencies.pickle')
#ell.load('frequencies.pickle')
ell.loadd(IUP)
ids = {}
for i in range(n):
record = {}
for fieldname in table.fields:
field = table[fieldname]
if not isinstance(field.type, (str, unicode)):
continue
elif field.type == 'id':
continue
## --- [SAMU 2011-11-01] BEGIN
elif values is not None and values.has_key(fieldname):
if callable(values[fieldname]):
record[fieldname] = values[fieldname](table, fieldname)
else:
record[fieldname] = values[fieldname]
## --- END
elif default and field.default:
record[fieldname] = field.default
elif field.type == 'text':
record[fieldname] = ell.generate(random.randint(10, 100),
prefix=None)
elif field.type == 'boolean':
record[fieldname] = random.random() > 0.5
elif field.type == 'date':
record[fieldname] = \
datetime.date(2009,1,1) - \
datetime.timedelta(days=random.randint(0,365))
elif field.type == 'datetime':
record[fieldname] = \
datetime.datetime(2009,1,1) - \
datetime.timedelta(days=random.randint(0,365))
elif field.type == 'time':
h = random.randint(0, 23)
m = 15 * random.randint(0, 3)
record[fieldname] = datetime.time(h, m, 0)
elif field.type == 'password':
record[fieldname] = ''
elif field.type == 'upload':
record[fieldname] = None
elif field.type == 'integer' and hasattr(field.requires,
'options'):
options = field.requires.options(zero=False)
if len(options) > 0:
record[fieldname] = options[random.randint(
0,
len(options) - 1)][0]
else:
record[fieldname] = None
elif field.type == 'list:integer' and hasattr(
field.requires, 'options'):
options = field.requires.options(zero=False)
if len(options) > 0:
vals = []
for i in range(0, random.randint(0, len(options) - 1) / 2):
vals.append(options[random.randint(
0,
len(options) - 1)][0])
record[fieldname] = vals
elif field.type in ['integer', 'double'] or str(
field.type).startswith('decimal'):
try:
record[fieldname] = random.randint(
field.requires.minimum, field.requires.maximum - 1)
except:
record[fieldname] = random.randint(0, 1000)
elif field.type[:10] == 'reference ':
tablename = field.type[10:]
if not tablename in ids:
if table._db._dbname == 'gql':
ids[tablename] = [
x.id for x in table._db(
table._db[field.type[10:]].id > 0).select()
]
else:
ids[tablename] = [
x.id for x in table._db(
table._db[field.type[10:]].id > 0).select()
]
n = len(ids[tablename])
if n:
record[fieldname] = ids[tablename][random.randint(
0, n - 1)]
else:
record[fieldname] = 0
elif field.type[:15] == 'list:reference ':
tablename = field.type[15:]
if not tablename in ids:
if table._db._dbname == 'gql':
ids[tablename] = [
x.id for x in table._db(
table._db[field.type[15:]].id > 0).select()
]
else:
ids[tablename] = [
x.id for x in table._db(
table._db[field.type[15:]].id > 0).select()
]
n = len(ids[tablename])
if n:
vals = []
for i in range(0, random.randint(0, n - 1) / 2):
vals.append(ids[tablename][random.randint(0, n - 1)])
record[fieldname] = vals
else:
record[fieldname] = 0
elif field.type == 'list:string' and hasattr(
field.requires, 'options'):
options = field.requires.options(zero=False)
if len(options) > 0:
vals = []
for i in range(0, random.randint(0, len(options) - 1) / 2):
vals.append(options[random.randint(
0,
len(options) - 1)][0])
record[fieldname] = vals
elif field.type == 'string' and hasattr(field.requires, 'options'):
options = field.requires.options(zero=False)
record[fieldname] = options[random.randint(
0,
len(options) - 1)][0]
elif field.type == 'string' and fieldname.find('url') >= 0:
record[fieldname] = 'http://%s.example.com' % da_du_ma(4)
elif field.type == 'string' and fieldname.find('email') >= 0:
record[fieldname] = '*****@*****.**' % da_du_ma(4)
elif field.type == 'string' and fieldname.find('name') >= 0:
record[fieldname] = da_du_ma(4).capitalize()
elif field.type == 'string':
record[fieldname] = ell.generate(
10, prefix=False)[:field.length].replace('\n', ' ')
table.insert(**record)
table._db.commit()
def populate(table, n, default=True, values=None):
"""
Custom population function, for web2cms
:param table: Table to populate
:param n: Amount of records to generate
:param default: Whether to use default value if one specified, or not
:param values: A list to be used to populate fields. It can be:
- a fixed value, used directly
- callable: will be called with (table, fieldname) and the
return value used as field value
"""
ell=Learner()
#ell.learn(open('20417.txt','r').read())
#ell.save('frequencies.pickle')
#ell.load('frequencies.pickle')
ell.loadd(IUP)
ids={}
for i in range(n):
record={}
for fieldname in table.fields:
field = table[fieldname]
if not isinstance(field.type,(str,unicode)):
continue
elif field.type == 'id':
continue
## --- [SAMU 2011-11-01] BEGIN
elif values is not None and values.has_key(fieldname):
if callable(values[fieldname]):
record[fieldname] = values[fieldname](table, fieldname)
else:
record[fieldname]=values[fieldname]
## --- END
elif default and field.default:
record[fieldname]=field.default
elif field.type == 'text':
record[fieldname]=ell.generate(random.randint(10,100),prefix=None)
elif field.type == 'boolean':
record[fieldname]=random.random()>0.5
elif field.type == 'date':
record[fieldname] = \
datetime.date(2009,1,1) - \
datetime.timedelta(days=random.randint(0,365))
elif field.type == 'datetime':
record[fieldname] = \
datetime.datetime(2009,1,1) - \
datetime.timedelta(days=random.randint(0,365))
elif field.type == 'time':
h = random.randint(0,23)
m = 15*random.randint(0,3)
record[fieldname] = datetime.time(h,m,0)
elif field.type == 'password':
record[fieldname] = ''
elif field.type == 'upload':
record[fieldname] = None
elif field.type=='integer' and hasattr(field.requires,'options'):
options=field.requires.options(zero=False)
if len(options)>0:
record[fieldname] = options[random.randint(0,len(options)-1)][0]
else:
record[fieldname] = None
elif field.type=='list:integer' and hasattr(field.requires,'options'):
options=field.requires.options(zero=False)
if len(options) > 0:
vals = []
for i in range(0, random.randint(0,len(options)-1)/2):
vals.append(options[random.randint(0,len(options)-1)][0])
record[fieldname] = vals
elif field.type in ['integer','double'] or str(field.type).startswith('decimal'):
try:
record[fieldname] = random.randint(field.requires.minimum,field.requires.maximum-1)
except:
record[fieldname] = random.randint(0,1000)
elif field.type[:10] == 'reference ':
tablename = field.type[10:]
if not tablename in ids:
if table._db._dbname=='gql':
ids[tablename] = [x.id for x in table._db(table._db[field.type[10:]].id>0).select()]
else:
ids[tablename] = [x.id for x in table._db(table._db[field.type[10:]].id>0).select()]
n = len(ids[tablename])
if n:
record[fieldname] = ids[tablename][random.randint(0,n-1)]
else:
record[fieldname] = 0
elif field.type[:15] == 'list:reference ':
tablename = field.type[15:]
if not tablename in ids:
if table._db._dbname=='gql':
ids[tablename] = [x.id for x in table._db(table._db[field.type[15:]].id>0).select()]
else:
ids[tablename] = [x.id for x in table._db(table._db[field.type[15:]].id>0).select()]
n = len(ids[tablename])
if n:
vals = []
for i in range(0, random.randint(0,n-1)/2):
vals.append(ids[tablename][random.randint(0,n-1)])
record[fieldname] = vals
else:
record[fieldname] = 0
elif field.type=='list:string' and hasattr(field.requires,'options'):
options=field.requires.options(zero=False)
if len(options) > 0:
vals = []
for i in range(0, random.randint(0,len(options)-1)/2):
vals.append(options[random.randint(0,len(options)-1)][0])
record[fieldname] = vals
elif field.type=='string' and hasattr(field.requires,'options'):
options=field.requires.options(zero=False)
record[fieldname] = options[random.randint(0,len(options)-1)][0]
elif field.type=='string' and fieldname.find('url')>=0:
record[fieldname] = 'http://%s.example.com' % da_du_ma(4)
elif field.type=='string' and fieldname.find('email')>=0:
record[fieldname] = '*****@*****.**' % da_du_ma(4)
elif field.type=='string' and fieldname.find('name')>=0:
record[fieldname] = da_du_ma(4).capitalize()
elif field.type=='string':
record[fieldname] = ell.generate(10, prefix=False)[:field.length].replace('\n',' ')
table.insert(**record)
table._db.commit()