ULTRA [ www.resource.optimyar.com ]

Linux uranus.pws-dns.net 5.14.0-427.42.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Nov 1 14:58:02 EDT 2024 x86_64

LiteSpeed

31.214.174.197 | Your IP: 216.73.216.55

Cant read [ /etc/named.conf ]

[ drwxr-xr-x ]

/ opt / alt / python38 / lib64 / python3.8 / site-packages /

Home Upload Mass Deface Mass Delete Back Connect Notify

pwiz.py

#!/opt/alt/python38/bin/python3

import datetime
import sys
from getpass import getpass
from optparse import OptionParser

from peewee import *
from peewee import print_
from peewee import __version__ as peewee_version
from playhouse.reflection import *

TEMPLATE = """from peewee import *%s

database = %s('%s', **%s)

class UnknownField(object):
    def __init__(self, *_, **__): pass

class BaseModel(Model):
    class Meta:
        database = database
"""

DATABASE_ALIASES = {
    MySQLDatabase: ['mysql', 'mysqldb'],
    PostgresqlDatabase: ['postgres', 'postgresql'],
    SqliteDatabase: ['sqlite', 'sqlite3'],
}

DATABASE_MAP = dict((value, key)
                    for key in DATABASE_ALIASES
                    for value in DATABASE_ALIASES[key])

def make_introspector(database_type, database_name, **kwargs):
    if database_type not in DATABASE_MAP:
        err('Unrecognized database, must be one of: %s' %
            ', '.join(DATABASE_MAP.keys()))
        sys.exit(1)

schema = kwargs.pop('schema', None)
    DatabaseClass = DATABASE_MAP[database_type]
    db = DatabaseClass(database_name, **kwargs)
    return Introspector.from_database(db, schema=schema)

def print_models(introspector, tables=None, preserve_order=False):
    database = introspector.introspect(table_names=tables)

print_(TEMPLATE % (
        introspector.get_additional_imports(),
        introspector.get_database_class().__name__,
        introspector.get_database_name(),
        repr(introspector.get_database_kwargs())))

def _print_table(table, seen, accum=None):
        accum = accum or []
        foreign_keys = database.foreign_keys[table]
        for foreign_key in foreign_keys:
            dest = foreign_key.dest_table

# In the event the destination table has already been pushed
            # for printing, then we have a reference cycle.
            if dest in accum and table not in accum:
                print_('# Possible reference cycle: %s' % dest)

# If this is not a self-referential foreign key, and we have
            # not already processed the destination table, do so now.
            if dest not in seen and dest not in accum:
                seen.add(dest)
                if dest != table:
                    _print_table(dest, seen, accum + [table])

print_('class %s(BaseModel):' % database.model_names[table])
        columns = database.columns[table].items()
        if not preserve_order:
            columns = sorted(columns)
        primary_keys = database.primary_keys[table]
        for name, column in columns:
            skip = all([
                name in primary_keys,
                name == 'id',
                len(primary_keys) == 1,
                column.field_class in introspector.pk_classes])
            if skip:
                continue
            if column.primary_key and len(primary_keys) > 1:
                # If we have a CompositeKey, then we do not want to explicitly
                # mark the columns as being primary keys.
                column.primary_key = False

print_('    %s' % column.get_field())

print_('')
        print_('    class Meta:')
        print_('        db_table = \'%s\'' % table)
        multi_column_indexes = database.multi_column_indexes(table)
        if multi_column_indexes:
            print_('        indexes = (')
            for fields, unique in sorted(multi_column_indexes):
                print_('            ((%s), %s),' % (
                    ', '.join("'%s'" % field for field in fields),
                    unique,
                ))
            print_('        )')

if introspector.schema:
            print_('        schema = \'%s\'' % introspector.schema)
        if len(primary_keys) > 1:
            pk_field_names = sorted([
                field.name for col, field in columns
                if col in primary_keys])
            pk_list = ', '.join("'%s'" % pk for pk in pk_field_names)
            print_('        primary_key = CompositeKey(%s)' % pk_list)
        print_('')

seen.add(table)

seen = set()
    for table in sorted(database.model_names.keys()):
        if table not in seen:
            if not tables or table in tables:
                _print_table(table, seen)

def print_header(cmd_line, introspector):
    timestamp = datetime.datetime.now()
    print_('# Code generated by:')
    print_('# python -m pwiz %s' % cmd_line)
    print_('# Date: %s' % timestamp.strftime('%B %d, %Y %I:%M%p'))
    print_('# Database: %s' % introspector.get_database_name())
    print_('# Peewee version: %s' % peewee_version)
    print_('')

def err(msg):
    sys.stderr.write('\033[91m%s\033[0m\n' % msg)
    sys.stderr.flush()

def get_option_parser():
    parser = OptionParser(usage='usage: %prog [options] database_name')
    ao = parser.add_option
    ao('-H', '--host', dest='host')
    ao('-p', '--port', dest='port', type='int')
    ao('-u', '--user', dest='user')
    ao('-P', '--password', dest='password', action='store_true')
    engines = sorted(DATABASE_MAP)
    ao('-e', '--engine', dest='engine', default='postgresql', choices=engines,
       help=('Database type, e.g. sqlite, mysql or postgresql. Default '
             'is "postgresql".'))
    ao('-s', '--schema', dest='schema')
    ao('-t', '--tables', dest='tables',
       help=('Only generate the specified tables. Multiple table names should '
             'be separated by commas.'))
    ao('-i', '--info', dest='info', action='store_true',
       help=('Add database information and other metadata to top of the '
             'generated file.'))
    ao('-o', '--preserve-order', action='store_true', dest='preserve_order',
       help='Model definition column ordering matches source table.')
    return parser

