Tag: H

Using query function with (matches) empty cell

Post author By Math Dev
Post date January 20, 2021
No Comments on Using query function with (matches) empty cell

=query(A1:S10,"select C,D,E,F,H,K,P,R,S WHERE Q=’USA’ AND R matches ‘Florida|NY|”’ I would like to add (or empty cell) to the ‘Florida|NY’ That is to say I would like to select rows with the Q= ‘USA’ and R matches either ‘Florida’,’NY’ or empty

Tags 'NY' or empty, "Select C, =query(A1:S10, d, e, f: '' }, H, K, P, r, S WHERE Q='USA' AND R matches 'Florida|NY|''' I would like to add (or empty cell) to the 'Florida|NY' That is to say I would like to select

Mastering Development

How do I select columnA columnB from table where columnA is not in the set of records and display those rows having columnA not in the set of records

Problem Summary The title is as syntactically identical to my target relational database management system (RDBMS) as possible, but I want to find a solution. Question How do I select two columns from a result of a join query, then use a where clause to display those results from the join also displaying the non […]

Tags `columna` char(5) NOT NULL, `columnb` date, `columnc` date ) DEFAULT CHARSET=utf8; INSERT INTO `tableb` (`col1`, `columnc`) VALUES ('a', '2020-01-01', '2020-01-01' as columnb, '2020-01-01' as columnc) `t10`) desired; Actual Query: SELECT columna, '2020-01-01' as columnc) `t2` union select * from (select 'val03' as columna, '2020-01-01' as columnc) `t3` union select * from (select 'val04' as columna, '2020-01-01' as columnc) `t4` union select * from (select 'val05' as columna, '2020-01-01' as columnc) `t5` union select * from (select 'val06' as columna, '2020-01-01' as columnc) `t6` union select * from (select 'val07' as columna, '2020-01-01' as columnc) `t7` union select * from (select 'val08' as columna, '2020-01-01' as columnc) `t8` union select * from (select 'val09' as columna, '2020-01-01' as columnc) `t9` union select * from (select 'val10' as columna, '2020-01-01'); CREATE TABLE IF NOT EXISTS `tablea` ( `col1` char(2) NOT NULL ) DEFAULT CHARSET=utf8; INSERT INTO `tablea` (`col1`) VALUES, 'val01', 'val02', 'val03', 'val04', 'val05', 'val06', 'val07', 'val08', 'val09', 'val10', 'val10') /* Presently: Using NOT IN returns 0, "columnA", "ColumnB", ('j'); Expected Result Query: select desired.columna, alongside the join results, B, but I want to find a solution. Question How do I select two columns from a result of a join query, but if desired can be added to question details), but on analysis, c--, columnc as null */ GROUP BY b.columna, columnc FROM tablea a, d, desired.columnb, desired.columnc from (select * from (select 'val01' as columna, e, f: '' }, find_in_set("b.columna", g, H, i, I want to also display the rows from the set of the NOT IN clause based upon, j, leading to a much more records than possible, null as columnb, null as columnc) `t1` union select * from (select 'val02' as columna, Problem Summary The title is as syntactically identical to my target relational database management system (RDBMS) as possible, tableb b # inner join WHERE a.col1 = b.col1 # on a.col1 = b.col1 AND b.columna NOT IN ('val01', that are not in the result set of the join, the primary issue lies in the misuse of my filter on join, then use a where clause to display those results from the join also displaying the non matching rows from the set of my in clause that have, val10") # find_in_set is here to adhere to original order of a.col1 SQL Fiddle http://sqlfiddle.com/#!9/2c98a7/27, which does not include the few missing records on columnA. What results get produced Result of the query below (in specific form) produces, which would show columnb

Raspberry Pi User Help

Using a toggle switch to turn the Pi on and off

Post author By How To
Post date January 20, 2021
No Comments on Using a toggle switch to turn the Pi on and off

I’d like to use a toggle switch to turn the pi on and off. I wrote a little code that works fine. But im not sure if this is the right way to do it. So my question is, is there a better/right way or is this just fine? import RPi.GPIO as GPIO import subprocess […]

Tags GPIO.IN) While True: if GPIO.input(5) == True: subprocess.call(['shutdown', H, I'd like to use a toggle switch to turn the pi on and off. I wrote a little code that works fine. But im not sure if this is the right way to, is there a better/right way or is this just fine? import RPi.GPIO as GPIO import subprocess GPIO.setmode(GPIO.BOARD) GPIO.setup(5, now, shell=False

Mastering Development

Label in the same position regardless of platform and resolution

Post author By Full Stack
Post date January 19, 2021
No Comments on Label in the same position regardless of platform and resolution

I’m trying to show a Label in the same position, regardless of screen resolution and platform, using LibGDX. On desktop I see it in the right position but on Android it is in the wrong position. How can I do? MyGdxGame.java (core): import com.badlogic.gdx.ApplicationAdapter; import com.badlogic.gdx.Gdx; import com.badlogic.gdx.InputProcessor; import com.badlogic.gdx.graphics.Color; import com.badlogic.gdx.graphics.GL20; import com.badlogic.gdx.graphics.OrthographicCamera; import […]

Tags -1f), -hTot), (heightPixel/2f)-heightPixel1Card); labelStart.setAlignment(Align.left); labelStart.setWrap(false); labelStart.setCol, 0, 0); cam.update(); viewport.update(width, 1 / 30f)); stage.draw(); } public static class CardActions { Pool actionPool = new Pool() {, 1); Gdx.gl.glClear(GL20.GL_COLOR_BUFFER_BIT | GL20.GL_DEPTH_BUFFER_BIT); drawCoordsDebug(); actions.update(delta);, 10); cam.lookAt(0, 1080 x 1920, 1f); for(float w = 0; w >= -wTot; w--) { shapeRenderer.line(new Vector2(w, 216/255f, 219/255f, adParams); layout.setKeepScreenOn(true); setContentView(layout); } protected Handler handler = new Handler(), alpha); card.angle = fromAngle + alpha * (toAngle - fromAngle); card.update(); } } @Override pub, Android 6.0.1): I already searched on Google and Stack Overflow, but I didn't found a working solution for my code. Ps. I started with the code of xoppa (see here) and its tutorial Thanks a lot!, cam); Gdx.input.setInputProcessor(this); actions = new CardActions(); vector3touch = new Vector3(); stage, config); } @Override public void showAds(boolean show) { } } AndroidLauncher.java: import android.os.Bundle; import an, false); Label.LabelStyle labelStyleDistanceField = new Label.LabelStyle(); labelStyleDistanceField.font = fontDistanceField;, FloatAttribute.createAlphaTest(0.2f)); cards = new CardBatch(material); cam = new OrthographicCamera(MINIMUM_VIEWPORT_SIZE, Gdx.graphics.getDeltaTime()); Gdx.gl.glClearColor(167/255f, Gdx.graphics.getWidth() * CARD_RATIO_W_H)); Texture texture = new Texture(Gdx.files.internal("arial32.png"), H, h)); } for(float h = 0; h <= hTot; h++) { shapeRenderer.line(new Vector2(-wTot, h)); } shapeRenderer.end(); } @Override public void dispose () { modelBatch.dispose(); atlas.dis, height); } @Override public boolean keyDown(int keycode) {return false; } @Override public boolean keyUp(int keycode) {r, height); stage.getViewport().update(width, heightPixel1Card); labelStart.setPosition(widthPixel/2-widthPixel1Card*1.5f, hTot)); } for(float h = 0; h >= -hTot; h--) { shapeRenderer.line(new Vector2(-wTot, hTot)); } for(float w = 0; w <= wTot; w++) { shapeRenderer.line(new Vector2(w, I'm trying to show a Label in the same position, initializationStatus -> { }); // Create and setup the AdMob view mAdView = new AdView(this); mAdView.setAdSi, int button) { return false; } @Override public boolean touchUp(int screenX, int button) {return false; } @Override public boolean touchDragged(int screenX, int height) { cam.position.set(0, int pointer, int pointer) {return false; } @Override public boolean mouseMoved(int screenX, int screenY, int screenY) {return false; } @Override public boolean scrolled(int amount) {return false; } public void drawCoordsDebug() {, labelStyleDistanceField); labelStart.setSize(widthPixel/2, MINIMUM_VIEWPORT_SIZE * CARD_RATIO_W_H, MINIMUM_VIEWPORT_SIZE * CARD_RATIO_W_H); viewport = new FitViewport(MINIMUM_VIEWPORT_SIZE, new BlendingAttribute(false, new TextureRegion(texture), new Vector2(w, new Vector2(wTot, regardless of screen resolution and platform, RelativeLayout.LayoutParams.WRAP_CONTENT); adParams.addRule(RelativeLayout.ALIGN_PARENT_BOTTOM); adParams.addRule(RelativeLay, Texture.TextureFilter.Linear); // linear filtering in nearest mipmap image BitmapFont fontDistanceField = new BitmapFont(Gdx.files.in, true); // true enables mipmaps texture.setFilter(Texture.TextureFilter.MipMapLinearNearest, true); actionPool.free(action); } public void update(float delta) { for (CardAction action : actions, using LibGDX. On desktop I see it in the right position but on Android it is in the wrong position. How can I do? MyGdxGame.java (core):, window at 640 x 480): On Android (Samsung galaxy, WindowManager.LayoutParams.FLAG_FULLSCREEN); getWindow().clearFlags(WindowManager.LayoutParams.FLAG_FORCE_NOT_FULLSCREEN); /

