`os.rename` only works if source and destination are on the same file system. You should use `shutil.move` instead.

I think rename only works when the source and target names are on the same file system. You probably have different mounts. Otherwise you get that error. You can implement the same effect with a copy and a delete.

Hope it helps

When making an auth request to the Google API (gapi), it&#39;s returning false on the checkOrigin.

I have removed any client id&#39;s or anything that would link directly to my account and replaced it with a regex indicating what the data is for reference.

Url: ```https://accounts.google.com/o/oauth2/iframerpc?action=checkOrigin&amp;origin=https%3A%2F%2Flocal.tools&amp;client_id=(\d{21})```

My origin url is a local url, which is `https://local.tools`

Result: `{valid: false}`

I&#39;m using the example found here without deviation (except for replacing clientid with my 21 digit clientid): https://ga-dev-tools.appspot.com/embed-api/third-party-visualizations/

The items I&#39;m trying to display show up nicely on the demo site, but aren&#39;t getting past the Not valid origin for the client error on my local.tools site.

Google API authentication: Not valid origin for the client

I&#39;m trying to call 

    parent.postMessage(obj, &#39;whatever&#39;);

 
from within an iframe and I&#39;m getting this error: `Uncaught DOMException: Failed to execute &#39;postMessage&#39; on &#39;Window&#39;: An object could not be cloned.`

Uncaught DOMException: Failed to execute &#39;postMessage&#39; on &#39;Window&#39;: An object could not be cloned

I&#39;m working with django 1.6.5 and python 2.7.
I have import feature in my app and I get error:

    OSError: [Errno 18] Invalid cross-device link

I have problem with this part of code:

    os.rename(db_temp, settings.DATABASES[&#39;bookmat&#39;][&#39;NAME&#39;])

code in settings:

    &#39;bookmat&#39;: {
        &#39;ENGINE&#39;: &#39;django.db.backends.sqlite3&#39;,
        &#39;NAME&#39;: &#39;/my_projects/book/db/bookmat.sqlite3&#39;,
    },



OSError: [Errno 18] Invalid cross-device link

I'm working with django 1.6.5 and python 2.7.
I have import feature in my app and I get error:
<pre><code class="hljs language-bash">OSError: [Errno 18] Invalid cross-device link
</code></pre>
I have problem with this part of code:
<pre><code class="hljs language-css">os.rename(db_temp, settings.DATABASES['bookmat']['NAME'])
</code></pre>
code in settings:
<pre><code class="hljs language-arduino">'bookmat': {
 'ENGINE': 'django.db.backends.sqlite3',
 'NAME': '/my_projects/book/db/bookmat.sqlite3',
},
</code></pre>

I have a `.tfrecord` but I don&#39;t know how it is structured. How can I inspect the schema to understand what the `.tfrecord` file contains?

All Stackoverflow answers or documentation seem to assume I know the structure of the file.

    reader = tf.TFRecordReader()
    file = tf.train.string_input_producer(&quot;record.tfrecord&quot;)
    _, serialized_record = reader.read(file)
    
    ...HOW TO INSPECT serialized_record...

How to inspect a Tensorflow .tfrecord file?

Is it possible to specify type of records in Django QuerySet with Python type hints? Something like `QuerySet[SomeModel]`?

For example, we have model:

    class SomeModel(models.Model):
        smth = models.IntegerField()

And we want to pass QuerySet of that model as param in func:

    def somefunc(rows: QuerySet):
        pass

But how to specify type of records in QuerySet, like with `List[SomeModel]`:

    def somefunc(rows: List[SomeModel]):
        pass

but with QuerySet?

How to use Python type hints with Django QuerySet?

Seems pretty Googleable but haven&#39;t been able to find something online that works.

I&#39;ve tried both `sns.boxplot(&#39;Day&#39;, &#39;Count&#39;, data= gg).title(&#39;lalala&#39;)` and `sns.boxplot(&#39;Day&#39;, &#39;Count&#39;, data= gg).suptitle(&#39;lalala&#39;)`. None worked. I think it might be because I&#39;m also working with matplotlib.

How to add title to seaborn boxplot

I have the following piece of code:

    imgs = glob.glob(&#39;/home/chipin/heart/tray.png&#39;)
    current_img = io.imread(imgs[0])
    cv2.imwrite(&#39;/home/chipin/heart/01.png&#39;, current_img[0:511,0:511])  


The size of picture is 512*512, after being saved, a blue picture turns yellow. It seems that a channel is abandoned. I really don&#39;t know why.

Here is the value of current_img:

[![value of current_img][1]][1]


  [1]: https://i.stack.imgur.com/abr5h.png

why cv2.imwrite() changes the color of pics?

I&#39;m beginning the automate the boring stuff book and I&#39;m trying to open a chrome web browser through python. I have already installed selenium and

 I have tried to run this file:

    from selenium import webdriver
    from selenium.webdriver.common.by import By
    from selenium.webdriver.common.keys import Keys
    
    browser = webdriver.Chrome()
    browser.get(&#39;https://automatetheboringstuff.com&#39;)

But because of that I get this Error:

&gt; 

    Traceback (most recent call last):   File &quot;C:\Program Files
       (x86)\Python36-32\lib\site-packages\selenium\webdriver\common\service.py&quot;,
     line 74, in start
         stdout=self.log_file, stderr=self.log_file)   File &quot;C:\Program Files (x86)\Python36-32\lib\subprocess.py&quot;, line 707, in __init__
         restore_signals, start_new_session)   File &quot;C:\Program Files (x86)\Python36-32\lib\subprocess.py&quot;, line 990, in _execute_child
         startupinfo) FileNotFoundError: [WinError 2] The system cannot find the file specified

 
During handling of the above exception, another exception occurred:

    Traceback (most recent call last):   File &quot;C:/Program Files
    (x86)/Python36-32/test.py&quot;, line 5, in &lt;module&gt;
        browser = webdriver.Chrome()   File &quot;C:\Program Files (x86)\Python36-32\lib\site-packages\selenium\webdriver\chrome\webdriver.py&quot;,
    line 62, in __init__
       self.service.start()   File &quot;C:\Program Files (x86)\Python36-32\lib\site-packages\selenium\webdriver\common\service.py&quot;,
    line 81, in start
       os.path.basename(self.path), self.start_error_message) selenium.common.exceptions.WebDriverException: Message: &#39;chromedriver&#39;
      executable needs to be in PATH. Please see
    https://sites.google.com/a/chromium.org/chromedriver/home



Python Selenium Chrome Webdriver

In [DRF][1], I can serialize a native Python object like this:

    class Comment(object):
        def __init__(self, email, content, created=None):
            self.email = email
            self.content = content
            self.created = created or datetime.now()

    class CommentSerializer(serializers.Serializer):
        email = serializers.EmailField()
        content = serializers.CharField(max_length=200)
        created = serializers.DateTimeField()

    comment = Comment(email=&#39;leila@example.com&#39;, content=&#39;foo bar&#39;)
    serializer = CommentSerializer(comment)
    serializer.data

    # --&gt; {&#39;email&#39;: &#39;leila@example.com&#39;, &#39;content&#39;: &#39;foo bar&#39;, &#39;created&#39;: &#39;2016-01-27T15:17:10.375877&#39;}

Is it possible to do the same for a list of objects using [`ListSerializer`][2]?
    


  [1]: http://www.django-rest-framework.org/api-guide/serializers/#listserializer/
  [2]: http://www.django-rest-framework.org/api-guide/serializers/#listserializer

Serializing a list of objects with django-rest-framework

This is a bleeding-edge feature that I&#39;m currently skewered upon and quickly bleeding out. I want to annotate a subquery-aggregate onto an existing queryset. Doing this before 1.11 either meant custom SQL or hammering the database. [Here&#39;s the documentation for this][1], and the example from it:

    from django.db.models import OuterRef, Subquery, Sum
    comments = Comment.objects.filter(post=OuterRef(&#39;pk&#39;)).values(&#39;post&#39;)
    total_comments = comments.annotate(total=Sum(&#39;length&#39;)).values(&#39;total&#39;)
    Post.objects.filter(length__gt=Subquery(total_comments))

They&#39;re *annotating* on the aggregate, which seems weird to me, but whatever.

I&#39;m struggling with this so I&#39;m boiling it right back to the simplest real-world example I have data for. I have `Carpark`s which contain many `Space`s. Use `Book→Author` if that makes you happier but —for now— I just want to annotate on a count of the related model using `Subquery`\*.

    spaces = Space.objects.filter(carpark=OuterRef(&#39;pk&#39;)).values(&#39;carpark&#39;)
    count_spaces = spaces.annotate(c=Count(&#39;*&#39;)).values(&#39;c&#39;)
    Carpark.objects.annotate(space_count=Subquery(count_spaces))

This gives me a lovely `ProgrammingError: more than one row returned by a subquery used as an expression` and in my head, this error makes perfect sense. The subquery is returning a list of spaces with the annotated-on total.

The example suggested that some sort of magic would happen and I&#39;d end up with a number I could use. But that&#39;s not happening here? How do I annotate on aggregate Subquery data?

## Hmm, something&#39;s being added to my query&#39;s SQL...

I built a new Carpark/Space model and it worked. So the next step is working out what&#39;s poisoning my SQL. On Laurent&#39;s advice, I took a look at the SQL and tried to make it more like the version they posted in their answer. And this is where I found the real problem:

&lt;pre&gt;&lt;code&gt;SELECT &quot;bookings_carpark&quot;.*, (SELECT COUNT(U0.&quot;id&quot;) AS &quot;c&quot;
FROM &quot;bookings_space&quot; U0
WHERE U0.&quot;carpark_id&quot; = (&quot;bookings_carpark&quot;.&quot;id&quot;)
GROUP BY U0.&quot;carpark_id&quot;&lt;strong&gt;, U0.&quot;space&quot;&lt;/strong&gt;
)
AS &quot;space_count&quot; FROM &quot;bookings_carpark&quot;;&lt;/code&gt;&lt;/pre&gt;

I&#39;ve highlighted it but it&#39;s that subquery&#39;s `GROUP BY ... U0.&quot;space&quot;`. It&#39;s retuning both for some reason. Investigations continue.

Edit 2: Okay, just looking at the subquery SQL I can see that second group by coming through ☹

    In [12]: print(Space.objects_standard.filter().values(&#39;carpark&#39;).annotate(c=Count(&#39;*&#39;)).values(&#39;c&#39;).query)
    SELECT COUNT(*) AS &quot;c&quot; FROM &quot;bookings_space&quot; GROUP BY &quot;bookings_space&quot;.&quot;carpark_id&quot;, &quot;bookings_space&quot;.&quot;space&quot; ORDER BY &quot;bookings_space&quot;.&quot;carpark_id&quot; ASC, &quot;bookings_space&quot;.&quot;space&quot; ASC

**Edit 3**: Okay! Both these models have sort orders. These are being carried through to the subquery. It&#39;s these orders that are bloating out my query and breaking it.

I guess this might be a bug in Django but short of removing the Meta-order_by on both these models, **is there any way I can *unsort* a query at querytime?**

---

&lt;sub&gt;\***I know I could just annotate a Count for this example**. My real purpose for using this is a much more complex filter-count but I can&#39;t even get this working.&lt;/sub&gt;


  [1]: https://docs.djangoproject.com/en/1.11/ref/models/expressions/#using-aggregates-within-a-subquery-expression

Django 1.11 Annotating a Subquery Aggregate

I have started to work on a Django project, and I would like to set some environment variables without setting them manually or having a bash file to source.

I want to set the following variables:

    export DATABASE_URL=postgres://127.0.0.1:5432/my_db_name
    export DEBUG=1
    # there are other variables, but they contain personal information

I have read [this][1], but that does not solve what I want. In addition, I have tried setting the environment variables in **Preferences**-&gt; **Build, Execution, Deployment**-&gt;**Console**-&gt;**Python Console**/**Django Console**, but it sets the variables for the interpreter.


  [1]: https://stackoverflow.com/questions/21538859/pycharm-set-environment-variable-for-run-manage-py-task

How to set environment variables in PyCharm?

I am working on Django project where I need to create a form for inputs. I tried to import `reverse` from `django.core.urlresolvers`. I got an error:

    line 2, in from django.core.urlresolvers import reverse ImportError: No module named &#39;django.core.urlresolvers&#39;

I am using Python 3.5.2, Django 2.0 and MySQL.

ImportError: No module named &#39;django.core.urlresolvers&#39;

So I&#39;ve been trying to do some database update with python and while setting up the whole dev environment, I came across these three things which made me dizzy.

 1. There&#39;s [MySQLdb][1]


 2. There&#39;s [mysqlclient][2]
 3. And then there&#39;s a [mysql connector python][3]

What&#39;s each of them, the difference and where to use them? Thanks

  [1]: http://mysql-python.sourceforge.net/MySQLdb.html
  [2]: https://pypi.python.org/pypi/mysqlclient
  [3]: https://dev.mysql.com/doc/connector-python/en/

What&#39;s the difference between MySQLdb, mysqlclient and MySQL connector/Python?

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to connect to a DB Server.

After install, I execute SSMS and it asks me to connect to a DB Server. I don&#39;t have any and I saw that it is possible to create a &quot;local&quot; db by typing only a dot &#39;.&#39; for Server Name and use Windows authentication. 

It is not working; how to do it?

How to connect to a local database in SQL Server Management Studio?

&quot;Contains&quot; in Entity Framework core should equivalent to the SQL %like% operator. Therefore &quot;Contains&quot; should be case insensitive however it is case sensitive! (at least in postgres????)

The following only outputs a result when the correct casing for keyword is used.

    context.Counties.Where(x =&gt; x.Name.Contains(keyword)).ToList();

What am I doing wrong?


Entity Framework core - Contains is case sensitive or case insensitive?

I&#39;m learning about microservices and I&#39;m gonna build a project with a microservices architecture.

The thing is, one of my team mates want to use one database for all services, sharing all tables so &quot;data doesn&#39;t get repeated&quot;, each service would be built with different frameworks and languages like django and rails which use very different ORM standards.

What would be the correct approach? Since I think working with one database would involve a lot of &quot;hacking&quot; the ORMs in order to make them work correctly.

Microservices with shared database? using multiple ORM&#39;s?

I am trying to write a simple app using Kotlin and [Room Persistence Library][1].
I followed [the tutorial][2] in the Android Persistence codelab. 

Here is my `AppDatabase` class in Kotlin:

    @Database(entities = arrayOf(User::class), version = 1)
    abstract class AppDatabase : RoomDatabase() {
        abstract fun userModel(): UserDao
    
        companion object {
            private var INSTANCE: AppDatabase? = null
            @JvmStatic fun getInMemoryDatabase(context: Context): AppDatabase {
                if (INSTANCE == null) {
                    INSTANCE = Room.inMemoryDatabaseBuilder(context.applicationContext, AppDatabase::class.java).allowMainThreadQueries().build()
                }
                return INSTANCE!!
            }
    
            @JvmStatic fun destroyInstance() {
                INSTANCE = null
            }
        }
    }

But when I tried to run the app, it crashes immediately.
Here is the crash log:

    Caused by: java.lang.RuntimeException: cannot find implementation for com.ttp.kotlin.kotlinsample.room.AppDatabase. AppDatabase_Impl does not exist
        at android.arch.persistence.room.Room.getGeneratedImplementation(Room.java:90)
        at android.arch.persistence.room.RoomDatabase$Builder.build(RoomDatabase.java:340)
        at com.ttp.kotlin.kotlinsample.room.AppDatabase$Companion.getInMemoryDatabase(AppDatabase.kt:19)
        at com.ttp.kotlin.kotlinsample.MainKotlinActivity.onCreate(MainKotlinActivity.kt:28)
        at android.app.Activity.performCreate(Activity.java:6272)
        at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1108)
        at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2387)
        at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2494)&#160;
        at android.app.ActivityThread.access$900(ActivityThread.java:157)&#160;
        at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1356)

It looks like the class `AppDatabase_Impl` wasn&#39;t autogenerated. I checked the original java app downloaded from codelab and found that `AppDatabase_Impl` was autogenerated.

Kotlin version: `1.1.2-3`  
Room version: `1.0.0-alpha1`

Is there anyone experienced with this?

**Edit:**
Using `kapt` solves my problem. In my case, I have to replace `annotationProcessor` with `kapt`.

  [1]: https://developer.android.com/topic/libraries/architecture/room.html
  [2]: https://codelabs.developers.google.com/codelabs/android-persistence

Android Room Persistence library and Kotlin

I recently installed version 2017.2 of IntelliJ IDEA. I would like to keep my settings from my old 2017.1 version. IntelliJ&#39;s [support site](https://www.jetbrains.com/help/idea/install-and-set-up-intellij-idea.html#r_Install_and_set_up__product_.xmld320216e288) shows the following dialog box that is supposed to show up when you run the newly installed version for the first time.

[![Complete Installation Dialog][1]][1]


  [1]: https://i.stack.imgur.com/gLJa2.png

However, neither when I was installing the new version, nor when I ran the new version for the first time, was I ever shown this dialog box. I attempted to import settings from my old version via  the `File | Import Settings` menu option, but it expects a `.jar` file that would have been exported from an old version by going to `File | Export Settings`, which I did not do in the old version before installing the new one.

I do still have all of the config from my old version in `%MY_HOME_DIR%/.IntelliJIdea2017.1`.
How can I import those settings in the same way that the above dialog box would have done had it shown up when I opened the new version for the first time?

IntelliJ - Import configuration from old version after first run

When I run tests I get the error &quot;Command line is too long&quot;.
 It works if I set the &quot;Shorten command line&quot; method in the Run/Debug configuration to &quot;JAR manifest&quot; for the specific method or class, but how do I set it for the whole project or is there an IDE global setting for it? 

How to configure &quot;Shorten command line&quot; method for whole project in IntelliJ

I&#39;ve been using VSCode a lot lately and have gotten used to the keys-shortcuts/key-bindings (Ctrl+D, Ctrl+P, Alt+leftArrow, etc). However I&#39;ve recently had some work where I needed to use regular Visual Studio (Microsoft Visual Studio Enterprise 2019) and it&#39;s painful remembering two different shortcut keys.

Is there a way to import VSCode key-shortcuts to into regular Visual Studio?

I&#39;ve looked at [this question][1] and there wasn&#39;t much help besides manually changing them one at a time.


UPDATE: now the above post answers the question now that I posed Francois du Plessis&#39;s answer there.

  [1]: https://stackoverflow.com/questions/51786288/how-to-import-vscode-keybindings-into-visual-studio

Content Type	Original Author	Original Content on Stackoverflow
Question	mark	View Question on Stackoverflow
Solution 1 - Python	butesa	View Answer on Stackoverflow
Solution 2 - Python	Tiago A.	View Answer on Stackoverflow

OSError: [Errno 18] Invalid cross-device link

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Uncaught DOMException: Failed to execute 'postMessage' on 'Window': An object could not be cloned

Google API authentication: Not valid origin for the client

Attributions