Yeah, you should use the `option` command. You can set options from the command line this way:

    //CMakeLists.txt
    option(MyOption &quot;MyOption&quot; OFF)

    //Command line
    cmake -DMyOption=ON MyProjectFolder

Note that `-DMyOption` must come before the path.


Just a little correction: 

If you have other variables to pass, it is recommended to indicate the type of these:
 
    //CMakeLists.txt
    option(MyOption &quot;MyOption&quot; OFF)

    //Command line
    cmake -DMyOption:BOOL=ON MyProjectFolder -D...


I have the following SQLAlchemy mapped classes:

    class User(Base):
        __tablename__ = &#39;users&#39;
        email = Column(String, primary_key=True)
        name = Column(String)

    class Document(Base):
        __tablename__ = &quot;documents&quot;
        name = Column(String, primary_key=True)
        author = Column(String, ForeignKey(&quot;users.email&quot;))

    class DocumentsPermissions(Base):
        __tablename__ = &quot;documents_permissions&quot;
        readAllowed = Column(Boolean)
        writeAllowed = Column(Boolean)

        document = Column(String, ForeignKey(&quot;documents.name&quot;))

I need to get a table like this for `user.email = &quot;user@email.com&quot;`:

    email | name | document_name | document_readAllowed | document_writeAllowed

How can it be made using one query request for SQLAlchemy? The code below does not work for me:

    result = session.query(User, Document, DocumentPermission).filter_by(email = &quot;user@email.com&quot;).all()

Thanks,

sqlalchemy: how to join several tables by one query?

Can someone give an example on how to use `NSCache` to cache a string? 
Or anyone has a link to a good explanation? I can&#39;t seem to find any..

How to use NSCache

I&#39;m building a large library using CMake, and I would like users to be able to selectively enable/disable certain parts of my build process.

How can I add command-line options to my CMake build, e.g. so that users may type something like `cmake --build-partone --nobuild-parttwo --dothis=true --dothat=false ..`?

Apparently the OPTION keyword will create variables that can be set from the CMake GUI, but I can&#39;t figure out how to do this from the command line.


Adding command line options to CMake

I'm building a large library using CMake, and I would like users to be able to selectively enable/disable certain parts of my build process.
How can I add command-line options to my CMake build, e.g. so that users may type something like <code>cmake --build-partone --nobuild-parttwo --dothis=true --dothat=false ..</code>?
Apparently the OPTION keyword will create variables that can be set from the CMake GUI, but I can't figure out how to do this from the command line.

I have a PowerShell script to add a website to a Trusted Sites in Internet Explorer:


    set-location &quot;HKCU:\Software\Microsoft\Windows\CurrentVersion\Internet Settings&quot;
    set-location ZoneMap\Domains
    new-item TESTSERVERNAME
    set-location TESTSERVERNAME
    new-itemproperty . -Name http -Value 2 -Type DWORD


I want to execute these PowerShell commands from a batch file. It seems simple when I have to run a single command, **BUT** in this case I have a sequence of related commands. I want to avoid creating a separate file for the PS script to be called from the batch - everything must be in the batch file.

The question is: How to execute PowerShell commands (or statements) from a batch file?

How to execute PowerShell commands from a batch file?

I&#39;m looking to run a Linux command that will recursively compare two directories and output **only** the file names of what is different. This includes anything that is present in one directory and not the other or vice versa, and text differences.

diff to output only the file names

How to pass argument to Makefile from command line?

I understand I can do

    $ make action VAR=&quot;value&quot;
    $ value

with `Makefile`

    VAR = &quot;default&quot;
    action:
        @echo $(VAR)

How do I get the following behavior?
 
    $ make action value
    value

How about

    $make action value1 value2
    value1 value2

How to pass argument to Makefile from command line?

How can I list all Java processes in bash?
I need an command line. I know there is command `ps` but I don&#39;t know what parameters I need to use.

List of Java processes

While having a cygwin installed in windows gives most of unix command, still i was wondering how to search multiple filetypes in one command using windows &quot;find&quot; command.  
ie:   `find . -name *.cpp -o -name *.h -o -name *.java`

The above command gives me a list of all cpp, h &amp; java, what will be the equivalent using the windows find?

Windows equivalent for Unix find command to search multiple file types

I do `cmake . &amp;&amp; make all install`. This works, but installs to `/usr/local`.

I need to install to a different prefix (for example, to `/usr`).

What is the `cmake` and `make` command line to install to `/usr` instead of `/usr/local`?



What is CMake equivalent of &#39;configure --prefix=DIR &amp;&amp; make all install &#39;?