Mastering Development System & Network

Enabling MySQL authentication for proftpd

Post author By Server Questions
Post date January 19, 2021
No Comments on Enabling MySQL authentication for proftpd

I am trying to use MySQL authentication for proftpd. I have configured everything and the authentication is working fine. The issue I am facing is that there is another database already being used for logs. So during the authentication time, the database user for the authentication is trying to write data to log database. proftpd[234014] […]

Mastering Development

How to add padding in custom switch compat in android?

Post author By Full Stack
Post date January 19, 2021
No Comments on How to add padding in custom switch compat in android?

I am trying to implement a custom switch compat and I am referencing another stackoverflow answer: How to set width and track text in a Switch/SwitchCompat button and achieve this result? (Image and GIF attached) My code is almost identical to this other than small updates. class SwitchCompatEx : SwitchCompat { companion object { val […]

Tags 0, 0) } override fun draw(canvas: Canvas) { super.draw(canvas) drawLabel(canvas, attrs, attrs: AttributeSet, attrs: AttributeSet) : super(context, attrs) constructor(context: Context?, bounds: Rect, defStyleAttr: Int) : super(context, defStyleAttr) init { background = null trackDrawable = TrackDrawable() thumbDrawable = ThumbDrawable() } override fun onSizeCha, H, h: Int, h) (thumbDrawable as GradientDrawable).setSize(w / 2, h) } inner class TrackDrawable : GradientDrawable() { private val textOffBounds = Rect() private val textOnBounds = Rect() ini, I am trying to implement a custom switch compat and I am referencing another stackoverflow answer: How to set width and track text in a Switc, oldh: Int) { super.onSizeChanged(w, oldh) (trackDrawable as GradientDrawable).setSize(w, oldw, oldw: Int, paint: Paint, paint) } private inline val Float.sp2Px get() = TypedValue.applyDimension(TypedValue.COMPLEX_UNIT_SP, Resources.getSystem().displayMetrics) } private val trackLabelPaint = Paint().apply { isAntiAlias = true textSize = TRACK_LABEL_SIZE, Resources.getSystem().displayMetrics) private inline val Float.dp2Px get() = TypedValue.applyDimension(TypedValue.COMPLEX_UNIT_D, tb.left, tb.top, text: CharSequence?) { text ?: return val tb = RectF(); tb.right = paint.measureText(text, text.length) tb.bottom = paint.descent() - paint.ascent() tb.left += bounds.centerX() - tb.centerX() tb.top += bounds, textOff) drawLabel(canvas, textOffBounds, textOn) } } inner class ThumbDrawable : GradientDrawable() { private val thumbLabelBounds = Rect() init { setColor(THU, textOnBounds, this, thumbLabel) } } } I am trying to put padding between the thumb view and gray borders. How can I achieve that view? This is what I want, thumbLabelBounds, thumbLabelPaint, TRACK_STROKE_COLOR) } override fun onBoundsChange(r: Rect) { super.onBoundsChange(r) cornerRadius = r.height() / 2f, trackLabelPaint

Mastering Development System & Network

Enabling MySQL authentication for proftpd

Post author By Server Questions
Post date January 18, 2021
No Comments on Enabling MySQL authentication for proftpd

Arduino Ask Engineering

Run multiple function with different argument/return structure by one function pointer

Post author By Marcia D.
Post date January 15, 2021
No Comments on Run multiple function with different argument/return structure by one function pointer

I’m working on a project where I want to develop a small FSM code, and where I want to run the project with one switch function, I need a function pointer to run whatever function is called. Now, I started to assign functions to the function pointer, but I get a warning of incompatible pointer […]

Tags 'IW'), "w", } // to disable triggering this check if(y_axis == y_pre){ // if you reach end of l, 12:25 AM Project specs: This is the source file of the lcd128x64 based ST7920 using SPI interface with, 5); lcd_state = CMD; cmd_state = LCD_INIT; counts = 5; counter = 0;, and fetch it in the lcd128x64_manager that holds the main functions of the LCD, and where I want to run the project with one switch function, block_pre; static uint16_t p_pre; uint8_t p_hi, but I get a warning of incompatible pointer type. What to do now ? This is my .cpp file. The problems I get are of course at the beginning, but it's not improved yet, cmd_state; // basic write variables static uint8_t y, cmd], const char *str){ // row1: 80H~8FH // row2: 90H~9FH // row3: 88H~AFH // row4: 98H~BFH if(!lock){ lcd_state = CMD; if(grap, counter: '', Counts, DATA }; LCD_STATES lcd_state; //////////////////////////////////////////////////////////////////////////////////////////// // delay variable, delay_period; bool dly_lock, DISPLAY_CLEAR, DISPLAY_CONTROL, div; h = y1 - y0; w = x1 - x0; if(w>h){ div = w/h; for(ih=y0, ENTERY_MODE, graphics; // pixel variables static uint8_t y_pre, H, HIGH); dly_period = 40000; lcd_state = LCD128x64_INIT_CMD; dly_lock = 1; dly_, I have to take out the parts of the lcd initialization and but that in another place. /* Project name: lcd128x64 Author:, I need a function pointer to run whatever function is called. Now, I started to assign functions to the function pointer, I'm working on a project where I want to develop a small FSM code, ih); if((ih%div)==(div-1)){iw++;} } } }, ih); if((iw%div)==(div-1)){ih++;} } } else{ div = h/w; for(ih=y0, init_set, iw=x0;ih<y1;ih++){ lcd128x64_pixel_set(iw, iw=x0;iw<x1;iw++){ lcd128x64_pixel_set(iw, j, LCD128x64_CIRCLE, LCD128x64_CLR, LCD128x64_CS_HI, LCD128x64_IMG, LCD128x64_INIT_CMD, LCD128x64_LINE, LCD128x64_PIXEL, lock; bool write_lock; static uint8_t i, LOW); // disable CS_PIN SPI.begin(); dly_period = 100000; lcd_state, OUTPUT); digitalWrite(CS_PIN, OUTPUT); pinMode(CLK_PIN, OUTPUT); pinMode(MOSI_PIN, p_bit; // string variables const char *str_ptr; const char *str1 = {"hi how are you ?"}; // function pointers void (*fun_ptr)(void); /////, p_block, p_lo, p_pos, pixel_draw_flag, RETURN_HOME}; memcpy(task_buffer, str_counts, str_ptr); } } break; case DATA: if(counter < counts){, task_buffer[16]; static bool row32_64, uint8_t col, uint8_t col){ if(!lock){lcd_state = CMD;} if (row == 1){task_buffer[0] = (0x80 + (col - 1));} else if (row == 2){task_buffer, uint8_t x0, uint8_t x1){ uint8_t ih, uint8_t y_axis){ if(!lock){ lcd_state = CMD; if(!graphics){lcd128x64_graphics_set_mode(1);} fun_ptr = &lcd128x, uint8_t y_axis){ if(!lock){ lcd_state = CMD; if(!graphics){lcd128x64_graphics_set_mode(1);} fun_ptr = &lcd128x64_, uint8_t y1, X, y_pre = y_axis; // copy new row position p_pre = 0; // clear global buffer p_pre = p_buf

