popufare/server/sql_schema/testing/setup_testdb.sqlite

insert into drivers (id, pin, name) values (7357, 7357, 'Test driver');

insert into groups
  (group_id, group_name)
  values
  (73576, 'ORG');

insert into org_default_card_value
  (group_id, mag_track, rf_length, rf_site)
  values
  (73576, 2, 26, 137);

insert into rule_class
  (rulename, ruleclass)
  values
  ('ORG-NRIDE', 'NRIDE'),
  ('ORG-NDAY', 'NDAY'),
  ('ORG-TESTING', 'OTHER');

insert into rule_mappings
  (rule, rule_text, group_id, active)
  values
  ('ORG-NRIDE', 'N-Ride Pass', 73576, 1),
  ('ORG-NDAY', 'N-Day Pass', 73576, 1),
  ('ORG-TESTING', 'Org Testing', 73576, 1);

insert into user_card
  (logical_card_id, mag_token, rfid_token, comment,
   issued, active,
   deactivated, lastused, firstused,
   group_id, issuetype)
  values
  (1, '2:555', '35:507:555', 'testing card',
   datetime(), 1,
   NULL, NULL, NULL,
   73576, NULL);

insert into user_pass
  (user_pass_id, logical_card_id,
   issued, activated, deactivated,
   firstused, lastused,
   nrides_orig, nrides_remain,
   nday_orig, nday_expiration,
   active, expired,
   rule, queue_order,
   comment, paytype)

  values

  (11, 1,
   datetime(), datetime(), NULL,
   NULL, NULL,
   5, 5,
   NULL, NULL,
   1, 0,
   'RULE', 1,
   'Test pass', NULL),
  (12, 1,
   datetime(), datetime(), NULL,
   NULL, NULL,
   NULL, NULL,
   15, NULL,
   1, 0,
   'RULE', 1,
   'Test pass', NULL),

  (13, 2,
   datetime(), datetime(), NULL,
   NULL, NULL,
   5, 5,
   NULL, NULL,
   1, 0,
   'RULE', 1,
   'Test pass', NULL),
  (13, 2,
   datetime(), datetime(), NULL,
   NULL, NULL,
   NULL, NULL,
   15, NULL,
   1, 0,
   'RULE', 1,
   'Test pass', NULL);