hobodave (owner)

Revisions

gist: 225577 Download_button fork
public
Public Clone URL: git://gist.github.com/225577.git
Embed All Files: show embed
data.yml #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

dTicket:
  mainTicket:
    requestor: zach
    created: 2009-01-01
    event_date: 2009-01-01
    dDivision: defaultDivision
    dShop: defaultShop1
    dCompany: defaultMM
    dDepartment: defaultDept
    dBuilding: defaultBuilding
    floor: 1
  ticketWithDeletedSize:
    id: 400
    requestor: zach
    requestor_email: zlome@sentact.com
    created: 2009-01-01
    event_date: 2009-01-01
    dDivision: defaultDivision
    dShop: defaultShop1
    dCompany: defaultMM
    dDepartment: defaultDept
    dBuilding: defaultBuilding
    floor: 1
 
dTicketsMm:
  mainTicketMm:
    dTicket: mainTicket
  ticketWithDeletedSizeMm:
    dTicket: ticketWithDeletedSize
dTicket.php #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

<?php
class dTicket extends Doctrine_Record
{
    public function setTableDefinition()
    {
        $this->setTableName('tickets');
        $this->hasColumn('id', 'integer', 4, array(
            'primary' => true,
            'notnull' => true,
            'autoincrement' => true));
    }
 
    public function setUp()
    {
        parent::setUp();
        $this->hasOne('dTicketsMm', array(
            'local'   => 'id',
            'foreign' => 'ticket_id',
            'cascade' => array('delete')
        ));
    }
}
dTicketsMm.php #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

<?php
class dTicketsMm extends Doctrine_Record
{
    public function setTableDefinition()
    {
        $this->setTableName('tickets_mm');
        $this->hasColumn('ticket_id', 'integer', 4, array(
            'primary' => true,
            'notnull' => true,
        ));
        $this->hasColumn('external_identifier', 'string', 30, array(
            'notnull' => true,
            'default' => '',
        ));
        $this->hasColumn('delivery_requested', 'boolean', 1, array(
            'notnull' => true,
            'default' => false,
        ));
    }
 
    public function setUp()
    {
        parent::setUp();
 
        $this->hasOne('dTicket', array(
            'local'   => 'ticket_id',
            'foreign' => 'id'
        ));
    }
 
    /**
     * preUpdate
     *
     * @param mixed $event
     * @return void
     */
    public function preUpdate($event)
    {
        $this->dTicket->updated_at = date('Y-m-d H:i:s');
        $this->dTicket->save();
    }
}
 
log.sql #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

		  215 Query	COMMIT
091103 18:04:00	  215 Query	DELETE FROM `company_permissions`
		  215 Query	DELETE FROM `division_departments`
		  215 Query	DELETE FROM `ticket_users`
		  215 Query	DELETE FROM `mm_item_size_levels`
		  215 Query	DELETE FROM `mm_line_items`
		  215 Query	DELETE FROM `mm_items`
		  215 Query	DELETE FROM `tickets_mm`
		  215 Query	DELETE FROM `mm_item_groups`
		  215 Query	DELETE FROM `buildings`
		  215 Query	DELETE FROM `shops`
		  215 Query	DELETE FROM `users`
		  215 Query	DELETE FROM `tickets`
		  215 Query	DELETE FROM `divisions`
		  215 Query	DELETE FROM `companies`
		  215 Query	DELETE FROM `departments`
