# Using obj._mogrify() to display the SQL request
the_authors_of_posts_commented_by_gaston._mogrify()
input("continue ")
persons.delete(delete_all=True)
sys.exit()
# OLD CODE
import os.path
from half_orm.model import Model
dirname = os.path.dirname(__file__)
halftest = Model('{}/halftest.ini'.format(dirname))
person = halftest.relation("actor.person")
print(person)
person.delete(delete_all=True)
post = halftest.relation("blog.post")
print(post)
post.delete(delete_all=True)
comment = halftest.relation("blog.comment")
print(comment)
comment.delete(delete_all=True)
person = halftest.relation("actor.person")
print(type(person.last_name))
# just in case
#person.delete(delete_all=True)
@person.Transaction
#!/usr/bin/env python3
#-*- coding: utf-8 -*-
import time
from half_orm.model import Model
dpt_info = Model(config_file='/etc/half_orm/dpt_info')
oidt = dpt_info.relation(
'collorg.core.oid_table',
cog_oid=('e%', 'like'), cog_fqtn='seminaire.session')
for elt in oidt.select('cog_oid'):
print(elt)
print(len(oidt))
oidt.update(cog_fqtn='perdu')
dpt_info.connection.commit()
print(len(oidt))
oidt2 = oidt(cog_fqtn='perdu')
for elt in oidt2.select():
print(elt)
input('Allez faire un tour sur psql...')
oidt2.update(cog_fqtn='seminaire.session')
dpt_info.connection.commit()
# One model shared by all the tables...
print(id(dpt_info), id(oidt.model), id(oidt2.model))
print(len(oidt2))
PgDatabase()
relation('dpt_info.seminaire.session')
sys.exit()
"""
print(OidTable())
# print(BaseTable())
# print(ViewSession())
# print(relation('dpt_info.seminaire.session'))
# dpt_info.desc()
"""profiling"""
for i in range(1000):
relation('dpt_info."collorg.core".base_table')
"""request with no constraint."""
bt = dpt_info.relation('"collorg.core".data_type')
count = 0
for elt in bt.select():
count += 1
print(count)
bt = dpt_info.relation('"collorg.core".base_table')
print(type(bt.cog_signature))
print(bt)
"""Put a constraint on a Field"""
assert bt.cog_fqtn.is_set() is False
bt.cog_fqtn = 'collorg.access.access'
assert bt.cog_fqtn.is_set() is True
assert bt.cog_oid.is_set() is False
bt.cog_oid = 'd%', 'like'
assert bt.cog_oid.is_set() is True
assert bt.cog_oid.value == 'd%'