a.any() == 0:

This code checks if any element in a is equal to 0. If there is at least one element that is equal to 0, the function returns True. Otherwise, it returns False.

相关问题

d:\vbcentos7>vagrant up Bringing machine 'default' up with 'virtualbox' provider... ==> default: Clearing any previously set forwarded ports... ==> default: Clearing any previously set network interfaces... ==> default: Preparing network interfaces based on configuration... default: Adapter 1: nat default: Adapter 2: hostonly ==> default: Forwarding ports... default: 22 (guest) => 2222 (host) (adapter 1) ==> default: Booting VM... There was an error while executing `VBoxManage`, a CLI used by Vagrant for controlling VirtualBox. The command and stderr is shown below. Command: ["startvm", "2e091b45-6af1-43e0-ae0f-a59caad94d44", "--type", "headless"] Stderr: VBoxManage.exe: error: The VM session was closed before any attempt to power it on VBoxManage.exe: error: Details: code E_FAIL (0x80004005), component SessionMachine, interface ISession

根据你提供的信息，Vagrant 在启动 VirtualBox 虚拟机时遇到了错误。错误信息中提到了 VM session was closed before any attempt to power it on，可能是因为 VirtualBox 无法正常启动虚拟机。

解决该问题可以尝试以下几个步骤：

1. 检查 VirtualBox 版本：确保 VirtualBox 已经安装，并且版本号与 Vagrant 兼容。可以在命令行中输入 `vboxmanage -v` 查看版本号。

2. 升级 VirtualBox：如果 VirtualBox 版本过低，可以尝试升级到最新版本。可以在 VirtualBox 官网下载最新版本。

3. 检查虚拟机配置：检查 Vagrantfile 文件中的虚拟机配置是否正确，并且没有与已经存在的虚拟机冲突。可以使用 VirtualBox 管理界面查看已经存在的虚拟机列表。

4. 清除虚拟机缓存：如果 VirtualBox 虚拟机曾经启动过，可以尝试清除虚拟机缓存，然后重新启动。可以在 VirtualBox 管理界面中选择虚拟机，点击右键，选择 “移除和删除所有文件”。

希望这些步骤可以帮助你解决问题。如果问题仍然存在，可以提供更多详细的错误信息，以便我们更好地帮助你。

你能把pg视图改为sqlserver的视图吗 SELECT c.relname AS table_name, a.attname AS column_name, d.description AS column_comment, CASE WHEN a.attnotnull AND con.conname IS NULL THEN 1 ELSE 0 END AS is_required, CASE WHEN con.conname IS NOT NULL THEN 1 ELSE 0 END AS is_pk, a.attnum AS sort, CASE WHEN "position"(pg_get_expr(ad.adbin, ad.adrelid), ((c.relname::text || '_'::text) || a.attname::text) || '_seq'::text) > 0 THEN 1 ELSE 0 END AS is_increment, btrim( CASE WHEN t.typelem <> 0::oid AND t.typlen = '-1'::integer THEN 'ARRAY'::text ELSE CASE WHEN t.typtype = 'd'::"char" THEN format_type(t.typbasetype, NULL::integer) ELSE format_type(a.atttypid, NULL::integer) END END, '"'::text) AS column_type FROM pg_attribute a JOIN (pg_class c JOIN pg_namespace n ON c.relnamespace = n.oid) ON a.attrelid = c.oid LEFT JOIN pg_description d ON d.objoid = c.oid AND a.attnum = d.objsubid LEFT JOIN pg_constraint con ON con.conrelid = c.oid AND (a.attnum = ANY (con.conkey)) LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid WHERE (c.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND a.attnum > 0 AND n.nspname = 'public'::name ORDER BY c.relname, a.attnum

抱歉，我无法将此查询转换为SQL Server的视图。这是因为该查询涉及到了一些PostgreSQL特定的函数和表达式，这些在SQL Server中并不存在。你可能需要手动重新编写查询以适应SQL Server的语法和函数。以下是一个可能的SQL Server等效查询的示例，供参考：

SELECT 
    t.name AS table_name,
    c.name AS column_name,
    CAST(ep.value AS NVARCHAR(MAX)) AS column_comment,
    CASE
        WHEN c.is_nullable = 0 AND pk.constraint_column_id IS NULL THEN 1
        ELSE 0
    END AS is_required,
    CASE
        WHEN pk.constraint_column_id IS NOT NULL THEN 1
        ELSE 0
    END AS is_pk,
    c.column_id AS sort,
    CASE
        WHEN COLUMNPROPERTY(c.object_id, c.name, 'IsIdentity') = 1 THEN 1
        ELSE 0
    END AS is_increment,
    CASE
        WHEN t.name = 'varchar' AND c.max_length <> -1 THEN t.name + '(' + CAST(c.max_length AS NVARCHAR(MAX)) + ')'
        WHEN t.name = 'nvarchar' AND c.max_length <> -1 THEN t.name + '(' + CAST(c.max_length / 2 AS NVARCHAR(MAX)) + ')'
        ELSE t.name
    END AS column_type
FROM sys.tables t
INNER JOIN sys.columns c ON t.object_id = c.object_id
LEFT JOIN sys.extended_properties ep ON ep.major_id = t.object_id AND ep.minor_id = c.column_id AND ep.name = 'MS_Description'
LEFT JOIN sys.indexes i ON t.object_id = i.object_id AND i.is_primary_key = 1
LEFT JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id AND c.column_id = ic.column_id
LEFT JOIN sys.key_constraints pk ON t.object_id = pk.parent_object_id AND ic.index_column_id = pk.unique_index_id
WHERE t.type = 'U'
AND SCHEMA_NAME(t.schema_id) = 'dbo'
ORDER BY t.name, c.column_id

请注意，这只是一个示例查询，具体取决于你的数据库结构和需求，你可能需要进行一些调整和修改。建议在转换之前备份你的数据库，以防出现意外情况。