pytable.mysql.create_test_db
index
p:\table\pytable\mysql\create_test_db.py

 
Modules
       
pytable.dbspecifier
traceback

 
Data
        queries = ['ALTER TABLE temp DROP INDEX temp_first_second;', 'DROP TABLE temp2;', 'DROP TABLE temp;', 'DROP TABLE whatnot;', 'CREATE TABLE temp (\n\t\tid int4 NOT NULL,\n\t\tabc va...cde float8 NOT NULL DEFAULT 0.999,\n\t\tefg int8\n\t);', 'CREATE TABLE temp2 (\n\t\tid int4 NOT NULL PRIMARY ...RENCES temp (id),\n\t\tname varchar(32) NOT NULL\n\t);', 'CREATE TABLE whatnot (\n\t\trow_id INT PRIMARY KEY,...RCHAR(128),\n\t\ttemp INT REFERENCES temp.row_id\n\t);', "INSERT INTO whatnot values (0,'this', 0);", "INSERT INTO whatnot values (1,'this such', 0);", "INSERT INTO whatnot values (2,'those and', 1);", 'ALTER TABLE temp ADD COLUMN INDEX temp_first_second (abc, bcd);', "INSERT into temp values (1,'blah',23,.34, 55);", "INSERT into temp values (2,'hi there',25,4.34, 54);", "INSERT into temp2 values (1,1, 'blah');", "INSERT into temp2 values (2,2, 'blunder');"]
spec = <pytable.dbspecifier.DBSpecifier object at 0x01823F90>