wq0fRhJr

1#!/usr/bin/env ruby -Ku
2
3# encoding: utf-8
4
5require 'rubygems'
6require 'dm-core'
7
8DataMapper::Logger.new($stdout, :debug)
9DataMapper.setup(:default, 'mysql://localhost/dm_core_test')
10
11class Event
12  include DataMapper::Resource
13
14  property :id, Serial
15  property :name, Text
16end
17
18DataMapper.auto_migrate!
19
20e = Event.new(:name => 'test')
21p e.save
22id = e.id
23e = Event.get(id)
24e.name = 'test'
25p e.save
26
27__END__
28
29OUTPUT:
30
31 ~ (0.000128) SET sql_auto_is_null = 0
32 ~ (0.000110) SET SESSION sql_mode = 'ANSI,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_UNSIGNED_SUBTRACTION,TRADITIONAL'
33 ~ (0.000183) DROP TABLE IF EXISTS `events`
34 ~ (0.091431) SHOW TABLES LIKE 'events'
35 ~ (0.000290) SHOW VARIABLES LIKE 'character_set_connection'
36 ~ (0.000179) SHOW VARIABLES LIKE 'collation_connection'
37 ~ (0.032829) CREATE TABLE `events` (`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` TEXT, PRIMARY KEY(`id`)) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
38 ~ (0.000922) INSERT INTO `events` (`name`) VALUES ('test')
39true
40 ~ (0.000270) SELECT `id` FROM `events` WHERE `id` = 1 ORDER BY `id` LIMIT 1
41 ~ (0.000189) UPDATE `events` SET `name` = 'test' WHERE `id` = 1
42true