MySQL: Computed Column

I'm just started using SQL and ran into a problem. In my database, I presently have two tables, Cinemas and Theatres. I'm trying to create a column "# of Theatres# in the Cinemas table that...

Figure out if a business name is very similar to another one - Python

I'm working with a large database of businesses. I'd like to be able to compare two business names for similarity to see if they possibly might be duplicates. Below is a list of business names...

How to define a dynamic mixin or function name in SASS?

I want to dynamically create mixins in SASS, named after each item in the list, but it doesn't seem to work. I tried this but I get an error: $event-icons: fair, concert, art-show, conference,...

Rails: Invalid byte sequence in US-ASCII (Argument Error) when I run rake db:seed

When I run rake db:seed in my Rails app, I'm getting this error: invalid byte sequence in US-ASCII (Argument Error) I just added science_majors and down to my seed file, and now when I run rake...

Database for Movie ShowTime

I create one database that is theatre. In that Movie,Cinemas tables are created, but now i want to create showtime table in my database so i have confusion that how to make that table,how many...

Code works fine locally, but runtime error in Codeforces?

I was trying to do the first problem in codeforces just to be familiar with it. It gives results when I try it on my Ipython notebook, but always gives runtime error when I upload it on...

List comprehension, check if item is unique

I am trying to write a list comprehension statement that will only add an item if it's not currently contained in the list. Is there a way to check the current items in the list that is currently...

customizing multiple author affiliations in Orgmode for latex export using package authblk

I have this setup in my Orgmode doc and it doesnt export the author affiliations to latex or pdf. Instead I get a heuristic 'immediate' in place of authors I have added Latex to Org -babel-Load...

Attempt to invoke interface method 'int android.database.Cursor.getCount()' on a null object reference

I do have a problem that gives me a headache. I store some images of my city in the sqlite database via a custom content provider. However when I run my app I get a null cursor. Caused by:...

How to create custom dialog with cardview in android

I want to create a custom dialog in my app with the cardview. Searched on Google and implemented the same but did not got the expected result. So can anyone help me out in implementing it. The...

WikiData, locating entities with a specific type or subtype, located in a specific city

My Specific problem is that I have a place called "Beacon Theater". What I want to find is the best match for this in Wikidata. A Wikidata Search will give me three results: Live at the Beacon...

Rotate Strip Text in ggplot2

I'm having a hard time figuring out how to rotate the strip.text attribute in theme from ggplot2. I'm using R version 3.4.2 and ggplot2 version 2.2.1. Below is the data for the MWE. >...

"Multiple Upload" with VichUploaderBundle on Symfony 3

I try to allowed the multiple upload with the bundle VichUploader. On the project, i have a class Theater which own a main image but also a number of secondary images (Collection of images)....

Querying nested attributes in Dynamodb

How can I efficiently query on nested attributes in Dynamodb? I have a document structure as below, which lets me store related information in the document itself (rather than referencing it). It...

Deploying to heroku: Invalid end points

I am deploying my app to heroku , i followed all steps as they instruct in their doc for deployment, when I run the app I get the following error in browser: Invalid End point Here is my...

Seat Map Layout using Flutter

I have a problem in creating theatre seat map layout using Flutter. I need the seat arrangement to be scrollable, selectable.

How to getText from the Toggle Button in javafx

I am new to JavaFX. I'm working on the movie booking project. I have tried to retrieve the text from toggle button after looping it, but I don't see the getText() method. Is there any way to get...

How get elements from an ArrayList based by multiple conditions?

I'm creating an interface that manage the booking of Cinema tickets in different weeks/theatres. I have a Film Class: public class Film { private String title; private Double price; private...

where and how to apply a filter in a ggplot

I have a set of data called 'theatres' I have prepared a box plot of all the data with this code: There is a column in the data called 'sector' and the data within this column is set to either...

How do I set up correctly cloudinary for Netlify CMS?

I'm trying to set up Cloudinary in for my Gatsby.js blog using Netlify.cms What I want is to be able to have a widget in the CMS that allows me to select multiple images to add to a "gallery"...

Problem with getting Instagram hashtag json without api into google sheets

I'm trying to get a hashtag JSON back from Instagram to google sheets. I get the JSON if I put the URL in a browser but not using google sheets script (it used to work in the past). This is my...

Solving code-forces "1A Theatre Square" in C

novice programmer here trying to get better at C, so i began doing code problems on a website called codeforces. However i seem to be stuck, i have written code that appears to work in practice...

DeprecationWarning: use options instead of chrome_options error using ChromeDriver and Chrome through Selenium on Windows 10 system

Trying to run this code on my windows 10 machine https://github.com/KalleHallden/reddit_automations/blame/master/movie-tickets.py from selenium import webdriver from selenium.webdriver.common.keys...

How to use DataLoader for Connections with Hot Chocolate GraphQL

I see that it's possible to use Data Loaders for root queries, but is it also possible to use Data Loaders for nested connections? In the example below, I want use a Data Loader for the rooms...

How to sort with case insensitive without changing the settings

My index name is data_new Below is the code to insert into index test = [ {'id':1,'name': 'A', 'professor': ['Bill Cage', 'accounting']}, { 'id':2, 'name': 'AB', 'professor': ['Gregg...

Rust union usage features

I am working on my university homework. The task is to sort data in structure with variant field (union). We usually use C, but I decided to try Rust and faced a problem/ I can't understand how to...

Flask: BadRequestKeyError: 400 Bad Request: The browser (or proxy) sent a request that this server could not understand

I have created an edit view for my birthday reminder application and having previously worked, whenever I link to this edit view I receive a key error. I've checked the object being returned by...

Flask-SocketIO message queue using pubsub?

Super new programmer here! Have just been learning it this year to support some performances (the theatre industry's gotta pivot!). I have been really appreciating the amount of resources and...

LAB: Sorting TV Shows (dictionaries and lists)

I have used Pycharm to help me correct this issue. I have tried to put a specific range. I was considering user count +=1 every time something was print but couldn't get it into the code without...

ValueError: Incompatible indexer with Series when trying to add rows dynamically in the dataframe

I am very new to Python and am trying to understand how this piece of code is adding rows to the dataframe dynamically. But upon trying I am observing issue ValueError: Incompatible indexer with...