Mastering Development

How do I improve the number detection for blueprints (OCR)

Post author By Full Stack
Post date January 15, 2021
No Comments on How do I improve the number detection for blueprints (OCR)

I have a number of blueprints where I would like to detect the numbers on the blueprint such that I can turn them into proper models. for example I have the following image and would like all the numbers on this image so I ran the following code: import pytesseract from pytesseract import Output import […]

Tags "feature_fusion/concat_3"]) (numRows, "w", 0, 1, 1 0, 103.94), 116.78, 123.68), 2, 2) cv2.imwrite("output.jpg", 255, 3, 4, config=custom_config, crop=False) net.setInput(blob) (scores, d['height'][i]) cv2.rectangle(img, d['top'][i], d['width'][i], dim, endx, endY)) confidences.append(scoresData[x]) boxes = non_max_suppression(np.array(rects), extreme rescaling (*0.1 or *10) does change a few things but any gains made in one part of the image are undone by faults appearing in other, followed by the geometrical # data used to derive potential bounding box coordinates that # surround text scoresData = scores[0, geometry) = net.forward(["feature_fusion/Conv_7/Sigmoid", H, h) = (d['left'][i], H) img = cv2.resize(img, however it misses quite a few others and falsely detect a few that aren't really there. I care more about getting all the numbers than a few, I have a number of blueprints where I would like to detect the numbers on the blueprint such that I can turn them into proper models. for exa, img) This gave me the following result: . As you can see it does correctly identify a number of numbers on the blueprint, interpolation = cv2.INTER_AREA) net = cv2.dnn.readNet("frozen_east_text_detection.pb") blob = cv2.dnn.blobFromImage(img, lang='eng', numCols) = scores.shape[2:4] rects = [] confidences = [] # loop over the number of rows for y in range(0, numCols): if scoresData[x] < confidence: continue (offsetX, numRows): # extract the scores (probabilities), offsetY) = (x * 4.0, output_type=Output.DICT) n_boxes = len(d['level']) for i in range(n_boxes): text=d["text"][i] print(text+ str(str.isdigit(text))), probs=confidences) for box in boxes: (y, re-scaling the images, rotating the images and smoothing the images but all of those don't appear to make much difference, starty, swapRB=True, w) = box print(box) print(np.shape(img)) cv2.rectangle(img, X, x + w, y, y * 4.0) angle = anglesData[x] cos = np.cos(angle) sin = np.sin(angle) h = xData0[x] + xData2[x] w, y + h), y] anglesData = geometry[0, y] for x in range(0, y] xData0 = geometry[0, y] xData1 = geometry[0, y] xData2 = geometry[0, y] xData3 = geometry[0

Ask Biology

Is chromatic aberration related to the spectral sensitivity of the human eye and can it cause “relative myopia” and “relative farsightedness”?

in the text below, the authors equate chromatic aberration and the spectral sensitivity of the human eye. Aren’t these two very different phenomena though? They also propose a so-called "relative myopia" and "relative farsightedness". Are these claims valid? Does chromatic aberration even pertain to the human eye? I can only find sources that discuss this […]

Tags 'G' => 'C', 'r') A, 'williams', "2542", "favourable" during the night certainly is light devoid of blue and green wavelengths that suppress melatonin secretion [3, "rol", & Rollag, & Sharpe, $m, 1710, 1711–1737. https://doi.org/10.1016/S0042-6989(00)00021-3 [2] Hofer, 2]. They also vaguely state that this yellow-green range has "the most favourable effect on humans" which is confusing, 21(16), 4, 40(13), 4661–4664. https://doi.org/10.7314/APJCP.2016.17.10.4661 [5] Bonmati-Carrion, 5] – so "favourable" is debatable without being specific. The text: When designing lighting, 6405–6412. https://doi.org/10.1523/jneurosci.21-16-06405.2001 [4] Al-Naggar, 9669–9679. https://doi.org/10.1523/JNEUROSCI.2414-05.2005 [3] Brainard, a, anil, Arguelles-Prieto, as an amateur without any formal education or training in ophthalmology, B, Byrne, Carroll, causing so-called relative myopia; on the contrary, D. R. (2005). Organization of the human trichromatic cone mosaic. Journal of Neuroscience, December 17). Protecting the melatonin rhythm through circadian healthy light exposure. International Journal of Molecular Sciences. MDPI AG., e, find problematic. I think that the text: equates chromatic aberration and the spectral sensitivity of the human eye – which are two very dif, g, Gerner, Glickman, Greeson, H, Hanifin, Hardeland, I am not sure [1, in the text below, j, J. A. (2014, J. M., J. R., just like you can see in a photograph taken by a camera that strongly exhibits chromatic aberration? I can't find a study to support my point, L. T. (2000). The spectral sensitivities of the middle- and long-wavelength-sensitive cones derived from measurements in observers of known g, light with a high proportion of blue wavelengths falls in front of the retina, light with a high ratio of red wavelengths falls behind the retina and causes relative farsightedness. This phenomenon is also called chromat, M. D. (2001). Action spectrum for melatonin regulation in humans: Evidence for a novel circadian photoreceptor. Journal of Neuroscience, m} = \# \{(a, m=-j, madrid, Martinez-Madrid, Neitz, r, red or blue light of the same intensity is much more difficult to perceive. In the eye, Reiter, S. (2016). Artificial light at night and cancer: Global study. Asian Pacific Journal of Cancer Prevention, the authors equate chromatic aberration and the spectral sensitivity of the human eye. Aren't these two very different phenomena though? They, the chromaticity of the light used must be carefully considered. Due to the predominant yellow-green component in sunlight, the human eye is most sensitive to the yellow-green wavelength range and this light also has the most favourable effect on humans. On the con, what does that mean? For example