Hi,
Here is my code.
*postgres_db = DAL("postgres://postgres@localhost:5432/" +
get_postgres_db_filename(), auto_import=True, pool_size=10,
migrate_enabled=False, fake_migrate_all=True)*
"get_postgres_db_filename()" will get you
"CaptureOutput-2019-11-15_03-25-19-MN"
I have defined the table
postgres_db.define_table('vmhive',
Field('id', type='uuid'),
Field('owner', type='uuid'),
Field('fsid', type='bigint'),
Field('demuxer', type='uuid'),
Field('origin_hive', type='uuid'),
Field('name', type='citext'),
Field('replicaset', type='text'),
Field('visible', type='boolean'),
Field('creation_time', type='bigint'),
Field('platform_tag', type='text'),
Field('platform_name', type='text'),
Field('backup_policy', type='uuid'),
Field('deletion_time', type='bigint'),
Field('ancestor', type='uuid'),
Field('removed_time', type='bigint'),
Field('tree_id', type='uuid'),
Field('owner_number', type='bigint'),
Field('ready_for_backup', type='boolean'),
Field('hive_version', type='bigint'),
Field('hms_platform_id', type='text'),
Field('stat', type='text'),
Field('hms_host_id', type='text'),
Field('ft_enabled', 'boolean'),
Field('ft_primary', type='boolean'),
Field('power_state', type='text'),
Field('rb_ignore', type='boolean'))
When I explicitly issue SQL statements.
I am able to get result.
*print(postgres_db.executesql('SELECT * FROM vmhive where deletion_time >
0;'))*
[('*9f750dab-48e3-4a98-a62c-41e38b6b1ce1*',
'42147e2a-826a-f2a2-0130-7580c4cfad5f', 2874592791,
'4a5a47b8-4eb6-4d28-9b65-9a88a3f0727d',
'00000000-0000-0000-0000-000000000000', 'Oracle-test_172_16_0_201',
'2|36:4214534b-83c5-1feb-150d-a632928dd77c|36:42147e2a-826a-f2a2-0130-7580c4cfad5f|'
, True, 1573183778, '', 'Oracle-test_172_16_15_200',
'f67c4112-0b70-4309-9b15-83387fa316dd', 1573187250,
'd4985d85-d508-4565-bf7a-e125de44a4e5', 0,
'42bb9964-7026-4af2-849b-592858a899dd', 2, True, 1,
'51bd75d3-ab1c-4782-b73c-81f0605c2881:VirtualMachine:vm-153',
'1;0;0;16741;1;0;0;0;0;0;0;1573183778;1573183778;1573183778', '', False,
False, '3', False)]
But when I try the following
* for row in postgres_db(postgres_db.vmhive.deletion_time >
0).select():*
* print(row.name)*
ValueError: invalid literal for int() with base 10:
'9f750dab-48e3-4a98-a62c-41e38b6b1ce1'
But when I check the Field type and length
* print(postgres_db.vmhive.id.type)*
* print(postgres_db.vmhive.id.length)*
id
512
Other Fields are fine
* print(postgres_db.vmhive.owner.type)*
* print(postgres_db.vmhive.fsid.type)*
* print(postgres_db.vmhive.name.type)*
* print(postgres_db.vmhive.hms_host_id.type)*
* print(postgres_db.vmhive.rb_ignore.type)*
uuid
bigint
citext
text
boolean
Now this is a pre-populated database, so I cant change anything on it.
I am wondering how to force "id" Field to not behave like a int Field ?
Thanks in Advance.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/2d89e80c-57aa-474b-b09d-397fc5279e0b%40googlegroups.com.
