Linux boca.hozzt.com 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64
LiteSpeed
: 159.253.39.62 | : 18.227.183.238
Cant Read [ /etc/named.conf ]
7.4.33
renovkoron
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
opt /
cloudlinux /
venv /
lib /
python3.11 /
site-packages /
sqlalchemy /
testing /
suite /
[ HOME SHELL ]
Name
Size
Permission
Action
__pycache__
[ DIR ]
drwxr-xr-x
__init__.py
358
B
-rw-r--r--
test_cte.py
6.64
KB
-rw-r--r--
test_ddl.py
8.85
KB
-rw-r--r--
test_dialect.py
6.7
KB
-rw-r--r--
test_insert.py
9.45
KB
-rw-r--r--
test_reflection.py
47.26
KB
-rw-r--r--
test_results.py
10.71
KB
-rw-r--r--
test_select.py
23.82
KB
-rw-r--r--
test_sequence.py
6.81
KB
-rw-r--r--
test_types.py
36.29
KB
-rw-r--r--
test_update_delete.py
1.46
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : test_sequence.py
from .. import config from .. import fixtures from ..assertions import eq_ from ..config import requirements from ..schema import Column from ..schema import Table from ... import Integer from ... import MetaData from ... import schema from ... import Sequence from ... import String from ... import testing class SequenceTest(fixtures.TablesTest): __requires__ = ("sequences",) __backend__ = True run_create_tables = "each" @classmethod def define_tables(cls, metadata): Table( "seq_pk", metadata, Column("id", Integer, Sequence("tab_id_seq"), primary_key=True), Column("data", String(50)), ) Table( "seq_opt_pk", metadata, Column( "id", Integer, Sequence("tab_id_seq", optional=True), primary_key=True, ), Column("data", String(50)), ) Table( "seq_no_returning", metadata, Column( "id", Integer, Sequence("noret_id_seq"), primary_key=True, ), Column("data", String(50)), implicit_returning=False, ) if testing.requires.schemas.enabled: Table( "seq_no_returning_sch", metadata, Column( "id", Integer, Sequence("noret_sch_id_seq", schema=config.test_schema), primary_key=True, ), Column("data", String(50)), implicit_returning=False, schema=config.test_schema, ) def test_insert_roundtrip(self): config.db.execute(self.tables.seq_pk.insert(), data="some data") self._assert_round_trip(self.tables.seq_pk, config.db) def test_insert_lastrowid(self): r = config.db.execute(self.tables.seq_pk.insert(), data="some data") eq_(r.inserted_primary_key, [1]) def test_nextval_direct(self): r = config.db.execute(self.tables.seq_pk.c.id.default) eq_(r, 1) @requirements.sequences_optional def test_optional_seq(self): r = config.db.execute( self.tables.seq_opt_pk.insert(), data="some data" ) eq_(r.inserted_primary_key, [1]) def _assert_round_trip(self, table, conn): row = conn.execute(table.select()).first() eq_(row, (1, "some data")) def test_insert_roundtrip_no_implicit_returning(self, connection): connection.execute( self.tables.seq_no_returning.insert(), dict(data="some data") ) self._assert_round_trip(self.tables.seq_no_returning, connection) @testing.combinations((True,), (False,), argnames="implicit_returning") @testing.requires.schemas def test_insert_roundtrip_translate(self, connection, implicit_returning): seq_no_returning = Table( "seq_no_returning_sch", MetaData(), Column( "id", Integer, Sequence("noret_sch_id_seq", schema="alt_schema"), primary_key=True, ), Column("data", String(50)), implicit_returning=implicit_returning, schema="alt_schema", ) connection = connection.execution_options( schema_translate_map={"alt_schema": config.test_schema} ) connection.execute(seq_no_returning.insert(), dict(data="some data")) self._assert_round_trip(seq_no_returning, connection) @testing.requires.schemas def test_nextval_direct_schema_translate(self, connection): seq = Sequence("noret_sch_id_seq", schema="alt_schema") connection = connection.execution_options( schema_translate_map={"alt_schema": config.test_schema} ) r = connection.execute(seq) eq_(r, testing.db.dialect.default_sequence_base) class SequenceCompilerTest(testing.AssertsCompiledSQL, fixtures.TestBase): __requires__ = ("sequences",) __backend__ = True def test_literal_binds_inline_compile(self): table = Table( "x", MetaData(), Column("y", Integer, Sequence("y_seq")), Column("q", Integer), ) stmt = table.insert().values(q=5) seq_nextval = testing.db.dialect.statement_compiler( statement=None, dialect=testing.db.dialect ).visit_sequence(Sequence("y_seq")) self.assert_compile( stmt, "INSERT INTO x (y, q) VALUES (%s, 5)" % (seq_nextval,), literal_binds=True, dialect=testing.db.dialect, ) class HasSequenceTest(fixtures.TestBase): __requires__ = ("sequences",) __backend__ = True def test_has_sequence(self): s1 = Sequence("user_id_seq") testing.db.execute(schema.CreateSequence(s1)) try: eq_( testing.db.dialect.has_sequence(testing.db, "user_id_seq"), True, ) finally: testing.db.execute(schema.DropSequence(s1)) @testing.requires.schemas def test_has_sequence_schema(self): s1 = Sequence("user_id_seq", schema=config.test_schema) testing.db.execute(schema.CreateSequence(s1)) try: eq_( testing.db.dialect.has_sequence( testing.db, "user_id_seq", schema=config.test_schema ), True, ) finally: testing.db.execute(schema.DropSequence(s1)) def test_has_sequence_neg(self): eq_(testing.db.dialect.has_sequence(testing.db, "user_id_seq"), False) @testing.requires.schemas def test_has_sequence_schemas_neg(self): eq_( testing.db.dialect.has_sequence( testing.db, "user_id_seq", schema=config.test_schema ), False, ) @testing.requires.schemas def test_has_sequence_default_not_in_remote(self): s1 = Sequence("user_id_seq") testing.db.execute(schema.CreateSequence(s1)) try: eq_( testing.db.dialect.has_sequence( testing.db, "user_id_seq", schema=config.test_schema ), False, ) finally: testing.db.execute(schema.DropSequence(s1)) @testing.requires.schemas def test_has_sequence_remote_not_in_default(self): s1 = Sequence("user_id_seq", schema=config.test_schema) testing.db.execute(schema.CreateSequence(s1)) try: eq_( testing.db.dialect.has_sequence(testing.db, "user_id_seq"), False, ) finally: testing.db.execute(schema.DropSequence(s1))
Close