I set the CFLAGS in CMake by CMAKE_C_FLAGS.
Is something like this to set LDFLAGS?

How to set the LDFLAGS in CMakeLists.txt?

I have reached the end of my rope with CMake; it has so much potential, but I cannot seem to make it find the basic system tools (i.e. `make`) in order to function.

SYMPTOMS
--------

CMake and the CMake GUI produce the following (after deleting the CMakeCache.txt file):
 
    Processing top-level CMakelists.txt for project swb
    CMake Error: CMake was unable to find a build program corresponding to &quot;MinGW Makefiles&quot;.
    CMAKE_MAKE_PROGRAM is not set.  You probably need to select a different build tool.

I am focusing on finding `make` in this question, however, I&#39;ve also had many of the same issues with CMake failing to find libraries and other utility files (linker, nm, ar, etc.). The techniques I list below seem to enable CMake to find these files when running under Linux.

SYSTEM
------

Windows 7 (64-bit); multiple versions of MinGW (32-bit/64-bit); Cmake 2.8.4;
NONSTANDARD install location for MinGW (c:/MinGW-32 ).

THINGS I HAVE TRIED
-------------------

1. CMakelists.txt contains `SET( CMAKE_MAKE_PROGRAM c:/MinGW-32/bin/make.exe FORCE )` within the first 10 lines of the file.

2. Previous versions of CMakelists.txt contained:

        find_program(CMAKE_MAKE_PROGRAM
          NAMES make
                make.exe
          DOC &quot;Find a suitable make program for building under Windows/MinGW&quot;
          HINTS c:/MinGW-32/bin )  
3. Set `CMAKE_MAKE_PROGRAM` in a cmd.exe environment variable prior to running either CMake or CMake-GUI.

4. Use of a &quot;toolchain&quot; file which identifies `CMAKE_MAKE_PROGRAM` as well as `CMAKE_C_COMPILER`, etc.

ONE THING THAT HAS WORKED
-------------------------

CMake will successfully create build files IF I use the GUI to populate the `CMAKE_MAKE_PROGRAM` variable (&quot;C:/MinGW-32/bin/make.exe&quot;).

QUESTION(S)
-----------

I can get CMake to work if I identify the name of the make program via the GUI. *How does one enable CMake to find my make program without user intervention with the Windows 7 (64-bit) / MinGW combination?*






CMAKE_MAKE_PROGRAM not found

I want to generate Makefile with install target, making installation to /usr instead of default /usr/local. Assuming that build directory is done in the source subdirectory, I execute:

`cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr ..`

CMakeCache.txt contains: `CMAKE_INSTALL_PREFIX:PATH=/usr` (OK?)

Now I execute:
&lt;pre&gt;
make
make install
&lt;/pre&gt;

All files are still installed to usr/local. What is wrong?

Edit:
There is no CMAKE_INSTALL_PREFIX in any of CMakeLists.txt project files. 
Before running cmake, I delete everything from the output directory.
install directives in CMakeLists.txt look like: 

`install(TARGETS mylibrary DESTINATION lib)`

How to use CMAKE_INSTALL_PREFIX

I am trying to use ExternalProject_add() to download/install dependencies. It installs fine, but I can&#39;t figure out how to actually link the libraries after they are downloaded. 

I want to call target_link_libraries() on the library that was just downloaded, but the path to the library will vary by system. 

If this were a system dependency, I could just call find_package() - but the packages weren&#39;t installed on the default search path. I don&#39;t think you can specify a search path for find_package in module mode. 

Here&#39;s a snippet of my CMakeLists.txt that doesn&#39;t work: 

    ExternalProject_Add(
	protobuf
	URL http://protobuf.googlecode.com/files/protobuf-2.4.1.tar.gz
	CONFIGURE_COMMAND &lt;SOURCE_DIR&gt;/configure --prefix=&lt;INSTALL_DIR&gt;
	PREFIX ${MYPROJ_SOURCE_DIR}/dependencies
    )
    find_package(protobuf REQUIRED)
    set(LIBS ${LIBS} ${PROTOBUF_LIBRARIES})
    target_link_libraries (mybinary ${LIBS})



Content Type	Original Author	Original Content on Stackoverflow
Question	rcv	View Question on Stackoverflow
Solution 1 - Command Line	beduin	View Answer on Stackoverflow
Solution 2 - Command Line	guilloptero	View Answer on Stackoverflow

Adding command line options to CMake

Command Line Problem Overview

Command Line Solutions

Solution 1 - Command Line

Solution 2 - Command Line

How to use NSCache

sqlalchemy: how to join several tables by one query?

Attributions