Commits

Kumar McMillan committed 9d78c04

Fixed example SQL so that auto incrementing primary keys works for sqlite

  • Participants
  • Parent commits 2d7d271

Comments (0)

Files changed (1)

File fixture/examples/db/storm_examples.py

     conn.rollback()
     # NOTE: this SQL works in postgres and sqlite:
     conn.execute(SQL("""CREATE TABLE fixture_storm_category (
-      id serial primary key,
+      id integer primary key,
       name varchar(60)
       )"""))
     assert conn.find(Category).count() == 0
     conn.execute(SQL("""CREATE TABLE fixture_storm_product (
-       id serial primary key,
+       id integer primary key,
        name varchar(60),
        category_id integer
       )"""))
     assert conn.find(Product).count() == 0
     conn.execute(SQL("""CREATE TABLE fixture_storm_offer (
-       id serial primary key,
+       id integer primary key,
        name varchar(60),
        category_id integer,
        product_id integer