cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Tutkowski <mike.tutkow...@solidfire.com>
Subject Re: Just checked in a minor change to the DB
Date Fri, 07 Mar 2014 15:15:44 GMT
Good point! :) I should have said what branch it was in. You are correct it
was master.


On Fri, Mar 7, 2014 at 2:33 AM, Rajesh Battala <rajesh.battala@citrix.com>wrote:

> Hi Mike,
> This change is for master right?
>
> Thanks
> Rajesh Battala
>
> -----Original Message-----
> From: Mike Tutkowski [mailto:mike.tutkowski@solidfire.com]
> Sent: Friday, March 7, 2014 1:36 AM
> To: dev@cloudstack.apache.org
> Subject: Just checked in a minor change to the DB
>
> Hi everyone,
>
> Just wanted to give you a heads up that I made a minor change to two views
> in the DB in 9b66866dc2085486f465159cbd446ac03e266a2c:
>
> service_offering_view and disk_offering_view
>
> I added some columns to these views so I could present additional info in
> the GUI.
>
> If you want to bring these two views up to date, just run the following
> SQL:
>
> DROP VIEW IF EXISTS `cloud`.`disk_offering_view`; CREATE VIEW
> `cloud`.`disk_offering_view` AS
>     select
>         disk_offering.id,
>         disk_offering.uuid,
>         disk_offering.name,
>         disk_offering.display_text,
>         disk_offering.disk_size,
>         disk_offering.min_iops,
>         disk_offering.max_iops,
>         disk_offering.created,
>         disk_offering.tags,
>         disk_offering.customized,
>         disk_offering.customized_iops,
>         disk_offering.removed,
>         disk_offering.use_local_storage,
>         disk_offering.system_use,
>         disk_offering.hv_ss_reserve,
>         disk_offering.bytes_read_rate,
>         disk_offering.bytes_write_rate,
>         disk_offering.iops_read_rate,
>         disk_offering.iops_write_rate,
>         disk_offering.cache_mode,
>         disk_offering.sort_key,
>         disk_offering.type,
>         disk_offering.display_offering,
>         domain.id domain_id,
>         domain.uuid domain_uuid,
>         domain.name domain_name,
>         domain.path domain_path
>     from
>         `cloud`.`disk_offering`
>             left join
>         `cloud`.`domain` ON disk_offering.domain_id = domain.id
>     where
>         disk_offering.state='ACTIVE';
>
> DROP VIEW IF EXISTS `cloud`.`service_offering_view`; CREATE VIEW
> `cloud`.`service_offering_view` AS
>     select
>         service_offering.id,
>         disk_offering.uuid,
>         disk_offering.name,
>         disk_offering.display_text,
>         disk_offering.created,
>         disk_offering.tags,
>         disk_offering.removed,
>         disk_offering.use_local_storage,
>         disk_offering.system_use,
>         disk_offering.customized_iops,
>         disk_offering.min_iops,
>         disk_offering.max_iops,
>         disk_offering.hv_ss_reserve,
>         disk_offering.bytes_read_rate,
>         disk_offering.bytes_write_rate,
>         disk_offering.iops_read_rate,
>         disk_offering.iops_write_rate,
>         disk_offering.cache_mode,
>         service_offering.cpu,
>         service_offering.speed,
>         service_offering.ram_size,
>         service_offering.nw_rate,
>         service_offering.mc_rate,
>         service_offering.ha_enabled,
>         service_offering.limit_cpu_use,
>         service_offering.host_tag,
>         service_offering.default_use,
>         service_offering.vm_type,
>         service_offering.sort_key,
>         service_offering.is_volatile,
>         service_offering.deployment_planner,
>         domain.id domain_id,
>         domain.uuid domain_uuid,
>         domain.name domain_name,
>         domain.path domain_path
>     from
>         `cloud`.`service_offering`
>             inner join
>         `cloud`.`disk_offering` ON service_offering.id = disk_offering.id
>             left join
>         `cloud`.`domain` ON disk_offering.domain_id = domain.id
>     where
>         disk_offering.state='Active';
>
> Thanks!
>
> --
> *Mike Tutkowski*
> *Senior CloudStack Developer, SolidFire Inc.*
> e: mike.tutkowski@solidfire.com
> o: 303.746.7302
> Advancing the way the world uses the
> cloud<http://solidfire.com/solution/overview/?video=play>
> *(tm)*
>



-- 
*Mike Tutkowski*
*Senior CloudStack Developer, SolidFire Inc.*
e: mike.tutkowski@solidfire.com
o: 303.746.7302
Advancing the way the world uses the
cloud<http://solidfire.com/solution/overview/?video=play>
*(tm)*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message