API tools faq
paste
Guest User

Untitled

a guest
Jun 20th, 2018
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 64.62 KB | None | 0 0
raw download clone embed print report
  1. Name "SQL::Translator::DEBUG" used only once: possible typo at create_ddl.pl line 12.
  2. [SQL::Translator] Got parser: code ref
  3. [SQL::Translator] Got producer: code ref
  4. [SQL::Translator] Loading SQL::Translator::Parser::DBIx::Class as SQL/Translator/Parser/DBIx/Class.pm
  5. [SQL::Translator] Got parser: SQL::Translator::Parser::DBIx::Class::parse
  6. [SQL::Translator] translate: Got a hashref
  7. [SQL::Translator] Schema =
  8. $VAR1 = bless( {
  9. 'tables' => {
  10. 'blog' => bless( {
  11. '_order' => {
  12. 'field' => 6
  13. },
  14. '_ID' => 'SQL::Translator::Schema::Table',
  15. 'name' => 'blog',
  16. 'schema' => $VAR1,
  17. 'constraints' => [
  18. bless( {
  19. 'fields' => [
  20. 'blog_id'
  21. ],
  22. '_ID' => 'SQL::Translator::Schema::Constraint',
  23. 'table' => $VAR1->{'tables'}{'blog'},
  24. '_DEBUG' => 0,
  25. 'type' => 'PRIMARY KEY',
  26. '_ERROR' => ''
  27. }, 'SQL::Translator::Schema::Constraint' )
  28. ],
  29. 'fields' => {
  30. 'createdate' => bless( {
  31. '_ID' => 'SQL::Translator::Schema::Field',
  32. 'name' => 'createdate',
  33. 'table' => $VAR1->{'tables'}{'blog'},
  34. 'size' => [
  35. '0'
  36. ],
  37. 'is_auto_increment' => 0,
  38. 'data_type' => 'datetime',
  39. 'order' => 5,
  40. '_DEBUG' => 0,
  41. 'extra' => {
  42. 'timezone' => 'UTC'
  43. },
  44. 'is_nullable' => 0,
  45. '_ERROR' => '',
  46. 'sql_data_type' => 9
  47. }, 'SQL::Translator::Schema::Field' ),
  48. 'user_id' => bless( {
  49. '_ID' => 'SQL::Translator::Schema::Field',
  50. 'name' => 'user_id',
  51. 'table' => $VAR1->{'tables'}{'blog'},
  52. 'size' => [
  53. '11'
  54. ],
  55. 'is_auto_increment' => 0,
  56. 'data_type' => 'integer',
  57. 'order' => 6,
  58. '_DEBUG' => 0,
  59. 'extra' => {
  60. 'unsigned' => 1
  61. },
  62. 'is_nullable' => 0,
  63. '_ERROR' => '',
  64. 'sql_data_type' => 4
  65. }, 'SQL::Translator::Schema::Field' ),
  66. 'title' => bless( {
  67. '_ID' => 'SQL::Translator::Schema::Field',
  68. 'name' => 'title',
  69. 'table' => $VAR1->{'tables'}{'blog'},
  70. 'size' => [
  71. '255'
  72. ],
  73. 'is_auto_increment' => 0,
  74. 'data_type' => 'varchar',
  75. 'order' => 3,
  76. '_DEBUG' => 0,
  77. 'is_nullable' => 0,
  78. '_ERROR' => '',
  79. 'sql_data_type' => 12
  80. }, 'SQL::Translator::Schema::Field' ),
  81. 'blog_id' => bless( {
  82. 'is_primary_key' => 1,
  83. '_ID' => 'SQL::Translator::Schema::Field',
  84. 'name' => 'blog_id',
  85. 'table' => $VAR1->{'tables'}{'blog'},
  86. 'size' => [
  87. '11'
  88. ],
  89. 'is_auto_increment' => 1,
  90. 'data_type' => 'integer',
  91. 'order' => 1,
  92. '_DEBUG' => 0,
  93. 'extra' => {
  94. 'unsigned' => 1
  95. },
  96. 'is_nullable' => 0,
  97. '_ERROR' => '',
  98. 'sql_data_type' => 4
  99. }, 'SQL::Translator::Schema::Field' ),
  100. 'description' => bless( {
  101. '_ID' => 'SQL::Translator::Schema::Field',
  102. 'name' => 'description',
  103. 'table' => $VAR1->{'tables'}{'blog'},
  104. 'size' => [
  105. '255'
  106. ],
  107. 'is_auto_increment' => 0,
  108. 'data_type' => 'varchar',
  109. 'order' => 4,
  110. '_DEBUG' => 0,
  111. 'is_nullable' => 0,
  112. '_ERROR' => '',
  113. 'sql_data_type' => 12
  114. }, 'SQL::Translator::Schema::Field' ),
  115. 'message' => bless( {
  116. '_ID' => 'SQL::Translator::Schema::Field',
  117. 'name' => 'message',
  118. 'table' => $VAR1->{'tables'}{'blog'},
  119. 'size' => [
  120. '65535'
  121. ],
  122. 'is_auto_increment' => 0,
  123. 'data_type' => 'text',
  124. 'order' => 2,
  125. '_DEBUG' => 0,
  126. 'is_nullable' => 0,
  127. '_ERROR' => '',
  128. 'sql_data_type' => -1
  129. }, 'SQL::Translator::Schema::Field' )
  130. },
  131. 'order' => 1,
  132. '_DEBUG' => 0,
  133. 'extra' => {
  134. 'mysql_charset' => 'UTF8'
  135. },
  136. '_ERROR' => 'No constraints'
  137. }, 'SQL::Translator::Schema::Table' )
  138. },
  139. '_order' => {
  140. 'trigger' => 0,
  141. 'proc' => 0,
  142. 'view' => 0,
  143. 'table' => 1
  144. },
  145. 'translator' => bless( {
  146. 'parser_args' => {},
  147. 'quote_field_names' => 1,
  148. '_ID' => 'SQL::Translator',
  149. 'parser' => sub { "DUMMY" },
  150. 'data' => \bless( {
  151. 'media_dir' => '/www/nacworld/service/../lib/Nacworld//../../root/media',
  152. 'class_mappings' => {
  153. 'Nacworld::Schema::Blog' => 'Blog'
  154. },
  155. 'source_registrations' => {
  156. 'Blog' => bless( {
  157. 'result_class' => 'Nacworld::Schema::Blog',
  158. 'resultset_attributes' => {},
  159. 'sqlt_deploy_callback' => 'default_sqlt_deploy_hook',
  160. 'name' => 'blog',
  161. 'schema' => ${$VAR1->{'translator'}{'data'}},
  162. '_relationships' => {},
  163. '_columns_info_loaded' => 0,
  164. 'source_name' => 'Blog',
  165. '_ordered_columns' => [
  166. 'blog_id',
  167. 'message',
  168. 'title',
  169. 'description',
  170. 'createdate',
  171. 'user_id'
  172. ],
  173. '_primaries' => [
  174. 'blog_id'
  175. ],
  176. 'resultset_class' => 'Nacworld::ResultSet::Blog',
  177. '_columns' => {
  178. 'createdate' => {
  179. 'data_type' => 'datetime',
  180. '_inflate_info' => {
  181. 'inflate' => sub { "DUMMY" },
  182. 'deflate' => sub { "DUMMY" }
  183. },
  184. 'extra' => {
  185. 'timezone' => 'UTC'
  186. },
  187. 'is_nullable' => 0
  188. },
  189. 'blog_id' => {
  190. 'is_auto_increment' => 1,
  191. 'data_type' => 'integer',
  192. 'extra' => {
  193. 'unsigned' => 1
  194. },
  195. 'size' => 11
  196. },
  197. 'title' => {
  198. 'data_type' => 'varchar',
  199. 'size' => 255
  200. },
  201. 'user_id' => {
  202. 'data_type' => 'integer',
  203. 'extra' => {
  204. 'unsigned' => 1
  205. },
  206. 'size' => 11
  207. },
  208. 'description' => {
  209. 'data_type' => 'varchar',
  210. 'size' => 255
  211. },
  212. 'message' => {
  213. 'data_type' => 'text',
  214. 'size' => 65535
  215. }
  216. },
  217. '_unique_constraints' => {
  218. 'primary' => ${$VAR1->{'translator'}{'data'}}->{'source_registrations'}->{'Blog'}->{'_primaries'}
  219. }
  220. }, 'DBIx::Class::ResultSource::Table' )
  221. },
  222. 'storage' => bless( {
  223. '_dbi_connect_info' => [
  224. 'dbi:mysql:dbname=nacworld',
  225. 'root',
  226. 'nac',
  227. {
  228. 'mysql_enable_utf8' => '1'
  229. }
  230. ],
  231. '_connect_info' => [
  232. 'dbi:mysql:dbname=nacworld',
  233. 'root',
  234. 'nac',
  235. {
  236. 'mysql_enable_utf8' => '1'
  237. }
  238. ],
  239. 'savepoints' => [],
  240. '_sql_maker_opts' => {},
  241. 'schema' => ${$VAR1->{'translator'}{'data'}},
  242. 'debugobj' => bless( {}, 'DBIx::Class::Storage::Statistics' ),
  243. '_dbh_gen' => 0,
  244. 'transaction_depth' => 0,
  245. '_in_dbh_do' => 0,
  246. '_sql_maker' => undef
  247. }, 'DBIx::Class::Storage::DBI' )
  248. }, 'Nacworld::Schema' ),
  249. 'schema' => $VAR1,
  250. 'quote_table_names' => 1,
  251. 'parser_type' => 'SQL::Translator::Parser::DBIx::Class',
  252. 'add_drop_table' => 1,
  253. '_DEBUG' => 1,
  254. 'producer' => sub { "DUMMY" },
  255. 'debug' => 1,
  256. '_ERROR' => '',
  257. 'producer_type' => 'CODE'
  258. }, 'SQL::Translator' ),
  259. '_ID' => 'SQL::Translator::Schema',
  260. 'name' => 'Nacworld::Schema v1.x',
  261. '_DEBUG' => 0,
  262. '_ERROR' => 'Table "blog" does not exist'
  263. }, 'SQL::Translator::Schema' );
  264.  
  265. [SQL::Translator] Loading MySQL as SQL/Translator/Producer/MySQL.pm
  266. [SQL::Translator] Got producer: SQL::Translator::Producer::MySQL::produce
  267. [SQL::Translator] Schema =
  268. $VAR1 = bless( {
  269. 'tables' => {
  270. 'blog' => bless( {
  271. '_order' => {
  272. 'field' => 6
  273. },
  274. '_ID' => 'SQL::Translator::Schema::Table',
  275. 'name' => 'blog',
  276. 'schema' => $VAR1,
  277. 'constraints' => [
  278. bless( {
  279. 'fields' => [
  280. 'blog_id'
  281. ],
  282. '_ID' => 'SQL::Translator::Schema::Constraint',
  283. 'table' => $VAR1->{'tables'}{'blog'},
  284. '_DEBUG' => 0,
  285. 'type' => 'PRIMARY KEY',
  286. '_ERROR' => ''
  287. }, 'SQL::Translator::Schema::Constraint' )
  288. ],
  289. 'fields' => {
  290. 'createdate' => bless( {
  291. '_ID' => 'SQL::Translator::Schema::Field',
  292. 'name' => 'createdate',
  293. 'table' => $VAR1->{'tables'}{'blog'},
  294. 'size' => [
  295. '0'
  296. ],
  297. 'is_auto_increment' => 0,
  298. 'data_type' => 'datetime',
  299. 'order' => 5,
  300. '_DEBUG' => 0,
  301. 'extra' => {
  302. 'timezone' => 'UTC'
  303. },
  304. 'is_nullable' => 0,
  305. '_ERROR' => '',
  306. 'sql_data_type' => 9
  307. }, 'SQL::Translator::Schema::Field' ),
  308. 'user_id' => bless( {
  309. '_ID' => 'SQL::Translator::Schema::Field',
  310. 'name' => 'user_id',
  311. 'table' => $VAR1->{'tables'}{'blog'},
  312. 'size' => [
  313. '11'
  314. ],
  315. 'is_auto_increment' => 0,
  316. 'data_type' => 'integer',
  317. 'order' => 6,
  318. '_DEBUG' => 0,
  319. 'extra' => {
  320. 'unsigned' => 1
  321. },
  322. 'is_nullable' => 0,
  323. '_ERROR' => '',
  324. 'sql_data_type' => 4
  325. }, 'SQL::Translator::Schema::Field' ),
  326. 'title' => bless( {
  327. '_ID' => 'SQL::Translator::Schema::Field',
  328. 'name' => 'title',
  329. 'table' => $VAR1->{'tables'}{'blog'},
  330. 'size' => [
  331. '255'
  332. ],
  333. 'is_auto_increment' => 0,
  334. 'data_type' => 'varchar',
  335. 'order' => 3,
  336. '_DEBUG' => 0,
  337. 'is_nullable' => 0,
  338. '_ERROR' => '',
  339. 'sql_data_type' => 12
  340. }, 'SQL::Translator::Schema::Field' ),
  341. 'blog_id' => bless( {
  342. 'is_primary_key' => 1,
  343. '_ID' => 'SQL::Translator::Schema::Field',
  344. 'name' => 'blog_id',
  345. 'table' => $VAR1->{'tables'}{'blog'},
  346. 'size' => [
  347. '11'
  348. ],
  349. 'is_auto_increment' => 1,
  350. 'data_type' => 'integer',
  351. 'order' => 1,
  352. '_DEBUG' => 0,
  353. 'extra' => {
  354. 'unsigned' => 1
  355. },
  356. 'is_nullable' => 0,
  357. '_ERROR' => '',
  358. 'sql_data_type' => 4
  359. }, 'SQL::Translator::Schema::Field' ),
  360. 'description' => bless( {
  361. '_ID' => 'SQL::Translator::Schema::Field',
  362. 'name' => 'description',
  363. 'table' => $VAR1->{'tables'}{'blog'},
  364. 'size' => [
  365. '255'
  366. ],
  367. 'is_auto_increment' => 0,
  368. 'data_type' => 'varchar',
  369. 'order' => 4,
  370. '_DEBUG' => 0,
  371. 'is_nullable' => 0,
  372. '_ERROR' => '',
  373. 'sql_data_type' => 12
  374. }, 'SQL::Translator::Schema::Field' ),
  375. 'message' => bless( {
  376. '_ID' => 'SQL::Translator::Schema::Field',
  377. 'name' => 'message',
  378. 'table' => $VAR1->{'tables'}{'blog'},
  379. 'size' => [
  380. '65535'
  381. ],
  382. 'is_auto_increment' => 0,
  383. 'data_type' => 'text',
  384. 'order' => 2,
  385. '_DEBUG' => 0,
  386. 'is_nullable' => 0,
  387. '_ERROR' => '',
  388. 'sql_data_type' => -1
  389. }, 'SQL::Translator::Schema::Field' )
  390. },
  391. 'order' => 1,
  392. '_DEBUG' => 0,
  393. 'extra' => {
  394. 'mysql_charset' => 'UTF8'
  395. },
  396. '_ERROR' => 'No constraints'
  397. }, 'SQL::Translator::Schema::Table' )
  398. },
  399. '_order' => {
  400. 'trigger' => 0,
  401. 'proc' => 0,
  402. 'view' => 0,
  403. 'table' => 1
  404. },
  405. 'translator' => bless( {
  406. 'parser_args' => {},
  407. 'quote_field_names' => 1,
  408. '_ID' => 'SQL::Translator',
  409. 'parser' => sub { "DUMMY" },
  410. 'filters' => [],
  411. 'data' => \bless( {
  412. 'media_dir' => '/www/nacworld/service/../lib/Nacworld//../../root/media',
  413. 'class_mappings' => {
  414. 'Nacworld::Schema::Blog' => 'Blog'
  415. },
  416. 'source_registrations' => {
  417. 'Blog' => bless( {
  418. 'result_class' => 'Nacworld::Schema::Blog',
  419. 'resultset_attributes' => {},
  420. 'sqlt_deploy_callback' => 'default_sqlt_deploy_hook',
  421. 'name' => 'blog',
  422. 'schema' => ${$VAR1->{'translator'}{'data'}},
  423. '_relationships' => {},
  424. '_columns_info_loaded' => 0,
  425. 'source_name' => 'Blog',
  426. '_ordered_columns' => [
  427. 'blog_id',
  428. 'message',
  429. 'title',
  430. 'description',
  431. 'createdate',
  432. 'user_id'
  433. ],
  434. '_primaries' => [
  435. 'blog_id'
  436. ],
  437. 'resultset_class' => 'Nacworld::ResultSet::Blog',
  438. '_columns' => {
  439. 'createdate' => {
  440. 'data_type' => 'datetime',
  441. '_inflate_info' => {
  442. 'inflate' => sub { "DUMMY" },
  443. 'deflate' => sub { "DUMMY" }
  444. },
  445. 'extra' => {
  446. 'timezone' => 'UTC'
  447. },
  448. 'is_nullable' => 0
  449. },
  450. 'blog_id' => {
  451. 'is_auto_increment' => 1,
  452. 'data_type' => 'integer',
  453. 'extra' => {
  454. 'unsigned' => 1
  455. },
  456. 'size' => 11
  457. },
  458. 'title' => {
  459. 'data_type' => 'varchar',
  460. 'size' => 255
  461. },
  462. 'user_id' => {
  463. 'data_type' => 'integer',
  464. 'extra' => {
  465. 'unsigned' => 1
  466. },
  467. 'size' => 11
  468. },
  469. 'description' => {
  470. 'data_type' => 'varchar',
  471. 'size' => 255
  472. },
  473. 'message' => {
  474. 'data_type' => 'text',
  475. 'size' => 65535
  476. }
  477. },
  478. '_unique_constraints' => {
  479. 'primary' => ${$VAR1->{'translator'}{'data'}}->{'source_registrations'}->{'Blog'}->{'_primaries'}
  480. }
  481. }, 'DBIx::Class::ResultSource::Table' )
  482. },
  483. 'storage' => bless( {
  484. '_dbi_connect_info' => [
  485. 'dbi:mysql:dbname=nacworld',
  486. 'root',
  487. 'nac',
  488. {
  489. 'mysql_enable_utf8' => '1'
  490. }
  491. ],
  492. '_connect_info' => [
  493. 'dbi:mysql:dbname=nacworld',
  494. 'root',
  495. 'nac',
  496. {
  497. 'mysql_enable_utf8' => '1'
  498. }
  499. ],
  500. 'savepoints' => [],
  501. '_sql_maker_opts' => {},
  502. 'schema' => ${$VAR1->{'translator'}{'data'}},
  503. 'debugobj' => bless( {}, 'DBIx::Class::Storage::Statistics' ),
  504. '_dbh_gen' => 0,
  505. 'transaction_depth' => 0,
  506. '_in_dbh_do' => 0,
  507. '_sql_maker' => undef
  508. }, 'DBIx::Class::Storage::DBI' )
  509. }, 'Nacworld::Schema' ),
  510. 'schema' => $VAR1,
  511. 'quote_table_names' => 1,
  512. 'parser_type' => 'SQL::Translator::Parser::DBIx::Class',
  513. 'add_drop_table' => 1,
  514. '_DEBUG' => 1,
  515. 'producer' => sub { "DUMMY" },
  516. 'debug' => 1,
  517. '_ERROR' => '',
  518. 'producer_type' => 'SQL::Translator::Producer::MySQL'
  519. }, 'SQL::Translator' ),
  520. '_ID' => 'SQL::Translator::Schema',
  521. 'name' => 'Nacworld::Schema v1.x',
  522. '_DEBUG' => 0,
  523. '_ERROR' => 'Table "blog" does not exist'
  524. }, 'SQL::Translator::Schema' );
  525.  
  526. [SQL::Translator] [SQL::Translator::Producer::MySQL: Beginning production]
  527. [SQL::Translator::Producer::MySQL: Looking at table '`blog`']
  528. [SQL::Translator::Producer::MySQL: Looking at field 'blog_id']
  529. [SQL::Translator::Producer::MySQL: Looking at field 'message']
  530. [SQL::Translator::Producer::MySQL: Looking at field 'title']
  531. [SQL::Translator::Producer::MySQL: Looking at field 'description']
  532. [SQL::Translator::Producer::MySQL: Looking at field 'createdate']
  533. [SQL::Translator::Producer::MySQL: Looking at field 'user_id']
  534. DBIx::Class::Schema::create_ddl_dir(): Overwriting existing diff file - ../sql/Nacworld-Schema-15-16-MySQL.sql at create_ddl.pl line 17
  535. [SQL::Translator] Got parser: code ref
  536. [SQL::Translator] Got producer: code ref
  537. [SQL::Translator] 0[SQL::Translator] Loading MySQL as SQL/Translator/Parser/MySQL.pm
  538. [SQL::Translator] Got parser: SQL::Translator::Parser::MySQL::parse
  539. [SQL::Translator] translate: Got a filename
  540. [SQL::Translator] Got filename: '../sql/Nacworld-Schema-15-MySQL.sql'
  541. [SQL::Translator] Opening '../sql/Nacworld-Schema-15-MySQL.sql' to get contents.
  542. [SQL::Translator] Parse result:$VAR1 = {
  543. 'procedures' => {},
  544. 'views' => {},
  545. 'tables' => {
  546. 'blog' => {
  547. 'table_options' => [
  548. {
  549. 'CHARACTER SET' => 'UTF8'
  550. }
  551. ],
  552. 'constraints' => [
  553. {
  554. 'fields' => [
  555. 'blog_id'
  556. ],
  557. 'name' => undef,
  558. 'type' => 'primary_key',
  559. 'supertype' => 'constraint'
  560. }
  561. ],
  562. 'fields' => {
  563. 'createdate' => {
  564. 'name' => 'createdate',
  565. 'comments' => [],
  566. 'size' => undef,
  567. 'null' => 0,
  568. 'data_type' => 'datetime',
  569. 'constraints' => [],
  570. 'order' => 5,
  571. 'supertype' => 'field',
  572. 'list' => []
  573. },
  574. 'user_id' => {
  575. 'name' => 'user_id',
  576. 'comments' => [],
  577. 'size' => [
  578. '11'
  579. ],
  580. 'null' => 0,
  581. 'data_type' => 'integer',
  582. 'constraints' => [],
  583. 'order' => 6,
  584. 'unsigned' => 1,
  585. 'supertype' => 'field',
  586. 'list' => []
  587. },
  588. 'title' => {
  589. 'name' => 'title',
  590. 'comments' => [],
  591. 'size' => [
  592. '255'
  593. ],
  594. 'null' => 0,
  595. 'data_type' => 'varchar',
  596. 'constraints' => [],
  597. 'order' => 3,
  598. 'supertype' => 'field',
  599. 'list' => []
  600. },
  601. 'blog_id' => {
  602. 'name' => 'blog_id',
  603. 'comments' => [],
  604. 'size' => [
  605. '11'
  606. ],
  607. 'null' => 0,
  608. 'data_type' => 'integer',
  609. 'constraints' => [],
  610. 'order' => 1,
  611. 'unsigned' => 1,
  612. 'supertype' => 'field',
  613. 'is_auto_inc' => 1,
  614. 'list' => []
  615. },
  616. 'description' => {
  617. 'name' => 'description',
  618. 'comments' => [],
  619. 'size' => [
  620. '255'
  621. ],
  622. 'null' => 0,
  623. 'data_type' => 'varchar',
  624. 'constraints' => [],
  625. 'order' => 4,
  626. 'supertype' => 'field',
  627. 'list' => []
  628. },
  629. 'message' => {
  630. 'name' => 'message',
  631. 'comments' => [],
  632. 'size' => undef,
  633. 'null' => 0,
  634. 'data_type' => 'text',
  635. 'constraints' => [],
  636. 'order' => 2,
  637. 'superty
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!