Python connectの例

コード例 #1

ファイル: nocache_tests.py プロジェクト: henryanand/vitess

  def test_query_timeout(self):
    vstart = self.env.debug_vars()
    conn = tablet_conn.connect(self.env.address, '', 'test_keyspace', '0', 5, user='******', password='******')
    cu = cursor.TabletCursor(conn)
    self.env.execute("set vt_query_timeout=0.25")
    try:
      conn.begin()
      cu.execute("select sleep(0.5) from vtocc_test", {})
    except dbexceptions.DatabaseError as e:
      if "error: Query" not in str(e) and "error: Lost connection" not in str(e):
        self.fail("Query not killed as expected")
    else:
      self.fail("Did not receive exception")

    try:
      cu.execute("select 1 from dual", {})
    except dbexceptions.DatabaseError as e:
      self.assertContains(str(e), "not_in_tx: Transaction")
    else:
      self.fail("Did not receive exception")

    cu.close()
    conn.close()

    vend = self.env.debug_vars()
    self.assertEqual(vend.QueryTimeout, 250000000)
    self.assertEqual(vstart.mget("Kills.Queries", 0)+1, vend.Kills.Queries)
    self.env.execute("set vt_query_timeout=30")
    vend = self.env.debug_vars()
    self.assertEqual(vend.QueryTimeout, 30000000000)

コード例 #2

  def test_query_timeout(self):
    vstart = self.env.debug_vars()
    conn = tablet_conn.connect(
        self.env.address, "", "test_keyspace", "0", 5, caller_id="dev")
    cu = cursor.TabletCursor(conn)
    self.env.execute("set vt_query_timeout=0.25")
    try:
      conn.begin()
      cu.execute("select sleep(0.5) from vtocc_test", {})
    except dbexceptions.DatabaseError as e:
      if ("error: Query" not in str(e) and
          "error: the query was killed" not in str(e)):
        self.fail("Query not killed as expected")
    else:
      self.fail("Did not receive exception")

    try:
      cu.execute("select 1 from dual", {})
    except dbexceptions.DatabaseError as e:
      self.assertContains(str(e), "not_in_tx: Transaction")
    else:
      self.fail("Did not receive exception")

    cu.close()
    conn.close()

    vend = self.env.debug_vars()
    self.assertEqual(vend.QueryTimeout, 250000000)
    self.assertEqual(vstart.mget("Kills.Queries", 0) + 1, vend.Kills.Queries)
    self.env.execute("set vt_query_timeout=30")
    vend = self.env.debug_vars()
    self.assertEqual(vend.QueryTimeout, 30000000000)

コード例 #3

ファイル: nocache_tests.py プロジェクト: yekeqiang/vitess

    def test_query_timeout(self):
        vstart = self.env.debug_vars()
        conn = tablet_conn.connect("localhost:9461", '', 'test_keyspace', '0',
                                   5)
        cu = cursor.TabletCursor(conn)
        self.env.execute("set vt_query_timeout=0.25")
        try:
            conn.begin()
            cu.execute("select sleep(0.5) from vtocc_test", {})
        except dbexceptions.DatabaseError as e:
            if "error: Query" not in str(
                    e) and "error: Lost connection" not in str(e):
                self.fail("Query not killed as expected")
        else:
            self.fail("Did not receive exception")

        try:
            cu.execute("select 1 from dual", {})
        except dbexceptions.DatabaseError as e:
            self.assertContains(str(e), "not_in_tx: Transaction")
        else:
            self.fail("Did not receive exception")

        cu.close()
        conn.close()

        vend = self.env.debug_vars()
        self.assertEqual(vend.Voltron.ActivePool.Timeout, 250000000)
        self.assertEqual(vend.ActivePoolTimeout, 250000000)
        self.assertEqual(
            vstart.mget("Kills.Queries", 0) + 1, vend.Kills.Queries)
        self.env.execute("set vt_query_timeout=30")
        vend = self.env.debug_vars()
        self.assertEqual(vend.Voltron.ActivePool.Timeout, 30000000000)
        self.assertEqual(vend.ActivePoolTimeout, 30000000000)

コード例 #4

ファイル: test_env.py プロジェクト: yyzi/vitess

 def connect(self):
     c = tablet_conn.connect(self.address,
                             '',
                             'test_keyspace',
                             '0',
                             2,
                             user='******',
                             password='******')
     c.max_attempts = 1
     return c

コード例 #5

ファイル: test_env.py プロジェクト: richarwu/vitess

 def connect(self):
   c = tablet_conn.connect(
       self.address, '', 'test_keyspace', '0', 2, caller_id='dev')
   c.max_attempts = 1
   return c

コード例 #6

ファイル: test_env.py プロジェクト: pranjal5215/vitess

 def connect(self):
     c = tablet_conn.connect(
         self.address, "", "test_keyspace", "0", 2, user="******", password="******"
     )
     c.max_attempts = 1
     return c

コード例 #7

ファイル: test_env.py プロジェクト: ShelleyZhang/vitess

 def connect(self):
   c = tablet_conn.connect("localhost:9461", '', 'test_keyspace', '0', 2)
   c.max_attempts = 1
   return c

コード例 #8

ファイル: test_env.py プロジェクト: ShelleyZhang/vitess

 def connect(self):
   c = tablet_conn.connect("localhost:%s" % self.tablet.port, '', 'test_keyspace', '0', 2)
   c.max_attempts = 1
   return c

コード例 #9

ファイル: test_env.py プロジェクト: cihangir/vitess

 def connect(self):
   c = tablet_conn.connect(self.address, '', 'test_keyspace', '0', 2, user='******', password='******')
   c.max_attempts = 1
   return c

コード例 #10

ファイル: test_env.py プロジェクト: qman1989/vitess

 def connect(self):
     c = tablet_conn.connect(self.address, "", "test_keyspace", "0", 2)
     c.max_attempts = 1
     return c

コード例 #11

ファイル: test_env.py プロジェクト: qman1989/vitess

 def connect(self):
     c = tablet_conn.connect("localhost:%s" % self.port, "", "test_keyspace", "0", 2)
     c.max_attempts = 1
     return c

コード例 #12

 def connect(self):
   c = tablet_conn.connect("localhost:9461", '', 'test_keyspace', '0', 2)
   c.max_attempts = 1
   return c

コード例 #13

 def connect(self):
   c = tablet_conn.connect("localhost:%s" % self.tablet.port, '', 'test_keyspace', '0', 2)
   c.max_attempts = 1
   return c