def get_connect_kwargs(options):
    ops = ('host', 'port', 'user', 'schema')
    kwargs = dict((o, getattr(options, o)) for o in ops if getattr(options, o))
    if options.password:
        kwargs['password'] = getpass()
    return kwargs

if __name__ == '__main__':
    raw_argv = sys.argv

parser = get_option_parser()
    options, args = parser.parse_args()

if options.preserve_order:
        try:
            from collections import OrderedDict
        except ImportError:
            err('Preserve order requires Python >= 2.7.')
            sys.exit(1)

if len(args) < 1:
        err('Missing required parameter "database"')
        parser.print_help()
        sys.exit(1)

connect = get_connect_kwargs(options)
    database = args[-1]

tables = None
    if options.tables:
        tables = [table.strip() for table in options.tables.split(',')
                  if table.strip()]

introspector = make_introspector(options.engine, database, **connect)
    if options.info:
        cmd_line = ' '.join(raw_argv[1:])
        print_header(cmd_line, introspector)

print_models(introspector, tables, preserve_order=options.preserve_order)

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/linksafe	drwxr-xr-x	2024-07-31 07:30:00
..	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:58
Crypto	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:20
Cython	dir	-	root/root	drwxr-xr-x	2024-06-02 05:10:52
Cython-0.28.1-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:52
MySQLdb	dir	-	root/linksafe	drwxr-xr-x	2024-07-31 07:29:38
PyYAML-5.4.1-py3.8.egg-info	dir	-	root/root	drwxr-xr-x	2024-07-05 06:23:48
__pycache__	dir	-	root/linksafe	drwxr-xr-x	2024-07-05 06:14:24
_yaml	dir	-	root/root	drwxr-xr-x	2024-07-05 06:23:48
aiohttp	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:41
aiohttp-3.8.1-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:41
cffi	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:06
cffi-1.14.0-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:06
frozenlist	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:21
frozenlist-1.3.0a0-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:21
google	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:39
maxminddb	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:15
maxminddb-1.5.4-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:15
multidict	dir	-	root/root	drwxr-xr-x	2024-07-05 06:17:48
multidict-5.1.0-py3.8.egg-info	dir	-	root/root	drwxr-xr-x	2024-07-05 06:17:48
mysqlclient-2.0.1-py3.8.egg-info	dir	-	root/root	drwxr-xr-x	2024-07-31 07:29:38
playhouse	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:10
protobuf-3.17.3-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:09:39
psutil	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:21
psutil-5.8.0-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:21
pycares	dir	-	root/root	drwxr-xr-x	2024-07-05 06:17:48
pycares-4.1.2-py3.8.egg-info	dir	-	root/root	drwxr-xr-x	2024-07-05 06:17:48
pyrsistent	dir	-	root/root	drwxr-xr-x	2024-07-05 06:14:24
pyrsistent-0.14.11-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-07-05 06:14:24
pytricia-1.0.2-py3.8.egg-info	dir	-	root/root	drwxr-xr-x	2024-07-05 06:23:35
pyximport	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:52
pyzstd	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:14
pyzstd-0.15.2-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:10:14
yaml	dir	-	root/root	drwxr-xr-x	2024-07-05 06:23:48
yarl	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:08:31
yarl-1.1.1-py3.8.egg-info	dir	-	root/linksafe	drwxr-xr-x	2024-06-02 05:08:31
README.txt	text/plain	119 B	root/linksafe	-rw-r--r--	2022-12-06 06:59:58
_cffi_backend.cpython-38-x86_64-linux-gnu.so	application/x-pie-executable	180.11 KB	root/linksafe	-rwxr-xr-x	2022-10-19 01:38:53
_mysql.so	application/x-sharedlib	93.18 KB	root/linksafe	-rw-r--r--	2024-03-07 08:30:16
_pyrsistent_version.py	text/plain	24 B	root/linksafe	-rw-r--r--	2019-02-21 09:31:17
cython.py	text/plain	498 B	root/linksafe	-rw-r--r--	2022-10-19 12:25:11
peewee-2.8.4-py3.8.egg-info	text/plain	9.08 KB	root/linksafe	-rw-r--r--	2022-10-19 04:56:35
peewee.py	text/x-script.python	173.67 KB	root/linksafe	-rw-r--r--	2016-10-02 06:08:19
protobuf-3.17.3-py3.8-nspkg.pth	text/plain	539 B	root/linksafe	-rw-r--r--	2022-10-19 05:21:48
pvectorc.cpython-38-x86_64-linux-gnu.so	application/x-pie-executable	37.5 KB	root/linksafe	-rwxr-xr-x	2024-06-05 11:59:19
pwiz.py	text/x-script.python	6.8 KB	root/linksafe	-rw-r--r--	2022-10-19 04:56:22
pycrypto-2.6.1-py3.8.egg-info	text/plain	666 B	root/linksafe	-rw-r--r--	2022-10-19 07:32:50
pytricia.cpython-38-x86_64-linux-gnu.so	application/x-pie-executable	32.61 KB	root/root	-rwxr-xr-x	2024-06-05 12:01:50