091103 18:04:04	  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `buildings` (`name`, `lower_level`, `mezzanine`, `sub_basement`, `active`) VALUES ('Default Building', '0', '0', '0', '1')
		  215 Query	COMMIT
		  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `companies` (`company_name`, `default_shop_id`, `autoroute`, `default_system`, `pathname`) VALUES ('Default MM', '0', '1', 'mm', '')
		  215 Query	COMMIT
		  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `divisions` (`division_name`, `company_id`) VALUES ('Default Division', '35')
		  215 Query	COMMIT
		  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `departments` (`division_id`, `name`, `active`, `tenant_id`, `vendoremail`, `company_id`) VALUES ('0', 'Default Department', 'Y', '', '', '35')
		  215 Query	COMMIT
		  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `shops` (`name`, `division_id`, `active`, `department_id`, `company_id`, `user_id`) VALUES ('Default Shop 1', '35', 'Y', '0', '35', '0')
		  215 Query	COMMIT
		  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `tickets_mm` (`external_identifier`, `delivery_requested`) VALUES ('', '0')
		  215 Query	SELECT `s`.`id` AS `s__id`, `s`.`name` AS `s__name`, `s`.`shop_id` AS `s__shop_id`, `s`.`start` AS `s__start`, `s`.`end` AS `s__end`, `s`.`active_pager_number` AS `s__active_pager_number`, `s`.`bccpager` AS `s__bccpager`, `s`.`bccinternalpager` AS `s__bccinternalpager`, `s`.`updated_by` AS `s__updated_by`, `s`.`updated_at` AS `s__updated_at`, `s3`.`id` AS `s3__id`, `s3`.`shift_id` AS `s3__shift_id`, `s3`.`user_id` AS `s3__user_id`, `s3`.`shift_position_id` AS `s3__shift_position_id`, `u`.`id` AS `u__id`, `u`.`firstname` AS `u__firstname`, `u`.`username` AS `u__username`, `u`.`lastname` AS `u__lastname`, `u`.`pager` AS `u__pager`, `s4`.`id` AS `s4__id`, `s4`.`level` AS `s4__level` FROM `shifts` `s` INNER JOIN `shift_times` `s2` ON `s`.`id` = `s2`.`shift_id` LEFT JOIN `shifts_users` `s3` ON `s`.`id` = `s3`.`shift_id` LEFT JOIN `users` `u` ON `s3`.`user_id` = `u`.`id` LEFT JOIN `shift_positions` `s4` ON `s3`.`shift_position_id` = `s4`.`id` WHERE (`s2`.`dow` = 4 AND TIME('18:00:00') BETWEEN `s2`.`start` AND `s2`.`end` AND `s`.`shop_id` = '35')
		  215 Query	INSERT INTO `tickets` (`problemtype_id`, `department_id`, `requestor`, `requestor_email`, `requestor_phone`, `building_id`, `shop_id`, `priority`, `ticket_status`, `status_flags`, `owner_id`, `created`, `resolved`, `acreated`, `aresolved`, `holdtime`, `resolved_by_id`, `submitter_id`, `reminders_sent`, `parent_id`, `system`, `permission_to_enter`, `supress_notifications`, `prev_ticket`, `pgroup`, `text_one`, `text_two`, `text_three`, `text_four`, `text_five`, `event_date`, `event_start`, `event_stop`, `time_assigned`, `time_arrived`, `resolution_seconds`, `division_id`, `company_id`, `resolution_source`, `requestor_lastname`, `floor`, `id`, `updated_at`) VALUES ('0', '35', 'zach', 'zlome@sentact.com', '', '35', '35', '0', '0', '0', '0', '1230789600', '0000-00-00 00:00:00', '1969-12-31', '0000-00-00', '0', '0', '0', '0', '0', 'fr', '0', '0', '0', '0', '', '', '', '', '', '2009-01-01', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '35', '35', 'web', 'lome', '1', NULL, '2009-11-03 18:04:04')
		  215 Query	INSERT INTO `transactions` (`user_id`, `ticket_id`, `created`, `transaction_type`, `owner_id`, `description`) VALUES ('0', '9', '1230789600', '1', '0', 'Ticket created')
		  215 Query	INSERT INTO `tickets_extra` (`ticket_id`) VALUES ('9')
		  215 Query	COMMIT
		  215 Query	START TRANSACTION
		  215 Query	INSERT INTO `tickets_mm` (`external_identifier`, `delivery_requested`) VALUES ('', '0')
		  215 Query	ROLLBACK